Recent content by edster

Thanks david, I've suggested this to the company however they have security resevations as he is a sub contractor!

I've had this before too, drove me nuts for ages before i worked it out.

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

Hi David, Its not stock control as such, just used that to try and explain the process. As you say in that case the product type wouls have a record not the items. They are specialised items which require individual tracking hence they receive Auto Ids on the individual records. There are...

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

Thanks george, the problem is they want it to be based on a filing cabinet system not just general searching thats what they've asked me to do with access. I was thinking of using tree view to do that part, eg. expand by years then months etc. or A-Z then by customer name.

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