Search results

Hi, On the access form I have designed , I need to give optional search option to the users. I have the following search options on the form (screenshot attached): From Date To Date Port Vessel Voyage --------------------- The query is as follows: SELECT dbo_VESSEL.VESSEL_NAME...

Hi, I am having an issue in a form I have designed. On the form I need to give the user the option to select a 'from date' and 'to date' and for this I have put in 2 calender controls which have the same control source(same table column). The problem I am facing is when I select a date from...

Hi, I have created a form which uses both textboxes and a combobox. What I wish to achieve is that once the user has entered a data and clicked on save button, the previous entered data should clear out from all the textboxes and the combobox. I have tried everything but it does not seem to...

Hi, I am getting this error- 2501 when I try to press the 'Add Record' button when the form is incomplete. At that point I get this pop-up that says: MS Access cvan't append all the records in the append query. Do you want to run the action query anyway ? When I press No, then I get the...

Hi, I have a added a code in the After Update event of a textbox which I need to call to display value in another textbox. This is what I have entered in the After Update event: ------------------------------------ Private Sub Text41_AfterUpdate() [Me].[Text45] = DLookup("DIVISION_CD"...

Hi, I am trying to autopopulate a textbox2 from another textbox1 and using this code for the same: =DLookUp("DIVISION_CD","dbo_DIVISION","[Text41]") The problem is the above code works for only the first time. When I change the value in textbox1 the next time, the value in textbox2 does not...