Recent content by matt164

I'm sorry I thought my question was relevant enough to the topic thread..next time I will start new. Even if I use the openArgs where would I insert the OrderBy / GroupBy ? In the code for "strQuery" ? Thanks

I have a bunch of text/combo boxes on a form that when information is entered into them and the "Ok" button is pressed runs a query: Private Sub ok_Click() 'Run query Dim argCount As Integer On Error GoTo Err_Handler If IsNull(creatorcb.Value) And IsNull(assigncb.Value) And...

Okay I removed some of the unnecessary code such as bob larson's FE_Update utility and I added back in the relevant linked tables. Problem arises when clicking "Brokers" button on GUI (Which normally opens on startup but I don't think it will in this version) and then searching for a broker...

I cannot post the db here, are there any forms/tables in particular you would like a sample of? It's a split db, front end on local machines back end on a shared server. I can post all the code you need as well as form design and table design just not actual data.

If the Where condition can suit my needs that will suffice just fine. No need to use the filter query. I entered this as my Where argument: "[BrokerID]=" & [Forms]![BrokerMgmt]![BrokerSearch].[Form]![Text20] And once again I got the 2105 error yet my BrokerDetails form still opened to the...

I'm now referring to it as: Criteria: [Forms]![BrokerMgmt]![BrokerSearch].[Form]![Text20] It works and gets me to the right record but still gives an error message

Thanks, that's how I refer to it in my code but the Access prompts in query builder didn't want me to do it that way..but I manually typed it in ignoring the suggestions and it worked! But.. I still get "Error 2105 You can't go to the specified record" .. however it opens the BrokerDetails form...

Hi, I'm trying to build a query to use as a filter in the DoCmd.OpenForm function. I have done this several times before, referencing values from forms e.g. Point To Field: LeadID Table: Lead Criteria: [Forms]![GridDisplay1]![LeadID] This filter is used in the procedure: DoCmd.OpenForm...

Thank you for the input, I will work on correcting syntax and spacing to make the code easier to read - but the issue here isn't the query because that works just fine, I just would like to have a message box pop up when there are no results as opposed to a "Could not find specified record" in VB.

Hi all, I do not have much experience working with Error Handling code and therefore am running into quite a few problems in constructing this database. First off, I have a form (Form_GUI) where a user inputs information and then clicks "Ok" which executes a query (strQuery) and opens a...

Thanks! Simple solution fixed the problem. Now my issue is with the continuous form I use to display the query results - "GridDisplay1" As you can see above, at the end of the query there is a command to open the form, which has been changed to now read: DoCmd.OpenForm "GridDisplay1"...

Hi, I am trying to code for a query in vb that will be executed when a certain button is clicked, and the query results will open in a different continuous form...this code has worked in the past I'm not sure why it's giving me trouble now. When I click "OK" to execute the query I get a error...