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...
hi .. does neone know how i can change a bmp to an icon .. cause if i use the bmp as the icon the picture in the icon looks too small ... so i thought the only way would be to change it to an icon ... ne ideas ??
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") is doesnt work...
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...
hey why not set up another command button, and in thier do the following
On Error GoTo Err_Save_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.GoToRecord , , acNewRec
Exit_Save_Click:
Exit Sub
basically this will clear the combo-box for the next...
hey guys ... just wondering if u can sort something out for .. well basically i have set up a database which is running fine .. but theres one thing i need to do, which is, when i delete all records from the tables i want the AutoNumber to restart again .... for some reason i cant seem to get it...
ok i dont want to be creatin a new table, cause the DB i am designing is actually for those who are not computer lit ... therefore was i delete all the records from the tables, i will still use the same table, but the counter has not been re-setted, therefore i need to know how to re-sit the...
Hi .... in VBA how would u re-set a counter having deleted a number of tables .... ???? so basically u i want the counter to start back from 1 again !!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.