Search results

Works great - thanks Bob. There's still one minor issue that I don't know if there'll be a way around - if the partial name matches more than one business then only the records of one of them are shown. Chin chin.

Thanks a lot, I'll try get that working in the morning and let you know how I get on. chin chin

Thanks for the advice, some good tips there I will be using. I'm not sure I explained the main issue very well though - They will be inputting a name or partial name, but from that I need to look up the corresponding number (hence the Dlookup) and filter based on the number. In short, the...

...well for me anyway. I'm a beginner using Access 2007 and have a problem with a filter. I've made filters on other forms without issue but the difference is that on this form the information displayed on the fields to filter (and the text the user will input) are from another table - they...

Got it - for some reason it needed a (1) at the end not (2). Nice trick. Thanks again. chin chin

Hmm.. can't get this working - I assume I replace combobox1 with the name of the one I just set up (combo25)? And column with the name of the column?

It worked - nice one. Yet again I was overthinking things. Thanks a lot, Chin chin

Could you please clarify 'type the number in the textbox' and also, what is the 'first column' please? The others are done. Chin chin

Thanks for pointing out the allowadditions property - that'll work. Re: Combo box, I am already using one but I need it to show the business names yet write the corresponding 'business number'. I've messed around for a while trying to get it to do that but the implementation I've mentioned...

Hi, I am a beginner using Access 2007 and I'm currently working on making my forms user friendly. I have some numbers to enter in a form (corresponding to business names in a different table) and would like for the user to be able to choose from the names rather than the numbers. The way I...

Believe me I've been keeping Google busy! Problem was I was looking at the SQL without considering that there might be an automation. Thanks again.

Great - I managed it from that thanks a lot. I was trying to write the SQL myself and would have never got it right looking at what has been generated. chin chin

Hi, I'm a beginner trying to get to grips with Access 2007 and can't make the query I need - would really appreciate a some advice. I need to count up the number of child entries for each record in a parent table. Sounds like it should be easy but I'm struggling badly. Parent table is called...

That seems to have done it - phew. Thanks a lot for everyone's help. chin chin

So I make a form that just shows that table, then refer to the form in my main form? I'll have a go - thanks.

It's definitely there. Perhaps I put the code in the wrong place - it is just in the module I get if I click 'view code' from the form design view?

Thanks, tried this now: Private Sub Form_Load() Me.[BookNum].ColumnHidden = True End Sub but get a new error saying it can't find the field. Don't I need to declare the name of the subform (child12) somewhere?

Thanks, Ok I'm now putting this: Me.[Child12].Form.[BookNum].ColumnHidden = True in the Form_Load() sub and I'm getting a run-time error 'the expression you entered refers to an object that is closed or doesn't exist' - did I write it correctly? (btw Child12 is the subform and booknum is the...

Hi, I am a beginner and struggling to get to grips with some fundamentals of Access 2007 and VBA. Like the subject says, I am currently trying to hide a column in a sub form without it hiding in the source table. I'm trying a workaround by using VBA to hide the column when the form opens then...

*It's ok - I've sorted it now. Thanks* Hi, I've been struggling to make the form I need and was hoping for some advice. I'm a beginner using access 2007 and I'm trying to make a database for a college library (not a real one yet, thank god). I have two tables one containing info on books...