Search results

Hi Gemma, Thank you for replying. it does have a certain structure/format, i.e. the data that i am after always falls between two unique strings. for example.... to retrieve the information "RC2789995" it always comes after this string - "Your details are shown below for order ref: " and it...

Update: I've looked into other expressions instead of split, such as left, right and mid but I can't seem to find a logical way to approach it. Does anyone know of any other expressions that I should look into as my searches on this forum and on google are coming up with these 4 expressions...

Good Morning, When I normally parse a string or csv I use the split feature and the delimiter used (I normally use the ">" symbol as commas come up quite often and mess it up). However I now have the problem of trying to parse data that someone sends me and I don't have any control over the...

thank you KenHigg, I feel really clever today!

Hi, I have a field "DisplayURL" that contains values of various lengths. Some are only 12 or 13 characters long, but others are 50 characters long. I need to run an update query to "cut-off" all the characters past the 35 limit - so that all records in the field will be 35 characters or less...

GOT A RESULT AT LAST! For anyone who searches this in future, create a module and enter the following... Public Function fReplace(ByVal Expression As String, ByVal Find As String, ByVal Replace As String) As String Dim strTmp As String, n As Integer strTmp = Expression n = InStr(strTmp, Find)...

Hi Bob, I think it varies depending on whether it was an early or late version of 2000, I presume I have the early one. here's a printscreen of the code and the error: Any other ideas how I can achieve the aim of replacing the various spaces? Thanks for your help Bob. Dean

Hi, I'm trying to run an update query on a field called "DisplayURL" to remove all of the spaces that the field contains. Some have 1 space, some 5 and some have no spaces. I'm using Access 2000 and the replace function ( Replace("DisplayURL"," ","") or Replace([DisplayURL]," ",""). However...

In complete honesty I don't understand the terms or context so I'll have to say no on that one, would you mind explaining a little please? thank you rural guy

hi, I have a table that contains itemcodes and prices. An example of the records would be: <Item Code> <Price> Product001 £34.56 Product001 £49.23 Product001 £23.22 Product001 £98.43 Product002 £12.45 Product002 £54.34 Product002 £25.51 Product002...

hi, I have created a search form based on a table, and a macro to show a list of my customers. If you press "C" it only shows customers whose surnames begin with C. However I've really been struggling with how to filter the names into alphabetical order as well. For example, the following...

Hi KeithG, Thanks for the reply, I've just finished doing it the hard way using """". here's the code incase anyone looks up this thread in future: Private Sub Generate_Click() Me.memo.Value = "Please copy and Paste the following code into the products webpage:" & vbCrLf & "" & vbCrLf & "<form...

Hi Keith, I changed the file name from H: drive to C: drive and it works perfectly, thank you for your help. Dean

Hi, Here's what I'm trying to achieve: By Clicking command button "GenerateButton" on the "OurProductsTable" form it outputs the text below to either a msgbox, or ideally a notepad file. [OurProductID] in the text below would be replaced by the field [OurProductID] from the "OurProductsTable"...

Hi KeithG, Thank you for replying, I've never touched modules with my experience to date, I might be having a dumb moment but I can't seem to "run" the module, when I double click on it, it only brings up the code. I'm using Access 2000 btw. Thanks again KeithG

Hi, Does anyone know if its possible to have a page break/line space in a query's results? For example, a query returns 5000 results, and after every 45 there is a space of 2 or 3 spaces. When I say "space" it could be a couple of empty records or rows. The reason I ask is because I use a...

Hi ChrisO, Thanks for the response, and good idea, had to change the code slightly but it works perfectly: Private Sub Command30_Click() If Abs([test1] - [test2]) < 0.011 Then MsgBox "Correct" Else MsgBox "Incorrect" End If End Sub Cheers ChrisO Dean

Hi, I have two text boxes that contain two number values, "test1" and "test2". I currently use the following code to check that the values match: if test1=test2 then msgbox "Correct" else msgbox "incorrect This works fine, however I want to be able to check they match "plus or minus a penny"...

thank you very much bob, I used the "If Val(Me.Test1) = Val(Me.Test2)" and it worked perfectly. The "Quotes" around the code was the last of many variations that I'd tried, I didn't think it would work but I wanted to test everything and forgot to change the code back when I posted it here...

Heres the part of the database that I'm struggling with, "InvoiceForm" is the form that contains the problem. I just can't get the msgbox to say correct when the "Duplicate ID" from the left subform is the same as the "OurOrderID" from the right subform. I'd appreciate any ideas at all, thank...