Search results

Hi, I am trying to make a query from fields out of 3 tables. All tables must include following fields: Table 1 fields: WR04 (year 2004) Date Reporting Person Table 2 fields: WR05 Date Reporting Person Table 3 fields: WR06 Date Reporting Person I am trying to pull together in the query any...

I have a form with several fields where a ref number such as AB1234 may be entered in one field but this ref number may also be entered in another field referring to another order. Using 'Like[RefNumber]' as a criteria is only returning ref number from one field when same number may be in...

Code: cboNumber1_AfterUpdate() Me.txtPerson1 = Me.cboNumber1.Column(1) Me.txtEthnicOrigin1 = Me.cboNumber1.Column(42) Bound to Column 1 table field 1 = Number table field 2 = Person, table field 43 = EthnicOrigin I had this running ok until importing fresh table data now I get run-time error...

Table field (primary key) data type:Number How can I validate / symbol as in 05/01 representing year and 1st record, etc. Many thanks in anticipation.

I am trying to create an MDE within A97 but I get "compile error message in a hidden module" Form....... I experimented with a timer function for auto close down of a form but abandoned it. I thought I had removed all the timer controls but it seems they are hidden preventing me making the MDE...

Try this one guys, I have a form based on a Query with Comboboxes reading a Table. the Combo's populate Textboxes with code as: Private Sub Combobox1_AfterUpdate() Me.Textbox1=Combobox1.Column(1) End Sub Combo bound to column 1,Row source=table. This was created in Access 2000 and works fine...

I have a Combobox on a Form reading from a Query, which autopopulates a textbox: =[MyCombo].Column(1) This works fine on Form but data from textbox is missing in Table & Query. Combobox has Row Source from another Table,if I change this Row Source to the Query the Combobox data is messed up...

I am trying to set up a copy & paste by the 'double click' command from a list box to a text box. The list box gets its data from a table with two fields which is ever changing and updated daily. Running Acc97 I would appreciate help on this. Example attached.

I have set up a Quit Database macro using the 'On Timer' property for a form, as the database is used on a network causing conflict problems when entering data and open on two or more machines which may be idle. Is it possible to make this quit after a period of timed inactivity?

From my example, Can someone help me or demonstrate with the example how to multi-select names from the ListBox field on the form. As can be seen,the names in the ListBox come from Table1. Also, the record is showing 1 of 13(because of the number of names in the table) when I wish it to be 1 of...

Hi, How do I capitalize all letters of an entry in a form field? I have seen the CApitalize help files for first two letters but wish to capitalize all letters when entering a name. Thanks

Created a list box on a form & multi-selecting a two column list from a table. When moving to create a new record the list box displays previous selections as 'active'. How do I set it to clear these selections for the new record? :confused:

Hi, I am new to this forum & hope I am using correct section. Is it possible to use a combobox on a form which can be built to multi-select from a table field?