Search results

Combo and List boxes don't have a Record Source, they have a Row Source, so - Me!YourCombo.RowSource = "" should clear the list.

If you want to return the fName then you need to use that as the strField argument and tblApprovers as the strTable argument. Also, your where clause is a bit off as you would need to compare the AppId fields from the two tables. It should probably look more like; ApproverNames...

What do you mean by size?

Thanks Galaxiom. This might be a good one for the Code Repository.

Not if they're using the runtime, as they will have no access to LTM and won't be able to link the back end.

Option groups are not available for web forms. You would have to use check boxes but with 5 or 6 this might be a bit tricky to have it function like an option group because.... ...VBA is also not available with web forms. Everything must be done using macros.

You have most likely misspelled a field or control name. Double check the spelling of all your objects. Also, please post your questions in the appropriate section. This section is for introductions.

In the Close event of the new Landlord form check if the dashboard form is open and if so requery it. Private Sub Form_Close() If CurrentProject.AllForms(frmDashboard).IsLoaded Then Forms!frmDashboard.Requery End If End Sub

Sounds like the business rules for this app are more like guidelines. I would probably add a boolean (Yes/No) field to the Groups table to indicate if this Group is valid or not. Users would not be allowed access to this field, it would be managed by code. The first time a Thing is added to...

You'll probably need to manage this with a bit of code. You could put a FK field in Things to store the GroupID, but without RI enforced. Then set up two forms, one (like a single form) for adding Things - with or without Groups. Then a second Main form / sub form for adding Groups. Then use...

Not sure what you mean here. When you're adding a record where? In one of the sub forms? In the main form? And what do you mean by auto update? Are you talking about saving the record? The record is saved automatically when you move to another record, etc.

Cross post. Answered in the other forum. If you're going to cross post at least do the courtesy of mentioning that you did.

@Galaxiom I agree with all of your points. However, in this case the OP seems to want to allow the users to not only select different criteria, but to actually select which fields they want returned by the resulting query. May or may not be a good idea - depending on the competence of the user...

[searchable] is likely a field in the record source of an object (i.e. a form), but hard to say for sure because we can't see your app. If you want to post back with more details or a sanitized, zipped copy of your app I can look into it further.

I see no need for a table here at all. If all you want to do is build a SQL statement on the fly and then open the query to view the results all you need is QueryDefs. Just create one saved query. Call it whatever you want and select whatever fields from the table. It won't matter how you build...

Not a problem.

Then you need a table structure that allows for you to track as many procedures as are necessary for each training session. I have attached a modified version of your test file for demonstration.

You might want to look here for some example data models. Look under the Vehicles category.

Why do you have the field carModelsID as a Foreign Key in your CarModels table? Foreign Key to what? Also, what is carReg? Is this the VIN? If so it really doesn't belong in any of those tables.

Right. When I converted my app I just used single column lookups that return only the ID field from the related table. I see no reason to return any other values at the table level. Yes. Thank you again for your time.