Works like a dream even on Vista!
Thanks so much I was dreading manually changing so many queries.
Paul...
pabs1111
Last Activity: Apr 1 '11, 04:01 PM
Joined: Sep 6 '08
Location:
-
Changing multiple pass through query property connection strings
Hi All
I think I have made a very newbie mistake in my use of Pass Through Queries. I have created pass through queries using the query wizard and then setting the connection string in the properties of that query (no VBA code)
New to pass through queries I simply copied and pasted an existing one to create a new one. And now that I'm ready to move to a test machine - I cannot seem to find away of updating all the connection... -
Doh! Sorry stupid Newbie mistake.
Paul...Leave a comment:
-
Thanks for the advice ADezii - will update my code.
Cheers
Paul...Leave a comment:
-
Works Perfectly! Thanks Fish
Paul...Leave a comment:
-
Unfortunately this is not the case - I have Select, Insert and Update privileges granted...Leave a comment:
-
Operation is not allowed when the object is closed
Hi All
I'm trying to insert records using VBA in Access into a mysql database and I'm getting the above error. The code I'm using I have found on the web, and in all frankness don't understand it as I'm only a beginner. However the code does work if I'm using a select statement to retrieve records, but it does not work when I'm trying to do an insert statement.
Any pointers/adivce would be really appreciated! The error... -
Yes I have been able to use a pass-thru query to filter a forms records.Leave a comment:
-
I really don't understand it - maybe there is something wrong with my form settings - I'm a newbie for Access. When I use me.requery it sets the form filter in the form properties to the correct statement (after execution) - but does not apply it i.e. the records are the same as before - no filtering. When I use refresh it sets the form filter in the form properties and then applies it - i.e. the records are filtered correctly. I really don't...Leave a comment:
-
Hi All
Just to let you know I've found a solution but no idea why it works.
In stead of using
useCode:Me.Filter = strFilter Me.FilterOn = IIf(strFilter <> "", True, False) Me.Requery strFilter = ""
For...Code:Me.Filter = strFilter Me.FilterOn = IIf(strFilter <> "", True, False) Me.Refresh strFilter = ""
Leave a comment:
-
Yes it is - I have tried using INT too but this doesn't work either.
The interesting thing is that if I use
strFilter = ([EventRoom] = "Sparc" AND code above )
it doesn't even filter on the EventRoom. If I don't use the code above then the data is filtered by the Event Room.
Cheers
Paul...Leave a comment:
-
Thanks NeoPa, but unfortunately neither option worked.
The query works perfectly (if slow) against a linked table and yes the first strFilter does contain an "AND".
I'll have to write a query against a linked table and suffer with the performance. Its weird - would of thought that it would of worked but not.
Thanks for the help
Paul...Leave a comment:
-
Can a form filter use a pass through query?
I'm trying to filter the records in a form using a pass through query.
The FWIPEvent is the pass through query. I use a pass through query as it is a complex query to select specific events and hence runs much faster as...Code:strFilter = strFilter & "( eventid in (select FWIPEvent.eventid from FWIPEvent )) " Me.Filter = strFilter Me.FilterOn = IIf(strFilter <> "", True, False) Me.Requery
No activity results to display
Leave a comment: