Search results

Hey all I'm trying to generate a report based on 3 crosstab queries. Each query has a date range which is the same for each query (1/1/2010-1/31/2010 for ex), and a number of columns based on criteria chosen by the user. For example, if they choose "Zone 3" qry1 might have 4 columns, qry2 might...

Hey all Couldn't find any good info on Google on this subject. I have a button that when clicked, the code needs to connect to a website, login, and download a CSV file. Could anyone help me do this, or does anyone have a link to a guide? Seems odd that I can't find one anywhere...

Hey all This sounds simple but I can't figure out how to open a simple Save As dialog box through VBA. I have some code that makes a picture pop up on the screen. I'd like the user to be able to save this picture using the Save As dialog box. Any ideas?

Hey all I have a form where a user can select, using check boxes, what types of defects from a sheet of metal they want. They then hit a button and it brings up the query results, showing all sheets with, for example, defect type 1 and type 4. The defect types are labeled as numbers. What I've...

Hey all I'm trying to run a macro in a different database than the current one when the user clicks a button. I'd like to do this without the other database actually opening (ie the user doesn't see the database opening) So far I have this: Dim ms0 As New Access.Application...

Hey all, So I have a program where the user selects some spreadsheets with information they want to import. They can select as many as they like, these are then added to a ListBox. The user than clicks the Import button to do some calculations and the actual import. This works fine when they...

Hey all, having some trouble figuring out the best way to do this. I have a query that is based on an ID number which is in a ComboBox on a form. Basically the user selects the ID, then the query is run based on that ID (the query pulls up their energy usage for the most recent 12 months). The...

Hey guys. I'm getting this error message when trying to delete something from a recordset based on a query. Basically if there is a negative number in the recordset, its purpose is to cancel out a positive number of the same value. So what I'd like to do is delete all negative rows and the...

Is there any way to programmatically change the selected index of a combo box in Access 97? .SelectedIndex doesn't seem to be included in this version.

Hey guys, probably a simple question but I can't figure out how to step thru a combobox. I just want to fill an array with every item in the combobox. The combobox is named Combo95. Any ideas?

Hey guys, having a problem. I have a Select query. If I open the query in design mode, change it to an Append query, enter the table to append to and run it, it works fine. However, if I save the query then close it, and run it again I get this error message: "An action query cannot be used as...

Hey guys, can anyone tell me whats wrong with my syntax here? Not sure where I'm missing quotes, or whatever it is I'm missing... PreviousAverage: iif([BeginDate] <= DateAdd("m", -12, Now()), 0, DLookup("[AverageforPeriod]", "qry12month", "[BeginDate] = DateAdd("m", -1, [BeginDate])") The...

Hey guys, have a question. I'm using Access 97. So I have a linked query I made in query designer. What I'm trying to do is call a VBA function I have in a module from the query designer. What this function needs to do is check if we are currently on the first row of the query (or the earliest...

Hi all. I have an Access97 database. I'm currently having a little trouble with a query I'm making. Basically, I have to pull a customer's electric usage from the past 12 months. That part is easy. However, I need it sorted by month, like January 1st-31st all summed up, then Feb, etc. The...