Search results

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

Yeah, That's exactly what I've done - the field is in the table - (as a check box) my problem is that I can't get the field to display on the form and update dependant upon which vehicle is chosen . . . The combo box gets it's data from Select Query (to which I have also added the CheckPrice...

Thanks both . . . With regards to formatting if I put a check box on the form with the following code in the After Update I can change the text colour Sub Check_Price() If Me.CheckPrice = True Then Me.Vehicle.ForeColor = Red 'Change text to red Else: Me.Vehicle.ForeColor = Black 'Change text...

Hi I am having problems . . I have a form which is basically an order form. It contains Customer Deatails, order details etc. One of the features of the form is a Combo box used to select a particular vehicle - this works fine - using a Select query for its data. Anyway, I have added a...

Thanks for that . .. . I'll give it a go - my biggest problem is going to be selecting the value to make the change. The combo contains a list of Over 500 vehicles - I want to make changes for all entries containing Mercedes, BMW and other marques . . . I'll crack on with your suggestion so...

Hi, I have a combo box in a form and dependent upon what is selected I want to display different formatting. Ideally I would like to display some entries in red. If I could change the colour of an individual record in the table my problem would be solved - but I can't find a way of doing...