Search results

Thanks very much, your code worked !! Thanks.

Thanks for your reply. However, it still doesnt work as intended. I am not an MS access (or VB) programmer and have never worked on this before and this is just a one off assignment. I would really appreciate if you could please help me on this. On the form there are 3 textboxes: txtport...

thanks for your reply, Nigel. Could you help me with another query please ? Ther MS access form I have designed is a search form with optional search. This means that the user can leave the textboxes blank but the from date and to date option should be used together as that would be a date...

What is this ??? Did you read my query at all ??? Do not give unnecessary / absurd answers as you block the post from getting genuine answers from others.

Sorry for the incorrect references. On the main form there are 3 tabs and I have to amend one of the tabs. is that supposed to be a subform ? also txttodept is the 'todate' and txtfromdept is the 'from date'. Please find the screenshot attached. Thanks.

Thanks but its not working. This is a sub-form and I have tried to modify the query as below but its doesnt work and still prompts me to complete all the textbox values (You must enter search criteria). The txtfromdept is the 'from date' and txttodate is the 'to date'. Also, if the user is using...

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...

Thanks a ton for your suggestion !! it worked !!

Thanks for your reply, it was helpful. I need one last assistance in terms of designing a query for the Search button. This is the query I have designed but dont know how to incoporate 'from date' and 'to date' in the where clause ? ------------------------------------ SELECT...

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...

Thanks a lot !!! I am not getting this error anymore. However, I am still stuck with this one. I am getting this ODBC call failed error. The full description is given on this: http://www.accessforums.net/forms/error-when-viewing-form-design-view-closing-20210.html#post95185 Thanks !

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...

I have created a form which adds row of data (record) to a table. I am able to test the form but the problem now is that when I try to go to Design View, it gives an error: ------------------------------------------ ODBC --call failed Cannot Insert the value NULL into the column. Column does...

I understand what you are saying but I need to work around this so that the data is not overwritten but added as a new row in the table. This is the reason I am using Add Record now instead of Save but I dont know what VB code would need to be input to get the Add Record button working. Do...

I am using this VB code to save data: ------------------------------------------- Private Sub Save_Click() Dim strMsg As String, strTitle As String strMsg = "Do You Want To Save This Record?" strTitle = " Save Record ?" If MsgBox(strMsg, vbQuestion + vbYesNo, strTitle) = vbNo Then Me.Undo End If...

basically the requirement is to enter new records into the table. however, if the values for the combination of three primary fields in the form already exist in the table, then the record should be updated. There is already a trigger in place on the table which updates records in the table.

Thanks for the reply. The form is based on and has been created using a table - VESSEL and is located in SQL Server. The form has exactly the same no of data entry fields as the table including 2 auto filled textboxes which are auto filled using a combo box. Please find the form attached which...

A record is created by filling in all the textboxes on the form and then saving by clicking on the Save button. This should create a new row of data in the table located in SQL.

Thanks, 1. well actually I am trying to save data from the ms access form to a table. What I noticed that when I press Save button the form for the first time it gets saved as a row in the table. But when I try to add another row through the form, the first row that was created gets...