Search results

Ahem, apologies...

Hi Dave, been a while :) I haven't installed Access on this one. I was curious about compatibility but it seems like compatibility isn't an issue. I'll see if I can get it installed, it's a legit copy albeit a bit old

This is the database. All it was designed to do is recorded customer entry in a members' club, the customer just scanned a key tag and the DB recorded their entry. It helped us fulfil a licensing requirement. I'm wondering now if we could use it for the basis of a loyalty scheme for a bar. The...

That would be really helpful, thanks. I'll get a copy posted

No, I don't have access on this laptop. If 2007 is compatible though I may be able to start there

The error is what I said originally, it just says 'runtime error'. I was just guessing at compatibility because of the age, 2007 is a long long time ago in computering world :)

I'm getting old too :) It's been a while but I found brilliant help here when developing my work database so... I have a couple of databases developed in Access 2007. They've been working fine for years but my computers are starting to expire now and the databases are less happy running on the...

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