Search results

Hi all, I'm trying to filter a form and really struggling with it. I've spent some time searching the forum and tried the various solutions posted and can't get it done. I want to filter products based on a checkbox, so a list of around 1000 products filters to show only the 100 or so 'active'...

Thanks Dave, I will give that a go this evening.

Thanks for looking Pat, all thoughts appreciated. I'm sure from a design perspective my application is all wrong, but it does everything that the market leading packages do and a few things that they don't as well. It's a triumph of optimism, ignorance and determination; enough to make a purist...

Well, the date that I want to extract is different in each case so yes I need 100. It's a front end / back end split so the back ends are just sets of tables. This is something of an add on to my database and not part of the original concept but as we get busier I find more things that I think...

Hi Pat, thanks for looking. It's in 100 databases but all the databases have the same structure. In every case the date i'm trying to reference is in a table called 'tblJob' and the field is called 'Date Done'. I will report back on specific wording of the error message, but it's 'could refer...

I did yes, but I don't think that's the answer. The problem is that the date I want to reference is held in around 100 different databases and is called the same thing 'Date Done'. All the databases I'm trying to reference have unique names but the same structure and table names. When I tried...

Hi Guys, I hope I can explain this properly. I have a stock and audit database setup with a folder called 'Outlets', within the outlets folder there are many sets of tables storing data for the various sites we work on. In a separate database I have a scheduling setup which holds site...

Two controls was the way to go, bound and unbound. The function works fine by the look of it so I just need to test it thoroughly and tidy up. Thanks for help fellas.

Thanks guys. That might be enough for me to get this working, I will have another go at it today and let you know.

Thanks for response Bill. I think what I'm after is a field that will accept data input like a calculator, so keying 1 + 1 'enter' will enter the total of 2 into the field. It will be entered into a table and then used in a query from there. I have a calculator in a form already, what I'm...

Hi all, it's dumb question time again :) I'm trying to get a field in one of my forms to calculate a total and write the total to the relevant table. I would like it to work like an excel spreadsheet, number '+' number then 'enter' gives a total. We enter till sales data and there may be...

The tutorials on the Microsoft site are good, they will get you started.

Ok, we are licensed trade stocktakers. We work 'on site' so the site may be a bar or pub. We would typically do 50 jobs per month or have that many sites in our work programme, so that is the number of jobs/sites we would hold on our laptop. Our workflow currently is as described. We would...

Sorry, to try and answer the rest of your question. The '50 jobs' are individual sites that have no relationship to each other, so what I was wondering there is would there be a front end on the handheld unit that can communicate with a back end on the laptop? Would it be the same front end that...

Well, what we do now as I said in my initial post is write down counts as we come across them. We may count the same product half a dozen times and then we would manually total those counts and enter that total into a 'stock on hand' field in the database on a laptop. What I'm asking is how...

But how to export to / from the right place? I might have 50 jobs on my laptop, I work on them one at a time, what would be the process of getting a handheld unit to store and total counts then update the main inventory on my laptop? Does the handheld need to run Access? Can they run Access?

I'm not really interested in barcodes, we never count really big inventories so they would be an added and unnecessary complication. What I really want an idea on is how the handheld unit can do the totalling and send those totals to another computer.

I had a conversation today about PDAs or handheld computers and it got me thinking that I may be able to use a handheld device to speed our process up. We are stocktakers, so traditionally we would use printed count sheets and write down counts as we come across them. We may find the same...

I think that David's daughter may log in to the forum at some stage and I'm sure his family would be pleased to know that he was appreciated and well thought of. I live quite close to his home and he has been enormously helpful with my projects. We had been working together on a database...

I was avoiding the mention of cricket :)