Recent content by justice8965

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