Recent content by jamiesadler

I am currently using the following code in the OnOpen event Private Sub Form_Open(Cancel As Integer) Dim cn As ADODB.Connection Dim rs As ADODB.Recordset 'Use the ADO connection that Access uses Set cn = CurrentProject.AccessConnection 'Create an instance of the ADO...

I have just upsized my database to run on an SQL server Now code I have in the Onload event does not run. Any ideas?

Is it possible to have a bitmap image that is linked to a parameter field or a database field. i.e. Name: Joe Bloggs Parameter: c:\pictures\joeb.bmp where the report print the name and the persons picture

I am grouping data by date. I then need to sum the data in the last entry for each group. If I setup a formula in the group footer that is equal to the data I am after the report displays the last entry in the group footer. If I try to sum this formula, is sums the data from all of the entries...

I get the same problem with MSAccess97. I have found a message that says that ODBC 2.X does not support unsigned integers. MySQL(TCX) say they have an ODBC 3.0 driver but as yet can't install it due to a Microsoft Problem. So it looks like I'm stuffed for the moment...

I am currently writing reports in Crystal reports 7. When I access the MySQL data thru MyODBC it reports back values that are specified in the database as unsigned integers as signed values. I have also tried using Access97, viewing the tables via MyODBC give the same result. I have loaded the...

Crystal sees the data as Type:Number I am currently using MyODBC to connect to the MySQL database My colleague has specified a 4 byte unsigned integer in the database e.g. 2731228448 is reported as -1563738848 which is the signed interpretation.

I am currently connecting to a MySQL server which has several fields specified as unsigned integers. When I display the field in a report (CR7) the field is displayed as a signed value and starts giving me negative numbers. Is there any way to get Crystal to recognise the values correctly? At...