Search results for query: *

Hi all, I can get the code below to work as an Excel Macro, but I'm at a loss with trying to do the same from Access VBA by using Excel automation (it's part of an import procedure I'm working on). Can anyone help? I'd like to just use Access VBA and don't want to use any external files (such...

I'm using the following line in my Access form, behind a command button, to open a web page in Internet Explorer (the page is located on a local server). dRetVal = Shell("C:\Program Files\Internet Explorer\iexplore.exe " & "\\server\file_to_print.htm", 1) Opening the file is fine, but telling...

I'm trying to create an equivalent of a HTA timer I found some months back. I've revised the code below to fit my needs with HTA (though the 10 seconds part is only to show that it works in a quick fashion). Here's my question: Is it possible to get a .vbs equivalent? I don't need a GUI (so...

In the VBSCript code below (its a fully functional .hta code), I can't figure out how to use the arrow buttons on the form in the HTA to go from record to record without manually telling it. Right now, I have it figured for 3 records per each associate, but what if there are 20 records...I...

I'm almost done with my quest to make a simulated Access listbox in hta by using javascript and a table. The code below works to have the table scroll to and highlight the first row where that letter shows up. In other words, if there's "Sam" and "Susan" in the column, it will always go to...

Below is the code I have which simulates an Access list box by using Javascript and "faking" the listbox by using an html table instead. My Questions: Is there a way I can further simulate the Access listbox feature by having the html table scroll to a cell (the first cell, which is the name...

I'm learning more about Javascript each day, but I'm still unable to figure this out this dilemma. I searched on tek-tips and elsewhere across the web for a solution, but couldn't find one that fits my needs. I need to change the following code to be able to do the following: 1. Change the...

The title of this post is probably a convoluded way of phrasing my dilemma (I've had more than my share of dilemmas lately with this database project I'm doing): The code below, which is behind a command button in a form, generates an email with an image attachment that graphically appears in...

My code below is not cooperating with me. I've opened up an Excel file and I'm trying to write data to the first two columns of the spreadsheet (eventually it will be around 40 columns). What I'm trying to do is loop through 10 subform records that are tied to 10 or so main records (which =...

I searched for an answer to this question, but I think I'm pretty unique in asking. I need to send 5 emails to the users containing 10 records (based off the subform) for each user. I can't figure out how to temporarily interrupt the htmlbody code in Access to allow me to go to the next record...

I just ran into a problem today and I'm stumped on what to do as a fix. I have about 400 records in a lone table where I have start and end work times for employees displaying in the hhmm format (for example: 1555 as start time and 2135 as the end). I need to now calculate the difference...

Is there a way in Access to control what order an update query writes data from the first table into a a second table (based on the values in the first table)? I'm trying to merge multiple records from the first table into one record on the second table. The common field for both tables would...