Search results

Not names, it contains a unique userID which is unique to each user and not repeated by anyone else. I have also made this the Primary Key for this table since the reference will be unique. I can add an auto-number column if this would help, but what would I then need to do to let the combo...

Hi all, I'm a bit stuck... On a form to enter some new client info, I want users to be able to select their UserID from a combo box for future reference to other users (ie; Who made these notes?). For various reasons I want them to be able to add their UserID to the combo list for future...

Hmmm... My No button still closes everything.... ??

OK. Added the Option Explicit part. Ran the debug. It stopped at the stDocName, but I've since figured out some stuff. I've changed the case vbYes to identify the variable as string, told it the name and it works! :eek: Case vbYes Dim stDocName As String stDocName...

OK. Have done that now but my buttons are still not working as they should? On clicking yes my desired input form does come up but there is an error message saying "Run-time error '2494': The action or method requires a form name argument." and the debugger highlights this line -...

So I just take out the Select Case intanswer from my code... Forgive me for being all beginner-ish. What do you mean assign it to intanswer? How do I do that?

Hello world... I have a form I use to search for clients when I hit a command button, using surname etc. I'd like a yes no button to pop up rather than the clunky ok button route I currently have. I'm a beginner with VBA and most this I've gleaned from internet. If there are matching...

Thanks both! James, your solution worked a treat. Namliam, I have to create another bigger more complicated version of the DB I'm building at the moment, so I will investigate your advice. Cheers, Jamie.

Hi Peeps, I have a switchboard which runs a google style search query to find people based on their first name, surname, date of birth or NI number on clicking the search button. It uses the following criteria in the query Like "*" & [Forms]![SearchF]![Firstname] & "*" for each of the above...

Thanks. Don't know why my custID was missing - I know it needs it. Must have deleted it when formatting the form or something daft. Have removed the Save bit. Didn't realise it auto updated records like that. Have also figured out the requery bit so my new entry appears when closing my...

I see!! Here....

Sorry to sound daft, but do you mean attach my database to a reply?

Although... now for some reason, once the input form has had info put in, when I click close the data is disappearing! I check the table and its not there. I've read a bit about refreshing and requerying, but it seems the new data is not ending up on the table anyway.... :confused...

Excellent!! It was easier to fix than I thought then!! Thanks a lot. :)

Hi, I have a main form created from a query (FrmQuerySearchResults) which has a sub-form within, (FrmPresentationsTabular) which I am using to show each presentation to our service made by any given client. For ease of use, I've removed the navigation buttons and want to replace them with...

Hi guys, I work for a Local Council in Housing Advice and Homelessness as an Admin Manager. Since the government decided that all Council's are now skint, and my Council decided we have to save £90m, our aspirations to buy a tailor made database which we've been after for around 10 years, have...