Search results

I recently found out about the graphics functionality that can be utilized during the paint event of a report. So I wanted to stress test it. I realize this is far outside the realm of what Access was designed for, but I'm still getting some weird behavior that I'd like to fix if possible...

I have two linked ODBC tables in my access applications. If I link them both with the same account, they work fine. If I link them each with a different account, when I view one, it will work fine. When I try to view the other, it will give an ODBC call failed. Regardless of which one I view...

I have a two dimensional array of strings: Dim testArray(3, 3) as string I need to pass this to a function. I've tried every combination of syntax possible for passing this to a function to no avail. Function analyzeCell(ByRef currentArray(,) as String) gives "Expected:)" Function...

I found some code online to do this but nothing seems to work. When I execute the line of code: CurrentDb.Properties("AllowFullMenus") = True, I get no errors. So I know the property exists. Yet it doesn't do anything when I set it. I'm trying to allow/disallow full menus based on user's...

I have a report. The source of the report is a simple query that includes as one of its criteria: Between [Start Date] and [End Date] This works fine. When the report launches, there are popups for the Start Date and End Date and everything is good. But what if I want the values entered for...

I thought I'd share some tips on publishing an Access application for those who are new to the concept. 1. Separate your front and back ends. http://hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65:split-database 2...

I have a form. In this form I have a subform. The subform is not any specific form. I just clicked the subform tool and drew a subform. Then in my code I'm trying to change the source object of the subform to a dynamically generated query. I can easily do: Me.child8.SourceObject =...

I have a field on a form. This field gets automatically updated by an event. Sometimes if the text attempting to be put into the control is long (example: length=249), it gives an error that the data is too long. I searched in the properties for the control and couldn't find anything that...

I have an Access 2003 form (frmCompanies) with a continuous sub-form (frmDepartments) I need a row number (sequential: 1, 2, 3, etc.) for each record displayed int he continuous form. I have found an example of how to do this online but it is not working for me...

I have a form with company level information. At the bottom of the form I would like to have a subform (or just a set of input boxes) that contain information about a department. And when they start entering information into one of the department level fields, another subform (or set of input...

I have an access application that has a front-end component which the users use to find the factorials/exponents/products of numbers with large amounts of digits. I came up with a better algorithm (which turned out to be a known way) for computing factorials than the recursive: factorial(n) = n...

In an Access Query, which is applied first: Grouping or Criteria? I am trying to run a query whose results could potentially differ depending on whether the query's data set is grouped, then filtered based on criteria or filtered based on criteria, then grouped. (i've done a little testing and...

So here's my setup. We have a database with several tables that have over 255 fields. So we must use pass-through queries to access some of the data. Usually no problem. Here is my pass-through query: qry001: SELECT db001.table001.field001 from db001.table001 If I execute this, it instantly...

So I've written some code to generate random variables. (using the polar form of the Box-Muller method) My issue is that though the values make sense with few enough samples, once there are 10's or 100's of millions of values generated, it's not getting anywhere beyond 5.1 standard deviations...

There is a table in a database I'm maintaining. One of the fields is a Text field. When I look at the datasheet view, i see the value #Error for every entry When I select the field to try to edit it, I get the following error popup: "Reserved error (-1517); there is no message for this...

http://support.microsoft.com/kb/209871 I have tried to implement Microsoft's example here but there is one critical issue: the Orders form opens the frmPassword form like this: DoCmd.OpenForm "frmPassword", acNormal, , , , acDialog Then the frmPassword sets the value MyPassword to some value...

I've googled this and found several explanations on how to do this. But none of them seem to deal with the case where there are multiple fields. Example: I have a table with a dozen columns. One of them is a date field. One of them is a transaction ID. I want to return a record for each...

I'm trying to create a pivot table. I haven't had any trouble with pivot tables that have rows, columns, and data elements. But if I try to make one that has no row elements: pt.AddFields ColumnFields:=sColName I get an error and it fails. Googling has revealed nothing about using Addfields...

I recently opened a query (in design view) that referenced a table whose link was not currently intact. The query gave an error message upon opening it in design view and then showed the query, with the table in question empty of any fields (normal) and all links between this table and the...

I'm trying to make modifications to an existing Access application. The app currently has a form in which, when a user presses enter in one of the fields, it inserts all the current fields on the form into a table. I am trying to figure out why. I've looked in the form's properties, the...