Search results

I have a button on my main form that when clicked I want to populate 3 fields on the subform. The weird thing is I have another form that this works perfectly in, I literally copied the code and replaced the form names and the field names. Anyway I get an error "Access cant find the field...

I need to generate an Order # on a form. I currently have a continuous form and the bottom is in Datasheet view. Each record has a check box and the user can check whichever record(s) they want and a SAVE button is provided that saves their selection to a SQL table when the button is pressed...

I have a simple data entry form and one of the fields the user needs to input into is a Ticket# field which is set as a long text but in reality its between 10-15 characters (SQL server has it as nvarchar(255). The ticket number already exists and the user just needs to pick/input the correct...

I have a search form and a subform underneath in datasheet view. On the search form i currently have a combobox where the user can select a name and press the search button (code below) and it gives the results for the name they selected. That part works fine. However I want to add 2...

I have a combobox on my main form that the user selects the employee and the the subform displays the results in a datasheet view. The code is below. I'd like to add 2 check boxes as additional criteria the user can search with. First checkbox will be "Open Tasks" and the 2nd checkbox would...

On my main form I have a combo box and search button. The combo box is just a listing of employees and its data source is a simple employee table. Once a name is selected in the combo box the search button queries a table to get all of the results for that employee and the results are in the...

I need some help handling an error. The below code takes a excel file and imports it into the Access database. It works fine as long as the file already exists but if something happens and that file doesn't exist, I get an error saying it can't find the object to (cant find object to delete)...