Search results

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 :)

Thanks for your help. I tried doing what you sid, but I got confused! In the end I put a button on the form that ran an append query and then a delete query for the records that i needed to move Thanks again :)

Yeah I think you have understood what I am trying to do, which is get rid of the navigation bar that comes up automatically at the bottom of the form which allows to go to the nex record or the previous one etc. I looked on the format tab of the properties but I couldnt see anything that says...

Is there a way of when you click a button in a form it moves that record from one table into another one? I know Access quite well, but I'm new to VB and modules. Cheers :)

Is there a way of getting rid of the navigation button that Access 2000 automatically puts on forms in the form view? :confused: