Search results for query: *

I never did figure the FindRecord problem out, but I was able to use a Filter to isolate my record instead.

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

Excellent SIMPLE idea . . . hadn't thought of it that way cause I don't normally put tales in the .mde file. But I sure could. Thank you . . .thank you. Most Apreciated!!!

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 found that the Row Source of the New List box makes the default value of the remaining combo box disappear. Go figure. The same Row Source of the old combo box works fine with the other combo box, but when the combo box changes to a list box and uses the same Row Source, no go. I removed the...

I opened both Development and Production and compared. No differences in the properties of the combo box. I imported Production form, deleted old combo box and replaced with new list box. I copied new code over the old code so that this form would function same as the one I was revising. Same...

I compared the property boxes of the two versions and found no differences. Specifically what I did was replace a combo box with a new list box on the form. The old combo box was and the new list box is the field before (tab order) the combo box I am having trouble with. I didn't really touch...

Control Source is blank. This is a Value List with the following: "Group";"G";"Individual";"I" I want "Group" to be the default. I am working in my "Development" file and have messed this up . . . . it still works fine in the Production version . . . . until I promote the Development file ...

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 received this reply first and it worked fine. strWhere = strWhere & " [GroupName] like '" & Me.txtGroupName & "*'" Thanks again.

Yes, that's exactly what I was looking for!!!!! I was close, but it may have taken me quite a while to get it exactly correct. Thanks so much!!!!!

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

Thanks again for your help in solving this for me. Both the responses above helped get me closer. Thank you.

Yes, I did, and I will try it again. Again, thanks for your tips. I'm getting closer.

Thank you much for your replies. They will both help. Yes, I am trying to update a specific record. Here is the code I've tried: Dim dbsGeneric As Object Dim rstTM As Object Set dbsGeneric = CurrentDb * Set rstTM = dbsGeneric.OpenRecordset(“tblTestMatrix”)...

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

I had responded, but I don't see the response here. Yes, that is the way I have it set up. I don't think I can link any other way. Thanks.

Yes, you are correct.

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