Search results

I have a table with 2 fields (for simplicity). These are called ID and Accuracy. Accuracy can have either "Correct", "Major Error" or "Minor Error" as a value. I want to create a report with Accuracy as the criteria which I am doing with a combo box on a form so the user can select one of the...

OK. Thanks Mile-O-Phile. That answers my question.

It still changes all of the records in the continuous form. It also only seems to work if the first record is checked, the others don't make any difference. My mistake, it actually works for whichever record the cursor is currently on, but it still changes the detail background colour for all...

Thanks. That does work to change the colour of the detail background but it does it for all the records in the continuous form, not just for the one that is checked. Any ideas?

I have a continuous form set up with text box (called text_1) on it which will either contain a 1 or a 0 (for simplicity sake). I want to change the background colour for the detail section of the form based on whether my text box contains a 1 or a 0. I have found a couple of posts for changing...

I have some code in Excel that allows the user to open a .lis file, it then creates a new workbook and formats the information how I want it and then gives the user the option of where to save the new file. I have a message box which is supposed to pop up if cancel is pressed on either the open...

Thanks very much dcx693. That has worked a treat! Thanks for your suggestions as well Neil.

I have already got a reference to Microsoft ADO Ext. for DDL and Security but I am using Access 97. Is that likely to be where the problem is? If you could show me how to do it using DAO (if that will make it work) I would greatly appreciate it.

Please ignore my last post, I've now figured out that I just needed to select ADO in the available references. I now get a 'Variable not defined' error for CurrentProject.Connection Thanks Neil. I'll have a look at that if I can't get this to work.

I've tried that code but I get an error when I try it - 'User defined type not defined.' for the three ADO declarations in this code. Private Sub Bulk_Update_Query_Click() Dim cat As ADOX.Catalog Dim cmd As ADODB.Command Dim vew As ADOX.View Dim strNewQueryName Set cat = New ADOX.Catalog...

I want to use the selected values from the list to go into a select query so I can display the records relating to those values. e.g. Table ([Employees]) contains [Employee_Name] and [Employee_ID] and I want to display both these fields, but only for the records selected from my list box with...

Thanks. How do I then get that comma separated list into a query (or table)?

No problem Neil. Hopefully dcx693 or someone else can come up with the goods.

Sorry dcx693. You must have posted while I was writing my last comment. You're right. I do need to select more than one value.

Sorry, I might not have been clear enough in my original post. I have the form and my list box, and a button to run my query which would work fine with a non-multi select list box, but I need it to work with a multi select list box which, from reading other posts on the subject, requires VBA...

Help!!! I need to create a query which selects records from table [Employees] where [Employee ID] matches [ID] selected from a multi select list box on a form when I click a button on my form. My list box is called list0. I have found several posts on this subject with samples of code etc. but...

I have a report with a subreport on it. Sometimes the subreport runs onto the next page and I want to show the same headers at the top of the next page when it runs over, I can't get the subreport page headers to display on the main report though. Can anyone tell me if this is possible, and if...

I have two seperate tables, say table x and table y and I want to produce a report containing information from both. Table x has a list of targets each belonging to one a group either A, B, C, D, E or F. Table y has a list of Actions each also corresponding to a group A, B, C etc. I want to...