June7's latest activity
-
June7 replied to the thread Problems once a record is retrieved to a form.The_Doc_Man, I have no problem opening form and table at same time. -
June7 replied to the thread Form jumping around in records when i field is typed.Why does subform "jump around" - what code is behind control where you type check number? Is this an UNBOUND control?
-
June7 replied to the thread control variable.So txtPayment and txtReceipt are controls (textboxes) NOT fields.
-
June7 replied to the thread control variable.Then what are you referencing with frm.Payment and frm.Receipt? Select Case shouldn't be needed. Pass -1 or 1 as an argument and...
-
June7 replied to the thread control variable.Need quote marks? - "txtPayment" Also: Case "txtPayment" Since function RetAmt is not actually returning anything, why not make this a...
-
June7 replied to the thread Relationships.I advise not to use same name for primary and foreign key fields. One way to fix that is to use suffix, like: ComputerID_FK.
-
June7 replied to the thread Relationships.Yes, that is possible (something I have done). However, still not sure it is best approach for OP to repetitively save computer names in...
-
June7 replied to the thread To directly open the database.Oops, memory failed me, yes, just Shift key. That's why it's called "Shift Key Bypass"!;)
-
June7 replied to the thread To directly open the database.Bypass what menu? Use Ctrl+Shift when opening database to bypass automation settings. Then use LinkedTableManager to change link paths...
-
June7 replied to the thread Relationships.@plog, but if there is no Computers table that will mean repetitively saving computer names in Drives table. Names can get lengthy. Even...
-
What do you mean "put the unit price in the inventory item"? If you copied it there, of course it won't change. Your price table should...
-
June7 replied to the thread Relationships.I didn't quite follow about "eliminating the join". If you saved computer name into Drives, would not need to join tables. Query would...
-
June7 replied to the thread Relationships.You keep Computers table so you don't repetitively save computer name in Drives table. As I pointed out in post 5, saving text might be...
