Search results for query: *

I'm no expert, but have developed some databases for the company I work for.I created a form to "print all reports" at the click of a button (which a macro was required listing all the reports I wanted to print). I have a total of 29 Reports which I print daily that range from 1 page...

G'Day Terry, Thanks for yout time & input. I have amended the code as below. When I run this (from a command button on a form), I get a "Syntax error in INSERT INTO statement". Any solution to this error message? Private Sub Command2_Click() sOutName = "ALL" For...

Bev, Appreciate your time taken in replying. I'm too a beginner in Access'97 & find it frustrating when things don't come together. I have tried to run the sample from a command button on a form but it returns an error message of "Object doesn't support this property or method". The...

Hi, I have a one off task that I'm trying to do which is sendng me round the bend. Background: Had 2,700 "dbf" files in a directory which I have extracted 1 table from each file into Access 2 (which has been converted into Access97). Each table has the same name (CustomerDetails) but...

Many Thanks for yor time in this matter. Your sample helps! What I'm trying to accomplished is to pick up a specific table from within each of the "dbf" files into Access'97. (Each of the "dbf" files are named differently) I know that if I write a macro using...

Hi, My name is Adam. I trying to determine if there is anyone out there can help me with an easy solution to my problem. I have been asked to collate some 3000 plus *.dbf files (each named differently) into a/1 Access'97 table. When individually importing a "dbf" file into Access...