Search results for query: *

Working in MS Access 2007 and when I am writing code, Access will help with tips that "hover" when you are completing specific code like "DoCmd.FindRecord" or "DoCmd.OpenReport" to help you know what parameters are required next. In the older version of Access, this help tip stayed visible for...

I have a screen I use to build records in a couple of tables. One table is the recordsource for the form. I use unbound text boxes to enter the initial data and a command button to activate the AddNew processes for building the records in the two tables. The AddNew works fine for both...

I provide an .mde file for use by several company personnel to help communicate progress on a project. They copy the .mde to their desktop and access a separate Access back end file for the data. I am using Access 2007, but have not converted the file from Aceess 2003. I do updates...

I was working to change the functionality of a form by adding a list box that was unrelated to another combo box. The combo box has (had) a default value that I had entered in the Default Value field in Properties as "[cboType].[ItemData](0)". All of a sudden, this combo box no longer displays a...

I am using a text box on a form to complete the criteria(s) to filter a report. A WHERE stmt that works is: strWhere = strWhere & " [GroupName] Like 'a*'" The above example finds all Group names that start with the letter "a". GroupName is the field in the report (underlying query) and I'd...

After an Event, I am trying to Update certain data for a record in a table. here is the code I've been able to come up with so far: Dim dbsGeneric As Object Dim rstTM As Object Set dbsGeneric = CurrentDb Set rstTM = dbsGeneric.OpenRecordset(“tblTestMatrix”) rstTM.Sequence = Me.Sequence...

Situation: Networked Access 2003 database. Back end on the server, includes an msd table and a linked excel worksheet Front end on users computers, includes forms, queries, reports. Problem: The linked Excel worksheet displays on the FIRST...