Search results

It seems to be that if User A has a form open with a lstbox populated by a query), then if User B tries to open the same form (from a copy of the database), it hangs until user A closes the form. The underlaying tables are in a master database and using snapshot seems to ease this problem.

Thanks DCrake. I wanted to set it to Snapshot so that multiple users could view the data at the same time. I guess ill have to create a seperate query and link it.

Hello, I have a list box with SQL as its row source. I keep editing the properties of this SQL (in qry editor), to show Recordset Type Snapshot, but for some reason if I close then open it again, its set back to Dynaset. Does anyone know whats going on? Thanks

Thats great! Thanks very much!

Of course! I change the name - Access didnt like it for some reason. OK guys... almost there. I naw have it running, but its only selecting 1 item from the list instead of all items. What else have I done wrong? LOL Thanks

Thanks Rainman. When I run the code with that bit done i get a debug on the row "SelectAll = True" saying compile error on left side of assignment must return varient or object. Do you know what that means? Thanks

Thanks - Ive seen this already (spent ages on Google), I cant seem to get it to work which is why I asked here... My first problem is "Argument no optional" on the Call SelectAll line.

Hello, Can anyone tell me how to select all items of a list box? Thanks

Hello, Im having a problem with RunTime error 2495 – The action or method requires a table name argument. My code is supposed to run in a form, call a public function in a module to select a save location, then return to the form code to export a file. I have the public code as a lot of forms...

Hello, I have a table with a Yes/No field and a Date field. The data in the table already exists and only the Yes/No and Date fields are empty (so that the user can check off whats been done). I want to have the table so that when the Yes/No field is checked, it shows the current date, and...

Thanks DCrake. Im still having problems with this though Now I get Run Time 3075 - Syntax Error, missing operator (in my WHERE clause) My latest code is below... Im getting myself confused with this.

Thanks DCrake... this is the SQL currently with no '. This transfers to QRY but with odd columns. If I add ' then it debugs.

Thanks DCrake. If i include " or in this case ' as its SQl in VBA, it debugs with 3270 property not found. Where as if I just have the numbers it makes the query with the odd columns...

Thanks for the link - thats were I was looking already... but I get a problem.

Hello, Im having a problem sending multiple items from a lstbox to a query. The query is QueryDef, and the SQL is below. Criteria is the data from the lstbox. I've put a msgbox it which shows my lstbox (Criteria) giving me 48 or 49 Or 50 (which is what I expect). When I run the query, it...

Thanks for all the advice guys. The query isnt a new one but I added the refresh anyway and still get the same error. The field is reporting_office not ID. and as there are 2 offices with the same code (but a differnt sub code), I added the iif statement to deal with it.

Its not that SQL thats causing the error. This works. The problem I have is in VBA where the querydef is created. When I try to set the parameter it debugs with Run time 3265 - Item not found in this collection

The expected SQL will look like With a WHERE clause in showing WHERE ID = [Reporting_Office] but I havent added that in yet cause I cant get past the Debug yet...

Hi DCrake, Just tried the revision and still debugs in the same place. The goal is that I want to export data directly to an Excel template (ive done this with a few other things and it work as I want). I have several listbox that a user selects options from. Then when the click a cmd button...

Thanks DCrake… This query can only run when the form is open and a selection is made so I think that will be OK. It seems lots of people on the net are having this same problem… I just cant find one with a solution yet…