Search results

I generate e-mails automatically by using an SMTP object. This works fine from my own computer but when I use a virtual server I receive the message "A program is trying to send an e-mail message on your behalf.." which I then need to allow manually. Is there any way to get around this?

I have a program that generates e-mails automatically using the SMTP protocol. My problem is that if I am working on the same machine, the e-mails being generating gain focus, so what I am typing goes into the automatically generated e-mails. Is there anyway to prevent the focus from shifting...

The Texas Heartbeat Bill provides a method that if upheld allows a state government to negate any constitutional right, in effect repealing the 14th amendment. The whole "private action" workaround could be used to ban guns for example. In addition, allowing lawsuits by anybody, for damages...

I have faced the same problem, which I solved by computing an average cost/lb for each zone and a per carton charge. The results were in a few % and I rounded it up to the nearest whole dollar. It was good enough for our purposes.

For more than a year, I have been using Selenium VBA to automate website interactions. Sometimes this works really well but for other websites there seems to be no way of getting the correct interaction to take place purely through Selenium. Yes, I know about frames. Can anyone suggest a...

My company recently moved and for 2 weeks we were relying on WiFi, using an SQL server backend. There was no corruption issue, but speed was a problem.

You should also review the spreadsheets and see if you can emulate them entirely in Access. You can do many Excel-like things in Access by using dlookup and formatted Reports.

I had converted the MDB years ago using an older version of Access that could convert it directly. Check with Microsoft for a converter.

Delete the linked table and relink it with all the fields. Then open the linked table in Access and hide the fields you don't want to see,

I used to have frequent problems with database corruption, which ended with a major office update last year. So the usual advice applies, make sure everyone is running the latest version of Access and update the old MDB files..

I would not expect a Product_Code to be a number or an autonumber field. The normal purpose of a Product_Code is to provide the ability to create summary information. I would expect it to be something descriptive about the group of products, not an arbitrary code. You have fields called...

This sort of issue is backend specific. Personally, I would hesitate to change more than 10,000 records at once. My earlier suggestion about being careful had an error in them (proving my point). You need to constrain the records for some queries. " ST" is OK in the middle of the field but not...

Try to see if you can you make the changes by hand using a select query. This may be an edit rights issue.

Be careful with this. You don't want to St. Louis Avenue to Street Louis Avenue. Or change "Stanley Road" to "Streetanley Road". You should be using spaces in front and behind so " ST " become " STREET "

Their answer is not wrong. In Queens, NY it is common to have addresses with a hyphen before the street (like 12-26). How do you sort non-numbers numerically.

Trying repairing your installation of Access.

If you have 90 fields most of which are unique to single record, then they should not be fields at all. You should have a "Comments" field with a "Long Text" type where you can enter free-form information.

I came across the following curious situation at work. I need to compute the average lot size of parts being produced. The obvious thing would be to divided the total number produced by the number of orders. However, my interest involves setup costs, so it is more logical to ask for the each...

Search & Replace in the SQL window is handy. I am glad you mentioned it, I have not seen any documentation of the recent update.

13426.20404