Hello, in the Default Value of the textbox in question I've written this =Format(Now(),"Medium Date") and it works Thanks again for your patience and...

hello everybody... I urgently need an answer to this question: I use the now() fuction but I need it to write only in medium date format. All the textboxes are...

OK Say I have a table called COURSESECTIONS that lists schedule numbers of courses and also facultyID's. I then have a form called FACULTY. On this form, I...

Hi, How is it possible to protect data fields in forms so that if a user wishes to alter a field with data he or she is prompted "Do You Really Want to...

I have a form with Header and Footer sections. I click a button in the Footer section and want to set focus to the Detail section. But I want the focus to go...

How can I set a form so that only additions to the table can be made, and only one record (the current one) shows? IOW, the form will be used for entering...

I am using Access 2000 and I want to alternate row colors in a form or table. I know very little about using Access. I tried copying the code from Stephan...

I'm using the "Order Entry" template supplied with Access. I rearranged the fields on one of the forms, so the Tab Stop settings were disrupted. I attempted...

Hi all! What I am doing is this: I have a combo box named: cboBridge and it is a drop-down to a list of 5 bridges. In the table Bridges I have ID, Bridge...

How can you do this in Access VBA code?

This may accidently be posted twice. I'm not for sure if I will explain this well enough to understand but I will try. I am making a sewer bypass record...

I have used the built in 'Find Record' facility behind a command button. The problem I have is when the form it's on opens, it won't work unless I select a...

How to determine the position of theLEFT nesrest numeric value in a string in a query? For example Microsoft2xyz = 10 and Oracle3xyz5hjg = 7 etc

I am going to ask this again as I didn't receive any worthwhile feedback the first time. This time I will be a little more clear. I have a customer service...

In the Form Header for my subform, I am trying to add up the values based on the value in another field in that sub form record. Specifically, I am trying...

I need to enter percentages by product for each business unit and function. I would like to display the data entry form in kind of a crosstab format as...

Albert - Spmetimes, on some of my forms and in the documents that we produce via SupeEasyWordMerge, there is some optional content. Here is one example: We...

(Access 97) I have a main form "Customers"and a subform "Orders" linked via CustomerID. I have the field name "AccountName" in both tables. I would like to...

I think I did a major no no in Access 2003. I tried to change the name of one of the sub-switchboard names and now I get the following error message...

My database is used for “importing� Excel reports, then running the “Find Duplicate Query Wizard�. I need to build a form that will allow users to...