Search results

Hi John, I had tried this sequence of events earlier but had coded the button to call the report in normal view. Naturally Access prompted me for the parameter each time I switched views. Your answer made me realize that, duh, my button should call the report to open in Print Preview mode...

Hi all, I am using Access 2007. I am using a query by form to specify a parameter for a report (the year). The form has two controls, a combo listing the years and a button to call the report. I really want the form to close automatically once the user presses the button and calls the...

this fixed my problem perfectly. thank you!

I am using Access 2007 and have created a juncture table to accommodate a many-to-many relationship between projects and checks in my database. The juncture table contains foreign keys of both the ProjectID PK from tbl_Projects and the CheckID PK from tbl_Checks. I use a data-entry form to...

Using Access 2007, I need a report that serves as a ledger. The database tracks a bank account used to pay for projects. The account receives deposits, and I write checks against the account to pay for the projects. The account has a one-to-many relationship with the deposits (the credits of...

Hi Mr. Larson, Thanks for your quick reply. I am putting two reports on two pages of a tab control in a report, not a form. I mistyped that - my apologies. Also - thanks for the tip on querying by form. In an earlier version of the report that I am creating, I used a report/subreport...

Hi all, I am using Access 2007 and I am trying to create a tabbed report. I tried doing this by adding a Tab Control in the Design section and then inserting a report on each of the tabs. Both of the reports are based on parameter queries, and when I try to open the form in Form View, Access...

I got it! I first made a query with an outer join that pulled all records from the junction table and only matching records from tbl_checks. Also included both fields from my juncture table. I then made a second query and linked the first query to tbl_Projects with a normal join (linked on...

Thank you so much for your quick reply. I followed your steps, and Access gave me the following message: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join...

I am using Access 2007. I have two tables, tbl_PROJECTS and tbl_CHECKS. Tbl_PROJECTS has a ProjectID field and Project Name field. Tbl_CHECKS has a CheckID and Check Number field. These tables are connected in a many-to-many relationship through a juncture table called tbl_Projects Checks mm...

Hi all, I have a table, tbl_Account Years, which stores annual financial data for several bank accounts. I have a primary key ID field (AutoNumber), an Account Number field, a Year field, and an Amount field. This allows the user to store what each account had for each year. I want a form...

Oh, no. Changing the OnLoad event to Me![Director] didn't work after all. I now have a compile error saying "Method or data member not found." What field should go between the brackets? I originally used DirectorID since I thought I needed to pass the bound column but obviously that didn't...

I deleted the extra equals sign and that gave me my message box. I received a 'Run Time Error' 2113 after that, so in my form's OnLoad event I changed Me![DirectorID] to Me![Director]. That allows me to enter the new data in a form - perfect. The only thing is that when I click out of the...

I have a form to enter bank info, and a combo on this form (cbo1) lists bank directors. The combobox is based on tbl_Directors containing three fields: DirectorID (AutoNumber), LastName, and FirstName. Cbo1 has two columns, DirectorID (the bound column, not shown) and an expression that displays...

I moved it to the Amount control and it works like a charm! Thank you so much!

I apologize for my delayed reply. There is only one column in the combobox and it lists the values "Debit" and "Credit." The Amount field is of Currency data type.

I, too, like the credit side and need more of it! vbaInet, I used your code for the BeforeUpdate event of my form, but I am still able to put negative amounts for Credit and positive for Debit. No error message pops up at all. The combobox from which I select "Debit" and Credit" is unbound...

JR - I didn't know this about Len. Thank you! DCrake - is this code for the BeforeUpdate event of the form? Or should i put it somewhere else. Also, I am a bit confused as to why I multiply Amount by (-1) if Combo = "Credit". I need the credits to be entered as positive numbers. Thank...

Hello all, I am using Access 2007 and have a form to enter debit and credits for a bank account. I have an unbound combo box named "Transaction" and it contains 2 options, Debit and Credit. There is also an "Amount" text box in which to enter the debit or credit amount. When the user selects...

Thank you all so much for your help. Changing the comboboxes to unbound solved the problem of combobox selections modifying data in the underlying table. I also placed a "GoToRecord New" macro in the "On Load" property of the main form, which opens it blank. I have one follow-up question...