Search results

Well I got it to work again, but I have no idea why. All I did was go back into each query and choose the Project Number field again (it wasn't changed I just reclicked it) and then rechose New Project Number query in my first instance of the macro and it works. The only thing it does now is...

OK, I've done everything I possibly can. I changed Project Name to Project Number in one query and not the other, but then it adds the correct number and puts it in the table but it doesn't show on the form. These are the queries I have in order they run on the macro. Anything jump out at...

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

Thank You!!!!!!!!!!!!!

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

LOL, no. The reason all this started was when I started here (6 months ago), they were having to input the SAME information in 4 spreadsheets in order to create a new project. That is not even the 4 spreadsheets it took for the satellite office to do theirs. They would simply send their...

I've gotten it to upload a specific excel spreadsheet when you click a button. I was working on getting it to import the spreadsheet and then update and append (but I got sidetracked on EXPORTING to a spreadsheet). Basically, I created a command button to automate the importing and added...

NEVERMIND! HOORAY IT WORKED!!! I just closed it and walked away for a sec and it worked. Thank you both.

Thanks. I know I'm having a brain fart but I'm getting really frustrated. I can't get either append or update queries to work. and these directions are working the same way. It will either pull too many occurances of the same record or pull the right number of records but not all the...

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

Thank you! That worked. When I did my search on this subject, that information didn't come up in my results. Thank you for the extra info, I'm sure I will need it.

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

Most of the time yes, it would be only new records added, but there could be a case where the project, for example, was changed (say the scope of work changes and the fee would also change). So if I set it to only updated with new records added, then it would miss that change entirely. But no...

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

You Are A Genius! THANK YOU! I used the union query to put both queries together and it worked!!!!! I just have to add a field to one because the other had more fields, but other than that, it worked!!!!!!!!!!!!!! THANK YOU THANK YOU!!!!!!!!!!!!

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

OK, I'm not kidding. It didn't work, then it did, now it doesn't again! I'll keep plugging along.......

Thank you. I'll try that! have Fun!

Here's one with data. I can't believe I got a complicated macro to work but this I have trouble with! D

Sorry about that. I made the change on the query, saved it, opened the form, filled in the dates, then opened the query and still nothing comes up. Is there anything else I'm missing?