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

    Table List box used as query / report selection

    Right now, the Departments table is just a simple table with the 11 departments. I created a table called ReportDepartment, which uses the Departments table as a row source -- tried using List box and Combo Box. I need the user to be able to select either one or multiple departments to...
  2. lisaharris

    Vanity Plates 15 !!!

    Saw on a Lexus over the weekend: DILIGAF Missing an L, but the driver got his point across! __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  3. lisaharris

    Table List box used as query / report selection

    I have a table with a list box for departments to be used in a query, which in turn is bound to a complex report. It works fine with a single selection but I need the users to be able to select more than one department. How can I make this happen? __________ Veni, Vidi, Visa: I came, I saw...
  4. lisaharris

    Need to match or join a field to a column name

    MajP, Little massaging and redesign of my master query and presto -- Works like a charm! Union query did exactly what I needed to accomplish. Thanks so much! __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  5. lisaharris

    Need to match or join a field to a column name

    Back to the drawing board. Thanks anyway. __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  6. lisaharris

    Need to match or join a field to a column name

    The tables are normalized...... Table 1 looks like this: Rep Plan Volume1 Volume2 Volume3 100 A1 50000 60000 50000 200 A2 45000 45000 55000 Table 2 looks like this: Plan VolumeIndicator A1 Volume1 A2 Volume3 There will never be a...
  7. lisaharris

    Need to match or join a field to a column name

    I have a table with computed values that have column names such as Volume1, Volume2, Volume3. Second table with the plan name, and a field indicating which volume to use (so the row may be PLAN1, Volume2) The indicator in the second table is the exact name of the column in the first table...
  8. lisaharris

    Word 2007: Macro to edit macro?

    I have over 1000 word documents with an embedded macro defining a merge data source. The server containing the merge data is changing. Basically, the users export a data file from our mainframe system, then open the merge doc and click a button. The doc unprotects, browses out to the user's...
  9. lisaharris

    Vanity Plates XII

    Near my house, there's a small Mom & pop jewelry store; the owner and his wife have custom plates: His yellow Corvette: HUDAMAN Her Range Rover: YUDAMAN __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  10. lisaharris

    Help me name my business!

    Well, I have a new name for my jewelry business. Many thanks for the advice on pricing and photography -- to answer Dr B0b, yes I do have a good camera and a tripod so my images will be crisp. Background is important as well, especially to capture some of the fine details. So, without...
  11. lisaharris

    Help me name my business!

    Recently I've decided to turn a hobby into a part-time business. I make jewelry -- hand made bracelets, necklaces, and earrings -- using Swarovski Crystal, Genuine Pearls, and other high-quality beads. I've been doing this for years, mostly for gifts and things to wear myself. I currently...
  12. lisaharris

    Can a macro delete a file?

    It's all working now. I placed the kill command in a VBA and set it as the "On Open" for an empty form. Then in the macro, I opened the form and immediately closed it. Works like a charm! __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  13. lisaharris

    Can a macro delete a file?

    How do I issue the Kill command in a Macro using Access 2007? I've tried many different things and I can't figure this out. __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  14. lisaharris

    Can a macro delete a file?

    I have a macro that runs a detailed daily process -- it runs several queries to create three final output tables. Two of the tables may be empty. Once the tables are created, they are exported in Excel format. I have a condition set for those two export lines so the empty tables won't...
  15. lisaharris

    Conditionally available checkbox

    Is there a way to lock (or hide) a checkbox if the contents of another field is not null? On one form, I have a processing date and a delete checkbox along with other information. If the item has been processed (in which case the processing date is filled in), I want the checkbox to be...
  16. lisaharris

    Need to re-use a month recap report for different dates

    Duane, Precisely what I needed!! I'm on the right track now!! Thank you so much! [medal] __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  17. lisaharris

    Need to re-use a month recap report for different dates

    TRANSFORM Count([Reporting Query].appnum) AS CountOfappnum SELECT [Reporting Query].EnterMONTH, [Reporting Query].AMPM, Count([Reporting Query].appnum) AS [Total Of appnum] FROM [Reporting Query] GROUP BY [Reporting Query].EnterMONTH, [Reporting Query].AMPM PIVOT [Reporting Query].EnterDAY...
  18. lisaharris

    Need to re-use a month recap report for different dates

    Yes, my process involves importing data, running queries to calculate some new fields, and then a make-table query to store the data. The crosstab queries are built off of the final table. __________ Veni, Vidi, Visa: I came, I saw, I charged it.
  19. lisaharris

    Need to re-use a month recap report for different dates

    I have a process that imports data from another source, then calculates data and compiles information based on day of the month. I want to create a "scorecard" report, but I am having a hard time creating something that is reusable. A few of the data fields for February's data are as...
  20. lisaharris

    Access and a large SQL Table

    Unfortunately, I have no control over the SQL table's design or normalization (or lack thereof). The table is part of our CRM system and can't be changed. I guess I could create a couple views in SQL and query those with Access. A royal pain, but I think that's my only workaround...

Part and Inventory Search

Back
Top