Search results

I have 6 spec fields because I have 6 separate fields that go to specific places on the labels (no pun intended - Spec refers to Part Specifications); Spec1 has to go to the upper left corner, Spec2 to the upper center, and so on. I probably could have merged the Spec tables but that would...

I'm also having problems getting a combobox filter happening. I am attaching what the forms look like, the VB code and the debug result. Layout looks like this: Main form Inventory Form InventoryDetail form Private Sub lblPackage_Click()...

I also had the problem of missing entries. I had figured out that the problem was with records not being found in SPEC tables. I just couldn't figure out how to set up the SQL to account for optional entries. NOW it works, this is what it looks like: SELECT I.Key, I.Barcode, P.Part...

I had a similar problem with a layout that looked like this Main form Inventory form (source is Part table) Inventory Detail form (source is Inventory table) A combobox at the detail level is bound to Inventory table; it is a query to a Spec table. The Spec values did not change...

I'm a visual person so it's going to take me a while to digest all that. Of course I thought of the term dynamic after I had posted the thread. I googled "access 2002 dynamic lookup" and fell on this: http://support.microsoft.com/kb/304302 It shows how to set up a dynamic select statement...

Here's an idea of where I'm going with this. My labels for the drawers look like this: All of them share the bottom right spec, package. That one is already implemented. Some of the specs like tolerance are shared by components like resistors and capacitors. Some are specific to a...

I don't what to search for (I'm a retired COBOL programmer), so I will describe what I need and hopefully it will make sense to someone. I am making a personal inventory for electronic components. I don't know the specs of components I haven't bought yet so I need complete flexibility in table...

Solved! It's not perfect, but I set focus on an invisible control on the subform and it works. Private Sub Form_Current() If IsNull(Me!Spec2) Then ' Check if heading is used Form_Parts_subform!Part_ID.SetFocus ' Set Focus on invisible...

I attach the database in case it helps. - Open Form Parts - Click NEXT - Controls on Subform enabled/disabled depending on heading Robert

Went all out with this: Private Sub CMD_NEXT_Click() Me!CMD_NEXT.SetFocus End Sub Private Sub CMD_NEXT_Enter() Me!CMD_NEXT.SetFocus End Sub Private Sub CMD_NEXT_GotFocus() Me!CMD_NEXT.SetFocus End Sub Private Sub CMD_NEXT_KeyDown(KeyCode As Integer, Shift As Integer)...

Private Sub Form_Current() If IsNull(Me!Spec2) Then Form_Parts_subform!Value2.Enabled = False Form_Parts_subform!Value2.Locked = True Form_Parts_subform!Value2.BorderStyle = 0 ' Transparent Form_Parts_subform!Value2.SpecialEffect = 0 ' Flat...

I have no clue how to do that. I googled "read the property values from a control" and found nothing useful. I did F2 while in Code window and found these: Property BorderStyle as Byte Property SpecialEffect as Byte Property BackStyle as Byte Property Enabled as Boolean Property Locked...

Hi, new to the forum so forgive the use of incorrect terms. I have a Form with embedded Subform, everything works well as far as moving through records. Scrolling through records on main table via Form brings up correct records of child table on Subform, so the link between the 2 tables is...

I am making a personal DB of electronics components and needed barcoded labels for hundreds of drawers so I can keep the quantities updated. MobiScan barcode app on my cell phone easily reads the barcode and copies the number to the clipboard. I ordered a mini-USB bluetooth dongle on eBay for...

Thanks for the generous offer, but I figured a better way from another thread here. (darn, can't post link, I don't have 10 posts yet) It suggests using NOW() in a DATE field. I feel dumb. I always timestamped records when I was still programming (over 10 years ago). I was looking for a...

I understand relational and hierarchical databases just fine. But there are situations when you might need more than 1 autonumber field in a record. I use autonumber as the primary key for an Item table, as I should. But I also need a separate autonumber to generate a barcode number in the...