Search results

Yes, absolutely right again, but my form doesn't clear. How do I set it to display with all fields vacant?

OK. Great. Thanks for that. I've now got a working form that displays the right values from my static data tables and stores them as keys in my underlying records table. As you say the record is written to the table when I close the form, but I want to do this using a button, which stores the...

OK, it looks like I've forgotten everything in the last fifteen years. Here's what I'm trying to do. I'm setting up a database to gather records about wildlife. Puting it simply I want to store data about what is found, who found it, when and where. There's more, but that's it in a nutshell...

Sorry about this. I told you I hadn't done it for fifteen years. I want my button to append the data collected in the form to my underlying table. I thought setting the"Data Entry" property to Yes would append a new record to the table, and the button would then populate that record. What do I...

Now I know this is going to sound daft, but I really can't figure it out. I've designed my form based on a table I want to populate, using data brought in from other tables and queries as lookups. This all seems to work. I've now put a button on the form, on click, to add a new record. I...

Thanks very much for the reply. I've realised that I failed to thank you for your reply to my last posting. I was trying to fix someone else's database, and I discovered they had not normalised their tables, so I've given up on that, and I'm re-building the whole thing from scratch. It's been...

I am designing a form. The first combo box will identify the item I want to store data about, but there is a list of about 4000 items to choose from. I want to set up the combo box so that when it is clicked or you tab to it you can start to type the first few letters of what you are looking...

I'm designing a form to gather data including two names for each item. The two names are listed in a query, and I want to display the value in the first column to allow the user to select the correct value, then to use the values in both the first and second columns to populate fields in the new...