Search results

So I've got a field called Date of Expiry for something. Is it possible to change the text box on the form so that if that date of expiry is Today or Earlier instead of showing the date if shows "EXPIRED" or something similar? Or would it be easier to just change the text box colour if it's...

I'm trying to help out my boss with ease of reporting. He made a satisfaction database that tracks satisfaction in 2 ways, so we have: Table ID SatisfactionAType SatisfactionAScore SatisfactionBType SatisfactionBScore I'd like to make a query that would split these into two lines, one for A...

Hey, So recently our team at work was upgraded to 2013, but no one else in the company was. I've recently made a database and get the "You need at least version 14.000.0000.0000etc" error when other uses try and access it. Does anyone know a way of checking what exactly is causing the...

[SOLVED] Can you use Dlookup values as search criteria on a form? Hey, So I'm working on something for housing. Each house has a "Property Reference". This property reference links to all other information on the property. There's two tables, Referral (For a tenant, with the Property...

So I've got a form set up, and it uses a combo box to find the name of a persons record to populate the form. Simple enough stuff, the wizard takes you through it. It works fine. However the people that use the database have kinda thrown me a curveball by asking if the search function can...

Hey everyone. I'm kinda new to VBA so please excuse me if anything is super dumb or impossible :p So I'm making a database for a part of the company who need a better way to hold all their info (You don't want to know how they were recording it before). It's all been simple enough, but now...

Just outta uni last year and now working in the scary real world. Did some database work on my course, but now I need to do some VBA specific stuff which it boggling my mind a little. Living in the UK, South Wales specifically. So... yeah. That's about it.