Search results

You are going to need the cleanup the data. To make this work as file you can import you will need to define a separator character that does not occur in the file itself. I would suggest using *. You can just use notepad to replace " 1. " with "*" and do that for the other numbers. You may able...

Your suggestions are interesting. I have tried using AutoHotKey, but I had trouble keeping focused on the web page. The IE application object might work for me. I don't see that my customers will give me the API calls.

I am taking data from Access and putting it on a website. So I need some method of turning arbitrary data into typing & clicking on a screen. I found a good website for doing the reverse, scraping information off websites and putting them into CSV's, called Data-Miner.io. However their ability...

I often need to fill out webforms when I ship customers. I create access queries which contain the information, but I still need to type (or paste) it in by hand. I would like to automate this process more. I am currently using a program called Clipboard Master which allows me to imbed tabs in...

I need to deal with this sort of problem, a lot as I often need to interact with external data sources that I can't link to directly. Here are some useful tricks which may help you. 1. Download them as CSV's (if that is an option) or open them and save them as CSV's. Then use a copy command...

Make sure to set up a 1-to-many relationship between customers and contacts. We have an ERP here that treats customers and contacts as having a many-to-many relationship, which makes it much harder to work with. Although it is possible to have the same contact at more than 1 customer, it is...

The documents aren't Access reports, they are image files. They need to be printed automatically, not by a user sitting there and selecting them manually. And how I can trust that files external to my database will be there when needed.

The attachments are image files that need to be included printed documents that are sent with shipments. It works, except for the annoyance that you need to edit attachments in the original database.

I have found that I can add attachments in the attachment field only if it is native table of the database, but I can't if it is a linked table. Is this a feature of Access or is there a way of doing it? I can always have the users work with the database containing the table, but it would be...

I have some similar problems. Access's stability in a multi-user environment has declined in recent years due to OS changes. Here are some things that have helped me. Overnight automatically copy the database to a new file and repair it. Function CompactAndCopyBack(FileName As String...

I have no choice but to run on network drives. I have never had compact & repair cause corruption.

I am doing it with this simple function Function CompactAndCopyBack(FileName As String) Kill "s:\temp.accdb" Application.CompactRepair FileName, "s:\temp.accdb" FileCopy "s:\temp.accdb", FileName End Function

I need to go in and out of the database during the day, so Compact on Close takes too long.

I have large database that I have run many automated queries running overnight, starting at midnight. I compact the database manually each day. I would like to compact it automatically before I run each night, due to database corruption issues. I tried using Task Scheduler by running with the...

All office apps have a safe mode. See https://support.office.com/en-us/article/open-office-apps-in-safe-mode-on-a-windows-pc-dedf944a-5f4b-4afb-a453-528af4f7ac72 for a discussion of how the safe mode works.

Sometimes, Access after a problem will offer to start in Safe Mode. This is never useful to me, and prevents Access from running unattended (I have a routine that runs after midnight. Is there anyway to prevent the Safe Mode prompt or to automatically choose no?

Your code for sending the e-mail is fine, the problem is that you are not getting the data correctly from the form. There is no need to use a CDO object.

I have a table called Exception Reports which contains the names of various queries which are run twice daily as well as information about the query (who receives the e-mail, the date/time is was last run, the number of records returned, the first record etc.). After the query is run (and any...

I assume that the Audit table has a date/time field. If you bring that into the query you can easily determine the most recent.

This is also needed Public Sub SetDAOFieldProperty _ (fld As DAO.Field, _ stName As String, vValue As Variant, _ lType As Long) Dim prp As DAO.Property For Each prp In fld.Properties If StrComp(prp.Name, stName, _ vbBinaryCompare) = 0...