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

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

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

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

I have 122 tables that need to be emailed to different sources if they contain information. I was wondering if anyone knows how I can do this in a Query, differentiate between a table with records and one with null records. Any help would be greatly appreciated. Christine

One of my first attempts at VBA: Option Compare Database Function Vendors() Dim CurComm As New ADODB.Connection Dim RS As New ADODB.Recordset Dim VendorID Dim i Set curDB = CurrentDb Set CurrConn = New ADODB.Connection With CurConn .Provider = "Microsoft.Jet.OLEDB.4.0&quot...

I have a table called INVUPC with no Primary Key that lists invalid UPC for products. They are sorted by Vendor. I want to be able to seperate the records by vendor into different tables, or into different excel files. TABLE could consist of only INVUPC and VENDORNUMBER. This is dynamic data so...

I am not sure if I have to use a module/macro to do the following, I was hoping someone would know some useful code to do this: Table: InvalidUPC Contains fields, UPC, AlternateUPC, VendorNum, etc. I need to sort these records by VendorNum and append each vendors information into seperate...