Recent content by gellerche

I have a VB front end that uses an Access database for data and to make reports. The front end passes parameters to the Access report, sends the report to a snapshot file, and then opens a VB form that contains the snapshot. This works fine. The problem is that when he runs the front end, his...

ghudson: Thanks for your reply. I do compact the database on a regular basis (It autocompacts everytime it's closed). The reason I was asking is that I recently used VB to import a LOT of data from a very convoluted spreadsheet to an Access database. I would like to be able to tell my...

Does anyone know if there's a way to see how many Megs of data are in an Access database? I know if you right click on the Access file in Explorer and go to Properties, you can get the size of the database. However, I'd like to find out the size of the data, not including the memory taken up...

I don't know if this would work, but how about: Dim txtReport as String txtReport = "Summary " & Date DoCmd.OutputTo acOutputReport, ' " & txtReport & " ' ,"SnapshotFormat(*.snp)", , -1

I have an Access db that I'm using to hold data and make reports for a VB front end. I have a report that has several controls (eg. Type) that are bound to the database. If I want to limit the report's output to certain criteria (for example only give output for records with Type = what the...

Thanks, Pat: I tried this approach, but couldn't get it to work right. The theory is sound, though, so I'll just keep trying until I get it (ie. I'm probably making a stupid mistake that I don't see right now). PS: I remember reading a while ago that you were considering writing a book. Is...

First off, I'd advise getting rid of the M-M relationship. You can do this by putting an intermediate table between the two tables with the M-M. If you can't do that (although you should be able to), can you make the source for your report a query? Then you could make the query "SELECT...

Thank you both for your advice. Amileaux: I tried the crosstab, and it did break it out left to right, but made a column for each value in the field (ie. column GA086, column GA089, etc.). This led to a lot of blank columns, so I can't use it. Thanks, though. GumbyD: I tried the report...

I have a report in Access. It its Detail section, there is a control that lists tables. The report prints just fine, listing each table after another down the page. However, these tables take up a lot of space going down the page, looking something like this: [Lots of blank space]GA086[Lots...

I found out how to do this: SQL = "ParentSoftware = '" & Me.cboSoftware & "' " Dim AccessObj As New Access.Application With AccessObj .OpenCurrentDatabase gblDatabaseLocation, False .DoCmd.Maximize .Visible = True .DoCmd.OpenReport "rptSoftwareInventory"...

I found out how to do this: SQL = "ParentSoftware = '" & Me.cboSoftware & "' " Dim AccessObj As New Access.Application With AccessObj .OpenCurrentDatabase gblDatabaseLocation, False .DoCmd.Maximize .Visible = True .DoCmd.OpenReport "rptSoftwareInventory"...

I want to call an Access report from Visual Basic. In the VB app, the user decides what parameters to be set when the report is run (eg. 'Name' = 'Bob' or 'City' = 'Chicago'). After the user selects the desired options, the code generates the SQL statement. I've read the posts about how to...

I have a function that takes three recordsets as arguments. I would like to create a recordset from these recordsets where the PKs match. Something like: SQL = "SELECT * FROM rs1 WHERE rs1("PK") = rs2("PK") " SQL = SQL + "AND rs2("PK") = rs3("PK")" I've read this forum, and have not found a...

I probably know less about security than AutoEng, but would this work? Step 1: Assuming you have your database access through a form, go to the logic that checks the user's entry against the database. After the code that lets the user in, add code like "DELETE * FROM (name of table that has...

Wayne and Jon: Thank you both for your help (especially Wayne, I know you've helped me out in the past). I've used Jon's solution, and it works perfectly. Steve Geller