Search results

Hi, I have a central database with multiple users on a fixed network. However now there is a need for an external service engineer to enter his service data into the database. He will very rarely be in the office so wants a way of doing this remotely. I'm looking for a solution really, my...

I have a form that adds an item into stock(every item has its own record), normally these are single one off items however now there will also be bulk orders of up to 25 identical items. I would like a way to add the product infomation, add a new box to enter the number of items then press a...

Hi, I've looked at some of the posts on this subject but just wondering if anyone has an example database I could look at. Many thanks.

Is there any way to have a virtical line in a report automatically fill the page length? Currently the column lines are in the detail section however there may up to three records on the form. With 3 records the lines run the full height of the report however with 1 or 2 they stop before...

Hi, my client has about 10,000 pages of old paper records filed away and wants to convert this to a scanned searchable digital archive. They've looked at existing products and have been put off by the price so have come to me!! Does anyone have any tips on this before i decide to take it on or not?

I'm designing a quotes database and have a problem, I want to add an optional 'Comments' field for each product in the subform so the user can select if they add a addition comment in that product line or not. Default setting is that it isn't shown, when they select 'Add Comment' the text box...

Hi, I’m looking for a bit of help. I have a form 'Holders' which has an autonumber field (holderID) with various other fields containing individual information. What I am looking to do is have a form with four text fields "LotID";"Owner";"Location" and "NumberReceived" Then a command button...

Hi hope you can help me out, I have a query which combines several linked tables, the query has about 10 columns, I need to show only the records which have one or more empty fields. Some records may only have one missing field others may have several. Any ideas? Many thanks, Ed

Hi everyone, hope you can help me with this one: I have a database of products all individually serial numbered. Each serial number will over time have four entry's, Manufacturer to us, us to customer, customer to us, us to manufactuer. I need to create a report which calls up a particular...

Hi everyone, hopefully you'll be able to help me out with this one, been searching but can't find the exact answer. I am running a database with multiple users, max of 10, currently the database autocompacts when it is closed, however this takes time every time anyone closes it. what i am...

I have a serial no combo box which displays serial numbers available for shipment. What i need is some way to make the combo box show the values 'serial numbers in stock' (simple sql) when the [tocompany] is not 'CVP' and to show 'serial numbers out' (another simple query) when the [tocompany]...

I have a database for taking orders for books, leaflets etc, what i want to do is this: When I receive a delivery of stock I enter how many of each ‘Product’ I have received, I then want Access to allocate these to the various orders to make then ready for collection. For example, if five...

Hi all I'm currently developing a new complex report which uses about 35 DCount functions and a couple of sub reports, this all works fine on the computer i've developed it on (768MB ram) however on friday i demoed it to the directors on one of the companies user computers and only 6 of the...

Hi all I'm currently developing a new complex report which uses about 35 DCount functions and a couple of sub reports, this all works fine on the computer i've developed it on (768MB ram) however on friday i demoed it to the directors on one of the companies user computers and only 6 of the...

Tomorrow i'm preparing to split the current database into front/back end databases. At the moment there are five users opening the whole database at any time, from reading other posts splitting it should improve speed and management. Just want to check (before i mess it up) that the users will...

I have a main form which is linked through a [PackageID] field to a subform. i wast to use the same form for both shipments in and out. the subform has a list of serial numbers add for each [package id]. On the main form i have addresses ect and then a combo box onthe [PackageID] field which...

Currently i have a table with approximatly 1000 records in it. Each record has three calculations in it 1) to find out the products age 2) to do calculation based on this 3) to multiply stage 2 by 37. As these are date dependable every record needs to be updated every day, at the moment i am...

Hi Ive just come across a problem, i used the code basics from the example database 'FormSave' which resulted in what i wanted - a working cancel button and a save button on a form, brilliant however this is what i descovered when i came to test it: The form has a subform which is linked to the...

Hi I've just up loaded a database onto a company server to allow all employees to use it. The problem is that now if i try to compact it a warning comes up about not being able to find a file or something (i forgot to write down what it said!!) I seem to remembe reading somewhere that this was...

Hi all, this site it a bit of a god send.hope you can help me, i've had a go at trying to code this myself but can't quite get it to happen. i need a piece of code which will cause a message box to pop up if the value of a check box on a form is "True". I want it so that if the value is false...