I have a date on my subform (TransactionDate) that I don't want to have shown but I want it to be filled in by the date (OrderDate) on the main form....

I have a Form with 2 subforms, in the subforms one is for taxable and the other is for non-taxable amounts. I then have a report running from a query that...

Is it possible to have say 3 background colors on a single form? If yes how is it done or worked around? TIA john

How can I send a SNP file to a my aaa folder on my c drive. Here is what I have so far. Thanks. DoCmd.SendObject acSendReport, "123report", acFormatSNP,...

Hi: I want to create a Custom Proposal Number that works like this: AA: Does not change 2007: This Year ABCD: Client Initials 001: First Proposal This Year...

I'm currently busy with the following: I have made the navigation buttons on my forms invisible, and added my own buttons on the form instead. Future users...

I've created a field for age in days on my subform. I'm trying to calculate the difference between date of birth (main form) and date of occurance...

This is my situation: I have a form that I might use in more than one place, so I don't want to use a fully qualified reference to a control on it within...

Hello: I have a created a form with two textboxes on there with the intention of letting users fill in dates on there for further input. In order to prevent...

Is there any way to rotate a text field 90 degrees? I want to print the title of an album along the spine of the box. Thanks in advance for any help. --...

Does anyone know a few good to excellent websites where I can read up on programming (syntax and style) in Access MDB and/or VB? Thanks Missy

Hi, I have set up a form that has a series of related sub-forms on Tab controls (it's a Contact management database, so the subforms/tabs contain information...

This may seem like an easy issue but I'm a bit stumped. I wrote a decent sized application in Access using a few forms and a whole bunch of VBA. My computer...

I created a main form that uses 4 subforms. All of the records show up perfectly, but I am not allowed to enter a new record OR update the existing records...

I am sorry I was extremely confusing. Let me try this again. I have three tables as listed below: Table1 Table2 ...

I have a form where the sum of a particular datasheet view field must be shown. Essentially it is a time tracking form where each step is recorded in the...

I would like to supress the error message which comes as err.number 0. "You can't save this record at this time. may have encountered an error while tryign...

I created a field in my table and made it a hyperlink field, when I drag and drop it into my form it makes it a field and not a command button (what I want)....

I have 4 field boxes that I want to join, but with a non-Field word (to) appearing in the middle of the sentence. Like this: Main St, E1 To South St, N1 My...

I have hours of failed research into this problem, so I sure hope I didn't pass over an obvious answer somewhere in here. Main Form based on...