I was wondering if it is possible to have a table with two columns in it, let's call them OldValue and NewValue, find the OldValue in a text file and replace it with the NewValue. Any information on this would be helpful. If it can't be done in Access, are there any other suggestions. I use...
I would like to create a quiz in Access 2000 for end users to take a required annual test. I don't want to be the one each year entering the information so I am looking for a way for the "super user" to enter the questions in. Once an employee enters their name and department, I want the...
Hello,
I am hoping that someone can help me. I have an Access database that exports 5 queries to an ASCII txt file. I need to append them in a certain sequence and that will need to happen everytime the application is used. Let's say I have one.txt, two.txt, three.txt, four.txt and five.txt...
Is there a way to run an update query using a macro? I have an update query that I would like the end user to be able to click a command button to run it. I tried the way that I usually run a query in Macro but when I choose "OpenQuery", my update query is not in the list.
Hello -
I have a txt file that I need to import into a table in Access. I have created an import spec, but the file doesn't have a pk. I need one in the table but the file will not import (using a macro) because the fields are not the same. Now, I can do it manually because it asks me if I...
I have Crystal Reports and Crystal Enterprise 9.0. I'm having a hard time finding good documentation. I want my end-users to use their browsers to view a crystal report. It is not necessary for them to modify anything other than dates. I want it to prompt them for the date range they want...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.