is it possible to include this function in the drop-down box of the expression builder, like inStr, so i can use it in design view of queries?
should it already be there?
e
yes, i mean the expression builder... sorry. i want to use it in a query. are you able to do that?
i thought maybe my access 2000 didn't include this function.
btw, thanks for thr prompt reply.
b
hello:
im trying to use the instrrev function in a select query. i dont see it in the list of available functions. i can use it in a module however.
i would like to have this function available by default in all my access dbs. is there any hope?
thanks
blute
hi
i have a sheet that is created populated via a macro, and each time it may contain a different number of rows.
in the last row i have 8 cells for which i want to display the contents (updated in real time, as they will change as sheet is modified during use, it is a formula based on the row...
hello
i currently use a form with a dropdown list to choose a customer, then hit 'go' on the form to run a macro which opens a make table query then runs a module to export it to excel. the customer comes from a table.
i would like to figure out how to run the macro for each customer in the...
hello
i hve a macro 'macro1' which i normally call from a form. the form passes a value 'cust_id' from the customer table. the macro runs several queries which use cust_id as a parameter, makes a table with the results, then calls a function which transfers the table to a spreadsheet. then i go...
you are right on there!
works like a charm.
i am really impressed with this process. i cant believe how long i have been struggling on my own when such a resource is available.
DOH!!
now that you have solved my critical issue, another arises.
can i make this this go on a db that is open...
getting there.
now i get syntax error in FROM clause.
sQuery = "Select * FROM VPP-Basis"
Set dbs = wks.OpenDatabase("\\s2\cc_queries\Evan\PricingPages.mdb", True)
Set rst = dbs.OpenRecordset(sQuery)
btw, and i hate to ask, how tough would it be to adapt this to run from access...
i have set reference to ms access 9 object library, does it need to be in a certain rank on the list..? i still get the same error.
here is the top of the code: vpp-basis is my table made from the query,pricingpages is the db.
Sub Use_DAO_to_RunQueryInAccess()
Dim dbs As Database
Dim...
ahh, code. thanks i'll give it a try.
this is a macro for excel? i get user compile error: user defined type not defined in the dim statements:
Dim dbs As Database
Dim rst As Recordset
Dim wks As Workspace
Dim ws As Worksheet
Dim sQuery As String
what am i overlooking?
blute
i dont know any programming, but have worked backwards from a sophisticated spreadsheet (afaic) which is formatted exactly the way i want it to be and has a bunch of macros built into it to a query that provides the info i need from my sql server db. (VERY time consuming given my limited...
hello.
first time caller.
i need to copy the results (datasheet) of an access query onto the clipboard so i can paste into an excel sheet. i have considered exporting and transferring, and really would like to give THIS method a go. i dont know much so i'm hoping for a 'turnkey' solution to get...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.