Search results

I have a login form for my access database to control user access to specific forms. For added security I want access to set all active forms visibility to false and display the login form if there has been no activity in say 5 minutes. Is there any way I can do this.

I want 1 button to print about 10-20 reports on 1 click. I have placed VBA on the button to open each report, print then close. DoCmd.OpenReport "maintenancepayments", acViewPreview, "", "", acNormal DoCmd.RunCommand acCmdPrint DoCmd.Close The problem I have is that each report opens...

I am creating a basic stock control query. I have 1 table which is stockitems. 1 table which is orders 1 table which is stockdelivery. I have created a query based on the stock items table and have created an expression to show the amount of stock in total that has been ordered. but I cannot...

I want to be able to in a form click a button which automatically creates a report converts it to .pdf and set the PDF file name to one of the field values and saves it in a specific location (k:/statements) E.G if field "accountno" in tblaccount is 45678 then the pdf would be called...

I have table which holds payments on a client account. If the client pays on a repeating contract I need a form to basically create a record for each future transaction. IE if the client pays monthly on a year contract it would create 12 records in the transactions table with the due date set...

My apologies for being thick. self taught so that means i no nothing. I have been given this to create a hyper-link based on record content however i don't know how to enter it in. I want it to be on a control button that when clicked runs this code. please can someone provide me with the...

I have a form which i want to be able to click a command button and it change the record source of the form from a specific table to a query (which will ask for a parameter to search the table and change the form to show the matching record). can anyone help with some ideas for coding the...

I do not know whether to put this in the form or query forum section (sorry if it’s wrong) I am creating a database to track all enquiries in a letting agents. What I am looking to do is enter the person’s requirements in the form and have a list of all matching properties shown in a sub...