Recent content by russ1985

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.

Thanks for the reply. They are actually 10-20 separate reports. in my code I have only put 1 but this would be repeated for each report name.

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...

Thanks for the reply. After your confirm that it should work in principal i looked through absolutely everything and found that in my table one of the fields it was using as criteria was a list box and it was bound to the wrong column. thanks again for all your help.

Thanks for supplying that but it gives the same problem as first line. no error but it just displays no number in the field. i have double checked the content of the fields and they do match the criteria so they should show. but is is acting as if nothing matches the criteria.

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...

Thanks, Ironically it searched access's 'online' help LOL. Found it now i have included below for any future persons. Shell "cmd.exe /c Start ""Electronic Document"" ""k:/ed/" & Me.fieldname & ".pdf""", vbHide Thanks very much.

My apologies, i have searched for the word Shell as instructed but only can find vague forum posts none of which explain what it is. Is there any possibility you can elaborate or help with the code as requested? Thanks and apologies for the thickness again.

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...

Hi Thanks for the code worked a treat. to answer your question i want to save the user needing to open a different form for different queries and tables. much better to just have a button to change the record source to run from a different table/query. thanks again.

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...

Sorry again for my thinkness but i am getting the following error message when i try to run the query Undefined Function [Forms]![New Enquiry]![Property Size].Column(1) in expression.

sorry for my thinkness but i do not understand how to change the boundcolumn 'edit: sorry this last code was horseshit. I'v tested it but it coulden't work. To use a combo box you must change the boundcolumn to the correct column, in my example it would be BoundColumn = 2'