Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kimsMTC

    Excel 2007 import

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

    Excel 2007 import

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

    Excel 2007 import

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

    Combo Box not displaying correctly

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

    Combo Box not displaying correctly

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

    Combo Box not displaying correctly

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

    Can't print Access 2003 report

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

    Can't print Access 2003 report

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

    Can't print Access 2003 report

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

    Tab triggering BeforeUpdate event

    Thank you so much! That worked perfectly! Kim
  11. kimsMTC

    Tab triggering BeforeUpdate event

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

    Access Tables Smart Tag

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

    Access Tables Smart Tag

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

    Nulls in Pivot Tables

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

    db.execute problem

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

    db.execute problem

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

    db.execute problem

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

    db.execute problem

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

    Crosstab report

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

    Crosstab report

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

Part and Inventory Search

Back
Top