Search results

I am doing exactly as you have mentioned. But the problem is that the main file is being imported as a text file and the date fields are imported in "TEXT" format. The file that it is being copied on to has the same date field in the "DATE" format. Now I need the dates to be in a date format...

I have a macro which copies a table to a table which is already existing (ie macro to copy the table to an already existing table.) The idea is to update the table with new information. (Note that we are not appending the data but trying to get in completely new data into the existing table...

I found the format while browsing the internet: It is as follows: C:/Program Files/Microsoft Office/Office/MSACCESS.exe (path to database)/cmd "DB"/x (Macro name).

The way my ACCESS project is structured the macro shld not run when the database is opened because the databse will also be opened manually. The batch file is used to automatically import a certain TEXT file at certain intervals (ie weekly and monthly) and the macro has to be invoked only if...

I want to run a macro using a batch file. I would like to know the exact format that shld be used for the macro name to do this. The batch file opens the dtata base by using the following path: C:\Program Files\Microsoft \Office\Office\MSACCESS.exe\coding.mdb\(What should I type here for the...

It works!! That works fabulously! Thanks a lot!!!

Problem in running a batch file I have been trying to make a batch file. The way I am doing this is going to MsWord opening a new file typing in C:\Program Files\Microsoft Office\Office\MSACCESS.exe. (since that is where the MSACEESS program is stored) I am then saving this file as exp.bat...

Will try to get that changed The original fields were defined and named by the management. But I will take your suggestion and see if it can be changed. Will get back to you if there still is a problem. By the way I was just browsing through the Microsoft Knowledge Network for some different...

Sending the code This is the code forthe Control Source in the Properties of the Text box. =DMin([Date],[tbl_Call_Coding_Data_New1]) Thanks.

I thought my work was finished but now we have decided on a little more automation for the ACCESS project that I am working on. The task has many stages to it but my question is for the first step. How can you set up ACCESS so that it automatically imports a certain TEXT file from the server...

I am using the following but it is still not working: For the control on the form (which is a Text box called [Text16] I go into properties and select "Data". For the control source I type the following: =Dmin([Date],[table name]) where Date is the field in the table. In form view it still...

That worked. Thanks! Thanks. That really helped.:)

I am trying to import a TEXT file into ACCESS using a macro (using import delimited). But what happens is that it creates a table with only one field and also generates an error table which seems to state that Row 2 is "unparseable" Now when I import the same TEXT file using File->Get External...

I have created a form and I need to incorporate two boxes for dates. Effectively it is to show the end user that the reports being analyzed are for a certain period. To do this I have made a query which is based on the underlying table to be analyzed and this table has a date field for every...

Did you change the control name Did you change the control name to be different then the control source name?

That works!! That works beautifully!! Thanks.:)

For crosstab queries, when a sum valuates to zero, it returns a null value. Is there anyway that it can return a zero instead of null because I get these blank spaces in the report obtained from the crosstab which would look better with zeros and not confuse the management who reads these...

I will ask as I go along. Thanks! Thanks! I will try to understand the process and ask questions as I go. And by the way can you recommend a good book which deals in VBA for Excel and ACCESS? I have bought the ACCESS and EXCEL bibles but they have a very surface treatment for VBA. These...

I would like to program a button on a form which does the folllowing: 1. It opens a particular file folder on a drive. (say U://) 2. It then allows to select a file ( which is a TEXT file) from this folder. 3. After the selection is made, it imports the TEXT file into ACCESS as an ACCESS...

I need to program a button on a form that does the following: 1. On the click of the button it should open a particular drive (say the U:// drive) 2. It should allow me to choose a file from the U:// drive ( which will be a text file). 3. Upon choosing the required TEXT file from the...