Recent content by Smiley 3636

Thanks every one especially the demo from arnelgp. That was simple compared to my over grown mix

Moderator Edit:- (Code Tags Added) iMenuSQl = " UPDATE [dbtMenuSubList1] " & _ " SET [dbtMenuSubList1].[CatSublist] = True " & _ " FROM [dbtMenuSubList1] " & _ " WHERE [dbtMenuSubList1].[MLBID] Between " & i2F & _...

I did but unfortunately the do command fails the debug print out put is as follows UPDATE [dbtMenuSubList1] SET [dbtMenuSubList1].[CatSublist] = True FROM [dbtMenuSubList1] WHERE [dbtMenuSubList1].[MLBID] Between 1.01 AND 1.99

I changed the sql statement and it works by the debug. Print but still has a syntax error Private Sub List3_Click() 'MS ACCESS DETERMINE THE LISTBOX ITEM CLICKED ON CLICKED EVENT Dim rowIndex As Integer Dim rowValue As String, iMLBid As String, isub As String Dim rowIsSelected As Integer...

because i want stayaway from the active x controls

Hi I have list box attached to a table i am trying to achieve a treeview output. What i am trying to acheive is that when i click on the list box it shows the main category with the sub caategorys in view. for example: OVERVIEW CHART OF ACCOUNTS to OVERVIEW - Immediate window - Lodgement...

Hi i am a accountant in Australia, who would like to develop a ms access program that act's a front end, with the back end possibly dataverse, while share files in sharepoint

Hi I understand, the reasons, not to run the access database from other sources, other than your desktop as has been clearly pointed out. But what Id like to achieve, is to use Microsoft access to view uploaded documents like PDF files, on to SharePoint, as well as Excel and Word files. And to...