Search results for query: *

A field in an Access table is formated as Short Time which displays the value as 7:25. If I export this table to a tab delimited text file the same field displays as 12/30/1899 7:25:00. How do I change the format to remove the 12/30/1899.

Access has a query function to find duplicate records in a table, but is it possible to automatically delete the 2nd occurance of duplicates ?

Your suggestion worked fine. Thank you

I want to be able to locate a specific record in a table by filtering the records using an input box on the form. If the complete description in the order field is 100073856, I need to be able to select the record by entering only 7385. The code I have constructed thus far works only if I enter...

How do you pause an Excel macro at the print menu to allow for user input of number of copies.

If I call for, in the criteria line of a query a prompt, that would require an input, such as a City, is it possible for that prompt to be in the form of a combo or list box that would provide a list of choices from a drop down.

I have created an application calling for the entry in one Combo Box (Customer) which then populates the dropdown list of a second Combo Box (Structure).The code seems to work except when I try to change my selection from the first item in the Structure field. Clicking on the down arrow to enter...

How would I create the following. In a form with 2 combo box fields, Customer and Products, When I exit the Customer field with and entry of "A" I want the the Products field dropdown to display only Customer "A" products. Likewise, if I choose "B" in the Customer field, I want the Preducts...

AceMan1 That's got it !!!!!! Thank you very much Dickx

AceMan1 Hopefully one last question/problem. Plugging in the above code I get the following message "Production Information System can't find the field 'Ans'referred to in your expression" Correction ?? Really appreciate your help Dickx

Thank you again Aceman1 The code worked except one problem. If I enter 2300 (1100PM)as time1,then 0100 (1:00 AM)as time2, I get the elapsed time as 1320 minutes instead of 120 minutes. How do I correct this?

AceMan1 Thank you. Follow up question What would the code be to calculate the time difference in minutes between time1 and time2 if for example, time1 = 1900 (7:00 pm) and 0700 (7:00am) Should be 720 minutes Dickx

AM or PM is not entered

Is it possible to enter a time as a short time, and on field exit, convert the display to military (24 hour) time.

How to open an Excel spreadsheet to a specific worksheet and cell address.

What would be the code behind a command button in Access to open Excel to a specific spreadsheet and worksheet. c:\order.xls Worksheet Summary

Using Excel's auto filter function, how can I change the color of the drop down filter or the column that I am filtering.

Yes. My purpose is to create derived (calculated) fields in table B based on enteries made in table A and linked to table B

How do I link tables within the same database so that entry into multiple fields in table A will automatically populate the same fields in table B.

How do you reset an Auto number field back to record 1