Search results

Excellent - still finding my way around!!!

So SORRY! - AccessB !!!

Thanks UtterA

UtterAccess - What version of Access does Slider 6 work on?

The only thing I can do for present is to use the Forms 2 scrollbar control which is included in 2013....

Hi All, I have an Access 2010 program using Microsoft Slider Controls 6 (I know, I know - mistake!!) Access 2013 won't run the program for my user. What can I do? Do slider controls exist for 2013? or is there a Non ActiveX slider solution? Any thoughts (or commiserations) appreciated...

Almost immediately found the answer, probably not the most elegant but .. <CurrentDb.Execute "INSERT INTO [ArchivedWrittenStatementsTable] SELECT * FROM [tblLVRWrittenStatements] WHERE [tblLVRWrittenStatements].[seedrsID] = " & seedrsIDVar & ""> Hope this helps someone as useless as me!!

Driving me mad!! I select records from a table based on criteria: < Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("SELECT * FROM [tblLVRWrittenStatements] WHERE [tblLVRWrittenStatements].[seedrsID] = " & seedrsIDVar & "") > I now want to append these filtered records to another...

Hi all, I have a back end of split database (the tables) on Microsoft Sharepoint. I have used: < DoCmd.TransferDatabase acImport, "Microsoft Access", FullpathToHoldFile, acTable, strOldTable, strNewTable, False > to import tables from a local database (< FullPathToHoldFile > is the path to...

Thanks Bob; that did the trick - now for Sunday lunch thanks to you ....:)

Thanks for response but produces "Expected end of Statement" at first Square Bracket.

Hi All, Can anyone help here: Public strOldTable,strNewTable as string OldTable has data, NewTable is empty but with same field structure. I assign names of tables to these variables and attempt to fill up the NewTable with the data from the OldTable using : DoCmd.RunSQL "INSERT INTO ('" &...

PeterF thanks for reply but they are still there after a compact and repair. Best wishes, Roger ..

Does anyone know how to get rid of the list of files in my database which are labelled <Form_~TMPCLPetc.> ? They appear when in Code view in the nav pane and don't seem to be required. Thanks....

Got it! - Thanks Paul. Best wishes, Roger ..

Thanks for reply Paul, but tBusVar is a variable and not actual text; how would that play with DCount and DLookup in my situation?

Can anyone help here: Table is named tblLVR Field is BusinessName I want to check the previous existence of this name in the table. I assign a variable tBusVar to the entered name on it's changed event and write the following code to see if it is already in:- If DCount("[BusinessName]"...

Rx: Well done!! Thanks for the solution - was driving me crazy as well.......Roger ..

Thanks kipcliff that's helpful....

Is there a way of searching a rich text box for any text which is highlighted and then deleting that text? I cannot find an answer to this anywhere..