Search results for query: *

I have a vertical scrollbar on subfrm_Ticket, and just noticed that when I click and hold on the slider is shows "Record 1 of 4." But as soon as I drag the mouse the slider goes from being a small slider (as if indicating many records) to a slider filling the entire area of the scrollbar, this...

I'm also having this problem, but might have more info to help us get an answer. (I have already checked the names of all forms and subforms, and they are properly being referenced.) I have four subforms, which are on a subform of a main form. Basically the user's main screen has five...

When you say characters, does that mean bytes? So if I have 3 Double fields in a table (24 bytes), then one page of data would consist of 83 (2,000/24) records? Maybe the fact I had such a hard time finding out about this online should tell me going down this road won't help me much...

Maybe I'm taking crazy pills, but I could swear I've seen references before to something called "data pages." I believe it was in response to people asking how many fields is "too many" in a table. I'm looking for specifics on them but haven't had any luck, but I believe they might help with...

I've never heard that expression before, "Deep is better than wide." Not to nit-pick, but I wonder what the cut-off is, or what the thought process is behind that expression. For example, is it better to A) have 20 fully normalized tables with an average of 3 or so fields each and about 10,000...

All good points about separating drivers and vehicles. This database is actually a supplement to a larger full-fledged web app created by our full IT resources. I'm just the one-man show that gets to make these databases to fill the gaps. Drivers and vehicles are stored separately in that...

I generally get around record locks by having users edit data on forms tied to temporary tables, then update queries being run to change the live table when they 'Save' their changes. We haven't run into any problems with that approach. The more normal the data, the better for storage...

Thanks Dontremb. I'm only dealing with 20-30 fields at the most in this table, and there is a one-to-one relationship with the data. I guess I was just wondering what the magic number was regarding "too many" fields. I've made a handful of databases before, and they all run into the same...

I'm trying to find the right balance of normalizing data. I know the basics like separating customer info into one table and the vehicles that belong to those customers in another. But within that, should I have two vehicle-specific tables, one for VIN, license plate, etc, and another for...

Go to Control Panel > Internet Options > Advanced tab. You should find a checkbox with the caption 'Reuse windows for launching shortcuts.' If that is checked it should open the link in the existing window if there is one. No clue how you'll change that setting if you need to, but maybe this...

As I understand it...when the default printer is b&w, Excel will always print b&w, regardless of what printer is selected in the print menu. So on the Print event I'd like to store the current default, change it to a color default (our pdf converter should work), let them choose their printer...

Thanks Tony, As much as I like an easy answer, I'd feel less like a moron if it was at least a little more complicated. :( So I copied the microsoft.com code directly into my project to avoid my changes completely. But now I get the same error --Run-time error '13': Type mismatch-- on this...

I'm trying to retrieve info on the user of whatever machine is running my code. From support.microsoft.com ticket 179083 I found the code at the far bottom (I trimmed 20 or so extra fields in the For loop to save space). But I need to use this code in Reflections (or any program other than...

Thanks DrBowes, but I tried Application.Interactive = False and it wasn't recognized. I searched for 'interact' in VBA help and couldn't find anything helpful. I'm in Reflection v9.0.3 and Windows XP, so I'm using the Reflection 9.0 and Visual Basic 6.3 if that helps at all. Thanks again, Bob

I'm trying to find a way to prevent user input via the keyboard in Reflections VBA. I use WaitForEvent rcEnterPos... quite a bit in my code, to the point where I don't think they'd have an occasion where they would want to type anything. But I've written programs in the past where users type...