Recent content by Sezzy

I now need the code to find the first word in a string. I have tried using the InStrRev function but I think that looks for everything after/before the last space. At the moment I'm using: Left$([Ad1],InStrRev([Ad1]," ")-1) But that gives me this: 6a Green 3 Ings 13 Lower 52 New Pool 4b Amen...

That done the trick, Thanks a lot

This is an example of what that code produced: reen Lane gs Lane wer Close ew Pool Road en Court ees Road l Street verwood Close eneagles Road estfield Road rescent eneagles Road It seems to be finding everything after the first space and then cutting off the first 2 characters. Any way it...

Is there a way I can select the last part of a string after a space? e.g. I want to get all the last words from the first line of address. So if it was 1 Smith Close, I just want the word 'Close'. I've tried using the RIGHT function, but as all the words are different lengths, that isn't...

Thank you very much. That did the trick!!

I'm trying to import a file that is in a dbf format. The code I'm using at the moment is: fname = Me.filename tblname = Me.filename Set db = CurrentDb Path = "Q:\HH Survey DataPool 2005\PPS\" ImportNew: DoCmd.TransferText acImport, , tblname, Path & fname & ".dbf" This brings up an error...

Hi all, When using the go to record action to move to a blank record on a form. Is there a way to not save what the user has typed on the form when they press the button to take them to a blank record? Thanks ;)

WayneRyan, I opened the database today, and it worked!! I really don't understand it!! Thanks for your help. Oh and when I open the table it's only to check that data looks ok in the table. Cheers :)

Opening a table I am now having trouble trying to open a table aswell: tblname = Me.filename DoCmd.OpenTable tblname Not sure what I'm doing wrong!!!!

I am trying to get the record count from a table. I want the table name to come from the filename that the user inputs into the form. The code I am using at the moment is: tblname = Me.filename totrec = DCount("*", tblname) Me.TotalRec = totrec But it throws an error, saying I entered an...

I went through each And Or line and found the one that threw the problem. It didnt like the '*'*'. So I took the middle single out. I'll just have to live without it looking for addresses with that in! Thanks for the help

I have an SQL statement embedded in VB in Access. When I try to run it it comes up with Runtime error 3075 and says syntax error (missing operator) in query expression. I can't see what is wrong with and have tried numerous ways of writing it. Any ideas? Thanks :) Code: Private Sub...

Thank you very much, these things are always much simpler than I think! :)

I've got a macro that opens a form on startup, is it possible to hide the database window on startup as well? :confused:

Thanks, I've done it! I was looking in the properties of the detail of my form! Doh! Thanks again :)