Replies

Hans, It works great except for the dialog box. It returns the error:
Method of ‘FileDialog’ of object ‘_Application’ failed
and the error line is:
With Application.FileDialog(msoFileDialogOpen)
Is there a reference I need?

Thanks again!

What is MYOB? Do the table names change from time to time? If not, you could link to them manually then run delete, append, update queries (whatever fits your needs) via code and you should be all set. Food for thought anyway.

Why don’t you use a form-subform set-up. In the form, you could use the Orders as your record source then set up a sub-form with the order details linked via the OrderID. That way you can see the complete Order and see the order details below. Then when you add details to an order, the Order ID will populate automatically.

Hans,
Is there any way to save an XML file via Excel into another format if it exceeds 65,536 rows?
Thanks!

What are my options?

In XL it opens with a single table and is well formatted. If I could get it to come over in 1 table as it appears when opened in XL, I would be fired up. If not, then multiple tables would do.

(Edited by HansV to make URL clickable – see Help 19)

Hi Hans,

I think the audit trail created by Allen Browne will work for me with one (slight or not so slight) modification. What needs to be changed in the code at his post: http://allenbrowne.com/AppAudit.html%5B/url%5D to pull the old value and the new value.

As always, thanks for the help!
Dashiell

I am unaware of anything that could be added but if there is such a beast, I’m sure someone will point it out to us.

Something along these lines should do it. You might have to replace the calculation that triggers the warning but it is a start.

Private Sub Report_Activate()
If Me![balance] Me!In – Me!Out Then
MsgBox “The balance reflects ” & me![Balance] & ” while the In minus Out amount equals ” & me!In – Me!Out
else
endif
End Sub

Once you delete them in Access they are gone.
You could create a boolean field titled “Deleted” and have a delete record button that merely changes the value from no to yes. You could then base all your queries, forms, etc. off the records where deleted =0.

In your table try setting the Data Type to Number and the field size to single. This should allow you to see the decimals. Then in your query, form or report, format it for $ or Pounds and that should do the trick.

A cold boot fixed it. Also, the Voting buttons code worked perfectly.
Thanks!

Hi Hans,
A simple link hit me after I clicked Post. I’m quitecertain I can use the link. My only problem is when I select File | Get External Data | Link Tables and set it to Outlook(), the screen flashed and it kicks me out of the Link table dialog box. IT Security is pretty tight around here…is there a setting that might cause the link dialog to automatically close or is there another way around this?

Hi Hans,
The attached is a sample. Cell A3 is a simple drop-down. When selected, the main office info. populates using a lookup. Underneath it, I would like the satellite offices to appear and the associated employees under each office reporting to the main office. I set-up a simple layout illustrating what I want to show. (Column H contains sample data to populate the left side of the sheet).
Thanks!

Sorry Hans…I should have been more clear. It’s not necessarily in the header it’s just that we have to use the same graphic on multiple sheets in various locations and it is increasing the file size. If there is a way to reference a picture in one sheet while the picture resides in another, that would be great as there would be only one true instance of the picture.
Hope that clarifies things.