Search results

Hi CJ Sorry I could not get this to work :s I have redesigned the form to perhaps make this simpler... frmNotesAdd allows someone to add notes to a date not yet entered. frmNotes will allow someone to update existing notes - this is the one I am stuck on. User needs to select a date using...

I have a form that each day needs to be filled in by staff of their activities. By selecting a date, I want to the textbox to display the contents of the comments memo pad field in the table (tblToday...columns are t_date and t_comments). My very limited access and previous SQL knowledge has...

That's perfect, thanks Namliam :)

No, as it will be used every weekday by the sales team (and other staff for that matter). if all dates are added each day then I think that the table would end up being too big... All data is in the tblSpeak which has a date column (s_date) and tblmeeting (m_date) The query I ran had the...

Hi Plog Have found an issue which might need resolving first and fixing it could correct the problem I am having. The first query run is called qrySpeakPerAction. As you can see from the first screenshot, it only displays dates when there is data. Is there a way for this to run and fill in...

Final few snagging points on a CRM system I am building for everyone in the office to use, with the help from you guys so far I am almost there, so thanks! Background: Sales will make calls and record data using a form (frmEnquirySpeak) which will save to tblSpeak. If the call results in a...

Yup, just run a test after amending the form which inputs the data and the query now runs as it should. I now remember this is one of the reasons for seperating out the date and time element when the table structure was designed. Thanks again!

Hi Gina The report shows the same as the query. I think I have found the issue though! looking at the query the s_date column for 25/12/2014 shows the date and when I click in the record it shows only the date. If I go to the 02/01/2015 records it shows the date AND a timestamp (25/12 data was...

No not that I am aware of

The query has been updated to the below (noticed some odd results which was a result of including SUM. TRANSFORM Nz(Count(tblSpeak.s_action))+0 AS CountOfs_action SELECT tblSpeak.s_date FROM tblDrpSpeak INNER JOIN tblSpeak ON tblDrpSpeak.ID = tblSpeak.s_action GROUP BY tblSpeak.s_date ORDER BY...

tblSpeak has 2 columns for this: s_date s_time if this is bad practice I can amend to be 1 single date & time field?

Thanks Gina I've got it working (to a point) now, and thanks to thread 64141 (sorry cant link!) it shows 0 values as well Edit: However, it has presented a new problem: the subsequent query qrySpeakPerAction contains the date field and 14 types of action available (1 action per contact with...

Apologies if this has been posted before, I have not managed to find it so far! Creating an access database for use as a CRM system and need to start building reports into it. I have a table named tblSpeak (2 key fields here are s_date and s_action) and need to create 2 reports initially: 1 -...

Thanks plog! Simple things are catching me out! I updated the query to show all tblEnquiries p_ID records and only those which match on tblPeople (in the datasheet it now displays the null records correctly). The Enquiry form record source has now been updated to the same, which now allows me...

Trying to build a CRM system for the office but am getting stuck with the below, any help is much appreciated! Each company (tblCompany) in the database has at least 1 enquiry (tblEnquiries) linked to it and normally at least 1 (sometimes 0) people (tblPeople). I have a form which loads...

Doh! It was simpler than I was expecting! Thanks very much! Will also change the 'text' to something else, this was based on code I had found from a web search so had not crossed my mind to update it.

I am new to access and have found extensive help on this forum from previous posts so thank you all for unknowingly assisting! I cannot find the answer to this on the forum so far, please point me in the right direction if I have missed something... I have a form (frmMasterPeople) which...