Search results

I hope someone can help me. This module is giving me the "undefined function" error message when I try to run my query. I don't know why, but I have checked that there are no references with "missing" and there are not. I also added the word "Public" to the function becasue that was advised...

Thanks lagbolt. I think I understand. I will give it a try and let you know how I go. Really appreciate your help and quick response.

I have an order form that auto-populates details from the customer table into adderss and contact controls. But I don't want it to auto-populate when the underlying order table already has data in the related fields. I am a complete novice so I am sure the answer will eb simple. Here is the...

Hi Mr. B., I am an idiot. I realised what I was doing wrong. I had an expression in the query field that I forgot to take out when I wrote up the code. Just having a very blode moment.! Sorry. But thanks for the reply. All is now working, just put the if statements that was in the...

I have a form with 3 controls boudn to the following fields: DPBatchNumber - textbox where the company batch details are recorded. SupplierBatchNumber - textbox where the supplier's batch info is recorded SupplierBatch - query control where either the DPBatchNumber or the SupplierBatchNumber...

I figured out if I set the focus to another control and then back to the control I want to have the focus, then that works, but I cannot enetr data in the text box. It appears to be locked or not enabled for some reason. Private Sub SupplierBatch_Exit(Cancel As Integer) Dim strNewBatch As...

Hi Catalina, It doesn't work. I found another suggestion that added Cancel = True before Set.Focus and that gives the control the focus, but I cannot enter data into the field for some reason. Private Sub SupplierBatch_Exit(Cancel As Integer) Dim strNewBatch As String If Nz([SupplierBatch])...

I have something wrong in my code. I want the cursor to be positioned at the control "SupplierBatch" after the message box alerts the user that they need to enter the supplier batch details. The code works as I expeceted except that the cursor go to the next control on the form istead of...

Thanks for that,but I am not sure that will work for me. I have many different location paths to change. I have over 700 entries with documetns in varying locations. The only hing in common is that they all have the extra unnecessary "\" as the last character in the doc location field for...

I am a novice and learning update queries for a document register I have at work. Can someone tell me how to update the records in a hyperlink field to remove the last character ONLY. I imported data from another source and the hyperlink has an extra "\" at the end of each record that I...

I am a novice with MS Access, so I need all the help I can get. I have a main form with several checkboxes and I would like the subform to change based upon which checkbox the user checks. I have 3 different subforms and I would like them only to be displayed once the user has checked the...