Search results

But wouldn't I need to place them into a table to create the update query? That's what I'm confused about. How would I do it. If I place them into a table to do that how do I import the ones that have matching primary keys?

Ok, we receive a file from a client with all approved orders everytime there's a new order they add it to the spreadsheet. When they install an order they update the spreadsheet with a date in the install field. Right now I import the data and because of my no dups primary key it only imports...

I am already appending new data. I want to take the data which doesn't append because it's already in there place it in another table and compare it with the main table to see if anything has changed.

I am importing an excel spreadsheet into a table with VBA Code. This works fine. The problem I'm having is the spreadsheet is a running spreadsheet that we keep adding to and I can append the new data because of my primary key having no dups. My question is, is there a way to append the new...

Thanks so much Rich. I tried everything and nothing wanted to work. When I looked up the format function for date I found the formatdatetime function but that was for long and short date not medium. I greatly appreciate your help.

I have 3 queries pulling different data from different tables and the dates in the tables and queries are set to Medium. I have one union query pulling all the data together and all the dates display as short. I also have a report generated from the union query and I set the date text boxes to...

If I take out the code it prints, right now I am opening a report in the report footer. If I use a subreport instead of just opening another report it prints fine. I guess it doesn't like me opening a report in the report footer. Here is my code... gtotal = Text130 x = int(gtotal /...

I have a report that opens just fine but when we go to print the report it doesn't give me an error but it doesn't print. I need to print this report. It never used to do this but I just recently added code the to report footer to open another report. Someone please help.

I know how to code it I'm just not sure where to place the code to set the reports recordsource .

Where would I place the code? In the form? In the report? And what event?

I have a form that the user enters the start and end dates they would like to view. There they also select the office they would like to view. The date parameters work just fine but and I so does the office criteria. What if I want to show either a specific office or I just want to view all...

Thanks so much Jon that worked perfectly.

Yes that works with the Transferspreadsheet option but I am using the SendObject option which doesn't save the spreadsheet to the hard drive but automatically sends it to an e-mail. Thanks for trying though.

I have a macro set up that e-mails a spreadsheet which is based on one of my queries. When you do this access automatically names the spreadsheet the name of the query. Is there any way to change the name of the spreadsheet to be the name plus today's date? Any help is greatly appreciated...

I created a form with an option group to select One Day or Multi Days. When the user clicks One Day a text box pops up asking for the date. When they select Multi Days two text boxes pop up asking for the start date and end date. This works fine on my computer but when I sent it to someone...

I have a right function in my code that has worked fine before. I am currently logged on to the server at work from home and for some reason my right function does not want to work. I checked all the references and they were fine I even tried to restart the server but that didn't work. Can...

Thanks for trying. Does anyone know how to fix the "Too Few Parameters Error"?

Access XP

Ok I did that and on the set rs = currentdb.openrecordset("TestQuery") I receive the Too Few Parameters. Expected 1. Error again.

That works but I'm not familiar with querydef I need to be able to loop through this query and update another table based on the id number from each record. How can I do that with querydef?