Search results

All, I recently moved from having my database within Access to now having it within SQL. Basically, my access application will remain as the front end and SQL Server will now be the back end. After getting everything set up I tried to add some data with the access front end. It works fine...

I am currently working on an application for a friend. I am developing this application in 2003. However, they are running 2010. So far we have tried just sending my application directly over and running in 2010, but when information is being read into the database issues begin to appear...

I am trying to use the Option Button on a form. I have never used this before and I am experiencing some trouble. I have two options, one is to be used to "export only new records" and the other is to "re-export". The default setting for the when the form is first opened should have "export...

I have the following code in a .bat file: Somedatabase.mdb /x TestMacro The database will open, but the macro "TestMacro" will not start. After the database is open, I can can manually click the macro and it will display a msgbox as it is intended to do. Any idea why this is not working?

All, This could be another simple question...here we go: 'Channel_Data_Table' contains 2 variable channels each with their corresponding channel ID column. Channel_Data_Table: Channel A, Channel A_ID, Channel B, Channel B_ID 'Conversion Table' is used to store channel ID's and their...

I am printing values from a table to a text file. When printing the column for price, regardless of the actual price in the table, I need to make sure it fits into 10 digits which will then be printed to a text file. For example: The price in the table is $1.45. When I print to the...

I am currently using the following statement from within Access VBA to print records to a file: Print #FF, DLookup("[Column1]", "Some Table") This part has worked. For the next step I would like to print the next records in the table, starting with the first record and ending with the last...

All, I am trying to create an append query based on data currently in a table. For discussion purposes, lets assume 'Table1' contains (A,B,C) in 'Field1'. I would like the append query to search for a value, 'B' in this case, and if present, create another record 'X'. Here is the code I...

Does access handle automatic column heading assigments for tables? I have files that I am importing via VBA. As of now the column headings are the same, but in the future, they will change. I would like to continue to import the files into the same database and have access automatically...

What is the recommended method for deleting records using a VBA module? Currently I am using an SQL method that specifies the table name and the upper time stamp date from which values should be deleted. My database is continually being updated with new files from this same VBA module. I...

All, I have limited experience with VBA but have used it in the past. I am currently trying to set up a module within access so that I can read the current files of the directory (.txt files) and then bring them into a database using "TransferText". I am running into one issue when using...