Search results for query: *

I know that this has to do with a calendar object, but how to fix? Running Access97 on Windows 2000 and keep getting this error. Any help will be appreciated.

I need with making an addendum to some code. This code was created by someone else and being the novice that I am, I know what I want it to do, but am unsure of the code. This is how it currently stands: Private Sub Download_AS400_Click() On Error GoTo Err_Download_AS400_Click...

I have inherited a db that has a form with 8 check boxes for selection. These check box fields are Yes/No results and I can not change them. All 8 boxes are surrounded with a rectangular box and they were not created with the Options tool. What I need to do is create code that will cause the...

In my form there are three check boxes. Depending on the selection (1, 2 or 3) other fields got/lost focus, special effects, etc. Here is the code: ************************************************************ Private Sub Form_Current() If (test = 0) Then Forms!BTDENTRY!select = 0...

I am using Access 97. I have recreated a database with some major Table structure changes. Actually I normalized the table creating 3 tables from 1. Question: Is there a way I can export field data from the old db table into the new db tables. Example: OldTable NewTableComputer...

I must have set this up incorrectly. I have a date field that has a format of mm/yy and an input mask of 99/00;0;_ I only want an entry of the month and two digit year. When the information is entered, ex. 05/02, the table is updated with 05/02/2003. How can I fix this?

This is the brain dead question of the day. I have the following tables: CPU Monitor Workstation Dept Now, if I create a Query using all of those tables I can create one form that will update all these tables? AT least that is what I thought. When I use the form it indicates that the...

When I would use the combo box option while creating my form I used to get the combo wizard. Well I can not get it to work again. Did I turn something off?

I have a table that was created (after db in use for 3 years) and I need to add that table to an existing form. Can this be done? The form I would like to add this table to was based on one table and now I need to add an additional table. Thanks

I have reloaded Office 97 on my machine after removing Office 2000 (we have a mixture here and only use Access 97). AFter install I now get the following message: Microsoft Access can't start because there is no license on this machine. I can run Word, PowerPoint and the rest of the office...

Received help previously and now have another issue. I have a subform that creates a calculation that is embedded in a main form. In the control source of the main form I have =[Query].[Form]![Total Sections] This places the calculation from the subform into the field Sections of the main...

I have a subform that performs a calculation. Is there a way to make that calculated field write to another field in the main form? Right now the user has to transfer that information. Thanks

I have created a from from a query and used this form as a subform. I am not able to update\enter data in this subform. Any suggestions? I need to use this query as it does some calulcations for me. If I create the subform from a the table, I can do updates. Thanks

I have attended a class at the comm college on Access. I definitely did not go into the type of detail that I find on this forum. I have also taken a class at JMU on Database design. Can anyone recommend what type of classes I should look for so that I can use code and other options in...

In Excel there is a SUM function that you can list a range of cells to add. Is there such a function in Access? I have: Form1 (math function) Form2 (math function) Form3 (math function) etc for 35 forms I would like to have the sum of all the math functions to calculate. Now, I am a novice...

I am having a probllem creating a report that shows the calculated difference between two numbers. I am running this report from a query that allows a date range for a monthly report. Ex. Table: Machine, Unit, Date, Impression (There are several different machines(21, 15, 22, etc), each...

Can you make one report, using the information from two seperate reports? Senerio: Report 1 = Machine - Unit# - Counter - Date (for previous month) Report 2 = Machine - Unit# - Counter - Date (for current month) On report 3 I want to take the Max counter per machine, per unit and subtract...

Using a database that was created using a form. There have been no changes to the db or the structures. Today the form can not be opened, get an 3197 error indicating that the fields are in use by another. No one else is in the program. I have copied the form from the test db (that works)...

Does anyone know how to hide a date field and show a text field in a report. What I am trying to do - If there is not a date in the field, show N/A. Not able to hide the date field in the report.

There is a comment feature related to the cells in Excel. Once the comments are created, is there a way to export those comments into Access? Example: Excel 97 has a worksheet with comments attached to particular cells. I need to extract those comments and export them to an Access database...