Search results

Hi plog, It seems to be doing what I need so far. Just doing more tests to confirm, but so far so good!

Hi plog, :eek: I almost can't believe it was that simple. I'm very embarrassed. :o Thanks for your help. I am going to go away now and dig a nice big hole. Can you fill it in for me after I hop in? Thanks.

Hi plog, Thanks so much for taking the time to look at my problem. To be honest, I am struggling with understanding SQL, and I think it shows. The database in question is to manage stock of "Store Rooms" of computer equipment. Like any store room, it needs to be audited from time to time. It...

Hi liddlem, No one on here replied, but I did manage to find out something. I'll post a solution a bit later.

Hi All!, I have a question regarding SQL Queries and nulls. This is my scenario. I am comparing two tables, tblImportAuditTable and tblDevices. There are 5 fields that are being compared to see if they are the same. The primary key in tblDevices is the Serial Number. I want the query to...

Hi JHB, Thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou, thankyou! You...

Hi All, Still no luck! I have attached a database that has the report and the table with some dummy data in it. What have I done wrong? It still repeats the Group Header for each entry...

Thanks for the reply JHB. While I was waiting for someone to reply, I had a play with that exact scenario. The attached screen shot shows the result. It repeats the Group Header for EACH entry. Is there another option somewhere that I have to set to make it only do it at the top of the page...

Hi All, Hope you can help solve this strange one. I have searched the web on this topic and have not found any real useful information. I have a report, a phone list, which has two columns, see the attached file for a screen shot. The Employee Name, Mobile Phone and Desk Phone text is in...

Hi All, Can anyone tell me if it is possible for Access 2010 to check the Outlook 2010 calendar of the user running the database to see if a particular date and time are "free" or "available" and for Access 2010 then be able to send a command to put an appointment into that time slot of the...

Hi CJ_London, What I am talking about is Active Directory Organisational Units (otherwise known as OU). I need to get all the members of a particular OU into a table that I can then use.

Hi All, Long time reader of this forum, first time poster! I am constructing an Access database and wish to get all the members from a particular OU into a table. I have searched high and low on the net for help with this, but none of the answers I have found seem to operate correctly. Can...