Search results

Nz() How would I do that? w/2 queries? could you provide me with an example of the syntax

My query tallys the no of reject by plant and displays in a report, and this works great, but now it's a new year, only 3 plants have rejects (which is really a good thing), I need a 0 to display for the other 2 plants but don't know if this can be done, any ideas? Plant (5 possible) group by...

Got It Thank you, Thank you, Thank you

that doesn't work, any other ideas?

Help! I have a combobox combo22, which via SQL is hooked to tblMachineType w/many records for look up purposes. combo22 rowsource is selectdistict statement to SELECT DISTINCTROW tblMachineType.MachineTypeID. Its bound on the ID. The form displays the field type. This works great! but how...

My brain has locked up, I just added a field to an existing db and I need to to hold exactly 8 intergers / numbers; typically the first few numbers are 0's, but the 0 do not display; still using 97, what is the field size/format/ going to be? Thank you in advance

I have a cboplant , txttotalcost, txtboxMI, and txttotalcostCH. The combobox has an if statement, something like If cboplant = mi then txttotalcost = txtboxMI, etc. This works great, unless the user changes the cboplant value. In other words it works once..how do I get the fields to update...

No I'm not using value in the combo box to dynamicly filter a query. The fields are cboplant, txttotalcost, txttotalcostMI, txttotalcostCH. Form is based on a table. combobox uses an if statement; if cboplant = mi then txttotalcost (default 0) then txtboxMI = txttotalcostMI; if plant = CH...

I can't see to get a combo box to refresh the contents of a textbox. Depending on the value selected in the combo box one of 4 different textboxes get populated, via if statement, with a value from another field. It works fine except if the user goes back and changes the value of the combo box...

I have a form with fields plant (combo with 5 possible values) and ccost. I've had to add 5 fields fcost, ccost, bcost, gcost and scost. I need to populate either fcost, ccost, bcost, gcost and scost to populate depending on the value of the fields plant and cost. What would be the syntax...

SysCmd(acSysCmdAccessVer) How would you write the exact syntax / code? Since I use a switchboard I suspect it would be placed on the form load event, If SysCmd(acSysCmdAccessVer) = 9 ' Acc97 is if something diffferent msgbox "Please use access 97"

I tried that, the problem is when I do, the horitozal scroll bar goes away, and there are about 15 columns that need to show. Any other idea's

So they used the db splitter? how would you accomplish this with many db?

I inherented a bunch of db from someone else, I've created / maintained db before, but this one has me stumped, the creater has a db, dbA, but dbB and dbC and dbD get the login info from dbA, has anyone done this? How is it done? I guess I get the concept, only one has to be maintained...

I have a form set to a datasheet view. Everything works fine, but how do I stop a user from rearranging columns (moving them around? or hiding)?

spaces, dashes and underlines are invalid, how does one validation for these 3 conditions

I have a db, that I used to maintain as a end user, now it's in a multiuser environment, problem is the user has to enter job numbers. Below are all valid job numbers, therefore a mask will not work. So I was thinking "HOW" could this be done, perhaps eliminating Spaces, underlines and dashes...

pbaldy, it worked like a charm, would rather not use ADODB or DOA if possible, curious to see how it works w/2003 Fifty2One, sometimes you have work w/the crap they give you. Thanks all

I tried this audit trail code, using 2003 and it works great, I try and use it at work w/97 and it blows up: Compile error, user defined type not defined I assume the ADODB is the problem? How would I change / fix this to work w/97 Table called UserLog w/field UserName txt WhenUsed date & time...

Probably a dumb questions but I have acquired a db and the password field has the ***mask, is there anyway to determine what the password is? When I try to paste it in the password box it doesn't work. For what its worth A97