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

Hmm thanks but that seems to only give a way to download something (an HTML file). I need a way to navigate and login

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

How would I go about doing that?

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?

Theres actually code above what i posted thats doing the string parsing. I figured out my problem. I just needed (" & newstring & ") instead of just (newstring). Works great now. Thanks all!

Ok I think I figured out basically how to do it, but I have a problem with my syntax strsql = "SELECT tblSheetInspect.Date, tblSheetInspect.Passed, tblSheetInspect.DefectLocation, tblSheetInspect.DefectType " _ & "FROM tblSheetInspect INNER JOIN tblDefectType ON tblSheetInspect.DefectType =...

The SQL view gives me the following: SELECT tblSheetInspect.Date, tblSheetInspect.Passed, tblSheetInspect.DefectLocation, tblSheetInspect.DefectType FROM tblSheetInspect INNER JOIN tblDefectType ON tblSheetInspect.DefectType = tblDefectType.Number WHERE (((tblSheetInspect.Date)>"#1/20/2010#")...

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

Well the actions themselves involve a lot of code, tables and queries from the other database. I at first tried to copy all the required stuff over to the other database, but there was just too many little references here and there. It got quite messy so I abandoned that idea. The way I have it...

jdraw, Thanks for the help, but do you know how to call a macro from that? The DoCmd.RunMacro method isn't available for that object

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

I'm not exactly sure what you mean by that (I'm somewhat new to this).

What do you want a sample of?

result="" Thats what it gives me for both of them

No error, it just skips the part that I highlighted which it shouldn't. It doesn't add anything to the list box.

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

I need this in a table for several business applications. Removing the ID parameter won't work because once the query is run, I'm doing several calculations in code based off the query and putting the results into the table. Each ID needs to be done separately from the rest because of how the...

I need this in a table for several business applications. Removing the ID parameter won't work because once the query is run, I'm doing several calculations in code based off the query and putting the results into the table. Each ID needs to be done separately from the rest because of how the...

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