Search results

Hello - I hope someone can help. We have an Access 2007 database with many thousands of names and addresses, for a mailshot. The name field is a single field with the title, initials and surname in the one field. We need to create salutation fields using the title and surname only. The...

Hi Everyone Apologies for what might well be yet another novice question ! I have a form with a subform from which the user selects a record, which then populates the form. The problem is that some (but not all) of the historical name, salutation and address fields in the original source...

Hi - I wonder if anyone can help? I'm making a form for colleagues to use which will eventually populate a table. I'm using DLookup to populate some of the fields in the form from another table. The problem is that for a few of the fields in that other table, the values are incorrect...

Hi All I'm still learning so please accept my apologies for what is probably a beginner's mistake. I have made a form with a subform to search for existing records based on inputting a postcode then selecting the relevant address from the subform which then fills the form with details of...

Hi All Apologies - I am new to VBA so am probably trying to run before I can crawl..... I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change...

Hi All As a newbie, I have what might be a beginners problem :o I have created a form to interrogate our database and display all records without a unique building reference code OSAPR. The form has two subforms which hold details of domestic and occupational addresses and OSAPR codes. Only...

Hi - I'm new to VBA having used Access for seven years. I'm now having "fun" designing forms and starting to use VBA (and SQL) so find this forum a godsend for answering all those "Why won't that work?" or "What does that error message mean?" questions. If nothing else, the fact that other...