Recent content by shankbanta

Isn't there a way to set the code so that it adds to the fields at the end of the database. Mimicking the >* button and then fill in the fields on the form?

Got it. Added ActiveX control for calender. Thanks

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 can change them into option buttons but is there a control to change so that only one out of the eight can be selected?

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...

As a newbie I use the export (table, form, ets) and browse the path to the needed db.

Thanks. Everything works like a charm.

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...

Well it did not keep it format. New Tables: Computer ->ComputerID, Asset# Monitor -> Monitor#, Asset# Workstation -> User, Location Hope this clarifies things.

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?

Tested the query and forms. Forms will update with cpu and workstation query and also with monitor and workstation query but not all three together.

OK, so can I force a one-to-one relationship? tables CPU - PK serial# FK WorkstationName Montior - PK Serial# FK WorkstationName Workstation - PK Name One CPU and one monitor make up a workstation. Workstation has a unique key of Name Name is a foreign key in CPU and Monitor. Join...

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...