Search results

:D I am trying to create a CrossTab query from a table of expenses: tblExpenses: PropertyID ExpenseType Amount There are many kinds of Expense Types. I want to use ExpenseType as the column header, BUT I want there to be 3 categories "Rent Expense," "Taxes," and "Other." HOW do I group all...

:D I am trying to make an accounting database that includes 3 (problematic) tables. 1) tblAccounts keyAccountID AccountName OpeningBalance... 2) tblLoanAccountsSupplemental AccountID (key) LoanName InterestRate... 3) tblRealEstateAccountsSupplemental AccountID (key) PropertyName Address...

:D I want to output a snapshot report from Access. I want the user to be able to select the file destination, but the report to have a pre-set name that includes the ".snp" extension (otherwise, the novice user will NEVER know to "save as type" and an unusable program file is saved). Is there...

:confused: I have a table of monthly gross sales reported by retail stores formatted like this TenantID MonthYear GrossSales I want to create a query of MISSING RECORDS (i.e. where a month is not reported). I have also made a table with ALL months. HOW DO I JOIN these these tables in a query...

:( All right, I avoided the problems of fixed column counts in a cross-tab query report by putting each value in the detail field of my report in it's own subreport. (I have 12 months and sales amounts that may or may not have been reported--and I need the report to run regardless. The result...

Because they are more efficient, I am using hyperlinks to connect my forms. I want to be able to deactivate hyperlinks based on criteria that are selected. Please help! :o

I am trying to make a query to prorate rent charges. In order to do this, i need the current charge and the charge directly previuos (BUT there are multiple types of rent and i can't combine different kinds). I have records that look like this: tenantID; startDate; endDate; chargeType...

:eek: I am new to VBA for Access. I want to have one set of functions for all the buttons on my forms. For example, I have a button to go to the next record (btnNext) on many forms. I do not want the same code in every form for the OnClick event of these buttons. I want to call a function...

:D I am using a continuous form, and I cannot figure out what conditional formatting expression to use to change controls in the ACTIVE RECORD. For example, continuous form may have: RECORD1: Field 1 Field 2 Field 3 Field 4 RECORD2: Field 1 Field 2 Field 3 Field 4 RECORD3: Field 1...

I have 2 forms: Employee List and Employee Info I want to be able to select an employee in my combo box on Employee List form, then click a hyperlink/button and go to THAT employee's information on Employee Info. The CAVEAT: I want to have the FULL recordset for Employee Info form(i.e. i do...

I have 2 forms: Employee List and Employee Info I want to be able to select an employee in my combo box on Employee List form, then click a hyperlink/button and go to THAT employee's information on Employee Info. The CAVEAT: I want to have the FULL recordset for Employee Info form(i.e. i do...

I have 2 data access pages. The first has a list of buildings, the second a list of staff assigned to buildings. I use hyperlinks from the first to go to the second and filter based on building. I want to use the second to be able to modify which staff are assigned to the building. This...

:confused: I have a subform set to continuous forms view, allowing a user to enter multiple addresses for each parent record. Next each address field in the subform detail, i have a hyperlink "Envelope" that I want to be able to click and print an envelope report with the address FOR THAT...

:mad: I don't know WHAT to DO! I have two data access pages, I have followed every instruction to a T on using a hyperlink on the first to find the associated record on the second, and still I get errors saying "No value provided for one or more parameters." I have 5x checked the spelling of...

I am trying to force the Detail section of my report to repeat for each month between two dates. I have tried doing a VB counter to repeat the detail in On_Format event, changing the dates using Unbound fields based on the counter. However, the On_Format event only occurs once and bound data...

I have been struggling and researching for an answer to this problem for so so long! :mad: What I am trying to do is have a table for a charge to a customer, have a start and end date for this specific charge, and have the report make an invoice (or repeat the detail) for EACH MONTH between...