Search results for query: *

Thank you for your help. Not sure I want to venture down the Excel Automation route, but it is a thought. While waiting for your reply, I've created the script and tested it and it works great that way. I can attach to a button and they can run it whenever they need to. Thanks again.

If I have 20 in each Excel file, I want 20 in the Access table IF the 20 PKeys match up. If only 18 match up, then 2 new records should be created for a total of 22. Make sense? I'm thinking I have to do what you eluded to, import each into temp tables, then use SQL script to join together...

I have 2 separate Excel 2007 worksheets that need imported into 1 table in Access 2007. Since I can only import 1 worksheet/import, how can I get the 2nd worksheet into the same table, matching up values from existing records? In other words, an append will not work. I need to match records...

Thank you all for your comments. I will use queries from now on.

It is based on a typed SELECT statement, not a saved query. That may have fixed my problem. However, I did get it fixed, I'm just really uncomfortable with HOW I fixed it...I had to open the mdb file at my client's location on one of their desktops, pull up that form, look at the code, save...

I changed the SELECT statement on a combo box on my window, added a sort order by LastName and reversed the columns to be LastName, FirstName. Here's the problem. The combo box displays correctly in my mdb file. I send it to my client, they see it correctly in the mdb file as well...

Thank you! I did not realize that the default for OPENREPORT was to auto print. I will try and see if this works. TY

The client has a default printer set that works for all her other applications. That's what I don't understand.

I have an Access 2003 application that has a PRINT button. The clicked event code is: strReport = "Preview Timesheet" DoCmd.OpenReport strReport, acViewPreview DoCmd.PrintOut DoCmd.Close acReport, "Preview Timesheet", acSaveNo This works for me, but when my client...

Thank you so much! That worked perfectly! Kim

I have a simple form with a sub-form. My form only allows additions. The sub-form displays the list of all previously added records. I have 2 buttons: "ADD TO PROJECT" and "CLOSE". There is only 1 field to enter the Project Name. My problem is stopping data from being entered without my...

The field is just a text field. What would I look for that would be restricting it? Thanks for your response.

In my database view, I am trying to attach a built-in Smart Tag. When I click on the ellipse button on the Smart Tag text box, the Smart Tag window pops up but there is only a Financial Symbol listed. I am finding nothing about the built-in tags in help except that they should already be...

I have a feeder query, then a pivot query that uses the feeder query, then a Pivot Report that uses the pivot query as its source. My problem is that when the report displays the data, some of the sums are null values. Therefore, I cannot get calculations done because of the nulls. I have...

Thank you VRoscioli! You have all been very helpful! This will fix my problem. Have a great day! Kim

Thank you maxhugen, this is what I'm wanting to do. But I'm not finding code that shows me how to trap that err. Can you please help with that? Thanks, Kim

I understand what he was describing, but that's an extra hit to the database. I've always coded where you capture the messages and display a friendly message to the user, then rollback the problem for the user without them knowing. Thanks for the tip. Kim

So there's not a way to capture the duplicate error message before it is displayed to the user in order to make the message a "friendly" one? Thanks, Kim

Sorry for the mis-posting. I determined my problem was in the data. The report I was ask to create on the crosstab did not include all the possible column types. Therefore, the summing was adding ALL time records, but the individual columns were adding on those I specified in the query. The...

I have a created a crosstab feeder query that joins my tables together, then created a cross table query that is used by a crosstab report. My problem is that my totals are incorrect and I cannot even figure out where the value being displayed is coming from. Please help! Feeder Query: SELECT...