Search results for query: *

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.

...DoCmd.SetWarnings False DoCmd.OpenQuery "Append AS/400" Me.Refresh DoCmd.SetWarnings True Me.RecordSource = "select * from [BTD1];" Dim R As Recordset Set R = Me.RecordsetClone R.FindFirst "[JobNum] = " & Chr(34) _ &...

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.

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

OK. So call me stupid. But, evidently you make the option buttonm first and them frame it. Never realized that I did that in the past. Things that make you go hhuummm

Using Access 97. I have not turned anything off so do not know why it is not working. Went to help and could not find a way to turn it on or even use it.

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?

Nope, this form was not based on a query. It was created straight from a table.

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