Recent content by mcgooie

Does anyone know if its possible to change the data type of a field from "Text" to "Number" by using a macro? thx

just realised my mistake when i submitted question. i should have used Like "A*"

Im looking to have a query that selects the "NAME" from a table "tblPeople" where the NAME field begins with "A". Ive tried using WHERE tblPeople.NAME Like "A" with no luck. Can anyone help me out, im sure im missing something really simple.

Using access 97, does anyone know how to have a macro run a query and save the data produced by the query in a table with the name "query 08/11/06" i.e. "query + currentdate" thanks

Dont know if its possible but no harm in asking. Can the caption for a form be set to the value of a text box i.e. "Text10" for example? cheers

i have 2 combo boxes on a form and a button to add a new record in a table. i am trying to add code so that if either of the boxes is 'null' that an error message displays and the code ends so that a partial record isnt entered into the table. i think the solution is adding a line somewhere to...

i have a combo box reading in two fields from a table - id and name. Is it possible to have "autofill" pick up the name but when i make my selection, the id becomes selected. i.e. if i have these: ID NAME 1 Pete 2 Dave 3 Alan and i type in "Dav" and press enter, the value in the combo...

I have a checkbox on a form (ClientDetails). the form also contains text boxes for "ClientID" and "ClientName". The values for these come from a table called 'clients' I want the checkbox to be TRUE if the ClientName on the form appears in the "Client Name" field of another table called...

nvm found it :D

where is the "On Load" function?? i can only see "On Enter" and "On Exit" under the Event tab? thanks for code btw

i have a form with a subform on it. the subform has 2 columns - one of which is hidden. Assume the other column is called "type". i was wondering if there is an easy way to 'hide' records in the subform which have "type" = "Car" thanks