Search results

If I click New Record button on the Switchboard, I want to display the Form with no data. Then click the Add Record to add the record to the table. If I click Find Record button on the Switchboard, I want to go to a subform, enter the key and have the same Form display the data. Can I use...

Thanks Thanks, I think this is precisely what I need. I will give it a whirl and see what happens.

Look up name I am running the query from a form where the Lastname, Firstname and Telephone will be passed to the query. There will always be the case where multiple records will be brought back. i.e. only a partial LastName is inputted or like your case where two people have the same LastName...

I have a table with patient's data. I have made the key the LastName, FirstName and Telephone. How can I query a patient by putting: 1. a partial LastName, no FirstName, no Telephone 2. a LastName, a partial FirstName, no Telephone 3. etc.

Update Thanks, this worked great

dateadd By adding 100 years with the dateadd function, will it only display the new date or can I update the db also?

I am accessing a FroPro DB. It has a Date/Time field with SOME bogus fields (01/01/1900) instead of (01/01/2000). Is there a query I can run to only change the CC part of the MM/DD/CCYY field in the DB.

Worked great!!!! Thanks

No, where dio I do this?

Oops Sorry for the confusion. I have a four column query, one combo box displaying the contains of one sorted column of the table and three text boxes displaying the corresponding data for the item displayed on the combo box. The data on the three text boxes does not change as I focus and...

Combo I was not trying to display the other columns in the combo box. I had already clicked and dragged the other columns from the Field List to the form. I go to the combo box and click any of the entities and the other textboxes do not display the corresponding data.

I have a form based on a query. The query reads a four column table and sorts one column. I have a combo box based on the query with the sorted column as the row source. Also on the form are the other columns. How can I get the other columns to display their data fields when I click on an...

I opened the table in Design View and the field is indeed defined as Date/Time. I get an ODBC - Call Failed error when I run the Form. If I run the Query by itself, It will query me for the input. If I type 10/10/1996 and 10/10/2002, I get an ODBC - Call Failed error. If I type #10/10/1996# and...

No Bueno I am sure the names are correct because I used the Build and picked up the Control Names from the Form. And I am running the Query by executing it in a Macro run by clicking on a Command Button, which leaves the form open. The Data Base is a DB2 table though. I was told that the format...

Date from Form This is the SQL SELECT PROD_TDSXFRHS.TRNF_SRP_N, PROD_TDSXFRHS.TRNF_LC_CHG_D FROM PROD_TDSXFRHS WHERE (((PROD_TDSXFRHS.TRNF_LC_CHG_D) Between [Forms]![DateRange]![fromdate] And [Forms]![DateRange]![todate])); I am inputting fromdate and todate in two Text Boxes in my Form. I...

I am trying to pass a Beginning and End date from a Text Box on a form to a Between Beginning And End criteria on a query, but it does not work. Not even just passing a date from a query works. What am I doing wrong?