Search results

To move forward or backward in larger increments than 1 you could do: (I don't have VB open, so i know the syntax is wrong) Dim intIncrement as Integer intIncrement = 3 Docmd.GotoRecord, acGoto, me.currentRecord + intIncrement

Multiple numbers in the same field? If so, how are they delineated? Or, perhaps, do you mean digits? Evan

I don't understand what you are trying to do. If you are trying to hide/show controls based on values in a recordset, how does this work with multiple records from the recordset? If the 1st record causes the control to be visible, couldn't the second record just hide it? I don't see the...

I'm not sure why you are outputting the records to a text file then reading the text file. Why not just open a recordset and grab whatever record you need? But it looks like your problem is the DO Until... Loop statement. It will continue to LOOP until it reaches the end of the file, which...

The subform remembers the last field that had focus in it. When you tab into the subform, it will automatically return the focus to the last field in the subform to have had the focus, rather than the 1st control of the subform. (or last, if you were shift-tabbing.) If you want to be able to...

If your form doesn't use check boxes you could do it this way: MyControl.Locked = not isnull(MyControl) Do this for each control in the OnLoad event of your form. This locks the control if data has been entered into it. Potential problems: You have to ensure that the form gets closed and...

If both your report and your form use the same query for their data source, when your report loads you could set it's filter to match the filter from the form. Evan

Is this an Active X control that you can download or buy? Or did you write it? I'm very interested, but don't have a clue how to proceed. Thank you, Evan

The tree structure - is this a feature of 2007?

ThinH - how did you do that? It looks very good!

So, do you set AllowFilters to False on all your forms?

Banana, Thanks for taking the time to put together such an informative post. I do indeed use parameter queries 99% of the time. In this case, as you said, I don't know what fields the user will choose to filter in the datasheet, and I must create a query that replicates this AND this query...

The following is from Access 2003 VBA help. Perhaps 2007 is different? Evan

Yes, I can create stored queries in an MDE file. I've actually never created one before (MDE), but always assumed when my database was ready for deployment as MDE is would be in a read-only state. Banana - Thank you very much, I had everything working and was just about to trash it all and...

To set focus on a control of a subform requires 2 steps: Me!MySubForm.SetFocus Me!MySubForm.Form!MyControl.SetFocus

It's going to be a MDE. Wait.... I was assuming that meant read-only. AHA!!!! Maybe it doesn't!??!! Banana, you may have just saved me a lot of time! Here's why my query has to be so special: The user has a button to perform a "global edit" on all records listed on my subform. I want to...

No, I don't have a tempdb. I'm just trying to update the contents of a saved query - but I'm having problems because the front end is read-only, so it doesn't allow changes. And If I put the query in the backend I can't link to it like you can with a table.

I don't have any queries in the back end because I can't link to them to use in the front end. Just the front end is read-only.

Mike - what you suggest is possible in a read-only frontend, but I don't think it would work for me. I am not able to use a query in memory, because I have half a dozen other queries that need to use it as part of their data source - great idea though to use a memo field... I'll have to remember...

When a query uses a control on a form to filter results, the value of that control is 'hard-coded' into the query when it loads. A requery does not go back to your form and look for a new value, it uses the existing one and checks the table for new data. Instead of requery try...