Search results

...Quick Follow-up Thanks for the responses. I appreciate the information... I have already installed XP on my computer...Will it be sufficient to uninstall it and then install 97 followed by reinstalling XP?

Hello. I am trying to install Access 97 on a machine that currently has Office 2002 (XP) installed on it. I have searched and found information about installing Access 97 on a machine with Office 2000... Has anyone successfully done this? Should I follow the same directions for installed...

Yes... It is possible. On the IMPORT form that pops up when you are importing objects from one Access database to another, click the ADVANCED button and it will display some additional check boxes...Ensure that the IMPORT RELATIONSHIPS button is clicked... And obvisouly, ensure that you are...

Create a new Menu Bar... Yes, this can be accomplished. 1. Create a new Menu and name something Specific to the Database (i.e. "My Menu). There is no need to add any buttons to the menu bar since you will be hidding it. 2. Under Tools|Startup change the setting of "Menu Bar" to be your...

I am attempting to save a report as a pdf. I have the code working that changes the default printer the Adobe Writer and then prints the report. However, I would like to bypass the Save As dialog box in Adobe Writer and have the report print (save to a specific location). I understand that...

Thanks... Thanks WayneRyan... I did not know that I could reference the field using the field number. So thanks for that information. In the end, I used a Select Case to determine which field was calling the function and then reference the apporpriate fields. Thanks much.

Any thoughts... Well, no replies to my questions...So, either it can not be done or it is beyond repair. I am still looking for a solution...Any thoughts would be greatly appreciated. Thanks.

I am using a recordset to retrieve data from a table. Because I need to retrieve data from a number of fields within in the table (depending on the contents of a number of textboxes), I have created a function that I call when these textboxes are exited. Into the function I feed the value of...

Hello. I tried to find a solution to this problem, but really couldn't even think of a way to search. Basically, I am filling a number of textboxes in a report dynamically when the report is opened. Based on the length of the text in the box, I want to fill the remainer of the textbox with...

Problem is with Calender Class After some research it appears that the Calender Class code that I am using is the source of the problem. I took the calender code and decompiled it by itself and the same problem arose. Interesting...

I tried that... ...with no success. The same error(s) persist to the new mdb container. Any other ideas? I might have to resort to the backup version, however, that does not resolve my performance issue (with the database :D ). Something about this database just doesn't want to be decompiled.

Hello all... In an effort to increase the performance of my database, I used the decompile feature in 97 to, well, decompile the database. I have used the feature before with no problems. However, this time it created multiple problems. Namely, when I try to complile the database I get and...

Redundant Data Storing calulated fields in your tables creates redundant data...Why store data that can be derived from other fields.

I got it... It appears that the % sign at the end was messing things up. So, I just trimmed off the % sign and the Val Function does the rest. Strange that the % would do that. OK. Thanks.

Hello all. I am trying to convert the contents of a textbox from a string to a number in order to test the input values. I am using the Val Function and it works great when the contents contain no decimals. However, as soon as decimals is entered, things go wrong. Here is the code...

Thanks for the response. The query is not being built via SQL in Code. Rather, I have created a query (which is the first in a series of queries used to get to the final product) using the Design View. Does your method still work, since I am not creating the query in code?

Hello. I am attempting to base a complicated query (which I do not create in SQL in code because of it's complexity) that has a number of parameters that are pulled from a form. The query works like a peach as long as a value is selected in combobox. The problem arises when the user does not...

Hello... I have a query that returns a number of fields from a table, i.e. Effective Date Employees Premium Increase ETC.... Sept 2002 22 $34.00 10.56% Oct 2002 24 $54.00 13.56% Now, I want to create a report using the query. The catch is...

Thanks for the Reply...Yes... After seeing the suggested workaround...I am thinking that your method of only locking the textbox may be the solution...I had tried that and it worked fun...However, I thought I would at least ask if there was another way... Thanks for the sugguestions!

Hey Pat...Yes... ...there is a checkbox associated with the textbox that allows the users to "reactivate" the textbox. I know it sounds sort of hoaky, but I am not working with the brightest users... Any Ideas? P.S. How are things is Stratford? I actually do not live there anymore...