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

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

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 guys, I hope I explain this correctly as it's a bit of an odd one We have data in a table, addresses which need letters sent every at set points during the year, for example Point 1 01/01/20XX Point 2 01/04/20XX Point 3 01/08/20XX This repeats for 5 years (15 letters in total) then it...

Good Afternoon all, I have a query which returns the results/fields needed for a search query containing 3 fields Query name QRY_SearchProp Fields - [Address_1] - [Address_2] - [Postcode] SELECT Table1.ID, Table1.[Address 1], Table1.[Address 2], Table1.Postcode FROM Table1 WHERE...

Evening guys, I have a DCOUNT on a reporting/stats section of a database. Works fine like it is, current code is =DCount("[DATE_ENTERED]","[CANVAS_DATA]","[DATE_ENTERED] Between #" & Format([Forms]![Admin_Reports]![txtfrom],"mm/dd/yyyy") & "# And #" &...

Hi guys, Hoping you can help, I have a form in my database with a from date box and to date box. I am trying to count the number of entries in the table between certain dates. Table name CANVAS_DATA Field name LETTER_1_DATE Form name Admin_Reports Date from name txtfrom Date to name txtto I...

Morning/Afternoon/Evening all. Need a bit of advice on the best way to approach a report. I have a report which gives a sum total of check boxes. The boxes are Letter_1_sent [Yes/No] Letter_2_sent [Yes/No] Letter_3_sent [Yes/No] Letter_4_sent [Yes/No] Letter_5_sent [Yes/No] Now this is fine...

Howdy Folks. Hopefully an easy one. I have a report with the fields Firstname_ Surname_ [field1] [field2] etc etc (they're not called field1/2 but they're irreverent at present. On the database people can be entered multiple times so I may have Bob Smith Jimmy Carter Bob Smith Jackson...

Hi Guys, Hopefully this will work. We have a button running a SQL query via VBA, how can I make it so the results doesn't show up in a table/preview? Also, I know it's for the SQL forum but how can I make a text box to show the results of a query to display it on screen?

Hi Guys... I am creating two databases currently (there is a reason it is split) One will be located at an off site location (ie branches) so we have Branch A Branch B Branch C and so on. One will be located centrally at HQ. The databases will be used slightly differently Database One...

Hi Folks. I am working on a new project involving two separate Access DB's. One will not be storing data itself, just used to create an initial order which is passed onto a person who processes it (their DB will store data) (I am working on the ordering one atm). It is designed to be able to...

Hi, So I have a new DB set up, tested and working and we're happy with it. However I am having difficulties importing from excel into the existing table and choosing the fields to import into, I have 7 excel spread sheets to into in to the one, each with around 5,000 entries. When I...

Hi everyone. Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010) Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up, but thought I'd check...

Hi, I have a Macro running as a search function. 99.5% of the time it is working perfectly, however every so often it will throw a hizzy fit and crash the system, I can't get a debug as the users who are doing it are running the DB in Access Runtime and of course it doesn't offer to debug...

Hi Guys, Me again.... So I have a DB I am working on which holds canvassing data. Now ever so often we sent a letter out to the people on the DB and it has a time period for example Letter 1 - Same Day Letter 2 - 7 Days after entry Letter 3 - 14 Days after entry This goes on for 30...

Hi All, I currently have a query set up which responds and filters by the date. I use the current code in the criteria on the query for todays date less 7 days DateAdd("d",-7,Date()) This works perfectly and I had no problem with it. However I need to adjust the criteria so it is less...

I have a report which provides me with three totals. Total 1 Total 2 Total 3 Total 1 is an easy one, it uses a count fields =Count([FIELD 1]) Total 2 is another eays one, it is a sum of all the numbers =Sum([FIELD 2]) Total 3 is a bit harder, it is the sum of all the ticks in a yes/no...

Not sure where to put this so here it goes, Yes it is the wonderful me again and once again I hit a little wall. :banghead: I have a basic button, the button opens a word document (Code here) Private Sub Letter1label_Click() Dim LWordDoc As String Dim oApp As Object 'Path to...

So I used John's guide for a name search box. http://www.access-programmers.co.uk/forums/showthread.php?t=188663 We are using the Database and have come across an error. We have two records (two names) excatly the same. When we use the dynamic search it shows both records in the results box...