Recent content by cliftonx

Thanks everyone for putting me on the right track. I found the ColumnOrder property that I was looking for to place the following fields in the proper order on the Datasheet: Set Me.Recordset = rst Forms!frmiimain.Form.Requery Me.Phase.ColumnOrder = 32 Me.Skid.ColumnOrder = 33

In design view for forms, I click the detail button, then I click the tab order button, highlight the desire fields and move them to the desired position on the form. Save it and run the application and take the option to display the form and I can see the fields in its new position. Today, I’m...

After further review of the DSN names used at our shop. We are currently maintaining 3 environments (Production, Development and Test). When I Altered the table in our Development environment in SQL Server. Everything worked fine. However, I used the TEST environment for the DSN name. After...

I've relinked the table and used a query to update the field value. But still getting the same error message.

I'm trying to update a Description field on a input form by replacing it with a null/spaces. But when I move on onto the next field I get an error message; "You tried to assign the Null value to a variable that is not a Variant data type." I'm using a SQL Server backend. When I look at the table...

Thank You! Your suggestion worked.

After setting the Record Source to the underling source table and using the CreateQueryDef definition to define and execute the query. The form opens up with no records from the query. The following is the code that I am using. What am I doing wrong? Dim dbs As DAO.Database Dim qdf As...

Thank you. That solved the problem. I was using the dot notation outside the With block.

I tried the above code and now I get the following error: Here is the new code:

I'm trying to change the record source of a subform. I'm getting for following error: The following is the code I use to generate the error:

Hello, I'm simply trying to change the record source on a form. I'm using SQL Server as the backend. I'm assigning the record source to a stored procedure named: " "spDevsWithPartsSpec" plus passing along the parameter; "Forms!frmiimain.cboJobNumber". I'm getting the following run-time error...

Yes, I'm using ADO and tried using the % as a wildcard but I get the "Error search criteria" error message. However it does work with the * wildcard, but only when I use it at the end of the of the search string i.e. Like "A*" but not Like "*A".

Added the following Like filtering pattern: ssql = ssql + " and Chemicals.[Chemical Name] like '" & txtChemicalName.value & "*' " The code works as expected. However when I try to make the following modification to append an asterisk to the beginning of the like operator: ssql = ssgl + " and...

Yes, that's right, its a sub form actually. I've posted a before and after shots. Please see attachments. Thanks!!

I just upgraded an .accdb database from Microsoft Access 2010 to Microsoft Access 2016. After the upgrade, I opened the Access 2016 version and noticed that when I opened one of my forms, the date picker control is missing. I really need that date picker control back on the form and working...