Search results for query: *

Hi My access database seens to have the Set Warnings command turned off. Whenever i run queries it does not show the error command. All my macros use the set warnings command to no and yes at the end of the macro but for some reason its turned off. Any ideas AFKAFB

Hi I've a users form for say two depts. Finance and Marketing. Initially it was planned that one dept would process the data and the other could only view the input. Responsibilities have now changed so both users may have to access the same forms for data input. My problem is that whilst i...

Hi I need to write some code that will allow the user to browse through any path/folders/files, select the file and then import the file into the database. In total the user will be selecting up to ten different files - excel/text etc. thanks afkafb

Hi I've inherited a DB. At this stage i cannot change the structure and design as it will affect a rollout date. Access is not letting me change the data type of some of the fields. All relationships have been removed yet access is saying there are still relatonships. I've tried creating the...

hi i've entered the following validation rule >=1 and <=5 with a message saying blah blah blah the message box was being shown earlier but now its not being shown but the data validation is working. its like i've turned off the messages but i cannot see how. regards chris

hi i've entered the following validation rule >=1 and <=5 with a message saying blah blah blah the message box was being shown earlier but now its not being shown but the data validation is working. its like i've turned off the messages but i cannot see how. regards chris

Hi I've a number of access queries that I need to save as pipe delimited text files. That part is okay. But now the recipients require the files to have a header and footer as follows : The header will read say "P|QWERTY|dd/mm/yyyy|dd/mm/yyyy| and the footer will read "G|1000" I guess...

All I’m using Private Sub Form_Current() It was working quite well until a user suggested an improvement. When the form opens on a record, if a value is YES and the values in four other fields are not empty then the four fields should be disabled. If the form opens and the value is yes and...

All I've a number of combo boxes with YES/NO options on a form. However, its possible to type in different values which i want to prevent. Is this prevented through the data validation to limit the user to yes/no. regards chris

Hi This may sound odd as most developers want a system to run as fast as possible. I've a number of forms that the user works through to navigate their way through the App. When the user selects a button i want the app to pause for say 5 seconds before it openS the next screen. How do you that...

Hi I'm exporting an access file to txt. I'm having problems with the date. Its been set to short date 'dd/mm/yyyy' but when viewed in the text file its shows as 'dd/mm/yyyy hh:mm:ss' how do i suppress the hours, mins and seconds. regards chris

Hi I've a number of access tables that i need to save as pipe delimited text files. That part is okay. But now the recepients require the files to have a header and footer saying for example the date the file was created on one row, the number of records on the next and on the footer other stuff...

All I've a form with four command buttons. Selecting the first button allows the user to use the current DB. However, clicking any of the other three buttons should close the current DB and open up a new DB, e.g. DB_2.mdb, DB_3.mdb etc... Ideally the user should not notice the current DB has...

Hi Sometimes when i run the performance analyser my DB crashes. What are the known reasons for this. Regards Chris

Hi I'm running performance analyser for my DB. Some of my forms are quite busy but some are very basic. The Analyser is suggestimh i user fewer controls - but many of my forms have say 7/8 combo boxes with an additional close button. Surely this cannot be correct. Perhaps i'm doing...