Search results

Dear abby (yeah I know, I'm awful), you read the question right. Dlookup is the correct way to do it, I stumbled on it yesterday actually.... ...just responding to let you know that you were right. Thanx anyway, wrek.

Hi all, I have a table Preparer List, with two columns - User (primary key) and Computer. (eg. [John Smith, 3P15], [Jane Doe, 3Q14]) I've got a login form on which there is a combobox showing all the preparer names. LimitToList = No, because I want any user to access it. I've also got a...

Hi Pat, I've restructured my queries to reflect what you've suggested - making one Master table, with an additional ID field. That was helpful. Thanks. One more question though. Should I attach the subforms to the master table (the recordsource, I mean)...or should I make a query pulling...

Isn't there a way I can execute SQL statements through VBA? The Execute method accomplish this?

Hi Pat & others, Here's why I can't make just one table: http://www.angelfire.com/pw/access/MakeTableprob.doc

Hi, Someone please tell me that variables can be used in SQL statements? Is there any possible way? Heres the SQL: SELECT [Equipment Docs 1].EQ_COMPONENT_TAG, ORSUSR_TIDECDRW.DOCUMENT_TYPE, ORSUSR_TIDECDRW.DOCUMENT_SUB_TYPE, ORSUSR_TIDECDRW.DOCUMENT_NBR, ORSUSR_TIDECDRW.DOC_SHEET_NBR, Null AS...

I think you misunderstood. ASS_EQUIP 0,1,2,3,4 does not refer to Associated Equipment Number1, Number 2.... It refers to the Associated equipment that each part has (only 1 for each) for each Unit - namely Unit 0, unit 1, unit 2 etc. for the Nuclear Plant I work for. Ass_Equip is just another...

(0) = "RecID" (1) = "SAFTY_FUNC" (2) = "UNIT" (3) = "EQUIP_CODE" (4) = "UNITS" (5) = "ASS_EQUIP0" (6) = "ASS_EQUIP1" (7) = "ASS_EQUIP2" (8) = "ASS_EQUIP3" (9) = "ASS_EQUIP4" (10) = "MANUF0" (11) = "MANUF1" (12) = "MANUF2" (13) = "MANUF3" (14) = "MANUF4" (15) = "MODEL0" (16) =...

Hi guys, I have a table with about 40 fields. For any given record, usually only about 3 to 10 are populated. Is there a way I can run a query of some sort to eventually populate another field in that table with: "Stock Number, Quantity, Dosage" So in essence, this field tells which of the...

Hi Access gurus, How do I set a certain field to be a primary key, when I construct the table using a make table query? Is there a VBA property for primary key? Thanks. your disciple, wrek

I have a table(s) with layered codes and subcodes in them. Here's a sample: http://www.angelfire.com/pw/access/Nested.ppt I need to be able to have a QUICK, efficient way of displaying this information, starting off with displaying the Level 1 code. If a user double clicks that line item, I...

yep...sure: Private Sub GetDocs_Click() Dim stDocName, stdocname2 As String Dim stLinkCriteria As String 'Me.MANUFACTURER_CODE.SetFocus stDocName = "Manufacturer Docs Make Table" stdocname2 = "SubForm Retrieve Manuf Docs - Change" DoCmd.SetWarnings...

I think the solution to this one should be fairly straightforward....I had this problem once before, but I got around it by not using a button (I made the user double click the line item).... Take a look. http://www.angelfire.com/pw/access/subproblem.doc Thanks.

No, I suspected that too, so I checked that pretty carefully...Facility and Unit are in there twice but with different sources (you respond pretty damn quick, you monitor these boards or sumthing?)

Don't mean to become a pain on this board but.... I have a report with the same name for two different fields: Facility and Unit. They are two different controls and have two different sources. So the source and the names of the fields are: Change Data.FACILITY & Change Data.UNIT &...

The subreport is of a constant size...so the cangrow and canshrink wont affect the total report size...setting the fields to null, now you might have something there. Thanks. (Btw, I'm a graduate working for a nuclear plant....all that gibberish you see is nuclear safety credit...

Hey Rich, thanks for your input...here, I made a little graphic to clear it up... http://www.angelfire.com/pw/access/Pagenumprob.doc

Pixels, semantically, I guess would be an incorrect unit of measure in reports. But Access uses the same measure for their forms and reports (in the VB module at least) But the reason I can't use a generic Page N of M in the footer is because the 'maximum length' of my report is probably 4...

Hi guys, I have a report that uses a position variable for its controls (they are user defined so I give them the option of which ones come out on the report). I use the .top property to do this, but I was wondering if anyone knew how many pixels (unit of measure for .top and .left) make up a...

Hi guys, I have a subform on my form. But I don't want it to load unless the user hits a button (the underlying query for the subform takes forever to load, plus the data is optional). The subform currently loads on the Form Load. I guess I could make it a regular second form opened with...