Search results for query: *

Thanks Program Error, any chance of you providing the VBA, I'm just struggling to get the concept :( Form is called: frm_qry_slct Combo box (Unbound): Combo23 RowSourceType: Table/Query RowSoource:SELECT [Name] FROM MSysObjects WHERE [Type]=5 And [Name] Like "qry_#*" ORDER BY [Name]; Then...

I have a combo box, listing all the queries. Below that I have a subform (data sheet type) which I would like to populate using the query selected on the combo box. Thanks D

To simplify things, I want to create a combo box query, so a user makes a selection on the combo box then presses a button which then runs a query and the criteria will be based on the selection made on the combo box. Thanx

I basically need the VBA code for the problem stated. So I a user choses the month of April for example, the query will only show records which contain April on the month attended. Thank you. D

I have a query showing the following No. of Attendance Month Attended Customer Name 5 April 1 James Bond 5 Jan 1 James Bond 3 March 1 James Bond 8 Jan 2 Lily Bond 3 March 2 Lily Bond 5...

Thanx for the code, here's another problem The txtbox is not greyed out and only gets greyed out when I chose Agency 1,2 or 3. Is there a way of greying it out permanently and only appears when I chose "Agency Other"? Also if the txtbox wasn't greyed out on the previous record and I create a...

Thanx

I have a form with a combo box populated by a Table which contains a list of agencies. e.g. Agency1 Agency2 Agency3 Agency Other (pls specify) I have a text box next to the combo box and I want it to be greyed out and only enable it when the user choses "Agency Other (pls specify)" to type...

Sorry CoolFactor for the late reply, here's the website for the log in form http://www.databasedev.co.uk/login.html D

I have a button which runs an Append query when clicked but it shows a generic message box. I don't want my users to see the message box. I can disable this by going through Tools then Options then Edit and unticking confirm action query tick box but it only works on my machine and my database...

Finally got it working, thank you.

I found a user log in form online for MS Access which is very good which I've started using. Username (listbox) and password (textbox) are linked to the Users Table (containing usernames & passwords). What I want to do is create a user log which records when a user logs in including date and...