Search results

Hi: I did something and now when I click on my (previously working) command button I get "Error 2001 You cancelled the previous operation" and my command does not run. So I figured "Easy fix close form do not save" but on reopen I get the same error message. Closed access and restarted with...

Hi Dave: Thanks for the reply and good point. I tend to find that were users are concerned practicallity does not always meet reality. I will play with your option and Simon's if for no other reason the to improve my rusty skills. Thanks

Hi Simon: Thanks for the reply. If I understand you correctly, I create one subform for each location. The RecordSource would correspond to the specific location. I would then put each separate subform into its own tab-page. Ok, I can try that. Hi Pat: Just to make sure we are on the same...

Hi Pat: Thanks for the response. I have created a Master form with a combo box. The combo box allows the user to select location and then load a sub form to display the data for that location. The user will always toggle between all the locations. My thinking is that the user interface would...

Hi: For the A2003 mdb that I am working on I would like to display similar information on one form. I believed that tab controls would work but I am having difficulty understanding or setting it up. Essentially I have a table of locations and a second table with details for each location. I...

Hi gemma-the-husky: True it could be done that way. I do not see the difference between copy, import, delete and that way the original file stays original. Thanks

Hi gemma-the-husky: Thanks for the response Should have mentioned that the test was in A2003. Yes I could just rename the file but, as part of the audit trail and for backup recovery the original files are not to be changed. That way if there is any question about the origin of the data we...

Hi: I decided to do some testing before giving up on this topic. I created a good text file with the .txt extension and did an import and a link table on this file. It behaved as expected with the file being imported or linked. Data went to the proper cells or I had access to the proper data. I...

Hi Pat: It is hard for me to believe how much access I have forgotten. Your picture makes sense after I thought about it for a long while. I think later, after I get the database functioning, I could use that idea to allow somebody other than me create a new import table to add to my system...

Hi Pat: First off, thanks for the reply. I understand how difficult it can be to answer questions without full information, so thanks for the reply. I will use the Northwind sample data base to elaborate. The Location in my data is like customer name and the Group is like inventory items. The...

Hi: Thanks for all the responses. The basic purpose of the DB is to reconcile cash and stock to sales (from sales terminals) reports and then print reconciliation reports. At the end of the month produce summary reports for the month and output a summary file. The names of the location and...

Hi MStef: Thanks for the reply. Sorry if I was not clear enough. The problem is the file extension. Access (I am using 2003) generates an error message on files with non standard extensions. In your example instead of TxtFile1.Txt I would have TxtFile1.ABC and then Access would say "...must...

Hi: Is there a way to import text files with file extensions other than .txt either with VBA or SQL or? I have several files to import daily and they do not use the TXT extension. I would rather not have to rename each file before importing. Thanks

Hi: In the database I am developing there will exist a table for storing imported data. The data will be imported daily and will come from multiple locations. This will cause the import table to contain duplicate data in several fields. I am thinking of leaving this duplicate data in the import...

Hi: I have been asked by a friend to create a database to help them balance sales information. Although it has been a while (10 plus years) since I did this last I thought I would welcome the challenge. Before I get too far into the development I thought I would ask for critiques and...