Search results

You can delete this question. I have my answer. thanks

I unsuccessfully tried something in the lookup field cboFlcMinorID. It gave me a debug. I was trying to concatenate the 2 lookup choices and then compare the MajorMinor field in the main form. Private Sub cboFlcMinorID_AfterUpdate() 'Requery the whole Form 'Me.Requery DoCmd.ApplyFilter ...

new version 3 John or whomever. I am working faster on this. I have to get this done. So I made a new version 3. Still does not work but I feel that i am getting closer and can describe better to you. Please note my afterUpdate event in the cboFlcMinorID lookup field. Notice i concatenated...

John - I thought of something. In the cboFlcMinor, I could always make a similar MajorMinor calculated field into the row source of cboFlcMinor. I already have MajorMinor in the form's data area. (I plan to later make it invisible.) And then use the afterupdate coding that i showed above...

Re: 2 combo boxes but need an afterupdate - new file John - Your Frt combo file is not exactly what I am looking for. If you don't mind looking again, or anyone, I revised my file. I threw in a new lookup field .... cboFlcMajor55 ...... It's purpose is to select ONE major code and then all...

John - I did what you said. I took out the afterupdate in cboFlcMajorID and put your code instead to the On Current Event. Then saved and got out. Went to the frm2074MainItems main form. Went to the yellow Major lookup field. selected 022 and then went to the Minor lookup field and picked...

Hi John - found the manage attachments spot. Here is the shorty file for testing. I figured out now that my attachment could not be zipx but zip. Thanks for your patience in helping me. thanks Penwood

There are 2 combo boxes: cboFlcMajorID and cboFlcMinorID. Their underlying table fields are text. their answers are like 015 or 022 or 777. Unfortunately, the company started their codes with zero. I have the 2 combo box in sync. No problem there. I don't know how to make the records...

thanks. it just occurred to me to use the underscore. as for the spelling, i triple checked and all looked good. i notice that on my crosstab qry's, access uses the underscore. so i will go with that. my qry names then line up real nice. thanks for all your help

i think i will take out the spaces. thanks anyway.

I know it breaks the rules. but i find it easier to see my qry's.

I have an odd question. The following works for me in my qry criteria line: [forms]![frmNSBulkMain]![txtCatalogueReportPriceLevel] But i changed my form ...... frmNsBulkMain .... to ..... 7002frm NS Bulk Main. so now the criteria line looks like: [forms]![7002frm NS Bulk...

It works nicely Thank you so much. I was stressing out. This works better than ever before. regards, Penwood. Now i can go xmas shop.

I wonder if you can help me. In my query, for this calculated field, i get an error message about a syntax error missing operator in query expression. what did i do wrong? thanks FormulaID is a text field. UnitRM Combined: nz(DLookUp("UnitRM...

Yes, i will abandon the idea You are correct. I was only shooting for this answer because of my boss, who knows little Access, but has opionions. He still thinks we are wrong. So forget him. You are right. Penwood

I want to have a question in my query that does not get answered by date but by a concatenated field named "MonthYearPeriod". We always forget how many days in a month. But we remember the month and year. So for say a Sales Range of Nov 2006 to Oct 2007, we prefer to respond to the criteria...

Problem #1 - getting a crosstab to show more than 12 months of data across. Is this a limitation? Problem #2 - is related in that i prefer not to use in the Qry2 field name of: Expr1: Format([CalEndDate],"mmm") The above seems to limit me to just 12 month names like Jan, Feb, Mar etc etc I...

I have trouble making a button work on my subform. The query behind the scences is simple. it works if i manually enter the 3 answers. I use the following 3 criterias: [forms]![frmPriceMain]![SoldtoID2] [forms]![frmPriceMain]![ShipID2] [forms]![frmPriceMain]![FormulaID] Now the button on...

I would like to see if I am doing this okay. I want to confirm the best manner of storing a BilltoID and a ShiptoId address. I presently store 1,000 BilltoID's with 1 address each record in table1. Then I have 1,500 ShiptoID's with 1 address each record in table2. I figure that i would make...

i am getting closer. the answer now comes out fine. but i am prompted 2 times to enter the year and month. here are the fields in the Qry involved. Desired FiscalYear: [Enter Fiscal Year] Desired FiscalMonth: [Enter Fiscal Month] Desired BaseSeq: DLookUp("PerSeq","tblDates","[FiscalYear]="...