Search results for query: *

How do I get my ms access application to execute vba code when the application exits? (i.e do something before exiting)

Suppose my CSV file forms a table like this: COL_1,COL_2,COL_3 a,b,c d,e,f I want to import the csv file into the following table structure in MS Access: COL_2 | COL_1 | COL_3 ---------------------- b | a | c e | d | f ---------------------- How can I create a specification...

I have an .sql file which is about 75MB in size. It consists of INSERT statements with the values I need to import into an Access table. Is there an easy way to import this on the fly like via a DoCmd statement or should I just parse the file line by line and execute these insert statements to...

I would like to know how I can export to CSV format using the DoCmd.OutputTo function in VBA. I know how to do it in .xls format but not .csv. As well I know that when a file name is not specified in the arguments, a window will popup asking you where you would like the file to be saved in. How...

Here is my current situation: - Creating an Access app which relies on a series of Excel spreadsheets, each of which contains serveral worksheets. - Given a form, user inputs a set of values, these values are then used to query the set of worksheets within the spreadsheets and generates a set...

Hello, Suppose I have Tue 9:00 PM I want to do a subtraction and return the number of seconds. i.e Tue 9:00PM - Tue 6:00 PM returns 180 Also consider rollover i.e Wed 1:00AM - Tue 6:00 PM returns 25200 Thanks.

Let's say I have some data I parsed. And the time format is the following: hh:mm:ss (24hr format) i.e 15:13:09 I want to subtract the two times and get an overall duration value. i.e 10:00:00 - 9:30:00 = 00:30:00 or something of that nature.. thanks.

Hello, I have a function which contains two different collection objects. Given the name and key it will return the value if it exists or nothing if it doesnt. However, VBA prompts me with an error if we attempt to retrieve the value with a non existent key. I was wondering how to get around...

I am trying to convert my Access 2000 mdb to 97 and run the modules and found that there are some problems with using the split() function. Its telling me that it doesnt exist. Do I have to implement my own Split() ? Thanks.

Hello, I have a function in a module which executes to do stuff while reading a record set. It also opens a form which shows the progress of the record reading, however it is not refreshing until records have been all read. Public Function fCheckRating() Dim db As DAO.Database Dim rst...

Hello, I understand you can create something similar to a hashtable in VBA called a Collection and that you can use the add function to add key,value pairs. I was wondering if there is a way to create a static Collection object without using the add function. Like myCollection =...

Hello, I understand you can create something similar to a hashtable in VBA called a Collection and that you can use the add function to add key,value pairs. I was wondering if there is a way to create a static Collection object without using the add function. Like myCollection =...

Hi. I have a button with an onClick event which assigns a value to a textbox located on a left frame. This code works on IE browsers but on Mozilla it does not execute that command. this is the function function addToCart() { alert("adding to cart")...

How do I set the default page orientation for the Access application everytime it loads up. (i.e Landscape or Portriat) I already have a function in my modules which is set to load during startup of the application.

Does VBA allow null parameters? Because when I passed in a null parameter it says "invalid usage of null" right at the function call (it did not even go into the function body code). However when I called it using vbNullString it works but if i pass in lets say a textbox variable name...

I have a form which lets the user search for things. Depending on a combo box, the parameter could be a text or number. The search function will generate the querie corresponding to the combo box/parameter. I would like to know what is the conventional way of filtering a textbox before it gets...

I have a combo box which could have 2 different record sources, I set these record sources dynamically which is dependant on another combo box choice. One record source has 2 columns shown in the combo box the other has 1. When I first get the combo box to uses the recordsource which contained...

How do i check if there are other forms opened (other than the current one). I want to prompt the user to close off all forms before proceeding with the task on the current form im in.

I have a textbox and I would like to know how I can show the updated text as the user types in the textbox. i KNOW you can do this by appending each keystroke you type in but there are flaws in that method. (i.e if user highlights and deletes portion of the text it wont update correctly since it...

I splitted my access application into frontend and backend. I would like to know how I can compact my backend database from my frontend via a button click.