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

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!

...formulas in my summary worksheet, I'm either adding or multiplying for expenses. Sample for Cell A2 in my Summary Worksheet: Expense = sum(CP!G60 * 1.025 - HS!A5 - CP!G69) where G60 refers to 'Estimate' & G69 refers to 'Adjusted Amount' from worksheet CP, and A5 refers to 'Losses' from...

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

I was considering automating this but since I have a short ETC for the report for now, I will have to forego the VB script or do it steps by steps. Thanks for the info though! I got the temporary solution that I need.

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

Hm, I actually thought I did post it in the VBA forum. Sorry about that! And thanks for the Cell Select info. I went ahead and changed the VB script altogether because of formatting issues.

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

I used a variation of Skip's script: dim sHead(1), i dim r as range. sFindText as string Head(0) = "head1" Head(1) = "head2" for i = 0 to 1 set r = sheet1.rows(1).find(Head(i)) if not r is nothing then r.entirecolumn.delete shift:=xlleft next But realized a flaw that needs to be addressed...