Recent content by Johnmad86

Thank you for the help. The issue was with the fact that it is a Web database, so many things that are usually easy (changing primary key field etc) are very difficult to do. We managed to fix the issue by manually copying and pasting the missing data into the table, so crisis averted.

thanks for the reply. I'm not sure how else a new record would be given a unique ID. Also, the database is designed with the CandidateID as the primary key, and this will need to stay the same without re-designing the whole database around this.

We have suffered a large amount of data loss as part of a bulk import that went badly on sharepoint. As a result roughly half the data from a table in the database is now missing, the records are still present but only the surname remains populated. I have managed to combine previous backups...

Thank you so much for your swift response, and simplification of something I was making far too complex. Its easy when you know how! :)

For example, 1 record has the following field contents: CallbackFrequency: 1 Month Last Contacted: 01/05/2014 I need the query to add 1 month to the 01/05/2014 date in a new field (CallBackOn), if the callback frequency is set to 1 Month.

For example, 1 record has the following field contents: CallbackFrequency: 1 Month Last Contacted: 01/05/2014 I need the query to add 1 month to the 01/05/2014 date in a new field (CallBackOn), if the callback frequency is set to 1 Month.

Actually the above does work, the record I was finding had no "LastContacted" Date! My next question is how to manipulate this date to add 1 month to the resultant date. I've tried the below, but am definitely doing something wrong: CallbackOn: IIf([Candidates].[CallbackFrequency]="1...

Hi, I've been struggling with this for a while, and even though I understand the theory, I can't get my code to work correctly. I have 2 fields: CallbackFrequency & Last Contacted. I want to use these fields to populate a third field (callBackOn) so that we can have a list of candidates that...

Hi, I'm not sure this is the correct place to ask the query, so apologies if not... We have developed a database hosted on Sharepoint (Office 365), the forms and queries are not web compatible, so the database is always opened from within Access on the client machine/s. It appears that on 1...

Hi I've been struggling with this issue for days now and I'm nearly there, but can't get the code working. I have a report that pulls data from a crosstab query. The report works perfectly and prompts for a "StartDate" when it is run. I need a form with a date field that can be selected. Then...

thank you for the help. I have managed to get a working report now. I've attached the DB report here in case any others have a similar issue and need pointing in the right direction.

Apologies for the delay, I've attached a sample DB with the relevant crosstab query and report. Currently it displays by month, but as you can see, the figures for each month do not discern by year, so April2013 and April 2014 are totalled and the sum of these values is displayed. When I...

always 12 months would be fine, but a specified range would also be acceptable. Which ever would be easiest I'm thinking would be best! I've got a date picker form where the dates can be entered, but the code to pass the dates to the query doesn't seem to be working well: Private Sub...

OK, I've managed to create a simple crosstab query, and can list the results by Months with no problem. I've manually entered the Column headings as the Months with the PIVOT IN function ("Jan","Feb" etc) and these display correctly, even if there is no data for a certain month: TRANSFORM...

Excellent thanks. I had read about them, but didn't realise they were different to the usual query. I've got it working now and the query displays all months. I'm having trouble getting it to differentiate between different years, but with some tinkering I think I should be able to get that...