Search results

Hey all, I have a query that contains three headings: Supplier, Number, Dollars or John/ 1123/ $123.45 John/ 1123/ $69.05 John/ 1124/ $3249.34 How do I get the duplicate records (John, 1123) to SUM UP the dollar amounts and turn that into one line? So it would just be John/ 1123/...

Is there a way to modify Access (maybe in options or some kind of code) to make it look ... unlike Access? I have a switchboard that pops up when I open Access, and it's ALL I want to be displayed; no navigation bars, no tool bars, none of the typical Access things. Is this possible?

Hey All, I have a switchboard (form) in a database with several buttons. One of those buttons is "Exit." Upon clicking that button, I want a MsgBox to pop up saying something along the lines of "Are you sure you wish to exit?" with the options Yes/No, and then when Yes is pressed, a "Do you...

Hey everyone, I'm working with an excel file that I have to import into an access database twice a week. I have to run a special macro on this excel file before I import it. Once I import it into acess, I want it to replace the past information it has in the table and put the new information...

Hey All, I'm having a LOT of trouble with this. I have a query that contains PO Number, Supplier, Last Name, First Name and Value. I wanted to create a form that contained unbound drop down menus so I could run reports on individual components of my query (ie: if I wanted to see all of the...

Hey Everyone, I'm new here and am in desperate need for some Access help! I have two tables that are put together into one query with title headings, "Mission" "Master" "PO Number" "PO Item" "Item/Acct Value" and "Supplier Name". My goal is to create two reports from this query (one of sales...