Search results

I'm not exactly sure where to post this so I thought I'd try here. I have a database that is set up with three queries to, when in a form, click the department and then Access automatically assigns the next project number to the form. I copied this database so I had a backup copy. The backup...

QUICK QUESTION: I'm trying to export a table to a specific filepath/filename (so the table will be exported as the same file name every week for updating). I followed my VB instructions (so I think) and it doesn't give me a debug problem now, but its not working. Could someone let me know...

I am trying to come up with a way to update tables every week from two databases. I have one database for a satellite office and one for corporate. Each office has BOTH databases so as to keep up with their own data (we are not on a network). Each office will have to export their Project...

OK, I know how to make the shading highlight every other row. I know how to make just the field that the condition has to be met highlight. But how in the world do I make the whole row highlight when the condition is met. For example, Access highlights all the PENDING (STATUS FIELD) proposals...

I have two databases that are set up exactly alike - one for each office (Corporate and satellite). The Satellite office will have to send us their updated project, Proposal, and change orders data (which are in three different tables) every week so Corporate can update their database for the...

I have two date parameter queries set up (user sets dates are through a form). What I need is to have both of these queries in a format I can put them in one report and total the amount of sales at the bottom. Basically, it is a running sales report for the year. What I don't know is how to...

I have been trying to do something that should be simple I'm sure, but I can't figure out what to do. I have two tables (one for Projects and one for Change Orders to those projects linked by Project number). I need to create one sales log report that will include both, BUT I need them both to...