Search results

I got this from the Wrox book, VBA 97: Dim objWord As Word.Application Dim objDoc As Object Set objWord = New Word.Application objWord.Visible = True Set objDoc = objWord.Documents.Add(filename) 'Code to put in the record at the bookmark objDoc.SaveAs "filenameroot" &...

I know that this has been dealt with before, however, I am having trouble with this one. I want to count all of the records that pop up on the report. I have used =count([primarykey]) in a text box, but what I get is a count muktiplied by some number (which is not always the same otherwise I...

Just to make a note, I have tried that. For some reason I can't get any error catching to catch it. I tried ignoring any error messaged, trying to trap it with the error codes. I'm not sure what I'm doing wrong... Thank you

to clarify, I want to get rid of the "write conflict error box"

Could someone please help me figure out how to trap errors. I have a form with Navigation buttons, and I would like to trap errors when used by more than one user when the record is about to be updated. Thank you

Acctually, I found out where to put my error messages, but I just can't figure out how to do it. I am using the On Error event, but I think I have two errors that come up consecutively and only the first one is handled by mine Please help thanks

Just one point, the previous guy did not put in buttons for the most part, he pretty much just used the bottom record bar that comes by default on a from. Please help me, thank you

I'm trying to figure out how to change the error messages for a multi user application. The big problem is I'm fixing up someone elses work, and I don't want to redo it by putting in my own buttons, rather just by changing the error messages. Thank you

I'm trying to figure out how to change the error messages for a multi user application. The big problem is I'm fixing up someone elses work, and I don't want to redo it by putting in my own buttons, rather just by changing the error messages. Thank you

acctually scratch that, my problem is deleting the contents of the table

nope, though I tried creating an empty table, and that seems to work, though a new problem has arrisen, if I try to export the file again, using: DoCmd.TransferText acExportDelim, , "AddressTable", "C:/Addresses.csv", True the next time, the new data is appeneded to the old file, I want to...

thank you I think I'll try just creating an empty table, and copying only the records that I need. If that's not possible, please let me know. thanks

to clarify, prefferedAddress is a yes no, and if it's yes, the associated address should be kept, otherwise it should be deleted. Thanks

I would like to delete the current record from a query if a certain condition is true, however, whenever I try this I get an error message stating that database or object is read-only. How do I work around this?

I have a query that has addresses, there is a field called preffered address, which if they have 2 addresses, this is clicked for that address. My problem: I want to only show all of the addresses, and if one person has two, only the preffered address thank you

I realized what my problem was, I didn't know at the time that at the begining of each call I needed to put in to make the feilds visible, other wise, it stays at whatever it was before

I have a report which prints address. Some users have multiple addresses, but they have a preffered address. Only with those that have multiple address, I need to print out only the one that is preffered. The following is what I've done, but it doesn't work: I first have this in the Report_Open...