Search results for query: *

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

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?

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

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?

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

I have a macro that imports data from a file and then manipulates the data. The TransferSpreadsheet options are set to: Transfer Type: Import Spreadsheet Type: Microsoft 8-10 Table Name: t_PPCGooglePhrases_WeeklyData_Imported File Name...

I'm teaching myself to code in VBA and clearly I made an error, because Access is frozen up (trying to run a function) and I get the following error message when I try to end the program through the task manager: You can't exit Microsoft Access now. If you're running a visual basic module that...

I have a form: FRM – AddAttributesMainFormTest (Single Form View) that has a subform: FRM – AddAttributesTest (Datasheet View) The record source for the main form is: SELECT DISTINCT [TBL - PossibleAttsforItemsWithoutAtts].Page, [TBL - PossibleAttsforItemsWithoutAtts].[Proper Name], [TBL -...

I have exported a file from an Access query to Excel. In the query, three of the fields are hyperlinks, but in Excel they show up as text. There are about 26,000 lines and I need to (as quickly as possible) convert them to actual hyperlinks. They are showing up as: FriendlyLinkName# Actual...

I am creating a spreadsheet that has to be usable on both a MAC and a PC. Therefore, I am stuck using the forms controls instead of ActiveX controls. So, does anybody know if there is a way to change even the font size on the Forms labels and group boxes? I knew there were more limited, but...

This one is hard to explain.... I have two tables. Table1: AttributesFiltered Field: RecordID HeaderProduct AttributeName Table2: Category Field: Category AltProd These two tables are related through the HeaderProduct and AltProd fields. I currently have a form...

Here's my situation: I have two tables that have the following structure. Table 1: Attributes Fields: RecordID - auto number HeaderProduct AttributeName Table 2: Category Fields: Altprod Category The tables are related by the HeaderProduct and Altprod fields. What I...

I have a text box on a form that displays the number of records in a subform using the following expression =[Form]Form!Text10, where Text10 refers to a text box with =count([Field]) in the form's footer. It works well, except when the value is 0. Then it gives me an #Error. Any ideas?

I have a main form with three subforms. On two of the subforms, I have nested subforms. All of the subforms are set to view as datasheets. When I open the subdatasheets, though, all of the data isn't visible and I have to scroll through it. Is there a way to make this subdatasheet always on...

I have a text box on a form that counts the number of records in a subform using the following expression =[Form]Form!Text10, where Text10 refers to a text box with =count([Field]) in the form's footer. It works well, except when the value is 0. Then it gives me an #Error. Any ideas?

I am a very new Access user, and I have been able to get the information I want from my tables in a form with linked forms and subforms. However, I think it might be an inefficient way to getting where I want to be because updating it is very tedious. I have two tables - Attribute Table has...