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

How do I avoid the crosstab query problem where if one month has NO record, the whole report will not run (this is due to a fixed number of columns (12 for 12 months) but an empty crosstab dataset for one month).

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

How do I lock the hyperlink field? (Sorry, I'm a newbie) :rolleyes:

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

How about a different approach to the question: What is the best way to look up ONE piece of information by inputting a set of criteria it has to meet?

When I change everything to strings, the query doesn't return anything. I'm also doing this through the Access query interface so I can't define variables as suggested (x=...) Any other suggestions?

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

BRILLIANT! THANK YOU! I have a general question: since my application is getting bulky and SLOW... how does this coding affect its speed? What causes an application to slow down the most?

Thank you for your help. It works beautifully. Since you are a guru, what is the single biggest thing I can do to speed up the opening of my Access application. It uses one main, big form with subforms and lots of queried data, but all of it is essential. As is, it's getting to a point where...

where EXACTLY (remember, I am dumb) do I put "GotoNextRecord" I am going to the properties window for the button, and putting "GotoNextRecord" in the On Click event. I get this error: "DB can't find the Macro 'GotoNextRecord.' . . . "

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

Thanks for the link. This does what I want, for sure, yet it is so convoluted and code intensive. My database is getting too big and slow. Is there no simpler way to do this? For example, some kind of "me.currentrecord" statement in the Conditional Formatting box?

: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 am a huge fan of combo box lookups. BOTH of my forms have them. I want to be able to edit the information on the Employee List form, looking up employees quickly with a combo box. THEN IF NEEDED, drill down into the Employee Info form to THAT employee. I want this form to function...

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