Search results

Ok Bob. thanks for the help

My understanding is that a Combo Box is limited to something like 65,000 records. My record set contains almost 250,000 records. When I increased the number of records for list, the comb box stopped the autofilter at record number 65,533.

Is there any way to increase the limit on the number of records that can be listed in a Combo Box on a Form?

Thanks alot. This seems to be working great.

I have a situation where I have a ComboBox with a Key (bound) Column called CustomerID, but the ComboBox is designed to sort the data by a Column called CustomerNo. Is there any way to get the ComboBox to automatically filter the data presented in the ComboBox by the CustomerNo Column, rather...

Thanks pbaldy. Your solution worked great!!!

I am sorry Pbaldy, but I tried what you suggested several times using several different variations without successful results. Can you repost the file I posted with your changes. It would sure be appreciated. Thanks,

Great! Can you re-post the db with your updates to this string please? This would help greatly. Thanks.

I am posting a scrubbed version of the DB here. Please see what you can do to fix. I want to automatically update the "PSR Header Tbl" for the fields below when I select the "CustomerID" in the "PSR Header Data Entry Form". Fields for Update: Address City State ZipCode Country Thanks again...

Thanks for the response pbaldy. I tried the solution you provided in your HTML which was the last option on the page. However, it is not working. The solution I refer to is below: If your situation is that rare one where saving the related info is necessary, you'd use the same combo. In...

Hello all. I am so frustrated. I have been trying to find a solution to this problem for days. What I am trying to do is default values into a primary table when select a primary key value in another table. Both the primary and secondary table have a field called "Cust_ID". The primary...

Thanks Paul. That worked really great. Jerry

Item is a Text Field.

Need help creating a DSUM Expression that will summarize quantities in a Domain where the Item is the same in the Item column. The Table being used as the domain contains several items, but I want a Running Sum for each item in the Domain, assuming they are all sorted in order of item and...

Tried logon to Myform - getting error I tried using the alternative approach in this logon form which directs the user to a specific form based on a column in the tblEmployees table and got the following error message; Run-time error '2467' The expression you entered refers to an object...

The solution proposed by DCrake worked extremely well. thanks for the help Feinj

Hey DCrake, The solution you provided above using the code from KB Article 210297 slightly modified works great. Much Thanks for the assistance, Feinj

I am trying to use and understand this program (LogUsersOffNonUse2k.mdb) and find that in order for the Log-off to work on other users, the users must have the form (frmLogOffafterNonuse) open. If the other users do not have this form open, they are not logged off. How can I make adjustments to...

kill File Function Hey Gary, Success at last. I did some additional experimentation and was able to use what you gave me and combine it with the DoCmd output from a standard macro with the OutputTo Action after having converted the macro to VBA. The function I ended up with looks like this...

kill File Function Thanks for the help Gary, I plugged in the following code: If Dir("S:\FEIN\Kanban Systems in Access\Kanban Oracle Interface\Kanban Oracle Interface.xls") <> "" Then Kill ("S:\FEIN\Kanban Systems in Access\Kanban Oracle Interface\Kanban Oracle Interface.xls")...