Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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