Search results

We have 15 different site locations and numerous tables and listfiles at the 15 different sites. I'm trying to run review/cleanup before we go to a centralized system (YAY!). I've linked to all the table files then combine them all into one table file in Access so I can do counts, etc. For...

Issue: We have software that maps some of our "custom" grades that we use locally to the state-specified grades when we submit. Ex: Grades PA and PP map to report to the state as PK. The data stays in our software as PA and PP however as it is needed that way. I'm trying to run queries...

I have numerous dbf files that I need to do the following -compare this year's file with last year's file -identify ANY field that has different data so it can be reviewed. I am not just looking to change the current year to last year's as our year began in July so some changes may be valid...

Not sure if this is the right forum to post this but here's my task: -just started a new position; I have 15 sites that need to back up the data files located on their local server on a regular basis. This is done by users on site (occasionally!) and I've found out that when they do, they're...

Has anyone experienced problems with Me.Refresh not working? I have a couple procedures on a form where the form needs to refresh after running code. For one procedure, it always works. For the other, it doesn't. I need this primarily to update a field that shows the number of records in a...

I have a report that is sorted by the user from a form. If they choose to sort by district, I want it to also sort by name within the districts. I can't seem to get the report to sort for the seconf field. It sorts by the district but not the name within the district. I think I have it coded...

Hi, I've done this before and can't figure out why it's not working for this report. I have a report w/subtotals: branch and grand total. Branch and grand totals print on separate pages. Grand total is in the report footer section. When the user runs the report just for one sales rep, I...

Hi all, Simple thing, but I haven't done it before. I've got some reports that the user can run for multiple criteria. One of the parameter/criteria fields is dept. They can leave blank for all or choose the dept. Works fine. What I'm now back to doing is designing a mass email of one of...

In one of my databases, the user will edit/add information to 4 tables: Items, Users, Catalogs, and Depts. On the main form, there is an option button for all four. I would like to have ONE combo box that will display the information to edit depending on what is chosen in the option (instead...

Again, something simple tripping me up, or maybe I'm just brain dead. I have a text box on a form to filter the underlying query for a report when that report is selected to be run. I want to display a message if the field is blank. I've done this with combo boxes, etc. but with this I keep...

This is probably a very general question, since I've never programmed in Outlook before...if someone can point me in the right direction to learn more that would be helpful. Here's what I'd like to do. Next week our corporate office is initiating a spam filer; all users will receive an email...

This is probably going to be very easy... Background: I have a database that I calculate commissions on. All the commissions are in one big data file, the employee numbers indicate whether it is "regular" or "excess" commission. For one company, this was easy, if it was regular, it began with...

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

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

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] = " &...

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

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

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