Search results

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...

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

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 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...

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

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: