Search results

Hi, I have a report which has a few headers: 1. A static area on the top with company info, etc. 2. A details section for product info. 3. A static area on the bottom with some basic info. I'm trying to draw a single border and some lines which extends throughout the entire report page...

Hi, I have a form (called PersonalTaxPriceSheet) with an unbound textbox called SubTotal. This SubTotal field is calculated directly on the form. For example, on the form if the user chooses Option 1, the SubTotal textbox would update to $44.95. If the user chooses Option 2, the SubTotal...

Hi all, I basically have a long form which requires me to use the right side scroll bar to complete everything. I currently have a top header area (which is great because it is viewable even as you scroll all the way down). I'm wondering if Access is capable of having a "side header" (for...

Hi all, I currently have 2 databases: a main current database (Main.mdb), and a secondary database (Working.mdb). They are identical, except the working database has no data, just the existing tables, forms, etc. from the main database. When I (or a programmer) makes changes to the forms and...

Hi all, I have a Form which calculates how much to charge a client. I have a "Fee" field, and a few calculated fields based on this fee. The calculated field I'm having problems with is the "Tax" Field. Prior to July 1, 2006, i had no problems. The tax was basically " =[Fee]*.07 " in...

Hi all, I have created an Email button on a form, which automatically opens Outlook once pressed, and attaches a report (rpt_Form1) to the email. My problem is that I want to have the report in the body of the email (as opposed to an attachment). I've searched this topic and found some help...

My access database is on one central desktop. When I go to the office, my laptop "connects" with this central desktop and uses the database. Also, my partner's laptop connects with this central desktop as well. For some reason, when I connect to the central desktop's database via my laptop...

My query contains two calculated fields [TaxSavings1] and [TaxSavings2], which are based on some currency and number-type fields in one of my underlying tables. I just created another field in my query which looks like: [TaxSavings1]+[TaxSavings2]. Instead of adding the two fields, it...

I'm sure it's a simple fix, but I've been trying to figure it out for the last hour here... Basically, I'm creating an expression in a query that adds the numbers in 10 fields from a table to give the total. I.e.: Expression: [Amount1]+[Amount2]+[Amount3]...+[Amount10] The [Amount1]...

I am creating a query based on two tables: 1) tblClient (only one primary key "ClientID") and 2) tblContactDate (with two primary keys "ClientID" and "ContactDate"). Each client may have more than one contact date. In the query, I only want the records from the tblContactDate showing for the...

I one of my tables, I have a date field (DateCompleted) with the format: mm/dd/yyyy Now, I want to create a query which would create another field (DateExpected) by using the date in the above table and adding 5 months to the date. The only issue is that for the new field in the query I want...

I have a table with one primary key (ClientID) which is an autonumber (cannot be duplicated), and another field which is a number field which is set to a random 6 digits (also cannot be duplicated) whenever a new client record is created. Now, the main database is on a desktop, and my partner...

I have a Client Table which has the following Primary Key: "Control ID". The Control ID is an autonumber (ID increases by 1 with each new client). Now, I also need to create another field called "Client ID". The Client ID is unique for each client, but needs to be a random number, in the...

Hi, I have a form and want to change the background color and the record scroll/navigation button colors. Changing the background color is easy; just go into Design View, right click, and change the "background color" properties. Changing the record select button (on the bottom of the form)...

I have a simple table with two fields in that table called: 1. BankName 2. BankNumber Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a...

I have created a report for an underlying table. The underlying table records clients and their income for a certain year or years (in multiple records for client with multiple years). For example, client 1 may show income of $20000 for 2005, and in their second record 2004, income of $10000...

I am trying to incorporate a field in my customer order form for "Invoice Number". Not every customer order form will have an invoice number. The Invoice Number field will default as null, or blank. I want to make it so the Invoice Number gets automatically populated ONLY IF another field...

I have a Form which shows a bunch of client personal info, and 1. fees a client pays, and 2. a calculated value which shows the sum of fees + taxes. I've created a report which also shows the fees for every client, to be an invoice report. Now, on the original Form, I want to be able to...

I have an area on my form for basic marketing information, with the following 4 fields: HowHeardAboutUs: (drop-down box can choose either online, friend, flyer) OnlineMethod: FriendName: FlyerLocation: Now, I want all the irrelevant fields to become inactive and state "n/a" depending on...

-- I'm trying to create a main form (based on the Client table) and two subforms (based on the two other forms). I followed instructions found, and used the wizard. The wizards steps seem to go fine up until the point AFTER i add all the 3 tables and their respective fields...when I click...