Search results

OK i've made the amendments you recommended but to no avail it does and works exactly with the same run time errors. I still think its something to do with the fact that some of the table fields are referred to with the [] - this is because you can't refer to fields with some invalid characters...

I've taken out lp and thats fine heres the object I don't know if that will help at all its access 97

I could post the form object in a database but not the data The validation calculations are showing up on the error msgbox as errors but they arent real errors for example Error 1 150.09 150.09 - in this case they equal exactly the same value IF cal1 <> cal2 then display error It...

Sorry heres the code Private Sub Command60_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim sql As String Dim lp As Integer Dim Cal1 As Double Dim Cal2 As Double Dim Cal3 As Double Dim Cal4 As Double Set dbs = CurrentDb sql = "Select * from test" Set rst = dbs.OpenRecordset(sql)...

Thanks for all the help BUT... Now I get errors on records that arent real errors I don't know why this aint working. I am positive its something to do with the way these table values are set in brackets rst![C/F] but I can't change the field names as it wrecks all my data inside the fields...

lmao funny ; ) The problem aint solved I tried your code back to back it aint workin here so I reverted back to what I originnally had with ADODB silly me. am not as seasoned with programming as some but to insult my debugging skills those are fightin word lol this is the error I get with the...

thanks for the hint but OK I've downloaded MDAC and I have got the ADODB references working, but now am getting a Run time error '13' Type Mismatch at Set RS = Me.RecordsetClone yeah am using Access 97

thanks ; ) I tested your code out but it gives me this - Dim RS As adodb.Recordset - this brings back the following compile error User defined Data Type not defined why aint this workin, I ave no idea I think the correct references are set for that object type but not sure :confused: :eek:

I have made a validation routine to check through my data to see the values within my table are correct using the code below. I know theres errors in my table yet no errors are found. I know its something to do with my referencing of these table fields :RS![C/F] & [BalanceC/F] as when I step...

I've checked I searched and found nothing that was related to what I want to accomplish. Is my first post clear in what I am trying to do?

I am asking for advise Isn't this a forum what is your problem, can't you help me or what!

this is what I have done so far if anyone is interested? OK this is how far I've gottin its slow but it does grab the value of [C/F] and then places it in [Balance C/F] in the next record. Anyone am I on the right path, I think theres a more effecient method in SQL but I dont know how to...

why? can u tell me why?? is there an alternative to what I am trying to do??? please help i am desperate ; ) I mean this is not a calculated SUM, the value is stored in a field in a table and then it will be used in a report. I've heard its ill advised to store calculated fields in tables...

I need HELP! O(o_o)O --------------------------- I am suriously stuck, Debugging code without documentation is a nightmare for trainee programmers. Basically I need to loop a record set called Summary and Validate all informtion containned within it, I assume the way I can accomplish the task...

Basically I want to create a form that allows the users to select there formatting preference for all my database forms. I want the users selection to be replicated through out the whole database on all forms but I dont want to indivdually reference and assign all controls within my database...

Basically am new to Access so am lookin for help Heres my problem, I'm tryin to create a form with a button which opens up a common dialog box and when I select a graphic file with the dialog it will update my database with a new path to the file I open and possible display the new image on the...

Basically am new to Access so am lookin for help Heres my problem, I'm tryin to create a form with a button which opens up a common dialog box and when I select a graphic file with the dialog it will update my database with a new path to the file I open and possible display the new image on the...