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 actually found a solution. I removed criteria from the query itself and relied more strictly on the filtering in my VBA code. The query criteria were somehow ending up in my filter criteria in the form I was trying to open.

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...

Hi Duane, I was able to solve my problem this afternoon. Part of it was that Table Two and Table Four were linked on fields that were indexed but were not used as the primary key. I removed Table Four from the main query and accessed information from it in a different way. There was an...

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...

Thank you.

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...

That is not a bad idea, but I am afraid my filtering criteria will not fit into the ControlSource property. What I had tried to do was to declare a variable: Dim intVarName As Integer = 0 In the area where the background color was set I had a statement like this: intVarName = intVarName +...

I am working on a pair of reports for sister companies that have fields for a KeyCode, Date, Orders, SaleAmount, and Description. There is a group footer that shows sums for a year (in this case, 2006 and 2007). There is another group with a header showing customer information, and another...

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...

One problem. How do I get DataDiff to tell me if one date is greater than another, or vice versa? The amount of difference is one thing, but it also matters which of the two date values is greater as well. Thank you for your input.

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.