Search results for query: *

I have a three table query...the last table being the vendor table. On the form, I need to key in a vendor number and automatically populate the name and address field from the vendor table. I have made this work, however I need to do this 5 different times on the form....different vendors on...

Thanks anyway, I got it to work.

How to you make a field on a form default to 0 whenever the form is opened? On properties, I have put =0 in the default value but it will not work. Any suggestions?

I use the following to calculate age based on the birthdate entered on a form Expr1: IIf(IsNull([Birthdate]),Null,IIf(CDate(Month([birthdate]) & "/" & Day([birthdate]) & "/" & Year(Date()))>Date(),DateDiff("yyyy",[birthdate],Date())-1,DateDiff("yyyy",[birthdate],Date()))) It works fine until a...

I have a form (frmApplication...using record source tbldemgraphics) where I key in social security number (SSNODemo). Once it is keyed, I want to search the table tbldemographics for this number. I am searching in the fields HHM1 Social Sec No, HHM2 Social Sec No, and HHM3 Social Sec No. If...

I have a form where social security number is entered. The name is SSNODemo. When this number is entered, I want to do a search on the table Demographics in the field called HHM1 Social Sec No to see if there is a duplicate number. If there is, I want to display a message box stating the...

Is there an easy way to print empty forms? I need to print a form I have been working on to show and I am having a hard time.

I have a pc with XP as the operating system. On the system, I have an application. I need to run the application remotely from another XP pc. I have mapped to the hard drive and folder on the host pc where the application is stored. On the remote pc, I can see the whole hard drive of the...

I have a query that needs to pull info from three tables. The three tables are: tblEmp - primary key of social security number tblEmpChg - no primary key tblLocalTravel - no primary key tblEmp is linked to tblEmpChg by SSNO tblEmp is linked to tblLocalTravel by EmpSocial My test queries of...

First, what is the difference between MDB and MDE? Also, I highlighted the table and went to properties, but did not see anything about attributes. What did I do wrong?

Ok, I have the syntax working now. However, when I enter a user id, the msgbox appears whether the id is valid or not. It is as if the Dlookup statement is being ignored and the Else condition is executed not matter what. Any suggestions?

What is wrong with this code? I cannot get the Dlookup statement to compile. Field Names ********************************** User = Name of field on table tblUser = Name of table the lookup is occuring Name = Name of field on logon form *************************************** Private Sub...

Is there a way to block users from looking or altering the underlying tables? I have some users that stumbled upon the tables and are now in a position to alter data.

Thanks. If the user is found, I would like to open another form. What is the code to do this?

I am trying to develope a database that requires the user to login. I have a login form where the user will enter his id. I have a user table that will have user id's stored. When I click the enter button, I would like access to take the data entered on the form and compare it to the user...

The unique field is Social Security Number. The table is tblChild. For this particular report, I want Case ID, Date Entered, Name, Address, City, State and Zip. Birthdate and Gender. Thanks

I have a child advocacy database where a child is entered with a unique case id. For Federal reporting, a count of the cases during a certain time period is required...no problem. I run a query with a date range parameter...design a report based on that query that will print the records for...

I have a database that has employee records. In some instances, there are duplicate records in the database that are an integral part. I want a report to list the employee records but not the duplicates. How do I construct the query to only print the duplicate records once?

I have a form the will calculate age based on system date and birthdate. The formula to do this is located in the query that the report is based upon. The formula consists of an IFF statement that not only calculates age but accounts for the fact that the birthday has not occured yet for the...

I need to print a report that is based on a query that is based on a table. The table/query will have duplicate social security numbers. On the report, I do not want the duplicates to print. How do I go about filtering out the duplicate social security numbers so they will only print once on...