Search results

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

Thanks Everyone!!! I solved the problem. I had inserted the SetFocus and Requery statements right before I had saved and closed the table in the Pop-up window. I simply moved the code below the save and close statement and it worked. :) Excerpt for code: DoCmd.Save 'save table from...

I have a button on a subform that allows a user to add a new task record. When the "Add New Task" button get pressed, a pop-up window appears that allows a user to enter a new task record. The pop up window contains a "Save and Close" button. When the user enters a new record on pop-up window...

My question is with ms access 2003. I have add-ins on the tool bar that consists of various menu items that you can select from. I would like to edit the menu selections but the command to edit the add-ins (menu commands, tool bar commands and custom tool bars) are all grayed out. How do I get...

Hello All, I'm expirencing a strange error that I haven't encountered before. The following are the particulars: 1. Using MS ACCESS 2010. 2. Code compiles clean. 3. Using .mde file on a file server to access the application. 4. When application runs. It works fine on my PC, but...

Hello Forum Members, I'm experiencing an intermittent problem. I have Microsoft Access 2010 front-end and Sql2008 back-end. Every once in a while, I get an error while running the following pass-through query and report: DocName = "rptGrossFieldSummary" Set qdfList =...