Recent content by bruced3846

OK, I have an ADP that works fine on my desktop, have an OnKeyPress event for vbKeyReturn in a listbox to open a form with the selected record displayed. Transfer the app to a laptop and the enter key advances to the next control. In debug on the laptop when going from the search criteria box...

Workaround Pat, I am way too far in to recreate the wheel using an MDB. I tried converting to VB6, but the best program I can find is not too good... 17 pages of uncoverted code. Here is what I ended up doing: I created a form for all the fields and call it in add mode from a command...

No fix for cascading combos? Well, what I finally ended up doing was creating an extended detail form fpr my data entry, and calling it from a command button on the form. This way the cascading combos are in a single form, so the single query is fine, and the values stored in the table show up...

Pat, I am probably guilty of over-enthusiasm and under-education. I thank you for your comments. If you are talking about a form in datasheet view, it works the same as in continuous view. If you are talking about viewing a table or query directly, you can't use cascading combos because you...

Tim, Thanks for the test database... I am using an ADP, not an MDB, so a lot of what you did has no exact corollary. In the Product Table, have you set the Lookup for the Color and Size fields Display Control to Textbox or Combo/List box. In ADP's there is no "Lookup" tab on the table...

Hmm... you mean you have a logon screen, they enter username/password, splash screen pops up, and when you close popup the logon is STILL displayed? If so, you could do something as an [Event Procedure] in the OnClose event of the splashscreen to close the logon form. An abundance of caution...

Why not ... Since the only if condition for the primary is password, and the first column number is 0, then password = combo10.column(3) If Me.Password = Me.Combo10.Column(3) Then If Combo10.Column(2) = "Manager" Then DoCmd.OpenForm "frm_Splash_Screen" If Combo10.Column(2) = "Clerk"...

Tim, Thank you again for the continuing replies. You asked: "What colours are you expecting to be in the list, obviously not just the ones associated with the individual the item, 'pen' or 'hat'?" - No, all colors associated with the Supplier of that product. Do you wish the list to...

Pat, Thank you for the reply, I arrived at this forum via a link to that very post that someone else gave me on a different forum (with a note saying how great YOU are, by the way). I see where the solution you propose is useful in continuous form view, but I still have a problem with...

OK, I am probably not describing this correctly, let me try again. The problem is NOT poplulating the 2nd and 3rd combo boxes. I can do that several different ways, nor is the problem the unit price, that works fine. I probably gave too much info at first. The problem is the when the user...

In the microsoft article is says the resolution is to not hide the bound column, so when you only want to display the id field you are doing just that. The problem I have is that normalization procedures call for a unique id on each record, and if I do that then I have to hide to bound column...

Not sure there is a way around it. Been looking for two weeks, tried every event and still no luck. I may have to abandon normalization and store duplicte data in my details table - if I can even get around it that way. Because I want to use a combo box to display the possible choices, the...

Tim, Thanks for the quick reply, but according to microsoft in the article, http://support.microsoft.com/default.aspx?scid=kb;en-us;208866 , the resolution is: "Do not hide the BoundColumn field. If you want to see a different column, use the DLookup() function or the AutoLookup technique to...

I am having a similar problem - just posted a new thread, "Cacading Combos in DataSheet view". The problem with cascading combo boxes tied to a query (at least as far as I understand it) is that there is only one query for the form, so when you select a different ClientID, the subset (query...

OK, here is the problem. I have the following tables: Customers Consignment ConsignDetails Employees Products Suppliers CompanyColors CompanySizes and I am creating a form to view the items currently on consignment with the customer. I have the main form 'Consignment' that holds the...