Recent content by neillovell

"1";"1";"2";"2";"3";"3";"4";"4";"5";"5";"*";"ALL" Selecting ALL returns the error message saying the expression is typed incorrectly or is too complex to be evaluated. Seelcting 1, 2 ,3 etc. is fine however. The row source type is Value List, in case that is important. Steps to reproduce: 1...

Using a column that has numbers in it, 1-5, I told the combobox wizard to use the first column as the identifier with the following 1 1 2 2 3 3 4 4 5 5 * ALL And when I select the bottom option I get an "expression is too complex" error Here is the Row Source...

So when I create a combobox I have two columns, the first is zero width, and has 1, 2, 3, * the second is the one the user sees, and that has the app name e.g. WORD, NOTEPAD, POWERPOINT, ALL like so... 1 WORD 2 NOTEPAD 3 POWERPOINT * ALL And so when the query fires it gets all records...

Sorry, I do not understand what you mean by adding an all option to the combobox Row Source. I have typed in <all> in different ways (with, without "", with/without <>) but nothing works - it treats it as a string. If you can tell me how to do this I'd be very thankful - I am currently writing...

Nevermind all the "holds more records, faster, more users at once" etc. I would like to know how much easier it is to do things. For example, right now in Access I am trying to write some VBA code to look at some combo boxes and based on those selections build up an SQL string (e.g. if the...

That's right, only saved queries. So in my on-click event code I'd need to save the query then run it... it seems a bit poor. I think I'll try it though. Thanks.

I can use VBA to UPDATE and INSERT entries into table, but what about regular queries? For example, I want the VBA equivilent of creating a new query from the Queries control panel, and running it (so the results appear on the screen). Here is some simple VBA code that performs a query, but...

No the source of the combo box is text typed in by me, i.e. I have written what options are available. Is it not possible to write code in VBA that puts the result of a query on the screen? I can write the VBA code to get the values from the combo boxes and perform a query, but I cannot show it...

Ah, a problem. If I have three combo boxes and I want one of them to have a choice of 'ALL' how can I do this? I wrote the VBA code to do this complete with if then else statements, but I am back where I started - I can't show it to the user! How can I present the results of an SQL statement...

I got round it by creating a macro: action-> Requery control name -> MySubform and in the VBA code for a button I have ' Run this macro which performs a requery of the datasheet on the form. Command12.OnClick = "RequeryMacro" Thank you very much for your help on this, I'll jot...

Ah, small problem. When I change the combo box, I get the message MSAccess can't find the macro ComboQuerySubform. It either doesn;t exist or it is not saved. It says when I put in the macrogroup.macroname syntax I must specify the macro's macrogroup it was saved under. Funnily enough, if I go...

No, the fields are all defined. Each row has several fields, one of which is AppName. The user opens the form, chooses from the list e.g. ACROBAT or WORD. and the code is supposed to return all records where AppName == ACROBAT for example. What I cannot understand is how, using my code, I can...

Thanks for responding, but I don't fully understand your reply. I need the user to set the AppName parameter and they do this via the form, and you think I can either use the button or the onUpdate event to generate a datasheet subform... I need to expand this form so users can enter other...

What is the command to show my query results to a user? Here is my code for a form with a button and a drop down menu, which the user selects a record identifier from e.g. to get all records that have AppName = ACROBAT, choose ACROBAT from the list. Private Sub Command12_Click() ' Create...

Ah, I can set the field type to be Date/Time then in the format property text box I can type 00\:00\:00\:00;00 and when entering times I just type 1988 for 00:00:19:88