Search results

This is driving me crazy!:banghead: I have a simple form with a textbox whose controlsource I get from function: < Public ControlSourceName as String Public Function getControlSourceName() getControlSourceName = ControlSourceName End Function > I set the controlsource of the textbox to...

Hi All, Can anyone recommend a good book from which to learn SQL? Not too esoteric and with plenty of examples (including all the double quotes, single quotes, brackets etc.) I have been able to get a certain amount of knowhow (from this site mainly) but need to advance my abilities (!:o.)...

Thanks for reply Catalina but I am not scrolling records or otherwise; just need the ability to scroll down a navigation subform. Scrollbars set to vertical but mouse won't co-operate!

Why can't I scroll with the mouse wheel in a subform?

Sorry that my question has produced such dissent amongst such a high powered peer group - all these replies have been noted and have been extremely helpful to this new access user - thank you all .....:)

Trevor THANK YOU! Who invented this SQL never took into account the resulting deterioration of users brain cells. All good experience. Thanks for your time and on such a lovely day as well .....

Thank you both for suggestions Null noted. I have copied in Trevor's code but I have a red line not accepted . Does there need to be underscores somewhere? strSQL to do this must be around. I am all at sea (metaphorically speaking only - sadly!)

Thanks for reply Trevor but I have tried; 'strSQL = "DELETE FROM [tblLVRWrittenStatements] " & _ '"WHERE [clientName] = '" & "" & "'" 'CurrentDb.Execute strSQL, dbFailOnError DeBug says: DELETE FROM [tblLVRWrittenStatements] WHERE [clientName] = ' '...

Struggling with this one: I need an SQL statement to delete all records in a recordset which have an empty field (text field). strSQL = "DELETE FROM [tblLVRWrittenStatements] " & _ "WHERE [clientName] = '" & "" & "'" CurrentDb.Execute strSQL, dbFailOnError I have tried with (above) and...

Hi All 1 quick question with respect to hyperlinks in an Access Form: I have successfully hyperlinked a word document from my Access Form. However, I can't seem to work out how to go to a particular bookmark within such word document. I want the user to click on the hyperlink called '3.1' in...

Thanks IsSkint - The very answer I needed. You should get an award!!!! R ....

I am going crazy with this; I have a navigation form containing several forms. The forms are set to a table and the controls are set to the appropriate fields. I need to filter the data to the forms (in the navigation pane to field "BusinessName" passed as the variable lvrName) I have ...

The following is the setup of the Access Database I have created: - Access 2010 Database with several tables and forms. - The Database will be used by multiple users simultaneously - The Database has been published to Office 365 (sharepoint) without being split. - I create a separate 'user...

Thanks for your time Bob. I may well go to the pub as well

Yes same problem with that one..

Same problem ..

Yes same problem..

The pub and a few drinks sounds very tempting! Here is another try after converting to mdb

Sorry to take so much of your Sunday Bob . Hopefully here is the DB

Don't know how to attach!!!