Search results

Probably a good idea to attach the db. Then we can how you are searching and make suggestions.

Hope those ideas can help you. Glad you had a look at them. When you say you have lot more - how does that cause a problem? Those examples can be changed to cover a lot more fields. What is about dates that makes it hard?

You can build your own custom menus. You could build a custom menu for that form and include a print preview button. Are you using A2010 and embedding a report in a form?

You did ask "Right; I was hoping to add some buttons to the form that appears so the user can just press that. Is it not really possible? "

The standard way is to add a button with code on its click event. DoCmd.OpenReport "ReportName", acViewPreview If you want to print a specific record, use: DoCmd.OpenReport "RptMyReport", acViewPreview, , "MyID=" & KeyFieldName If the field MyID is a text field, use: DoCmd.OpenReport...

Here are my favorite search screens for dynamic searches: On this page http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp download 'A better record finder' http://www.allenbrowne.com/AppFindAsUType.html http://www.allenbrowne.com/ser-62.html

I assume that when you create tables on the fly, you can use DDL queries to change the properties of particular fields. I have never needed to create tables on the fly - so haven't tried it. Search for posts on using DDL to modify tables or tabledefs. I believe you can also store an empty table...

That's a great outcome - thanks for posting back about your success.

Please explain how interventions, contexts and outcomes work in the 'real world' of your data. For starters, I assume that interventions are done to a 'patient' and that you would need a table of patients. I also assume that the context is somehow related to the patient. Describe a bit about the...

Nope, the limits on editing an object have never stopped people using a saved query like qryMyQuery and changing it frequently. You must use a saved query for the code you posted - that is the reason for the error about item not found in this collection. Access will only look in the saved...

I have downloaded your sample database. The relationships between the tables are not correct for you to create a successful database. In order to get a successful database, it is necessary to go back to the start and answer the question: 'What are the main entities 'things' in the data that I...

Here's a link that explains about queries that don't allow additions or edits. http://www.allenbrowne.com/ser-61.html

Create a query with just one field from one table and call it qryMyQuery and save it. The code you have is looking for qryMyQuery. When it finds qryMyQuery, the code is changing the query to the fields in the query to the ones in strMySQL and saving it.

If you put the database in a trusted location or set macro security to low, the warning message should disappear. For your users, as far as I know, they may see the warning message the first time they open the database.

Look for an access developer in your area. Understand that a database with one table and one form is not going to do the things that you need from this data. Spread sheets can work with one big massive table, aka the 'sheet', but databases are relational - this is what makes them great for...

As far as I know, a subform always loads before the parent form loads. It has always been that way. It is more likely that the main form is the problem - the detail section will go blank if there are no records for the main form in some circumstances. See if this helps...

Post the code you have on the delete event or a delete button, or alternatively comment out the code on the delete event or a delete button and see if you still get the delete msgbox twice. Check through your code and see if you have any code that asks the user if they wish to delete a record.

The usual way to hide the calendar icon is to set the 'Show date picker' property for the textbox (on its property sheet) to Never. You can do the same thing for the same field in the table. Are you suggesting that you have already done this and that the runtime is still showing the calendar...

I created a new form in my test database. The database has a setting for confirm record changes. I ticked all the options so that Record changes Document deletions Action queries are turned on. When I hit the record selector and hit the delete button, I only get asked once if I want to...

What is preventing you from being able to open the form in design view and set the field to locked?