Recent content by Smiley 3636

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