Recent content by jrmywvr

How about something like this: Dim db As Database Dim rs As recordset Set db = CurrentDb() Set rs = db.OpenRecordset("Table Name") Me![Control Name]= Left(rs![Field Name, 3) Set db = Nothing Set rs = Nothing This will set the value of the control on the current form to the first three...

I had a similar problem with a tabbed form (frmDetail) that had several checkboxes. Each page of the form was virtually the same so I copied the first pages controls and pasted them on each subsequent page until I got that lovely error message. I think the total allowable number of controls is...

Thanks for your help. I had tried referring to these controls using Me.Control and had gotten an error message and I assumed the error was about these references. But it is working now--thanks!

I can't seem to make this work. I have a new form with several checkboxes on several pages linked to an existing table. I'm using the following code in the On Load even of the form to activate textboxes that correspond to the checkboxes: If Me!chkSomething= -1 then...

I have a form that has several checkboxes. Each checkbox has a corresponding textbox that I want to enable or disable depending on whether or not the checkbox is checked. I did this by using the following code in the On Load event for the form: If Me!chkSomething = -1 Then...

Yeah, it looks like I'm going to have to try to make that work. I found the Add Method for the Controls Object in Visual Basic 6 but that isn't available in Access 97. The only problem with using continuous forms is that my list is big enough that I would like to have it in more than one...

I have a query that is based on a table with a list of employees. The criteria for the query is "active" in the [status] field. I then have a form that is based on this query with a check box for each employee listed. What I would like to do is have the form change when the query changes. I...

I know what you mean about trial and error! I know very little about VB. I wasn't even familiar with access when I started this project--I've just been learning as I go. Anyway, It looks like all I needed to do was add the .clone to my openrecordset statement. I did that and it ran without...

Well, I think that's a step in the right direction...at least now I'm getting a different error! :D I'm getting an "item not found in this collection" error when I don't predefine the Manufacturer parameter in the parameter list for the query. This error points to the "qd.parameters" line...

I have a question regarding a previous post--using recordset as query criteria? I have a form with several combo boxes corresponding to the fields in a query. The idea is that when a user clicks on the "Find" button on the form, the selections they have made in the combo boxes will be passed...