Getting Started

Parameter Value
I have to questions. !) How do I set a parameter value for printing a record? I have a form that I enter the information on. I want to put a command button on the form to print the report of the record that I entered the information on. Is there a way to do this and how would I do it? 2) I also would like t... 21 Feb 2007 23:03

all data from query not displaying on report
Access 2003 I have created a query of data from sales by customer and service by customer. Basically, I want to show all invoices billed to a customer, less all service (our costs) and arrive at our net profit by customer. I already have the query created and the report designed. The query is correct, howe... 26 Feb 2007 16:02

2 Questions
Hoping someone can help me out with these two questions: #1 - Is there a way to call a function or procedure at a given time interval? For example, I have a db that is used to create some tasks that need to be accomplished by certain times. I would like to pop-up a warning if the task is 30 minutes away. ... 21 Feb 2007 14:19

Function
Hello, There is a funcition in excel that allows you to say, "If there is an value in this cell and the value = 0 then input XYZ in this cell." Is there something like that in Access? Andre Adams ... 21 Feb 2007 13:47

Register for adsense
Register for Google Adsense and make thousands of dollars a month. Click here http://www.adsenseonline.info to find out how to make over 10,000 ! dollars a month using the tips and techniques only before avaliable to online professionals. Google Adsense tips that have made millions. 2 Co 5:19 - - - - And for the ... 21 Feb 2007 03:23

you don't have australia in your sign ups?
you don't have australia in your sign ups ... 21 Feb 2007 01:50

Multi-field data entry
Is there a way to prevent duplicate records from being entered into a table where certain fields may contain nulls? For instance a name record: Prefix FName MName LName Suffix There can be no middle name, no suffix (Sr, Jr) and rarely only a first name. Multi-key indexing requires that all fields cont... 21 Feb 2007 10:06

Label wizard
Have tried to use a label-wizard generated report to print 3-across labels containing the following 7 fields. Some can be null: Company Address Line 1 Address Line 2 City, State, Country, Zip Code Once in a while a field repeats itself two or three times, vertically, generating more lines on the printed p... 22 Feb 2007 04:08

trouble using access in xp
i have a MS Access database located in a server. when we tried to access the database using computers in xp and ms office 2003, we always lost connection to it. and we do this everyday: open MS Access, locate the workgroup information file before we can use the database. what's the problem? why do these compute... 21 Feb 2007 15:22

Updating a table from a Form...
What is the easiest way to allow changes to certain fields in a table from a form, without erasing other data??? My table contains an EmployeeID, Cert1, Cert1Exp (date), Cert2, Cert2Exp, .... I wish to open a form (or otherwise) and only have to update what needs to be changed... Does that make sense??? ... 21 Feb 2007 01:19