Search results for query: *

Got it! Thanks!

Using VBA? Can you give me an example of what the code would look like?

My database contains a form (Form1) with one combo box (Combo0) and a subform. The combo box datasource is a table with two fields: Criteria, CriteriaForm. CriteriaForm is the name of the form that I would like to have populate the subform on the form. So, restating, when the user...

I have a table that has the following fields: Category Subcategory Page I am creating an index from this table that is grouped by: Category Subcategory Page So, I end up with multiple page numbers for each Category/ Subcategory . I would like to create page ranges from the list of pages...

The reason it isn't that simple is that the points in ZipCodes do not exactly match up with the points in AllGridPoints. I need each Zipcode to have an assigned gridpoint. So, I need to find the latitude/longitude point in AllGridPoints that is closest to each identified zip code. I can...

I am using Access 2003. I have two tables and no official grid. Only a grid in the sense that a grid is defined in one of the tables. For instance, the table AllGridPoints just contains all of the grid points (i.e., latitude/longitude) in my grid. Is that enough info? Thanks! Caryn

I have a table (AllGridPoints) with a defined latitude/longitude grid for the US(864,363 rows). I also have another table (ZipCodes) listing zip codes and their latitude/longitude. I need to place these zip codes within the established grid. Any ideas on how to get this done efficiently...

I want to create a report that opens a subreport many times (i.e., 34 times) with a different value for one of the parameters each time. Any tips would be appreciated. Thanks!

I am in need of applying conditional formatting to my query in pivot table view. Is that possible? If that is possible, I also need the condition to be based on another entry in the pivot table. Is that possible?

Along these same lines, is there a way to use this methodology to get not just previous sales, but only sales from the previous month (monthyear - 1 month) and then sales from the previous month (monthyear - 2 months) and then sales from the previous month (monthyear - 3 months),etc. So, in...

Never mind. I figured it out. There was a bad record in one of the upstream queries.

I have a query with the following sql: SELECT q_ReportMonths_RosettaKeywords.Page, q_ReportMonths_RosettaKeywords.Keyword, q_ReportMonths_RosettaKeywords.AssignedMonth, q_ExternalSummarybyMonth_Rosetta.SumOfSalesSameSession AS OrganicSales, q_InternalSummarybyDate_Rosetta.SumOfSales AS...

Thank you, thank you! I very much appreciate the tip about the date. This is not a problem as it starts as an actual date and I split it for a reason I'm not remembering. I can just go back and "unsplit" it. I always appreciate a good database tip, though, as I'm fairly new to this.

This is just for use by one person. A query would be fine - it doesn't really have to be automated. I know how to compare and manipulate fields, but I need to compare and manipulate records. Does that make sense? My data is roughly in this format: Keyword Month Year Sales (etc.) I...

I have a PivotTable (i.e., a query) that shows me monthly sales (i.e., sales vs. month/year). Is there a way to program Access to pop up a notification if sales decrease by more than say 10% in a month?

Assume I have a form (Form_x) with a subform (Form_x_subform). Both are in datasheet view. They are linked by Field_z. I only want the subform (i.e., subdatasheet) to expand automatically if it has data in it. If the subform is empty, I do not want it to expand. How can I do this?

TheAceMan1 - Thanks. I see that now! Dhookom - I am not adding anything to the master/page record --- only to the subform using an existing page.

Maybe I should start over, because for some reason, I am just not able to find the Master/Child fields. I created my forms using the form wizard and they were working correctly, but adding data to the subform was creating problems (i.e., blank Page field). So, starting over: I have two...

I have a form (f_Pages_Update - based on the table t_Pages_Update) and a subform (f_Keywords_Update - based on the table t_Keywords_Update). The form has the following fields: Page Priority Level URL The subform has the following fields: Page Keyword MonthlySearches Ranking Status (Add...

PHV - You are a person of few words, but very helpful. Thanks!