Search results

You can simply close and reopen the form and user cannot even tell it happened or is this a subform?

So now you are saying the second combo box works filtering out the selection from combobox1 but when you go to combobox3 it is not filtering out seleciton from combo2? What is the SQL code for the query combo3?

One other thought I had is that maybe it is doing it one by one and not bulk? Does it do a bulk update or is it appending record by record within my query and/or macro?

you could have the data source be queries for combo 2 and 3 where criteria is not like and reference the previous combo boxes.

Hello, I was not sure if this post should be in the queries or macros section. Basically I have a few forms that users fill out and then the data from that table is appended to a transactionTBL and then deleted from the working table. From there it goes into inventoryTBL. All of this is done...

Hello, I am trying to schedule games of teams in the same league. I have four courts which play four nights a week. I do not want the same two teams to play each other more than once unless they must to fill the schedule, and in that case not the same team as the week before. I want to fill...

That worked perfectly using the left outer joins and that formula. THANKS!

Hello, I have three tables that have OnOrder, OpenReqs, and OnHand. They are not totalled by the primary key which is PartCode. I need to total each of them and then make a field that will include every part code from another table, RM Description Table, and give the inventory position for...

All the machines are running Access 2003. Some of the computers are using and MDE version of the file but the ones that are also running MDB versions of the file, as on my computer, are also giving the same issues. It is currently not split into front/back end. I deleted the calendar and...

Hello, Thanks for the reply. It is unbound, there is no recordsource for the calendar control.It is unbound.

Calendar control error loading events Hello, I have an activeX calendar.10 control on my form. It works fine on my computer but when I go to any other computer there are a few errors. First, it will not set to the default date of today. It sets to the date the calendar was added. I have...