Search results

Hi All, Hoping you can help as I am sure this is straight forward, I have a database and I am trying to extract answer questions, The premise is as follows. tables are as follows tblClients - ClientID - DateAdded - ClientName - ClientRef - OtherComments - AdviserContact tblQuestions...

To explain where I was going with the following tables tblFeeType tblTenType tblRenPeriod tblBranch These tables contain items that need to be amended by users (add new Fee types, new TenTypes, RenPeriod, Branch etc. So for example, a user adds a new Fee Type "TDS Fee" When the user is then...

Sorry, Landlord/Property are the same thing (the tbllandlord stores information about a single property and is unique to that property) tbh could be reworded to tblproperty AspasiaID is an internal ID from our inhouse system where some data comes from. (we need this to reference back)...

Afternoon guys, Hoping for a little advice on a front end structure, for clarity I will explain the system in full. I have a proposed database with the following structure tblLandlord - Contains data for the landlords property tblRenewal - Contains data for a specific renewal, each property...

Surely the easiest way would be for the form to be unbound and then only write the data to the table once the user completes the form and hits save/new record?

So essential it'll look like this. Ideally I'd like the rows (8) to load automatically when the form is opened with the values added to them in 1-8. Can this be done via an VBA on open? if so where would I start?

Hi, So couple of questions, Firstly, is it possible to have the sheet to populate 8 records when loaded rather than only show one and for more to appear when the first is filled in. Secondly, the Questions column, questions run 1-8 in order without fail. How can I make the numbers auto...

I assume I'll need it as a sub table as I have questions further up which will not form part of the data sheet? This I'd have a form with the normal fields fields Sub form with questions 1 - 8 which sits inside the first form?

Hi all, I have a database I am creating asking a client questions, I have the following tables & fields Table > Clients - ClientID (Primary Key) - DateAdded - ClientName - ClientRef - Other Comment - AdviserContact - MSCContact Table > Questions - QuestionID - ClientID - Foreign Key linked...

Hi Plog, Thanks and sorry for the delay in the response. Been away for a few days. Overall this looks amazing and the structure or set up seems to do everything I need it to. If I have more questions I may post back, :)

Thank you. So looking at this and how it works it looks so simple and straight forward. It's great. So just so I think I have it right I'll explain what's happening or I think is happening. *[SendLetters] the new field in property will tell me which properties need letters, Ergo I'll need to...

Yeah I figured that, I'll crack on this morning and import them into the DB I have sitting here, (my working project)

Apologies I thought I answered that already, Yes Canvas & Block are two independent operations and should not interfere with each other.

Interesting.... Yes it would. We would need to base it on the DUE date of the letter 26 not the SEND date of the letter. The only time letters are not usually sent on the Due date is usually over weekend/public holidays. What if I built a 14 day buffer in to defer/delay letter crossover?

That is where my logic for it was originally going until I got overridden by the powers that be. Powers that be said that: If a Landlord has letters going out when a property is added, that property NEVER gets letters If a Landlord has no letters going out (even if he had letters go out...

Just a thought, could it work on the logic that When a Property is added to a Landlord, if Landlord is inbetween receiving Letter1 to Letter26 the file is marked "DoNotMail" so it doesn't appear in the mailings.

I think first entry for the LL is the wrong term to use. sorry. So from the example I have here, PropertyID 4 was the first property on the DB and had a letter run begin, Half way through PropertyID 5 got added (they have the same Landlord) Property 5 NEVER gets a letter sent out as letters...

I figured it would be based of the property table as it'll be reliant on the "PropDateEntered" field. I think I will keep as two queries, 1st letters which will then add the initial entry into the Letters table and then continue to use LettersDue as it is. I'll try a few things, will prob post...

Thanks, I've done that. I've noticed that the query LetterDue requires a Letter to have been sent for it to show a result. However when a property is first added it will not have had a letter sent, Dealing with the "initial" letter, would it be better to use a different query i.e...

Thanks, I don't think I need +7 as I only want to run for letters due on the day, the Due date represents when they're due to be processed/printed not due to arrive. So using <=Date() is perfect as I only want results with todays results or less. But thanks. This is fine, I have comething...