Search results

Workin for me now cheers mate!

Im running some VB code when you click the cmdSearch button on a form the code is pretty basic but i need to take values in from my Supervisor and Months combo boxes on the form how do i write the code to take these values from the form so VB knows what they are.

Nah mate this doesnt work its asks me to enter a parameter value enter date field here: I put in a date then it asks me to enter a month in numeric form which i did and it returned nothing

I want to be able to search my table with a query in which it instructs the user to enter a month and it returns all the values in te table for that month. the problem is that the date values in the table are in the form 18/08/2006 Is it possible to do this sort of query

i have a table which contains the attendance records for employees. It shows their supervisor their name aemp number and which kind of hours they worked basic, overtime, Been late and absent is all recorded here. Supervisor Emp No Surname Forename Code Value JENNIFER BUCKLEY 200 McCormack...

thanks bud ill work with this and see how I get on

No sorry its Access 2000 any tips on where i could find some info on what i want to do.

What is this piece of code actually doing ive typed it into vb and getting an error on the Set rs = Me.RecordsetClone

Hi I am trying to populate text boxes with data from a table. The type of data is dependent on what name you select from a list box. if the user selects a certain name from the list box i want to populate the text box with certain information about that person from the table that his/her data...

I have a list box and three text boxes on a form. the list box contains data about an individual. I want to be able to select a certai individual and populate the text boxes with info from the list box any ideas on how i go about doing this?

I have a list box on a form which is populated with data. I want to be able to click on a record and when i do it will fill text boxes on the form with specific data. anyone know how i would go about this.

Thanks very much mate, have a guddin!!!:D

CHEERS MATE!

how do i code the yes no command sin a msg box i want to code if its yes then ************* if its no then ************* how do i go about doing this

I have a form which allows the user to search for a name in a dtabase and display the deatils in a different form in a list box. the code i used to write the search method seems fine but it keeps giving me an error. the code is here as follows Private Sub Command49_Click() Dim strSQL2 As...

that sorted it for the moment i can use it til i try and find out how to do a search cheers!!:) :)

I was looking for help to find out how i would put a search facility on a form Ive written a query with a parameter where you input a persons name in order to find it in a table the porblem is when i base a from on this query it brings up the parameter asking me to enter the name, the query...

i want to have the date in my report which is in letter form in the following format 21st July, 2006 22nd July, 2006 15th July, 2006 etc etc How do i do this I have it set up but its coming up like this 25 July, 2006

i want to write a query where i ask it to update a table where the text is like "Ack. Stamp" And the lenght is less than 15 how do i do this

is there a way to stop duplicate values appearing in a query result. i querying a table but i dont want to see the same value twice ca i prevent this?