Recent content by DJ100

Hi, I have a multi-user split access db which is running really well. What I really want to do is run an update routine (which is already written) when the first person launches the DB in the morning - but not anyone else. Is there an easy way to look at a flag file somewhere (which will...

Thank you . . . works a treat

Hi, I have written a stock management system in EXCEL (will be migrating it to SQL Server eventually) but one of my users keeps using CTRL+BREAK to break in and make changes to the spreadsheet - then these changes aren't logged - the whole reason for making it form based in the first place -...

Hi, Here goes . . . . I have an order processing DB with several tables. One of these is Orders one is Lineitem. It is possible to have many Lineitem entries to one Order which are entered using a continuous subform. Each Lineitem has a shortcode. What I would like to do is concatonate the...

PDF Writer Anothe good one is PDF 995 - on their developer FAQ they also have a code example which shows you how to print an Access report straight to PDF - without any user intervention . .. If you go to www.pdf995.com you will find it . . .

Thanks Thanks . . . am now sorted :)

Looking for some help . . . I have a VBA project in Excel which is used by several people on my network. As the main spreadsheet can change I save it on our fileserver and each morning the machines automatically make a local copy for use that day. The problem I have is that I have several...

Thank you Got it working - at last - idiot here forgot first column in combo box is column 0 - was trying to populate the text box with a column that doesn't exist! Thanks for your help DJ

Having a problem. I have a combo box on a form that I use to select a vehicle from a table. (tblVehicles) there is another field in the table called category. I have put a text box on the form and I would like it to display the value of the category field when the value in the combo box is...

Hi, I use a combo box on a form to select info and update text boxes on the form . . . Ie Combo Box Shows 3 Fields - to enable selection, Once selected 10 Text Boxes are updated . . . . As the text boxes are bound to the select query for the form (so that the data updates if a different...

Hi, Daft question probably! I have designed a form (for order entry) that contains several sub-forms. I would like to be able to print some hard copies for employees who do not use PC's but occaisionally answer the phone - so I get all the info first time round. Problem is that when I try...

thank you . . . works like a dream :)

Doesn't work I'm afraid . . . There are 4 options in the drop down box and dependent upon which you choose the IIf statement does different things. The problem is only with the client details bit. What I would like it to do is return a space if either [Title] or [Initial] are null. What it...

Thanks - will give it a go . . and let you know!

Hi, I have a text box which has a calulated value dependent upon the value of a drop down list . .. it uses nested IIF statements and works quite well in most cases. However, I have a problem in that the returned value is a combination of other text boxes on the form and if one of them doesn't...