Hello, I need to regularly move 6 text files from a directory into a database (Access97). The text files all differ in specs and the data...

mooneater

07-02-2003 12:58 PM
Cameron

I'm currently working on a payroll database, and it has a form that is used to make payroll adjustments (overtime, vacation, etc). This particular...

N Pratt

07-02-2003 12:56 PM
Bruce

I can't get this to work, and no one at work can figure it out either. It involves a SELECT DISTINCT on a text field "SCRNm". There are multiple...

Derek

07-02-2003 10:49 AM
Richard Bernstein

Given that I have an ADODB connection object, is there a property that returns the "Data Source" ? I know I can parse the string myself, but it would...

William Grigg

07-02-2003 10:48 AM
William Grigg

First of all thank you all for all the great help you've provided me in the past. Ok, heres my question. I have two fields in a table that holding...

Ed Collins

07-02-2003 10:40 AM
Ed Collins

Hello, My question is: how to implement the regular Access toolbar (buttons: find, sort, filter etc.) to runtime Access application in simple and...

ada

07-02-2003 10:18 AM
ada

Richard, Now I'm getting "Can't assign to array" error message. I wish I knew how to write a function that selects the last word in a field and if...

Sue

07-02-2003 10:08 AM
Richard Bernstein

Assuming I have 2 tables: files.Id files.name downloads.file_id downloads.person Table downloads logs every instance when a file is downloaded in...

Skiip

07-02-2003 10:02 AM
Steve Jorgensen

For those of you who are interested.... Removing the "Include System Files" will resolve this problem. This is the only way that i could get around...

RWC

07-02-2003 09:53 AM
RWC

Hi All, I am trying to put together a query that will return just the first row of the sample table below. The reason is that the records...

Shuffs

07-02-2003 09:35 AM
Shuffs

Thanks BUT (1) I only need (WANT) to UPDATE one record at a time (for a delicate user-specific function) ... (2) I JUST want the SQL statement to...

Richard C Buchanan

07-02-2003 09:09 AM
Richard C Buchanan

On Sun, 29 Jun 2003 08:10:48 GMT, "Jeff Pritchard" <jeff.pritchard (AT) asken (DOT) com.au> wrote: No, I was just making a suggestion. There is...

Jeff Pritchard

07-02-2003 09:01 AM
Patrick Finucane

I am trying to populate an Excel worksheet with the contents of an array. I can't just use CopyFromRecordset becuase I have to modify some of the...

Dan Bostwick

07-02-2003 08:37 AM
Dan Bostwick

Fred, Diane's advice is good and very relevant and Larry Linson's questions are relevant to the ambitious project you've sketched. Once you've...

sftwrdvlpr

07-02-2003 08:35 AM
Larry Daugherty

Any reason you couldn't do something like change the SendMail *subroutine* into a function and then just set the return type to Long, and set the...

Pieter Linden

07-02-2003 08:31 AM
Josh Nikle

Hi, how can I keep the value of a variable (MyVar) en get it into another Private Sub? e.g. Private Sub A_Click() Dim stDocName As String Dim...

TTD_hck

07-02-2003 08:15 AM
TTD_hck

On Mon, 30 Jun 2003 02:52:04 GMT, "Albert D. Kallal" <kallal (AT) msn (DOT) com> wrote: All correct. And the reason the poster's 4 * 100000 worked...

Mark

07-02-2003 07:46 AM
Paul Bredbury

dear sir i wanted to create the folder of today date by default in c driver under c:\reports folder..i hve tried mkdir, dir with vbdirectory but did...

MUHAMAMD SALIM SHAHZAD

07-02-2003 06:53 AM
Nigel Lawrance

Hi Hopefully someone can help, I'm trying to get my datebase to able to check for certain records when entering via a form, and then if a match is...

leaper

07-02-2003 06:40 AM
Keith Wilby

I notice that there have been several postings about this topic but with no specific information on how to accomplish this. Recently I posted a note...

LR

07-02-2003 06:37 AM
LR

How can I hide a record so that it does not appear in a report?

Andy Kowaluk

07-02-2003 04:14 AM
Andy Kowaluk

Does Access support trigger? If not, how can I do? Thanks.

John Luongs

07-02-2003 04:12 AM
Andy

