Search results

For what it's worth, I have three machines available, one for development and two for testing. I do my development on a Win2000 machine using Access 2000. I convert backwards to Access 97 and test on three machines that run Access 97: Win 2000, Win 98, and Win 95. I have never seen a...

I have a split database. The path to the back end database is saved in a table. I want to let the user change the location of the back end so it can be moved, e.g., from its install directory to a LAN directory. The back end tables are linked when the DB is opened and unlinked when it's closed...

I have had this problem - I think the solution is to change the size of the help screen manually - but not maximize it - then close it. I'm pretty sure that when you close it at a larger size (not maximized) it remembers the larger size for next time. I posed this question myself a while ago -...

Kent, If you just want to have a single user of the DB you can reset the "MyAnswer" field in all the questions by doing something like ' DoCmd.SetWarnings False ' Uncomment to suppress warnings about update DoCmd.RunSQL "UPDATE tblQuestions SET MyAnswer=Null" DoCmd.SetWarnings True whenever...

Kentendresen- You could put a field in the questions table containing the correct answer ("RightAnswer"), maybe a number 1-4. Also include in the table a "MyAnswer" field. Give the radio buttons in the option group values 1-4, and bind them to the MyAnswer field. Now, at any point when the...

Bear in mind that Date is a reserved word in Access. (See ACC: Reserved Words in Microsoft Access .)In the expressions above, Access will behave unpredictably when it encounters the "Date" argument. If you express it as "[Date]" that may help, but I try to avoid using reserved words as field...

skate- If I understand your requirement, what I'd do is have an AfterUpdate routine on the combo box that sets the rowsource of the listbox to the base query ordered by the current value of the combo box. After setting the rowsource, requery the list box. When this works as you wish, be sure...

jrh- Dates are the work of the devil. First, when you set a date in the form field, are you using Now() or Date()? Date() would be preferred. Second, be sure the "Medium Date" format is specified in all tables that will contain the date in question, and in all controls bound to that date in...

The way I've done this is a little harder to code, but very nice for the user. First, define a form with a recordsource the table Dave/oldsoftboss suggested. The table would have the value of your "Quarter and Unit Location" combo boxes for its two fields. (This is NOT the same as your...

Two possibilities I can think of: First possibility: If Access 97 is installed on the user machine in addition to Access 2000, Windows will become confused (bet you find THAT hard to believe!) and will open either 97 or 2K, depending on which of the myriad ways the user finds to try to open the...

First of all, please note that Date is an Access reserved word. You should change the field name in your table(s). You might want to bookmark http://support.microsoft.com/default.aspx?scid=KB;en-us;q109312 which enumerates all the reserved words. Assuming it's now called MyDate: In the...

You can say Me.chkBoxName = somecondition where somecondition is an expression that evaluates to a True when you want the check box checked, and false otherwise. For example, if you wanted the check box to mean AccountIsOverDue you could write Me.chkOverDue = (Me.AccountBalance>0) And...

Try Format$(RecNo,"000000") for a six-digit return.

Check out http://www.bizfonts.com/free/ It seems to be TrueType, so ought to be usable in any Windows app.

Gail, I did a Google search on the msjt3032 + "page fault". There are some hits that suggest updates may be available. I think that module is Microsoft Jet version 3 or so - a pretty old version. You might see about finding a later Jet engine that's compatible with your version of Windows - I...

Is the rowsource for the listbox a query (SQL)? If so just add to the end of the query ORDER BY CityName so the query will look something like SELECT fields FROM table WHERE Province="Ontario" ORDER BY CityName;

OK - the problem is, the DBase characters coming in are encoded in some character set wider than ASCII (i.e., more than 8 bits per character) - possibly Unicode, 'tho I have no experience with Unicode. The numeric equivalent of a Unicode character can be obtained with the AscW (w-wide?)...

Gareth, Would it be possible to post at least a few (say 2-400) actual keys? I still believe if the keys from DBase are unique, and can be parsed apart in 8-bit chunks, you can use the conversion technique I suggested, or something similar. You might have to take the key field and convert it to...

Gareth, If you are using a 256-character code set (e.g., ASCII), the encoding is unique. It's easy to see if you think of it in hexadecimal. With a 5-character key, e.g., AbCdE, the hex value of the equivalent numeric key would be something like X'6192639465 As you can see, each character...

I think if it was MY database, I'd take the easy way out and convert all the key values into numbers: NumKey = 256*(Asc(Mid(AlphKey,1,1))+256*(Asc(Mid(AlphKey,2,1))+256*(Asc(Mid(AlphKey,3,1))+Asc(Mid(AlphKey,4,1)))))+Asc(Mid(AlphKey,5,1)) (The parens may not be right - count'em.) If the...