Search results

Cheers for that George.. Works like a dream now...

Ok well that worked.. However when I ran the form for a second time it faulted and told me that the query already existed.. How do I delete the query once its been made?

ah i follow now.. I thought the querydef WAS the query name.. which is probably why it wasn't working

No it doesn't exist.. creating the file isn't the problem, its the command recognising the query

Do you mean in the query builder?

Ok, this is what i've got so far.. The error i'm getting is that the datatype is invalid.. So,i'm guessing that it doesn't like me passing in the query def as the output object.. I tried acStoredProcedure, but had the same result.. outputSQL = "SELECT tbl_Approval.ChangeNumber...

Hey, i'm trying to output a query i've built in code to a excel doc, but failing to get it to work.. Im trying to use the docmd.outputTo command. I've tried creating a querydef, but can't seem to get it to work.. Does anyone know how I can do this? Cheers

Yeah i've been doing SQL for quite a while, and mostly do it by hand.. I reckon i'll master visual studio next.. and probably php as well since they both seem to be fairly popular.. Probably leading into .Net (still have to figure out what .Net actually is first) Is crystal reports worth...

Hey guys, I've been working on Access for a little while now, and my job here is about to end soon (hired through a recruitment agency). After playing with databases for a while, i've grown to like it, and i'm contemplating furthering my knowledge in the area, thus I was wondering if people...

I finally got it working by changing the end of the string to & "))" Most random.. Cheers guys

Yeah i'm kind of forced to do it this way george.. the list is for people to contact within a department... Currently I have a query which just pulls people by their name, so the WHERE clause is "Tom Jones", "Frank Peters" etc this is done in the query builder, using a custom expression...

Hi, if I have a table field with a line of ID's like 323 OR 234 OR 12 OR 654 OR 1232 (memo field) How would I incorporate that into a WHERE clause of a query? I tried WHERE [userID] = [groupIDs] but that just confused access and the query wouldn't open or display the datasheet Cheers :)

I'm looking at moving my db to a SQL backend.. My db is already split, so i'm unsure what I have to do to point my frontend to the SQL backend.. I'm just going to start by testing with SQL Server Desktop edition.. Any help would be greatly appreciated..

How are you sending the email? Most functions have a To parameter for the recipient list.. How are you generating the report you send?

Ah yeah forgot about that Bob.. But its not my issue, I changed Name to one of the other fields in the query and nothing changed.. Paul, the issue isn't the SQL, its that vba won't let it compile to even run.. (code turns red in the VB editor) The nested SELECT pulls a list of ID's from a...

also make sure you're including both tables in your update query.. UPDATE ItemsOrdered, Contracts SET Contracts.Product = Product([Description])

You should be adding a Primary Key for your sickness table to identify each sickness.. That way you can identify each individual one and delete it. An alternate method to the beforeupdate method would be to have a delete button

that was one of the first things i tried.. No matter what, if i have anything after the GetChangeNumber it throws the expected: end of expression error and won't compile

I've got the following Select statement, but vba won't let me compile it with a ) on the end (as shown). Giving a "Expected: end of statement" error. But Access obviously throws an error if there are no ) Me.frm_Change_ApproversSubform.Form.RecordSource = "SELECT name FROM qry_getName WHERE...

ah, just realised this wouldn't solve my problem, since that would only be effective for that particular user.. Not accross the whole system (everyone has their own frontend)... Would a table that held the list of ID's be viable? ID___|___Members 1____|__ 321, 234,6435 2____|__ 12, 235,3...