Search results for query: *

We have an Access application with a subroutine that posts information to the GeckoBoard cloud service several times a day. Sometimes the connection fails, so I have added code to the subroutine that will make a second and a third attempt so as to minimize the number of fails. Lately I found out...

We have an Access application with a subroutine that posts information to the GeckoBoard cloud service several times a day. Sometimes the connection fails, so I have added code to the subroutine that will make a second and a third attempt so as to minimize the number of fails. Lately I found...

Good morning. I am working on an application that will take a graphic file that is copied to the clipboard and save it as a bitmap file. After I came up with this code I figured out how to add a line that determines what the default folder is, but I do not know how to determine the default...

I am working on a form that has a button to open another form. The code that opens the other form applies a filter, but the filter only works when the filter value is hard coded. I can get the value to be used and save it in a variable, but when I use the variable the other form opens with no...

I have a query that draws on four tables. Table One connects to Table Two with an Inner Join. Table Two connects to Table Three and also Table Four through Inner Joins. The query results are displayed in a form with a sub-form. All the records display correctly, but if I try to change any...

Good evening. Every few weeks there has been a problem caused by error 3022 on our main ORDERS form. When this happens it is because somebody is moving from one record to another record. We then boot everybody out of the front end database and use Compact and Repair to clean up the back end...

I have a report that draws on data tables in a vertical market application. One of the fields is a numeric field in which the entries designate the year and the month: 200901 for January, 200902 for February, and so on. I am trying to set up a formula that will pull records for the year that...

Good evening. I am reworking a web site for a client. I have set things up in my CSS file so that a hyperlink changes color when a cursor is above the text on one of my web pages, and again once a page has been visited. What I would like to do is to have a similar color change for the cells...

I am working on a report where I am trying to get subtotals by putting code in my report's VBA window. So far my code is crashing because it comes to the EOF(). What is the correct syntax to avoid this problem?

I am working on a business history report. My main data sources are a table connected to the database through ODBC (open database connectivity), a Snapshot table in Access with a copy of the external database’s information from a month ago, and some smaller tables within Access. I started by...

Good afternoon. I have been working on a query that draws on two subqueries. Each of the subqueries draws on three tables and another query that draws from three small tables. My subqueries seem to work, and my main query seems to work, but when I try to run my report I get a message box that...

Good evening. I am working on a report to match catalog mailings to the number of orders received and the dollar amounts of those orders. The report draws on a query; the query is composed of two other querys, each of which draws on three tables and another query that summarizes data from...

I am working on automating the process of importing data from Excel spreadsheets into temporary Access tables. How can I set up DoCmd.TransferSpreadsheet so I can select an Excel file at runtime? Thank you in advance.

I know how to select an Access table programmatically and I know how to remove a table programmatically from an Access database. Is there a way to locate or otherwise confirm the existence of an Access table programmatically before selecting or removing it from the database? Thank you in advance.

An old Windows 98 laptop has been able to send and receive email but is presently unable to open any web pages. The computer runs a slightly older version of a popular internet security software package. This problem occurs with both Internet Explorer and the ISP software. I have checked the...

Good evening. I have acquired a laptop computer that I am trying to connect with my minitower. I have added the Windows component for setting up peer to peer networks to both computers. I used a parallel port cable to physically link the two machines, and I was able to get the laptop to...

I am working on a query for a mailing to a list of health care providers. (There can be several entries in the source table for the same provider, since each provider can work at more than one location.) However, we do not want to send more than one piece of mail to each provider. How do I...

I want to create a button that a user would click on, to open up a browse window for searching though the hard drive or network drives to locate a file. After selecting the file and clicking on an OK button this process would return the full path and file name to Access and be stored on my...

I have imported data from two spreadsheets into an Access database. The first table is a list of manufactured parts; each record has a unique part number, a brief description, and additional fields with information on the costs involved in making the part in question. The second table has a...

I want to set up an Access database for a club I belong to. I would like to be able to get information from these tables to display on the club's web site. I have opened the Data Sources Shortcut tool in the Control Panel's Administrative Tools section, clicked on the System DSN tab, and added...