forms don t display on print preview

[chris11590]

Hi,
i am very new at creating anything from access. i created forms which do not display in print preview and print blank. can anyone help me??

also, can anyone give some default values. i am looking for the current time to display on my form, as well as the date. I am using 2002, 2003.

thaks..

chris

 

[jfgambit]

An Unbound TextBox with the Record Source set to =Now() will give you the Current Date and Time. But as Pat stated, a report is better for printing. You can use the same textbox in the report.

 

[chris11590]

i tried now() but that value did not work and i need forms that can be edited and data entered. ironically other forms print.

 

[Mike375]

What came up as a result of Now()

Did you put = in front as in =Now()

If you just entered Now() then it would show #Name?

What do you mean by "i tried now() but that value did not work"...what happened.

 

[chris11590]

it worked thank u can you tell me how to do date only

 

[chris11590]

i need a combox box type button with the ability to add data to table from form. is this possible?

 

[Mike375]

Now() is combo of the current time and date

Date() is the current date

Time() is the current time

 

[Mike375]

On your form in design view select Combo from the tool box. It is then failry clear sailing.

Basically, you use the combo to enter data into a field or use it to find a record.

If you want enter data that is like models of car, methods of payment or whatever then you make a table that has the appropriate entries.

 

[chris11590]

i looking for somthing that is interchangeable with entering data .. such you can enter data from a subform and it will be enter in the table or visa vera, enter info on table and appears on subform. somethin like that. combo box has to be listed on table. no entries accepted from form view.

 

[Mike375]

A form only displays data, it does not hold data. A table holds the data and forms and queries display the data and are used to select what data will display and to perform calculations that relate to the data.

If you enter data in a table and it does not display in the subform then there are other reasons. For example, the subform might not display the record where you made a data entry.

But something is not right if you are entering data directly into a table. A form is the normal method. Tables are only used to enter data via append queries, general data that is in bulk like a large list of names and address details.