Search results

Ah, that second part is exactly what I'm looking for, thank you. The form is for display rather than data entry, so it doesn't matter that the user can't edit it. Thank you :D

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

Ah, hadn't heard of Union All. Gave it a google, and it's exactly what I need. As mentioned, I do tend to get lost thinking of more complicated answers to easy questions. Thanks for the help!

I'd agree with the design rethink, but for now this is the hand I've been dealt. What do you mean by simple query? Am I missing something super obvious? Because that happens to me a lot (See a previous thread where I forgot how subforms work)

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

Oh man, it just clicked what you meant. Yeah, I've used subforms before, and yeah, that is a much better option. Thank you so much for guiding me through a brain melt :D

Sorry, could you elaborate on that? Tbh I'd prefer to not faff about Dlookup and just have all the information entered into the referral table, but I want people to have to update as little as possible.

Yeah, sorry, I forget not everyone can see what I'm working on atm :p Basically, two tables: Referral Referral ID Tenant Name Date of Referral Property Reference (The foreign key) Property Info Property Reference (Links to Referral table) Address1 (E.g. 1 Smith Road) County Postcode After...

It's bound to the Referral table, but not the property info table.

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

Brilliant. Thanks for all the help mate :)

Oh yeah, don't worry, I stay away from the reserved words. The actual name for the field is "ReferralName", was just using Name as an example. If you think quickfind is overkill, do you have any suggestions for alternate methods? I don't need code specifically, just something to go research...

Sorry, I should've specified that "Name" is a single field. Would the approach be the same, just Private Sub QuickFind_Change() Me.Filter = "[Name] like '*" & replace(QuickFind.Text,"'","''") & "*'" Me.FilterOn = True End Sub instead?

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.