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

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

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

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

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

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

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

Hi, I have created a database for multiusers, have split the frond end etc and all is working well. My only problem now is that I have hidden the database window and tool bars on the Users PC's BUT I have a button on one of my forms which opens another form and prints it. When I click this...

What I'm trying to do is have a button to print a letter to a specific customer, then record the date the letter was printed in the field in the customer table. Any ideas?? Help much appreciated!

I have had a problem ever since I sorted out the integrity on a shared database. Everytime I try to build a query and I bring in a second table - access crashes and exits. Does anybody have any idea what I've done wrong?

Hi there, I have a problem with Access Security . . . Using Access 2002 (XP) and trying to create a multi user database . . . I have set up all my security (groups, users etc) and then split the back-end. When I try to connect one of the workstations with just the forms etc on I am not...

Has anyone any idea how to open a form in VBA based upon an If statement??? Basically I want to open a form when I get a certain answer in a combo box! I have no probs opening a form after updating a text box but I cannot limit it to only open when a certain answer is given! ANY IDEAS?????????

Does anyone have any idea of how to copy text from one text box to another in the same form? I have been trying for hours and have had no joy whatsoever! Any answers VERY gratefully received!

I'm really new to this and I am struggling! I have set up a database and am attempting to operate an ordering system through it. I have recently encountered a problem. I am attempting to bring prices from a list in a stock item table into the order table (via an order form) but sometimes I...