Recent content by jaykellogg

yep, good to go and using the Dot! I'm going to go through and make all of the syntax changes. If I have any other issues while doing that, I'll post them here. If I have other issues not related to this syntax changing, should I post them here or create a new thread?

Got it to work! I used "Forms.frmBid.frmBidSubSetup.Form.PrevailingWages" By the way, when you asked for clarification on the control names, I noticed that the subform was named frmBidSetup not frmBidSubSetup. I renamed the form itself but the design screen on frmBid showed the older, incorrect...

mainform "frmBid" has tabs named "tabcontrol". Tab0 is named "Setup". I have a form named "frmBidSubSetup" on the tab "Setup". On the form "frmBidSetup" I have the combobox "PrevailingWages". The line where I got the error message was the first line of the if/then statement when I try to...

Here is the old code. BTW, I noticed that I had taken some shortcuts, here is a better example. Public Function PrevailingWageUpdate() 'Update the Unit Price in the Resource Table to equal the Labor Rate based on the Prevailing Wage selection Dim dbs As dao.Database Dim rst As...

I tried updating one of the procedures and I get the error message: Run-time error '2465: K5-Estimating can't find the field 'frmBidSubSetup' referred to in your expression. Here is the procedure: Public Function PrevailingWageUpdate() 'Update the Unit Price in the Resource Table to equal the...

I believe all I will have to do is the First replace. I don't recall ever using the "Sub Form_" syntax.

The database will be used to develop construction estimates. I want to have custom estimating software so that I can build in features that other estimating software doesn't have. It is currently up and running and I have completed multiple estimates. I am getting a few annoying error messages...

not sure what you mean by this. I will have to do some reading! Do you mean the events like Deactive, GotFocus, LostFocus... will not work? I will switch all of the incorrect syntax then play with the program and see if I am getting weird responses.

@Galaxiom - I will quit using this sytanx! thanks for the info @RuralGuy - I will utilize the replace method to correct. I typically copy the database every couple of days and put in a dated folder. Helps when I really blow something up!

Thanks for the link. That helped me figure out what I was doing wrong. I needed to use: [forms]![frmBid]![BidID] :D:D:D

I am not 100% sure of the difference between class module and standard module. What I have done is create a module called modEstimate. When the form frmBid is opened, it and all of the other forms and subforms on it have the code in modEstimate. The only code in each form is to call a Public...

I have a form with a tabbed control on it. Each tab has a form, with subforms, on it. The main form (frmBid) is opened to a specific record (BidID). Is there a simple way to limit the comboboxes to only show records containing BidID for the open bid? I've tried using the Criteria area of the...

RG, forgive me but can you clarify if the referencing that I am using is "ok"? I have a main form with a tabbed control. Each tab has a form on it with subforms. I've been putting all of my code in a module and utilizing functions that the different forms/subforms call. So, I'm not sure if...

I see many examples utilizing this syntax: Forms!FormName.ComboName Yet I have to write mine like this: Form_FormName.ComboName I've been dealing with it for awhile now so i have a lot of code already written like this. But, my concern is that I might have to re-write all of the code in the...