Recent content by kimsMTC

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