Search results

Hi All, I have jst swapped to a mySQl backend (long story) and it seemed to be working fine, however the following code is giving me an error: Private Sub cmdMakeJHCSV_Click() Dim Accuracy As Single Dim AllowNeg As Boolean Dim FileName As String Dim i, J, TBLLoop, intRecs As...

Thanks jDraw, Got it to work, please see code Line Input #1, buffer While Not EOF(1) Select Case Mid(buffer, 1, 2) Case "Sa" SampleName = RTrim(Mid(buffer, 24, 25)) Case "Ap" MeasureOriginName = RTrim(Mid(buffer, 24, 20)) Set rst =...

Hi All, I have recently been converiting my former access backend to mySQl, all seems to be going well, but, after about 3 days of pulling my hair out, I can't figure out why the following script is not working! Line Input #1, buffer While Not EOF(1) Select Case Mid(buffer, 1, 2)...

Nope, I'm afriad that still doesn't work, is this some sort of bug in Access2007? Anyone else have any problems like this?

Thanks for the reply, the front end is a normal access2007 database, .mdb.

Ok, tried that, when I tried to refresh the lnks to the tables using Linked Table Manager it gave me a error saying something like "MS access does not support linking to and Acess database or Excel workbook saved in a format that is later than the current format" All was done on the same...

Thanks Pat, it should have been obvious that's what I should have done. I will give it a try and post the outcome.

Hi Again guys, I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users...

Thanks Bob That could work pretty well, I have tried it using Allen Browne's audit trail procedure and it worked as it was supposed to, the only issue I had was that we have one machine in our network that has a generic login (it is used for data capture from an instrument) and also runs the...

Hi All, Many thanks to all who have helped in the past. I have a form which is linked to a table, pretty standard. The form header has a combo box for the user to select their user name when they are entering data. Each record has 5 fields and when the final field is updated I would like to...

Hi all, I am tryng to make a form with a sub-fom in the header, all pretty easty so far. The subform is a login form with a username and password control and a command button "LOGIN" with the follwoing code: Private Sub cmdLogin_Click() 'Check to see if data is entered into the UserName combo...

Thanks Keith, Only issue I have is that the ResultID is not on my form at all, do I need to add it? Can I add it but have it hidden?

Hi All, I am attempting to use the Audit Trail code form Allen Browne's excellent website and I am having a few issues. In my forms Before Update Event I have the following Private Sub Form_BeforeUpdate(Cancel As Integer) bWasNewRecord = Me.NewRecord Call AuditEditBegin("tblLOIData"...

Fixed, it was a problem with the underlying query.

Hi, I am hoping this is a pretty easy one. Recently I have been reformatting a Db created in Access2003 in 2007 and I have found a problem with a form. All my forms are based on queries and most of them seem to work fine. However, one form will not allow me to enter data and comes up with the...

Hi, I'm not sure if this is the right group, but I am sure it will involve some VBA. I have quite a large Db that contains some quality assurance data, what I am trying to do is set-up a system that will check the date of the last record in a table (the date is one of the fields) and determine...

Just in case anyone is interested, here is the working code below, I didn't come up with it, but it works. Private Sub cmdMakeJHCSV_Click() Dim Accuracy As Single Dim AllowNeg As Boolean Dim FileName As String Dim I, J, TBLLoop, intRecs As Integer Dim sql, strColName As...

Thanks for the reply Neil, I guess I could do as you suggest and run a query, but, the delimited file needs three header rows and I'm not quite sure how I would do that with a query. Any suggestions would be greatly appreciated.

Hi, I am having a few issues with using VBA to output a temporary table to a delimited text file. Someone has done some code for me to output to a variable width file (.SIF), but I need to change it slightly to output a .CSV. Here is the code I have Private Sub cmdMakeJHCSV_Click() Dim...

Thanks RG, works like a charm.