Search results

Got it. Same name but one had a space and the other has a "_" in the name Thanks I really appreciate it!!!

where is the subcontrol name at?

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

You're right. I might be thinking about this all wrong by trying to force everything into one table when maybe I need to be using multiple tables.

I'll search for Dmax. I was searching for auto generating a # and didn't get anything that I thought would work

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

thanks. How would I implement it to my field? I copied the module to my DB but I don't see where he is calling the module in his form.

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

Thanks but I would need the option for both checkboxes to be checked.

Yeah I kept getting syntax errors so I stripped the AND off from yours and I stopped getting the errors. I think I may just abandon this. I'm too new at VBA to make this work Thanks for the help though.

not sure if its working or not but now getting error "syntax error in union query and Me.[Tasks subform].Form.RecordSource = StrWhere line is highlighted. Private Sub cbo_Search_Click() Dim StrWhere Dim lngLen As Long If Not IsNull(Me.cbo_Employee) Then StrWhere = StrWhere &...

I added the code below but I'm not sure what to put for my checkboxes in the strWhere line. Both are looking at the status field and the status field in the table will be populated with: Closed, In Work, On Hold, & Not Started as its values. Open = In Work, On Hold, Not Started Closed =...

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'm not sure how to add the checkboxes to the VBA code

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

The subform is a datasheet but where do I set AssignedTo control to look at my employee table?

Are you saying use a combobox on the subform where the data is?

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

Would it be easier when importing the files it creates tables instead of linked files (tables) to Excel? Here is what i'm trying to do: 1. bout 12 Excel files get downloaded to a file share folder each month. The names of the files aren't consistent but they all begin xxx_001. I have a...

No I think i'm going to start it over. I think the way its importing the excel files is causing the db to hang up. I'm no longer getting an error message but its not importing any files over neither. Its just hanging and I have to go to the task manager and quit Access.