Search results

I cannot use the report wizard function without getting the following error: Program Error: MSACESS.exe has generated errors and will be closed by Windows. You will need to restart the program. I did see another thread here where the person created a new database and imported all the items...

I'm not sure if I set this up most efficiently from the start but here's what I have: 1. Table with catalogs (catalognum, catalogname) 2. Table with users (user info, catalogs they can access) Since some users have multiple catalogs, I created 4 fields* in the user table: cat1, cat2, cat3...

Oh, who would've thought it would be so simple? Thanks - it worked after I took out the [] and put quotes! Thanks a bunch!

I have a report run from a query that worked fine before we moved to Windows 2000. In the query, a custom field called PPD ran an iif statement; if true, it would assign "3" to the field, if false, null. On the report, I formatted the field for a certain font (monotype sorts) which would show...

That was it! Thanks.

I'm sure I'm doing something simple wrong...but what? Here's the code: ------------------------------------ Select Case grpBPInfo Case 1 stDocName = "BPInfo" stcondition = "[CostCenter]=" & Me![cboCUS] Case 2 stDocName = "BPInfo" stcondition = "[AKACostCenter] = " &...

Thanks. I also found it buried on the Access cd, but it's good to have a link. Any idea why Microsoft took it off? Good ol' Microsoft.

Hello, I've looked and saw variations of this problem but not exactly what I need: Users will be using a form to import text files into tables in the database. Reports will be run from these different files through queries. I want to be able to list the tables and list the date/time that they...

I am also looking for the download... I have the link set (to go to Microsoft's site for downloading snapshot viewer) to always show when emailing a snapshot report, just in case recipient doesn't have it. I was told today that they couldn't download it. I went to the site and can't find the...

Just wanted to post that I've got this working - finally! In case this can help someone else. Had to take a closer look; the "=" was bothering me, because it really didn't fit. Here's what worked, taking the "=" out of the docmd line, as the ">" and "between" conditions took the place, then...

Thanks for replying! I've tried fixing it a variety of different ways. I'm currently getting the following error: RTE # 3075 Extra ) is query expression '([RespDept]=)' Here's the complete button vba. I probably should have left "well enough" alone but how am I going to learn to streamline...

I'm going back to an "old" database that was designed a while ago and trying to streamline it. There are 3 inventory reports that include the dept code for each inventory item [respdept]. There are 4 queries (for each report!!) that I have done to accomplish different filtering methods. I...

Thanks for the info guys. Pat - I've looked there; I was looking here for more along the lines of "experiences from the battle field" :)

We are converting from Office 97 to Office 2000. I'd like to get a feel for people's opinions/experiences with upgrading and what problems you've noticed with "converting" databases from Access 97 to 2000 to get a feel for possible bumps in the road. (right now we are keeping Access 97 until...

No, the combobox is not on the report - it's on the form that is used to select the parameters for the report. They can run the report for all (which will need the footers/totals) or filter the report for specific customers, sales reps, etc. (and not need the footers/totals). I'm trying to...

Thanks for the reply Rich. The problem is, it can't find the control on the form ("method or data member not found"). FYI - I'm putting this code in the report's module, under the "on format"...should I be putting it in the form module instead that calls the report?? ------------ Private Sub...

I'm hoping someone can help me here. I have reports that from criteria chosen on a form. Report is grouped by 1)Sales Area 2) Sales Rep. There is a group footer for both, with subtotals. There is also grand totals in the report footer. There are page breaks between the reps because they need...

I'm back to this as I'm trying to tie up loose ends in this database. I'm using Access 97. I tried the code in another report and it works; it wasn't working in the report I was initially testing it in. The first report is just a display of a totals query. Occasionally, there WILL be no...

Well, I was able to HIDE the footers when they are not needed, but there is still an extra page that prints because the grand total (report footer) is set to print on a separate page (needs to be that way so it is not on a rep's page). This is what I put in the report module, after creating a...

I have a report that can be run for all or filtered. There are groups on the report for Sales Reps and Sales Area (Sales reps are in a Sales Area). Both groups have a footer with totals. The report footer holds grand totals for the columns. The Sales Reps footer/totals would always be...