Search results

This is really "ugly code" but it works. AuditorType: IIf([tblDataEntry]![AuditorClock]="0000",[tblAuditors]![AuditorType],IIf([tblDataEntry]![OverRide]<>1,[tblOverRide]![SwapID],IIf([tblAuditors]![AuditorDept]<>[tblSeries]![Department_ID],"QA",[tblAuditors]![AuditorType])))The problem is...

I'm looking.. not sure I have enough experience to figure out how to use this yet.

Let's suppose for a minute that I have several different fields in a table, and they are ABC1, DEF1, GHI1, JKL1, etc.. Now let's suppose that based on a form entry, I would like for a query to display the particular field I'm looking for.. For example if I entered ABC in the form, I'd want...

Everything is fixed. I don't completely understand why?.. but when I started with a blank dbase, and imported the tables/queries etc all over again.. it works like it's supposed to.

Well duh. Private Sub Auditor_ID_AfterUpdate() If Not IsNull(Me.Auditor_ID.Value) Then Auditor_ID.DefaultValue = """" & Me.Auditor_ID.Value & """" End If If Me.Auditor_ID.Value = "LR" Then Me.cboSeries_Master.Enabled = True End If End Sub The "Auditor_ID" was...

Auditor_ID is the combo box. Auditor_ID_Label is the label. (yes I know.. cboAuditor_ID would have been preferred. ;)) It's got to be simple if I provide you with all the information you need.

The event procedure is "after update".. and I added the missing "end if" Private Sub Auditor_ID_AfterUpdate() If Not IsNull(Me.Auditor_ID.Value) Then Auditor_ID.DefaultValue = """" & Me.Auditor_ID.Value & """" End If If Me.Auditor_ID.Value = "LR" Then...

Basically, I'm trying to ENABLE a field based another field. If Me.Auditor_ID.Value = "LR" Then Me.Series_Master.Enabled = TrueI'm close, but no cigar. What am I doing wrong?

Thank you thank you thank you.. I was sitting here working on it.. even made a BLANK database and brought over only four of the tables to see if I could change the keys and make it all work.. the database application hates me apparently..

SOS -- Can I get the file emailed back that you reviewed (and assuming you corrected)? I just need to study this some more so I can understand exactly how to make all this work. I see, but I can't seem to get it right. By the way, the reason that tblVendors seems linked to nothing.. is cos it...

I get the feeling I just did your "Introduction To Microsoft Access" school assignment?.. but here you go sir.

I know what you are saying. Let me see if that works. (a few minutes later.. ) SOS -- pls check your private messages.

Maybe this will help. Two attachments. One "doeswork" (from the original dbase), and the other "doesntwork" (from the new modified database).

Oh I'm sorry. I didn't realize that photobucket was problematic. Better?

I should have said that (in addition to not being able to ad to the form) I also cannot ADD to the query. Sorry. but as far as "add additions" set to yes..

OK.. I think I have it. Check out this example. By the way, using LETTERs (although common practice) is a pain.. but to answer your question: Hope that helps sir. (DISCLAIMER: I just noticed that I forget to use standard naming convention on my queries. Sorry about that. I was doing like...

Link the four tables together into a common query, and then while in design view "build" the formula/calculation you need. For example, the screenshot below is not "YOUR" calculation, but it shows you how this is done inside a query. Also.. looking at your problem some more.. You might have...

I'm sure there is a simple explanation, but i don't know where I made the mistake. I have a data entry form, that uses qryDataEntry for the record source. qryDataEntry is comprised of data from several tables. (posting a screenshot) Everything USED to work fine, but somewhere along the way...

Actually?.. that might work fine.. let me ponder that. And what I like best about that idea, if it would be dynamic instead of hard-coded like it is now..

Originally, for some stupid reason I took the easy way out and took advantage of using Access' new setTempVars feature. BAD MOVE. It worked great, but today because of some changes to the application I am trying to add additional parameters (if you will) to the original code. Field name is...