Search results for query: *

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

nevermind... i guess the change event was the wrong one anyway. i used the calculate event. 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...

thanks for the reply... actually i use the strCustID as a parameter in the make table query. sorry i wasn't clear before. blute

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...

wow, that was easy. now how do i 'browse the form's recordset'? thanks for the prompt effective reply. blute

hi thanks for the reply and suggestion. i neglected to mention (sorry) i'm not too hip with the programming... how do i do that? b

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...

thanks Geoff. you have been a tremendous help to me. and early in the morning (EST) to boot. blute

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...

sorry, not clear. when i click debug, Set rst = dbs.OpenRecordset(sQuery) is highlighted blute

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...