Search results for query: *

Can a button be used on a webpage which executes a macro when pressed? I want to be able to be able to push information into an access database based on the specific button which is pressed. diane

Pretty green to coding but i have a simular macro running in excel which does the same thing except the WHERE stmt compares the field to a date variable. In this case I'm trying to filter out records from an ACCESS query with a particular month found in a specific cell in excel. Once found it...

I have an excel 2003 SP3 spreadsheet which has a script that dumps data into Access 2003. This has been working great until the other day and now we get an error which when I go to references I see "Missing: MS ActiveX Data Objects (Multi-Diminentional) 6.0 Library" . I uncheck this and...

I need some guidance as how to best approach my form. I have two tables (example only)... Table1 has a record for each hour of the day (Date, Hour,Factor)*Note: there is a factor for every hour Table2 has random records which need to be matched with Table1 and calculations made (Date,Hour,Qty)...

I've got a report which is generated from a query. For each record in the query I calculate Qty * dollars. But there are records which will have 0 in the qty so I need to use the last known qty for the next records until the qty is no longer 0. The total dollars are summarized. Not sure how...

I'm launching excel spreadsheets from a main menu in Access. These spreadsheets are key to data that gets entered into the database. I thought this would be easier for the user but I've discovered that some 3rd party addins don't get installed using this method. After excel has launched i...

I have this excel macro pulling information from a specific record in Access. on the "open.strQstr" stmt I get "No value given for one or more required parameters" Is there something i am missing thanks diane _______________________________________________ Dim cn As ADODB.Connection Dim rs...

I have an Access Form which passes a value to an excel spreadsheet. I want to test to ensure that the spreadsheet is not already open prior to me giving the OPEN cmd. If it is OPEN then proceed to select the sheet and move data in. I have two issues but lets start with this one.... 1. If I...

I have a macro which I have used the On error handling and executes a specific error routine whenever it obtains Error 1004. The error 1004 routine runs correctly but I get an additional msg "Could not open <filename>"... how do i get rid of this message. Is there a specific code for it as...

I am new to VB so bear with me... I've got a subroutine which opens a CSV spreadsheet on a website. I need to grab some data based on a Date. I type in the requested date on my spreadsheet and have the macro format it to the same format on the remote spreadsheet (dd.mmm.yy) and use the...