Recent content by ronphx

Thank you. I was afraid of that. It looks like I'll go back to the old fashioned way and modify my query. It's not that big of a deal. Thanks again.

I'm creating a report that shows trial balance from a query. I take the beginning balance + transactions, and in my detail report area I create a field called TxtEndingBalance. In the report total, I'm creating a text box to add up all the balances in the TxtEndingBalance fields. My problem...

Thanks for the idea. I'll explore this to see if I can create a dbase application object. I'll let you know if it works. Thanks again.

I have a file in dBase that is a temporary file. I want to delete the items in that file (Zap it) with Access 2003 VBA code, then I want to add new items to the temp file. It really isn't difficult to do, but the problem is that when I bring up the temp file in dbase, the deleted items still...

Thanks again. I use the select and order by statements when coding, but every once in a while I just want to click on the table and open it to view the contents in the composite order. Sounds like I'll still have to do a simple query to see the multiple sorted fields.

Thank you. That's it. How do I activate that index when I am viewing the table?

I am more curious about this than anything, because most indexing and sorting is done through queries, but in Excel you can sort a range by a primary and secondary field. Can you have a primary and secondayr sort field when you view an Access table or can you only sort one field at a time?

Thanks to both of you. I tried both of the suggesstions, and both of them worked perfectly. I appreciate your prompt and helpful responses.

I have two recordsets which represent tables - rsmaster and rsship. the recordset rsship refers to a table (tblship) which may or may not contain a ship to address for a customer that is different from the ship to address in rsmaster. If there is a record present in tblship, I want to transfer...

I'm trying to blank out the field so the user can start over. The sendkeys and ESC did the trick. Thanks much.

I think I'm figuring out a little bit of what's happening. I tried only using the cancel = true, and that put the focus back into the text box, but did not change the value, and did not highlight the text (using the DoCmd did the same thing). When I use the undo, the focus goes to the text box...

This is very frustrating. I'm trying to undo changes to an unbound text box. Just to test this out, I have created a text box (txttest). I have created a simple BeforeUpdate event that does the following: cancel = true me.txtest.undo After I change the entry in the text box and press the...

Thanks to both of you. That is exactly what I needed. My problem was that the W2 forms have narrow top and bottom margins. I calculated the necessary space, then used the following code: If Me.cnum Mod 2 = 0 Then Me.GroupFooter0.Visible = False Else Me.GroupFooter0.Visible = True End If...

I am trying to format a report to print two W2 forms per page on the preprinted W2 forms. The top of each W2 is at 3/4" and 6 1/4" on each page, and each W2 form is half a page. How do I go to a new page after every other record (two records per page)?

Actually, you helped me a great deal. When you asked me the question regarding what I was trying to accomplish with the function, it made me realize my procedures under dBase were not appropriate at all under Access. I think the form with the openargs is going to be the way I'll go on this...