Search results

It can be done, and it was pretty easy actually. Here's what I did. I used a macro on my OnClick() event to SetTempVar. The Variable's name was deptstr, and the expression was...

Maybe this will help. I used this sample db to code what I needed. The trick used in this sample was to use an "alias".

Greetings sir. I noticed that issue a few days ago, and did a couple things to fix it. 1) I added the disposition to the NULL() fields, and also 2) Added "Limit to List" to the dropdowns in the Data Entry form. I'm still studying the project before I release it, but have made great progress...

Greetings. I have an expression that works fine, but only for a specific field [ShipTPF] within the table. What I’d like to be able to pick which field to use depending on the situation, through the use of a Switch() function to change out the [ShipTPF] to [ShipFab] and [ShipMir]. Here is the...

Leigh, I did step back, and I am man enough to admit I was wrong. In my effort to get the project done, I spent a good deal of my time with a migraine headache, convinced that I needed to set up some sort of relationship between tblDataEntry and tblFiscalCalendar, knowing all along that no such...

UPDATE: Ran "compact and fix" routine, but still won't let me add/modify records. UPDATE: Re-created qryDataEntry and all is well. All I need is someone to help me with the FiscalMonth thing.

Ok.. I am still "record is not updateable" but .. I do at least have the 214 vs 195 fixed. None of the "99 - No Defect Found" had the Dispo code in the table. It's weird -- I removed the fields from the query. Do I have to run some fix routine? Is it corrupted or something?

Yes. My intent is to lookup the correct FiscalMonth based on the AuditDate. Ah, there is a problem though. I have 214 records in tblDataEntry, and only 195 records in qryDataEntry. So I am back to my original request. Please see post #17. How do I get the FiscalMonth linked to the tblDataEntry...

The DataEntry table contains AuditDate. The qryFiscal was originally created to determine what FiscalMonth to assign the audit date to. I used to have two sepearate queries, but today (with my ephipany) I thought I solved the problem. I do not know any way to actually link the fields (because...

Whoa.. I am back in the frmDataEntry again, which is based on qryDataEntry, and although everything ~looks~ perfect -- when I try to modify a record it won't let me. "This record is not updateable." Ideas? http://kbalertz.com/209571/Cannot-update-record-Access.aspx SYMPTOMS When you try to...

All right. I will do some research today, but if i could just get someone to look at the sample db, they would understand why I'm confused. I just do not know how to do what I'm trying to ask... I've got a query on a table.. that selects a record based on a >= startDate, and a <= endDate...

Ooooo.. so I might have had it right?.. but since I didnt CHANGE the field.. Set the After Update property of the Quantity text box to [Event Procedure]. Click the Build button (...) beside this. Access opens the Code window. Enter this line between the Private Sub... and End Sub lines...

Thanks Leigh.. take a peek at the sample db if you would?.. If I can get this part right, the rest of this project will go a LOT better.

Let me upload a sample db, Bob.

OK.. made that change.. pasted it into the AfterUpdate event. Now on the control itself.. do I put Fiscal_ID for the source? I bound the control to the field in the table (Fiscal_ID)

Ok, I've tried this: Me.Fiscal_ID = Dlookup("Fiscal_ID", "qryFiscal", "[AuditDate]=" & Me.AuditDate) Anyone see my error?

Yes it does sir. The code below changes the parameter SQL to a SELECT SQL -- and now I in essence have a LOOKUP table for every audit date. SELECT DISTINCT filter_qFiscal.tbl_Code, filter_qFiscal.tbl_Start, filter_qFiscal.tbl_Stop, tbl_DataEntry.Audit_Date FROM filter_qFiscal, tbl_DataEntry...

Filter is the table name. qFiscal is the field name.

Raskew -- I'm not completely sure what all to change/modify. PARAMETERS [Enter TestDate] DateTime; SELECT Filter.qFiscal.tbl_code , Filter.qFiscal.tbl_start , Filter.qFiscal.tbl_stop FROM Filter.qFiscal WHERE (((Filter.qFiscal.tbl_start)<=[Enter TestDate])...

That was my fault. I guessed at Oct-09, and forgot to remove it from the PDF.