Search results for query: *

I am developing a macro that creates a table based on certain criteria entered by the user. Then this table is emailed in .xls format. I want to be able to run this macro via a button (I've already made) more then once in a row. HOwever, when I try to run it a second time it gives me an error...

I have built a switchboard that contains 4 buttons, each that runs a different query. I want one of the buttons to be rerun as many times as the user needs to utilize it. However, at the current time, I run the macro, it performs, then reverts to switchboard (perfect) but will not let me run it...

Hi! i was wondering if anyone could lend a hand on how, when the form is opened, to sepcify its size? it keeps maximizing but I want it to leave another application visible. Also, is there a way to open the form while leaving the access backend invisible? It is a simple application for creating...

The type mismatch error is on the very first line. Could it have something to do with DAO.ADO specifics? Chris

Jeff I am still a bit confused about the ADO DOA business, I know that I believe my version will support both. Is this line ADO or DOA DoCmd.OpenQuery "QUERY_APPENDCHP_LOAD_POA_STATUS", acNormal, acEdit and if I am currently using DOA how would I declare the recordset this way...

If someone could explain what I am doing wrong with the result set in this code to create the type mismatch error on the first line I would be extremely grateful. Chris Sub Proc_MacroModuleQueryTest_DONT_USE() On Error GoTo Proc_MacroModuleQueryTest_DONT_USE_Err Dim RS As New ADODB.Recordset...

Thanks again for your help..still having the hardest time with this but I guess It'll come with time. THANKS

I am the biggest pain, but the code is now giving me a type mismatch error??? Function Proc_MacroModuleQueryTest_DONT_USE() On Error GoTo Proc_MacroModuleQueryTest_DONT_USE_Err Dim RS As New ADODB.Recordset Set RS = CurrentDb.OpenRecordset("SELECT * FROM INVUPC;") ' This Query...

Hi again OK so kinda like this? Dim rs as New Recordset(do I have to put ADODB.Recordset?) then Set rs = CurrentDb.OpenRecordSet (Select Supplier, UPC from INVUPC;") Then If rs!Supplier = ..and so on?

'Can anyone tell me why the following code gives me a runtime error "Object Required"? I am very new to this! It gives me the error at the beginning of the If statement. Thanks Option Compare Database '------------------------------------------------------------ '...

Thanks Michael, never even occurred to me! ;)

Thanks you Bill for your suggestion. I should have explained that I am trying to generate this conidtion because I have many many Supplier that could possible be dealt with. I was hoping to use an If, Else if format, but was unsure if I could do this with a DoCmd. Thanks

Hi The following code is giving me the runtime error 13 Type Mismatch On the set rs line. Again, I am very new to VBA and would appreciate any pointers on this error. I am simply trying to self teach myself and thought running a query and emailing it would be an OK place to start. I know that a...

In the following VBA code, where I am using the SendObject Command how can I get it to only SendObject if within the Publisher Data tale, the field supplier is say equal to 1234? I know this is a simple question but I am relatively new to this but really want to learn! Thanks in advance for any...

Hi, I am trying to build a macro and utilize a condition. I have not used these before but think it would be super helpful to me. I am running a query called QrySUPPLIER thats builds the table tblPRODUCTS with the fields UPC, Retal,....,Supplier. However I want the macro condition to be run...

Sure Jim. I'm at cbotham@indigo.ca Would be fantastic! Thanks for your continued help! Christine

OK here goes. I have a million P.O's and these are the ones that include Invalid UPC's. I need to send each vendors its own UPCs, via a template we have for the vendors. It is not really for me, its a means to gain the information on these UPC's from the vendors. So unfortunately it is...

Thanks Jim, i was unfamiliar with either of these commands, but will take a look around!

Thanks so much for your help on this thus far... I have been working with this in Access and have had no luck yet but will definitely keep trying. If I could get this to work the user app would be soo much easier! Thanks again!

Thanks for your help. The problem is I am a dunce when it comes to VBA and cannot expect the user to do a select count for each table. Currently the macro pulls vendors information from a master table of products and splits these into 122 tables. One for each vendor. The macro then sends these...