HELP !!!

[159159]

Hey people, i was wondering if ne1 can help me on the following ....

1 = from a shortcut icon from the desktop, i want to open the access database so it takes me straight into the main screen ... (basically so the user does need to go into access and click from there to open the form) ...

2 = i have a textbox where the user will enter the date, but i want this to be automated, therefore making it alot easier for the user

and the final one ...

3 = when going from one screen to the next, i want the forms to be cleared, so when data needs to be inputted they dont need to worry about clearin the screen ... so bascially the forms are cleared before hand ...

can neone help !!!

 

[jon92]

Hi

1. Go to to tools/startup and tick/untick as required and select your startup form ( have a look at help for the switch board)

2. Not sure what your after with that one

 

[jon92]

Hi

1. Go to to tools/startup and tick/untick as required and select your startup form ( have a look at help for the switch board)

2. Not sure what your after with that one

oops clicked submit instead of preview !!

3. Set the Data Entry property to yes - on your input form

HTH

 

[humbleprogrammer]

1. Go to Tools - Startup and set the Display Form/Page to the form you want to open.

2. Type =Format(Date(),"mm/dd/yyyy&quot in your textbox control source.

3. Not sure what you mean when saying "when going from one screen to the next". If you want the forms to be cleared for a new entry when they open, set the Data Entry property to Yes.

 

[159159]

Thanks guys that helped, but one thing, the automated date, yes it had been automated, but now it doesnt save to the tables .... says something about a null value ... cause before my control source was set to Date .. but now having typed in =Format(Date(),"dd/mm/yyyy&quot is doesnt work ...

and as for clearing the form ... where do i find the data entry property .. ??? i still cant seem to clear the forms .. !!!

 

[hymn]

For 2 try now() in the format in the properties
for 3 when you open the form the code = DoCmd.OpenForm stDocName, , , acNew
which should take you to a new record

Hope this helps
Hymn

 

[159159]

i tired the following ... = DoCmd.OpenForm stDocName, , , acNew ... yes it worked but everything i went to another form, and then went back to that form, i new record was created automatically, and i didnt want that ... i just wantted the form to be cleared ready for the next input .... the only way i could see round it was to create another button doing this function ... i didnt really want that but it will have to do .. thanks alot neway guys .. helped me out loads !!