Search results for query: *

I have a table that has three columns: ProjName, AnnualInsp, PLInsp. AnnualInsp and PLInsp are dates--they are never the same date. Annual Insp is always 10 months prior to PLInsp. I would like to create a report that will tell me what Inspections are due each month. For example, If January...

Any help is appreciated: This seems really simple, but I can't seem to get it (still a beginner...) I have a link that opens an rtf file (MS Word Mailing Labels/Custom tag). I would like to run a query that updates the background database with info that the file has been opened--I only want...

I have one form containing a combo box (frmMain). The values in the combo box can be changed/added to from another form (frmContract). Currently, I have to close and reopen frmMain after I save changes in frmContract in order to make my new changes visible in the combo box on frmMain. I know...

Beginner Question - I know I'm missing a key step, but not sure what it is... I've got two tables. The main table contains a foreign key field called PAYMENT. The second table contains a the primary key (autonumber) for each payment type, cash or check: pkPmtType Type 1 Cash 2...

Unable to search by keyword to see if this has been answered in the past, sorry. I have created a form where I would like to add a command button to preview a report based on some criteria entered in my form. For example, in the form, I chose a project "A" which has a primary key...

(Forgive, I am still a beginner..) I am wanting to determine if a user's IP has accessed my site in any random time between now and the past 5 minutes. (I know cookies are the way to go for tracking, but please bear with me). I am currenly collecting the IP along with time that site was...

I am trying to ensure that a radio option is selected before the form is processed. It looks like, from the error message that I am getting, that my validation is not working. Included is the portion of my page containing the validation for the radio option. The error message I am receiving...

I have a field in an Access database called BidDate in which dates are entered in the database as a short date (example) 05/30/02. When I recall the field based on a very simple query, the format of the output looks like this 2002-05-30 00:00:00. Is there a way to modify the apperance of that...

Can someone please tell me how to make a form open automatically upon opening the entire database project? Thank you!

I have inherited an Access database developed by someone else. The primary key in the main table is a number field. This field should be an autonumber field. How do I change the primary key to an autonumber field starting at number 99401? I realize that I can not simply change the field...

This is a fine mess I've gotten myself in--any advice is most appreciated. I am creating a type of library to be accessed over the web (Cold Fusion). I have a book number, a book type (of which there are 2) and the options of either "checked in" or "checked out" for each...