Hello, I found in another newsgroup entry following... HESCott (Programmer) Apr 10, 2003 I have some code that you can drop into a module (which I...

mooneater

07-02-2003 04:04 AM
mooneater

Dear Allen, Chuck, My tables ar already normalized, but i had to gather information into one field for a crosstab query. Difficult to explain, but...

Dik Mus

07-02-2003 04:03 AM
Dik Mus

Hi, I have a VB6.0 application accessing MS Access 97 via Microsoft Jet OLEDB 4.0. Everything works fine from a computer running Windows XP with an...

Roger Bournival

07-02-2003 02:30 AM
Trevor Best

rkc (AT) rochester (DOT) rr.com (rkc) wrote in <K3pMa.29016$8B.19953 (AT) twister (DOT) nyroc.rr.com>: Me? I understood the question, once it was...

Andy

07-01-2003 10:45 PM
Peter Nurse

The answer to this questions is in the version of MS Access and the patch level. To resolve the overflow problem Access 2000 needs to be patched to...

Alex Pavluck

07-01-2003 10:37 PM
Alex Pavluck

Can anyone advise me of the probelms I might encounter mixing Access97 and Access2000 clients on the same linked to the same backend database. In...

Blake

07-01-2003 10:08 PM
Bullschmidt

Is it possible to use the MS Package and deploy wizard to produce an installation of a Runtime2002 mae on an officexp computer to run on a...

John

07-01-2003 07:29 PM
John

I have a database where the shop number is the index of the records. However, my client wants the shop number to be 7 digits, the first two being the...

Ed Collins

07-01-2003 06:42 PM
Wayne Gillespie

See the Help file -- Queries - Adding and Removing Tables and Queries - Ways to bring together data from multiple tables or queries in a query A...

jenn24ssu

07-01-2003 06:41 PM
jenn24ssu

I don't understand the problem. If you use that Query as the Record Source of the Form, and the Field as the Control Source of a Text Box, it...

Larry Linson

07-01-2003 06:37 PM
nick2003

Hello, I currently have a event in a form that will recode about 40 variables when a button is clicked (see example below). Is there an easy way to...

Alex Pavluck

07-01-2003 03:46 PM
Richard Bernstein

Please Help... I have a problem which really has me going around in circles...so any hint would be helpful. I am running Access XP on Windows XP Pro...

Bill Dearborn

07-01-2003 02:30 PM
Bill Dearborn

Greetings, I have a report with total textboxes in the group footer. All the numbers are like 7, 7.5, 8.25 etc... However when it sums the values it...

Chris Kettenbach

07-01-2003 02:07 PM
Chris Kettenbach

I know very well KeyPress associated to a form. I have a customized help in my main menu. I would like that when the user press F1, my customized...

Saintor

07-01-2003 01:52 PM
Arno R

Hi, I'm probably being thick but I need a spot of help here, in the section of code: With Me.RecordsetClone .FindFirst " = """ & Me.txtWot2Find &...

Graham Naylor

07-01-2003 10:48 AM
Graham Naylor

I'm trying to use the code below to check the spelling in several textboxes in a subform. However, I'm getting an error telling me that the...

Josh Nikle

07-01-2003 10:18 AM
Josh Nikle

Hi All, A client has a secure Access 2000 application, split db design, with front-end on client machines (about 7, mix of OSes), and back-end and...

Tom van Stiphout

07-01-2003 09:58 AM
Tom van Stiphout

I am using a button on a form to start internet syncronization. It worked before, but then all of a sudden stopped working. Also, I switched servers...

Nick Hansen

07-01-2003 09:53 AM
Nick Hansen

Paul, There are a few ways of doing this. I'm assuming you know about inputBox, and that doesn't meet your needs. If you're going to open the form...

Jeremy Wallace

07-01-2003 09:39 AM
David W. Fenton

Paul Copeland wrote: A tab control with only one page will behave pretty much as you describe. Just set the tab control's Style property to "none"...

HB

07-01-2003 09:33 AM
David W. Fenton

Hi, I'm having a problem that's bugging me. I run the code set out below from an Access module and half way through the module I get the following...

Emmett Power

07-01-2003 09:21 AM
Richard Bernstein

Hello dear friends, I developed an Access 97-Database (split in frontend and backend) for a customer. Now this customer reports to me by phone...

Werner Budde

07-01-2003 09:17 AM
Werner Budde

I am experiencing the dreaded Microsoft Access 2486 bug which gives the message "You can't carry out this action at the present time" I have read...

Ernie Page

07-01-2003 09:17 AM
David W. Fenton

UPDATE: found immediate solution; still curious about answers to #2 and #3 to a lesser extent I have been working with Stephen Lebans'...

Pete

07-01-2003 08:36 AM
Pete

Kinda like doing physical exercise! LOL. Umm... the changing printer stuff... there's code in Access Developer's Handbook (version). IT's in 2000,...

dixie

07-01-2003 08:02 AM
Pieter Linden

Mark Johnson <102334.12 (AT) compuserve (DOT) com> wrote I'm sure it's a failure on my part to fully understand the treeview control, combined with...

Mark Johnson

07-01-2003 06:45 AM
Wayne Gillespie

Second post, same question, same person -- Jeremy Wallace AlphaBet City Dataworks http://www.ABCDataworks.com "P" <plavallee (AT) rcn (DOT) com>...

Jeremy Wallace

07-01-2003 06:41 AM
Jeremy Wallace

Here is a join that works on a three-table database, giving me which people (poolers) have picked which Celebrities (celebs) for a Dead Pool...

Rick vV

07-01-2003 06:07 AM
RickvV