Search results for query: *

hi i'm unclear with your answer 1. where would i put the docmd 2. can you expalin more about turning warnings on at every error function

All three boxes ticked i've also a piece of code that normally fixes it but not workngi now. code below: Public Function setWarningsOn() As Boolean On Error GoTo ERR_HANDLER DoCmd.SetWarnings -1 NORMAL_EXIT: setWarningsOn = True Exit Function ERR_HANDLER...

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 apologies - whern the user clivks the button it needs to open the Import screen allowing the user to select the file they want per the spec saved. The Transfertext command is fine but the path/file name could change and i need ot give the user flexibility.

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

still not showing the message box

i think so how would i know if they are turned off

hi no would this help and if so what should i write to ascertain why the validation message boxes are not showing 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

hmmm i've not send a formatting on the form_current for that condition but its making me think perhaps i should. i think looking at the form it should appear as the first set of conditions. i know it sounds daft. if i were to showe you the form you could see what i'm trying to. does it really...

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 Thanks for the code. Unfortunately i'm new to programming so i don't really understand the code. To clarify i'll have already created the six files as txt files with names say fileA, fileB etc. The header will read say "P|QWERTY|dd/mm/yyyy|dd/mm/yyyy| and the footer will read "G|1000" Without...

Hi Tom Thanks for that but how would it work. say i click on cmd_open_formA() what would the code look like to set the timer.... sorry for being well useless on this. 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 am a tad lost here the field is in a table which i'm exporting where would i put the expression Format(DateField,"mm/dd/yyyy")