Search results

OK so I can see I will need to use SQL but taking that from the query I can also see is not sufficient.. Here is the SQL behind the query - What do I need to do to adapt it to work in VBA? newbie to sql -------------------- INSERT INTO TABLES ( SCHOOLNUM, TABLETYPE, CODE, CODEDESC ) SELECT...

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

Duh! Never mind after I posted that I realized (DUH) that all I need to do is create a table with the grades, link, and pull from there. I guess I'm Access-rusty....:D Need to pull the cobwebs from the ol brain.

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

Got it working I tried playing around with the replacement of the me.refresh line and it is now working. I'm posting this in case someone is having similar problems. ------------------------------------------------------- If MsgBox[message box data] = vbNo Then Exit Sub Else [multiple...

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

Thanks for replying. This is a database created by someone else; I'd have to go through everything to remove the space. Tried the brackets with same results. Not doing the secondary sort (name).

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

Thanks pat for your response. The thing is - the criteria won't be selected from a list box. This will eventually be set up so that the user clicks a button and the report is filtered for the individual's departments (yes, some have several) and the email is automatically generated and emailed...

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

Thanks Rich; I tried but still getting a type mismatch error. Don't know why. If I put a number in the field (i.e. 457) I will get the standard error that the value entered isn't valid, but if I leave it blank I get a type mismatch. This is a text box on a form formatted as date. The query...

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

Well, I got this working, had to go back to basic Like functions and think about it differently... basically using brackets and looking for alpha characters. I'm posting just in case someone else runs across this and is stuck with a similar problem. Ex of data: Empl# Name...

What books are you using? A good basic introduction I think is the "new Perspective" series...takes you through hands - on. Doesn't delve a lot into programming piece I don't think, but worth it to just go through and do the projects as a beginning point. You can probably find them very...

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