Search results

Honestly Pat you might as well be talking a foreign language, my Access DB knowledge is very very basic. @theDBguy is very useful and provides a good explanation but still I am a bit stuck!

@theDBguy I'm hearing you and thanks for jumping in with something constructive! So I now have a child Table called 'ContactAttemptT' with customerID, ContactID, ContactDate, ContactType. Just off subject slightly because I want to keep my form for inputting new leads and amending existing...

@June7, thank you. Do you mean like this: strSQL = "SELECT [CustomerID], [Broker], [Lead_Date], [Client_FN], [Client_SN], [Email_Address], [Mobile_No], [Email_Sent], [SMS/WhatsApp_Sent], Nz([Phone_Call_#1], "") AS C1, Nz([Phone_Call_#2], "") AS C2, Nz([Phone_Call_#3], "") AS C3 FROM Client" _...

@GPGeorge apologies for my silence have been working quite a bit! So lets assume I have 'Normalized' call attempts and now have a child table called 'CallAttemptsT' and being mindful I'm having to shoehorn this data into an Excel spreadsheet(THIS CANNOT BE CHANGED) which still has the three...

@GPGeorge Thank you all makes sense. I will have a re look at the code I have elsewhere i.e. the code that populates the spreadsheet and see if this can be changed to work with a new child table. If it involves more work than I was expecting then I will just scrap the whole thing. Can't...

@GPGeorge well worded and a much better approach 👏 I am upset with the approach not by the fact that I've been told its not a perfect design after all on several occasions I have admitted I agree. I have what I have and can only work with what I am given. I am not going to do something in a...

I'm self employed Pat so wouldn't make any difference and anyhow if they saw it probably wouldn't bother them anyway. Good comparison aircraft pilot and db designer I can see the similarities 🙄 Just because someone doesn't want to do it a certain way shouldn't open them up to abuse, which is...

I think you'll find Pat, that I have agreed with you so not ignoring you. Just looking for a solution for what I have rather than re-inventing the wheel.

Well that's why I'm here Pat for the code, not business advice. Should things change and I decide to leave the business well then that's not my problem is it! Sorry but my crystal ball fell out of the car this morning while I was crossing the Brooklyn Bridge and broke so I cant predict the...

@Pat Hartman you see the things is I have an advantage over you, I actually work for the organisation I am putting this together for and our sales process is three calls so its not about belief, its a fact! Anyhow this isn't about how the business is run its about working with what I have been...

@June7 thank you for your input and defence 👍 having said that what the other commenters don't know yet, as I have not explained this, is that elsewhere in the DB this information populates a spreadsheet with defined call attempt cells which then gets fired off to the directors. I am sure...

Hi Everything that you have said makes absolute sense and I do have child tables within my DB for example with notes, however, our sales process is for three calls max, one email and one message/WhatsApp and that's how I've built the lead input form & table. If value is null for placeholders...

@cheekybuddha If I'm honest cant really answer your question 😊 because I have pieced this code together slowly from other bits of code I have found elsewhere. so it is in this order because that's the way it was when I copied it!

Hello, So far with the very kind help of people of this forum website, I have pieced together the below code and it is working 😊 I am new to VBA and although dabbled in the past never got this involved. Essentially the code below takes information for a specific lead/customer from three...

@arnelgp that works, thank you 👍

Private Sub ClientStatus_Change() If Not (Me.ClientStatus.Value = "NPW - No Contact" Or Me.ClientStatus.Value = "NPW - Gone Elsewhere" Or Me.ClientStatus.Value = "NPW - Unable to Place") Then Exit Sub Else If Me.ClientStatus.Value = "NPW - No Contact" Or Me.ClientStatus.Value =...

Bound Column value is 1

Does this mean anything to you? This is under RowSource in property sheet for combo SELECT [ClientStatusQ].[ClientStatus], [ClientStatusQ].[ClientStatusID], [ClientStatusQ].[CustomerID] FROM ClientStatusQ ORDER BY [ClientStatus];

Tried this but every option I select from the combobox brings up message box?

@cheekybuddha and as if by magic, thank you. This is such a steep learning curve and something as simple as some brackets can make all the difference! Cheers