Recent content by adamburton

Thanks Neil Thanks very much Neil. I knew it was going to be simple!! regards, Adam.

Hi, I wonder if someone can help with what must be an easy solution to this problem. I have a table with 350,000 records, but without a unique identifier field. I just want a simple incrementing number field to become the primary key but dont know how to add this in. I cannot add an...

Still stuck Just pushing this back up the list in case anybody has got any ideas? Many thanks, Adam.

Ive been following the code on the Microsoft support site for automatically creating a PowerPoint presentation using data from Access. The sample code takes one field from the sample table and displays this on the PowerPoint slide - it then assumes the user can apply this knowledge and add more...

Thanks Thanks Peter, Ive had a read of the support page and think it makes sense. Could you advise what criteria I need to put in my query to point towards the current logged in user. Hope that makes sense. Adam.

I have a staff database in my office which holds, amongst other things a list of staff holiday taken. Presently the staff have no access to view holidays because they will also be able to view other employees details. What I need to do is enable members of staff to see their own holiday, but...

Thanks Pat Thanks for your reply Pat. I figured out the problem - I had a couple of fields on the right side of the report, at the same height. They were stopping the fields shifting up. But your advice about getting all the fields close together was very helpful too, and now it all works...

Handling blanks in address fields on reports For Pat and Rich, I have the same problem with wanting my report address fields to shunt upwards when there is no value. I have set my CanShrink property to Yes. Now sometimes the gaps disappear but others will not. I have checked these fields...

It Worked!! BRILLIANT!! It works a dream!!! Thanks so much for your help Peter. I will remember how to do this for future situations. kind regards, Adam.

Hi Peter, Thanks for the suggestion. However, neither of these will even accept in the query. They both say invalid string (even after adding the closing bracket) - it seems to be the AS part thats causing the problem. Any ideas? Thanks, Adam.

Here you go: SELECT tblCourseContact.CourseID, tblCourseContact.ContactID, tblCourseContact.CourseFee, tblCourseContact.Materials, tblCourseContact.HutFee, tblCourseContact.DepositPaid, tblCourseContact.BalanceReceived, tblCourseContact.DiscountReason, tblCourseContact.SpecialDiet...

Hi Paul, The field name it is referencing is exactly the same in both. Thanks, Adam.

Problems Ive just tried putting the dlookup in the query, but now the query is repeating the same phone number for all records. Im sure Ive got the dlookup correct, it was working for a single form. And I have just pasted across the exact string into the query, so am at a loss as to why it...

Thanks Paul Thanks for your suggestions Paul. I already have built in the button taking users to the phone form, so I think I might just hope the user is ok with that. But if not, I like the idea of the pop-up to add a new record. Thanks again, that gives me a couple of options. Cheers, Adam.

Thanks, but still didnt work. Thanks for your reply. Ive tried to do that, but the phone table can contain multiple entries for each contact (daytime, evening etc). So to pull it into the query Ive created a query on the phone table to group each person ID and then take just the first number...