Search results

You're right, disconnected is the term I'm looking for. Thanks, DeWayne

Have you tried using a subform. It should work the way you want.

I'm having a hard time following what you are trying to do. Is the form based on a single table? Subforms are pretty easy to use and would be all visible in a single form.

Subforms are basically separate forms within another form so you have treat them as such. Try using something like me.[subform]![field name]....... to manipulate the fields or open the form separately and then try editing the form. Good luck!

If you use the drop down box in the form based on a filtered query then have the control sorce of the drop down box linked to the table that might work. You might have to temporarily dublicate the table. If you know VB it is much easier.

How to create a disconnected recordset? Does anyone know how to create a disconnected recordset? I don't want to have it linked to a table or query? I 've found CreateRecordset Method (RDS) in the help but I can't figure out how to use it. Thanks, DeWayne

A little more detail would help. But, it depends on how you have the form displayed and you could also use subforms. DeWayne

Try this Dim date1 As Date Dim date2 As Date Dim date3 As String Stop date1 = #1/20/2008# date2 = #8/10/2008# date3 = DateDiff("d", date1, date2) Date3 is a string since you are calculating the number of days difference. You need to then change date 3 back into the...

Can anyone tell me what the best way to move to specific recordset in a form based on a search of its underlying table. I've tried using aboluteposition but they seem to be independent of each other. Thanks, DeWayne

You could try using a string field to be fed by concatenating to different integer fields.

Try using the setfocus method when you close a form to resize the form you want.

Lock If this problem happens again look at the lock file and it will tell you who it was locked by. The problem might have been that 2 users were trying to change/modify/update the same table. DeWayne

If you want to do complicated tasks you really need to learn Visual Basic. Outside of code you could try using an additional field or table to set the order. More detail on what you are trying to do would help. DeWayne

Insert the pictures and place them anywhere on the form you would like. Using VB code set the properties of the picture's visible attribute to true or false depending on when you would like it visible. DeWayne

Have you tried setting permission via login ID? Can you give more detail on what is not working? DeWayne

Is your "link child field" and "link master field" linked correctly?

Yes, only in a form. Basically, I'm just trying to highlight some of the characters in a field on a form. So if the user searches on a keyword then that keyword will be highlighted anywhere on the recordset in the form. Thanks, DeWayne

I'm running a search on several tables feeding into a form. When I display the search results I would like to be able to highlight the key words found in the field. For instance, if the word "purchase" was found in a description field I would like "purchase" to be highlighted and not the rest...

Can you give more detail in what you are trying to do?

Using a subform is the correct way of doing it. I've never saw this problem so I would suggest you play around with some of the settings. Don't forget to link the key fields together. DeWayne