Search results

sure open your database then: Tools > Startup > Application Title... hope this helps - Ian

Hi - does your application have a Front End / Back End structure? could it be the default record locking setting on the problematic machine? just a few thoughts Ian

Hi - attached is a form with an autoset box with 2 buttons for selecting next / previous date - is this what your looking for? Ian

It is certainly something that can be automated - i have attached a little calendar form which shows how to select dates based on the calendar control. have a look through - point your parameters to the textboxes for the dates (ie CurrentDate and MonthStart) then a button to print the report...

Possibly create a 3rd table SeatingAllocation with Name and TableNo as columns, with a union query joining Parent and Child tables to populate a single list of all names which could then be used in a dropdown box... Ian

Hi B, You need the code as mentioned above > txtSearch_Change() in order for it to work correctly you need to have both or the text boxes [txtSearch] and [txtSearch2] on your form and named the same. 2nd Point to ensure is that in your query, your form is referenced by its name - i have...

Sounds to me as though you will need to relink the tables. Tools > Database Utilities > Linked Table Manager select the tables that point to the wrong path, tick "prompt for new location" then ok - browse to correct location of data hopefully then all should work again Ian

sorry just spotted a mistake in the previous attachment - rectified in this one, time did not update on change.

Hi - the query you need to edit is: "qryCDNoAsc" that is the one used to populate the list box when the form first loads, the others are only used when you click on the labels to re-order the list. Hi Have attached a cut down version you could have a look at - and also incorporated a few other...

A bit long winded but... if you use workgroup security... create a module and copy the following into it: (saved mine as mdlUserFunctions) (i have set the controls to be disabled by default on form load and then they are enabled as required - can also set controls to be invisible so the users...

Hi - I have a similar scenario, but use a form with the pop-up and modal properties set to yes, and then resize it to a suitable size. I load the form with the on click event of the code used to launch the target form and when the target form has loaded after processing and loading the data -...

Hi - apologies if that is your code ghudson - i know i found it somewhere on this forum and couldnt remember who or where it was to credit the author. Does anyone know if it is possible to add a password mask when typing in the password rather than it being in readable text? Kind Regards, Ian

to disable the warning dialogue "you are about to append x records" add the setwarnings properties before and after your code as: DoCmd.SetWarnings False stDocName = "Your_Query_Name" DoCmd.OpenQuery stDocName, acNormal, acEdit DoCmd.SetWarnings True Ian

The main thing to remember when disabling startup options via code - is that you have a way of re-enabling them I found and use a piece of code that allows these options to be enabled and disabled by the use of a password... which is a extremly useful, i use the code within the "on click" event...

Just a thought - are you altering the margins in page setup in design view or not. I think the margins only remain saved if you change in design view not page / report view Ian

Hi - this should work for you - add this to the on click event of a button on a form where you wish your user to select the password protected form: Dim strInput As String Dim strMsg As String Dim stDocName As String Dim stLinkCriteria As String strMsg = "Please Enter the password to open...

Sadie - there is a thread further down the list that sounds like just what you need: http://www.access-programmers.co.uk/forums/showthread.php?t=112195 a query to find matched and non matched records Ian

as a starter: UPDATE tbl_stock SET quantity = quantity+[stock_to_add] WHERE ProductID = ProductID_on_your_form maybe worth adding the extra code that once tickbox is checked it then disables to prevent users from unticking and reticking > adding again to stock Ian

on the toolbar click Σ which then adds the grouping to the query, using the dropdowns select "Expression" for the field you are calculating the sum for. Ian

I have a similar scenario but use a list box and add the following to the "on_double_click" event: Dim stDocName As String Dim stLinkCriteria As String stDocName = "form_you_want_to_open" stLinkCriteria = "[ID]=" & Me![List0] DoCmd.OpenForm stDocName, , ...