Hello all, I am trying to open a form in "Datasheet view" using a command button but if i use the wizard, the form opens to "form View", i have tried looking...

First thing is, don't carry calculated values in tables. Calculate them each time you need to use them, both in reports and on forms. "odie123" wrote: ...

I have a form with a state field that I want to force to upper case if it is entered incorrectly.

Hello; I have a form with several command buttons. When clicked, these buttons call up various subforms. All forms are related by one field in my main table...

I want users to fill in opening hours on a form. I planned four rows of multiple choice option buttons each row followed by four text boxes with opening and...

I was trying add some fields to my form and I must of hit something wrong because now none of my information will transfer over to my form or report from the...

I want to show the total of say 4 records in the subform, but I want it to display in the parent form. I tried =sum() in a control box but it doesn't...

I have a form with a text box and a command button. When the user types in a last name and uses the command button it shows the results in a subform. I would...

Looking for the code to pull Initials out of Names example (John S. Smith) J S S Thank you Steve

Hi Guys, Is it possible to type two field names in OrderBy property? e.g OrderBy: ; This works find, but when i exit the DB and start the application again...

I'm just a beginner… How can I use a Form to filter my query results? For example: I want to see product and order information in form view for account...

Hello, i have done this before but i cant recall, how do i enter todays date in a date field by clicking a command button or even have the date already on...

Hi I was wondering if someone can assist. I have a form that user enters Survey details. Among other fields are the Survey Code and the Question number. I...

I have a form that is in the correct position in design view. (although I notice there are horz and vert scroll bars in the design window even though the form...

I have a basic invoice program where I want to populate a form with data from a 'Products' table. The form itself also saves user selections in a...

I work in tourism. We have a form that we collect every month from guesthouses that has a list of all nationalities and then columns for the lenght of stay. It...

Hello! I have a question concerning to open the reports. I know that DoCmd.OpenReport is a obsolete form of opening the reports, but how to implement opening...

I am designing an induction database, there are numerous forms that all open up powerpoint presentations and excel spreadsheet for tests. These are...

I work in transportation and I need to project due dates based on service level and business days. Is there a way to take weekends and holidays into account...

I need to move forward about ten controls in my form if the answer to question 1 is "No". Am using Access with XP. Thanks in advance! Tina.