What is the function which can convert date field to string in a specific format? Thanks.

I have a subform in datasheet mode. How do I set the column widths so that they are the same all the time. Am using Access2002

I have a table of equiptment, and each piece of equiptment must be inspected yearly. I have a check box next to each piece of equiptment. If the item...

Hey All I have developed an audit trail using the sample code provided by Microsoft as follows: Public Function WriteAudit(frm As Form, lngPermitNumber) As...

Hi All I am taking the text string that the user enters and passing it to a field in another form that is opened. How do I automatically detect and remove the...

I have a Purchase Order database. I have a combo box that pulls employee names from a table. Is there a way to hide employee names after they have left the...

I have a form frmInvoice which also has a subform on it frmShipments. I can add as many shipments as I like to the same invoice. Each shipment has...

Can you create a Outlook 2003 "Task" from Access 2003

Hello, I have form that I would like to add a time stamp to. Currently, I have a field set up so that when the user tabs to the field and tabs out...

I have a frmorders that I use to place new orders, when the user selects the type of order to place, a unique ordernumber is assign, and then the user enters...

I have two codes that work fine individually but I need them to be combined in the before update event. The way I have it now is the part that checks for...

I am creating a database to keep track of our Consumers and Home Health Aides. I have my tables created and my form for the Consumers. I thought I had my...

I am trying to set up a form from which the user can select a list, and then that selection will determine the next list given to select from. For example. In...

I have 2 tables *tblItem (below is partial list of what it contains) ItemID (pk) ItemNum ItemDescrip GroupID (1 to many with tblGroup. An item may be part of...

We are not able to add records to or make changes to existing records in a subform. New record icon is dark, as it is when opening the table for this subform....

I am the PTA president and need to find a template in Access that can summerize all of the various fields parents hav signed up for at middle school. Any...

Hi, I have a data entry form in which specific numerical data is entered into several different places in the same form. I placed an expression into a text...

How do I position the insertion point in a field 3 spaces from the left?

I know this should be easy, but I am having trouble with opening a form from a button. Here is what I have, a Student Info Form with an Appt History button to...

I want to use AfterUpdate feature to run the query (displayed as a subform) based on the value chosen in the combo box. What visual basic code do I need to add?