Search results for query: *

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...

Essentially, yes. I probably could use an input box also and test for the answer.

I have users that want to continue to use dbase IV programs and Access users that want to use (and add and change) the same dbase files (tables). Is there a way that both the dbase users and Access users can use, update, add and lock the same dbase files so that each program will detect and...

Good question. In the past I've asked users to press a certain key (like the F5 or F6 key) to acknowledge that they have in fact read an important message instead of just pressing the enter key to continue. It really isn't terribly difficult to build in a test in Access using the Keypress...

Is there a built in function in Access that will give the last keystroke pressed? I know there are key down and key press events, but I was wondering if there was a built-in function that you could use anywhere in code. dBase had a function called LASTKEY() which would always return the last...

It does have to be live data since the master file changes frequently (the table is a linked table). Another thought I had was to use an index I had on the last name, but I don't know how to display indexed records on a continuous form. Do you?