Recent content by cclambie

Did you ever find a solution to this? I am having a similar issue!

Malcy, Thanks for your comments, if you look back in, how long do you think it would take to re-write the procedures in SQL Server processes? For someone with No SQL Server experience? C

Hi All, Solution: I think there was some underlying relationships left over from the table, even though I had deleted all FKs, and Relationships. I copied the table, structure only, renamed the old one, and replaced it with new one. Worked a charm. ???? Thanks for your help Malcy...

Hi Malcy, The only Autonumber is the ValueID, which is not being appended, so shouldn't be an issue....one would presume. I am going to try ADO.Addnew .Update this morning to see if similar issues crop up. The reason for the concept is speed of data retrieval. The Data is used in 10-15...

Hi All, I have a major hair puller... I have a system whereby I have a Front End (FE) and back end (BE) for storing data etc. I am appending data from the BE to the FE into a local table to work on it (checking it "OUT" so no one else can work on it, then back "IN" when finished...) Problem...

Hi all! I have read up on Word Automation and Bookmarking to put data into a word template from a Db. Had a play, and it is going to work great! I am even going to give dynamically grab the bookmark name to put in a string. This is all good. However, my document, will have 100s of bookmarks...

I have not been able to find an answer to this, what would seem simple question. Any help would be appreciated greatly! RePhrasing of Question: I want the $ symbol and thousands seperator's to display as I type in values into my textbox. Format set to currency doesn't work OnChange event...

Hi All, My Querie: I have a relational database, that is basically made up of a few tables, I will simplify for this to two. TblFieldNames and TblFieldValues Basically using a form you can fill in a field (TblFieldNames.FieldName) and it is then appended to TblFieldValues.FieldValue. On the...

FYI for anyone that wants to know: Solved it by doing this: ((Main.ValueID) In (SELECT TOP 1 Sub.ValueID FROM TblFieldValue AS Sub WHERE Sub.FieldID=Main.FieldID ORDER BY Sub.ValueID DESC))); I stoped using the Date as the Order By and it works perfectly! Cheers all!

It worked! Thanks so much!

Hi Guys, Thanks for the input. One issue I have is the strCalc is dynamically created from a table TblCalcRules, which puts the calculation into its form ie. strCalc = strCalcVal & strOp & strCalcVal So I was thinking I would have to divide the string up using inStr or similar to pick the...

I am still having this issue with sub queries, anyone out there that can possibly help me??

Hi All, I am trying to update a fieldvalue with the result of a calculation and it is only updating it with the string, rather than the result (which works in other cases. Dim rst As New ADODB.Recordset Dim conn As ADODB.Connection Dim strcalc as String strCalc = (100+100) rst.fieldname =...

Solved.... Did a test to remove the 0s from the string, then Concatenated the string into a update query and wullah...had my result. Thanks!

Hi. I have a recordset with 3 records (variable) each record has an Operator and a FieldID Dim strFieldValue As String Dim strOp As String The Operator is "*" but could be any other +, -, / The FieldID is used to pull a FieldValue using a function fGetFieldValue(strFieldID) as string.. I...