Search results

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...

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...

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...

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 have tblDates that has two number long integer fields named FiscalYear and FiscalMonth. then there is my field PerSeq is number long integer. in my Query1, i have 2 fields that use a question in the field part of the qry like: Desired FiscalYear: [Enter Fiscal Year] EG 2007 Desired...

when i change records, my subform that has a memo field, shows the memo field data is "highlighted". i can make a mistake and hit any keyboard key and the memo field data will get erased. is there a way to prevent such a problem? if not, is there a work around. eg, hide the memo field until...

How can i do the following? In a combo box, how can i type in say PEPPER and see every formulaName that contains Pepper in their description. I would get back Red Pepper, Orange Pepper, Black Pepper, Pepper, to choose from. Notice that Pepper can be anywhere inside the name. I would like the...

I have a Qry1 that contains a criteria of: Between [Start Date] And [End Date] I eventually use a crosstab Qry2. The wizard does just fine. but when i run the crosstab, i get an error message: "the microsoft Jet engine does not recognize "start date" as a valid field name or expression." Is...

i have a combo box on a main form. The name is cboFormulaStatus and control source is FormulaStatus. the control source is a Text field with 20 possible characters. The Row Source seems simple with: SELECT [tblFormulaStatus].[FormulaStatus] FROM tblFormulaStatus ORDER BY...

Need Different quotes after change to TEXT i have this qry field that works fine if my formulaID is a NUMBER field. UomUsageSum: Val(Round(DSum("nz([UomUsage])","[tblFormulaDetail]","[FormulaID] = '" & [FormulaID] & " "),4)) However, i just changed the formulaID to TEXT in my table. So I...

Dsum need 1 field inside divisor calc I have a Qry field: TotalUsage: Val((Round(Nz([UomUsage])/DSum("Nz([UomUsage])","[tblDetail]",),4)*100)) the problem is that the DSUM needs to sum up all the like records using the same SubID. I need some extra code in the divisor part. EG subID...

The following report method works on an old project but not on this one. I am missing a step somewhere. I have a Report Menu Form. I use Popup=Yes on all my forms and modal=NO. On the Report Menu form, i have 2 unbound combo fields to pick a customer SoldtoID and ShiptoID. I next hit my...

I have 2 text fields on my form named SOLDTONAME AND SHIPTONAME. Many times they are the same spelling of a customers name. To eliminate clutter from my input screen, i want to make an IIF statement. If the 2 names are spelled exactly the same, then make the ShiptoName form field empty...

Is it possible to create on my form a drop down combo box for just viewing purposes of table values? i want to manually enter my value but sometimes i like to look at my Standard ranges as a double check. I do NOT want the combo box values to come into the field. is there a way to do this...

I have a mainform with 4 fields which are marked with 4 primary keys: soldtoId, shiptoID, PlantId and formulaID. PlantID is a long integer number field and the other 3 are text fields. there is no default values. I have a subform1 that is linked by PlantID and FormulaID. These 2 field names...