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: *

  • Users: gall3on
  • Content: Threads
  • Order by date
  1. gall3on

    One Form for Multiple Entries

    I need some form help since I'm very new at creating forms in Access. I want to design a form that will allow me to create multiple records from one entry for efficiency's sake. For example, I want to create a new "Store" record for several cities. How can I design a form that will likely use...
  2. gall3on

    Requery SubForm After Update

    I have a main form display which contains a subform list of projects that have a field that needs to be corrected. How can I automatically requery that subform after a user updates a project with the needed correction? Right now, my main form can take care of this by using a main form Refresh...
  3. gall3on

    Month Order ID via SubQuery

    I've been working on an excel calendar project that's now migrating into access. Essentially, I have a table of events entered by various users and I need to create a report/view of such events by month. The table collects the following basic info: created by: date start: event name: date...
  4. gall3on

    Conditional Format Against an Array Set

    Hi, I'm trying to conditionally format a column of text cells where if the value belongs to a named range, it will highlight the cell. Here's the example: Column to Format Dog Catfish Elephant Goldfish Betta Fish Tiger Mammals: Dog, Elephant, Tiger So if the values under the column to...
  5. gall3on

    How to Get Multiple Values Based on Criteria

    Without using Macros/VB, is there a formula that can filter a table by a specific field and grab all the 'returned' results from a different column and paste them in a different worksheet? For Example: Test Name Month Start ABC 1 DEF 1 GHI 1 JKL 2 ACD...
  6. gall3on

    How to Combine Cells into a Single String with Commas

    I have a column of number values in Excel that grows over time. Example: Web IDs 1243 34565 2334 2357 Because of some reporting restrictions with another software, I have to constantly copy each cell value to a reporting field, with each value separated by a comma. Example: Enter IDs to...
  7. gall3on

    SQL For Getting Records in a Date Range

    Hi, I'm still feeling my way around SQL and need some assistance. I have the following SQL below: SELECT [All SOS with All CIDs].Date, [All SOS with All CIDs].SOS, sum([All SOS with All CIDs].Sumits) AS Submits INTO [Two Weeks] FROM [All SOS with All CIDs] WHERE ((([All SOS with All...
  8. gall3on

    Showing the Formula Based on Values from Different Worksheets

    I'm trying to create a macro that will perform calculations for an invoice. I know that I can do much of the calculations in the back end within a script, but I'm writing the macro for my boss who would be interested in seeing the formulas in the Excel Spreadsheet. Here's my main problem. For...
  9. gall3on

    Unique Lookup or Different Method

    I'm not that familiar with vLookups so my previous attempts failed at using it. I'm not sure this would even work since my 'return' value needs to be a value that happens to be located left of the lookup value. I have a table with values that correspond to dates. I wanted to find the max...
  10. gall3on

    Populate Date For Data Grouping from Web Table

    I have a table that has data copied from a webpage table report. The table when pasted in Excel has a format like this: Date Group ColX ColY 10/31 A 1 3 B 2 5 C 4 2 11/1 A 1 0 C 2 1 11/2 B...
  11. gall3on

    Select All Macro

    Probably silly question... I know in Excel, there's a function to Select All using Cntrl+A selecting cells that are not empty. What is the VB equivalent for this if I try to get this in a Macro? I've tried recording it and looked at the code, but all it does is define a range to select (EG...
  12. gall3on

    Auto-Refresh Linked Table When Opened or Macro

    Not sure if I dropped this in the right Access forum... I have a database that has 4 linked tables that needs to be refreshed after I open. Is there a way to get these tables updated? If not upon Open, I have a Macro in this database that performs several tasks (copy linked tables, run query...
  13. gall3on

    Macro Help for Finding and Deleting Specific Columns

    I'm not sure if I should have placed this in the VB forum but I need some assistance with a macro I'm trying to create. I want to be able to delete a column based on the first row heading. How can this be achieved in a Macro? For example: Version Pick Test Verification 1 x...
  14. gall3on

    Macro Help for Finding and Deleting Specific Columns

    I'm not sure if I should have placed this in the VB forum but I need some assistance with a macro I'm trying to create. I want to be able to delete a column based on the first row heading. How can this be achieved in a Macro? For example: Version Pick Test Verification 1 x...
  15. gall3on

    Prompt Table Name from Make Table Query

    I was wondering if there was a way to prompt for a Table name when using a Make Table Query. I'm basically combining two tables but I want to be able to name that table dynamically as I generate it instead of having to define it beforehand. Below is my code: SELECT SourceCodeSearchTable.[Offer...
  16. gall3on

    Transpose A Table in Access or Excel

    I'm not sure if this can be done in Access or Excel. I have an Access table that gets updated from several queries. The finalized table needs to be displayed in a certain way for me to copy the data to a different Excel sheet. Access Table: ID ColA ColB ColC Pink 5 3...
  17. gall3on

    Combine Multiple Update Queries

    I was wondering if there was a way to combine multiple Update queries that affect a singular field. I have to rename several values in 'X' field so I can group it properly. EG: 'Field X' A1 A2 A3 B2 B3 B4 Expected update Result table: 'Field X' A A A B B B
  18. gall3on

    Join or Union or Something Else?

    Need help figuring out which SQL will work... I have the following SQL code: SELECT NPP2.PID AS Others, Sum(NPP2.Total) AS Total, Sum(NPP2.AP) AS AP, Sum(NPP2.EN) AS EN, Sum(NPP2.CN) AS CN, Sum(NPP2.TD) AS TD FROM GroupedPartners, NPP2 WHERE ((NPP2.PID) In (GroupedPartners.[Grouped...
  19. gall3on

    Group Different Records in Access

    I need help in generating the SQL query for grouping distinct records into one record and summing up values. The query needs to go through a table and group several records together. The results need to show the grouped records plus distinct records. sample table: Name Total TotalX...
  20. gall3on

    Trim In Place for Excel

    I would like to know how to do a Trim in place for excel, instead of having to do it from a reference cell/column. I don't want the cell content to look like =TRIM(A1).

Part and Inventory Search

Back
Top