Recent content by gall3on

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

Hm, nevermind. I figured it out. I replaced " DoCmd.Requery "Projects_NoLeads"" with Forms![Home]![Projects_NoLeads].Form.Requery Thanks!

I'm not sure what you mean by saving normally. Essentially I have a 'Save' button on a ProjectDetails form. What I want to happen is whenever this Save action is done, another form (which is essentially a Home form) with a subform will get updated (using a requery) automatically as a...

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

Thanks a bunch! It's been driving me crazy all day! Thank you Thank you Thank you!

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

Wow, that was a pretty awesome solution. Thanks Golom!

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

Nevermind. I've figured it out. I realized that you can set the formula on the backend using Row and Column references. IE: ActiveCell.FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)" Thanks though!

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

Thanks a bunch! That Index/Match formula worked perfectly!

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