Search results

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

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

Hi, I've seen other posts that seem to be the same as my issue, but I'm afraid I've not understood the answers. Hopefully someone is able to point me in the right direction. I need to create a report from a query. I have created the query that pulls the below data from the relevant tables...

Hi, Hopefully someone may be able to assist me here, I have a query that is working, but would like to add some extra complexity to it. the query currently uses a search form for input with multiple fields, and displays all the results perfectly. I have a tick box which I can then filter the...

Hi, I hope someone is able to help me on this complex issue. I'm sure there is a way to do this with code, but my skills have left me tied up in knots. I have two tables - Interviews & Placements. these tables have multiple foreign keys which pull information from other tables...

Hi, Hopefully someone can help me on this. There are many similar posts and I've spent the last few days trawling the internet to see if I can find the solution to my problem, but I can't seem to get it right, or find an answer to this part of it. I have a single table with customer...

Hi, I'm a major newby on Access and trying to configure a database to work how I want. I've read many forum posts that seem similar but still not managed to get it working. I have 2 tables named Candidates & Comments. CandidateID is the Primary key for Candidates and CommentID is the primary...

Hi, I hope someone can shed some light on this issue. I'm pretty novice at creating Access Databases, but have managed to butcher the Contacts template for a Web Database I'm creating. I have it working mostly, but part of the requirement is to have a search form created so any fields can be...