Search results

thanks, although the traking change in status is one object, the other is having a table with null fields, or repeating information. example an individual can be employee of a company but i don't require their TFN, Visas etc.. just their name and contact details, as they are not client but a...

thanks - orginally that was my thoughts to, as shown in the table format with the contact table being the link to their status and relationships. but think i made to complex

Given the advice i have received, i think i will go with my original plan. of the table set up were a contact can be a client, contact, or protetential client, based upon weather or not they are business or individual. which have relation ships, eg spouse, employee, director, partner, etc and...

Thanks, thats fine I'm ok with that, and i understand the frustration

i was trying make each client code unique but similar

gee thanks

Hi I have a problem, an would appreciate help with the folowing. I need to extract the first three letters from a clients name and add a unique index number to it, as the primary key. For example ID: FLI0001-BIZ Type: Company Name: Flintstone Pty Ltd Type can be Individual (IND), while Sole...

thanks will do

Hi I have similar problem, an would appreciate help the folowing. I need to extract the first three letters from a clients name and add a unique index number to it, as the primary key. For example ID: FLI0001-BIZ Type: Company Name: Flintstone Pty Ltd Type can be Individual (IND), while Sole...

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