Search results

I struggle with the 'lease' model on these things, I much prefer a world where I buy something and it's mine to keep but the world changes. I'm pleased to find that Access 2007 is still relevant though; a little light in my cynical worldview :) Thanks for input guys; appreciated.

Thanks for the welcome :) I'm super rusty but there's nothing complex about the new project at this stage, just a few forms and data storage, so I'll make a start with some confidence that I'm not heading into a technological dead-end; thanks for that.

I haven't done anything with Access for a long while but my last big project, a stocktaking DB, is still working like a charm. It's still my daily workhorse and has kept me going for the best part of ten years so absolute kudos to all the knowledgable folk here and the few who I drove potty...

Just tried that and it worked a treat, thanks :)

I didn't think of other things being entered, you have to think of everything don't you? The numbers, 1 - 5 , are stored in a table and queried from there so inputting the number ( I think ) is necessary.

How would that work in the table though? I'm entering the numbers into a table, does a combo box not need a list of stored numbers to pick from?

The message box should appear when the user enters a number higher than 5. The message reads 'please enter a number between 1 and 5' It's a form that is tabbed through and this is a textbox. It's a '5x5' risk assessment so only numbers 1 to 5 should be used.

Need some help with a message box if possible, thanks in advance. I have a text box that the user enters a number into between 1 and 5. I can use the validation rule in the table and that works nicely, the trouble is that I don't want the standard Access message box. I've read through the...

Resolved I think, forms do the looking up. No need to do it at table level. Thanks John :)

Thanks for the sample, I like that and can see how it's working I think. It looks to me like the tables don't reference each other, the form references them both. What if I'm trying to reference tables directly though? If I have tbl_clients and tbl_sites, where one client may have several...

...are, I fully accept, the work of the devil. So what do we use instead? My last database ran into some issues because of my clumsy/inept design and probably the biggest mistake ( among many :) ) was using lookups to reference one table from another. I want to get this one right from the...

The option group was perfect for me, all working now, thanks Bob :)

That looks perfect, many thanks Bob :) I will test it and let you know if I can get it to work; I have a history with these things...

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