Search results

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

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

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

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

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

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

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

The following "Open file dialog box" code allows a user to browse through the folder and save a file at the user specifed location. It works perfectly in MS Access 2003: Dim strInputFileName As String Dim strfilter As String strfilter = ahtAddFilterItem(strfilter, _ "Portable...

Hello, I'm experiencing a run-time error 3000. The following is an excerpt of the code that I'm using: If [report selection] = 3 Then DocName = "rptGrossFieldSummary" Set qdfList = db.QueryDefs("qrySp_GrossFieldSummary") strSQL = "exec sp_GrossFieldSummary'" & Application.CurrentUser & "','"...

Hello, I'm using the following Open/Save Dialog Box function(code excerpt): Dim strInputFileName As String Dim strfilter As String strfilter = ahtAddFilterItem(strfilter, _ "Portable Doument Format (*.pdf)", "*.PDF") strInputFileName = ahtCommonFileOpenSave(Filter:=strfilter...

Hello, Could anyone provide some direction as to why I'm getting a 424 runtime error. The error occurs on the first line of the sub function(the 'set rep' statment). The following is the code that I'm using within a module, that causes the error whenever the module gets called, i.e...