Recent content by tomd1969
-
T
Enabling or Disabling Button in Details of Continuous Form
Yeah, that did the trick. Before calling up the form, I look at Count1 to make sure that it's not Null and used the Conditional Format of the TextBox to give a visual cue that it is not available. It looks a little odd, but it works. Thanks! -
T
Enabling or Disabling Button in Details of Continuous Form
What I did instead was fix the form that was causing the problem so that it would present a blank form instead of erroring out. :o Not as elegant as I would like, but it works. Thanks for your assistance. -
T
Enabling or Disabling Button in Details of Continuous Form
And Conditional Formatting is not available on a Command Button. :( -
T
Enabling or Disabling Button in Details of Continuous Form
This is a bit complicated, and I'm not sure if I can explain it correctly. I have a continuous form from which a user can look up a SKU and get to the forms that apply to that product number at that point in time, to sort of get an idea of the history of that SKU (each detail of the continuous... -
T
Query taking too long
Found a solution to this. It may not be optimal, but it works. First, I have to list all of the products and their Bins. This query is named "SKUsWithBin": SELECT CycleCounts.CC_ID, CycleCounts.CC_Date, CycleCounts.SKU, CycleCounts.PickLoc, Left([PickLoc],3) AS Bin FROM CycleCounts WHERE... -
T
Query taking too long
Nope. No dice. I'm getting: Here's the weird part: I tried to add a calculated field "Bin" in the CycleCounts table equal to =Left(PickLoc,3) thinking that might speed it up. I can see the calculated field working in the *_be.accdb, but it won't show up in the functionality file (the... -
T
Query taking too long
Long time listener, first time caller. :p I have a database that is split into two files. Let's call them: MyDatabase.accdb MyDatabase_be.accdb MyDatabase.accdb contains the functionality (forms, queries, reports, etc), and MyDatabase_be.accdb contains all of the tables and data that are...