Search results for query: *

Hi All Hope you are well. Have a quick question and hoping someone out there would be able to shed some light. We are having problems in PowerPoint 2007 with enhanced metafile images. People keep using these formats which we cannot stop. This causes powerpoint to run very slowly. We have...

Hi All I was wondering if anybody can shed some light or point me in the right direction. I am busy writing some code to pull data from excel into powerpoint textboxes. I have managed to do this without any issues. The problem I am having now is that I have to write a bit of code for each...

Hi All Here is one that is driving me up the wall. Maybe best to explain what I am after and if I could find out what would be the best way to go about this. I currently have a Biography document in PPT 2007 which I want to link through all my documents (other presentations) to make it easier...

Hi All Any help with the below would be great. I am trying to select a specific slide master in order to insert watermark text on the slides which have the hide background graphics ticked. Code so far: Sub ToggleWatermarkTest() Dim HBShape As Shape If...

Hi I am having a bit of a problem with this VBA code. I am trying to set visibility for a subform. I have used a column in my table which has a tick mark if the form should be visible. I think my problem lies in calling the actual subform as it is a subform in a subform in a tab control on a...

Hi Any help in the below will be greatly appreciated. I have a main form and need to split the data into months. I have created a table for each month and a query for each which calls the records I require. I am using a main form which I then inserted a tab control for each month. I then...

Hi All I am currently in the process of starting a new DB, the old one is out of date and needs to be revamped. What I would like to find out is what will be the best way to do the following: The DB used to work with the user inputting info into an excel spreadsheet, once that was finalized...

Hi All I am not very good with VBA and any help would be great. I have 2 macro's that run reports for diff day eg: Macro1 runs data as Date()-1 Macro2 runs data as Date()-2 What I want to do is use an if and then code to make this happen. This is what I got so far but does not seem to work...

Hi ALL Hope you are well!! I was wondering if there is any possible way to stop a user from selecting a specific option if it has already been selected from the drop down list. If the Dispatched, First Sent Check, Back from Check has already been selected then I don't want the user to beable...

Hi All I am stuck and any help will be great. I have an update query which works fine when I want to work out the percentage without changing the format of the field that it updates to percentage. But when I change the field in my table to format percentage it messes everything up. I then...

Hi All I am not good at VB code at all, any help in this would be great. I got this code from the microsoft website to transpose data in my DB. I get the code in a module and then tested it through the immediate window by using the following: ?Transposer("ytblMISDailyPerformance" ...

Hi All I have had a look at the threads in the forum and could not find anything helpful to me. Is there an easy way or a specific code I could use to do a transpose when I export a table to Excel. Any help in this would be greatly appreciated. Thanks Regards Mark

Hi All Just stuck again with combining a 3 queries. I have tried to combine them but I don't get the correct value at the end. What the query is suppost to do: I have a date which all 3 of these fields have to be signed off by (Attn, IP, SLA). If any of these miss the date that it needs to...

Hi All PHV has helped me so far but I am getting another problem and any help would be great. Problem: I have a query which is working great except for one thing when I try and change the date from a long date dd/mm/yyyy hh:mm:ss into a sort date dd/mm/yyyy. It changes the actual date if the...

Hi All Hope you are doing well today. I am a bit stuck on the following query, any help on this will be greatly appreciated. Code: SELECT tblTracking.PortfolioCode, tblTracking.[CRG Deadline], qrybDistributionDeadline.Date, Count(tblTracking.[CRG Deadline]) AS [CountOfCRG Deadline]...

Hi All Hope you are well!! I am currently in the process of trying to design a new DB. What I would like to find out is if it is possible to create a querie which runs other queries on specific days eg. I want to do a stats report but need to run the queries for yesterday's date (which I know...

Hi All Hope you can shed some light on this for me. I have a sub form which is in my main form it has a drop down selection which users can choose different options. This has been working all along with no problems, but all of a sudden today it started locking users out. Now I can't change...

Hi All Hope you are doing well. I am having a problem getting the sorting right on my report, well not even sure if this is possible. What I am trying to do is get the records to sort in accending order by the Date and then sort it by portfolio code so that it looks something like this...

Hi All This is a follow up on the Count Records in an update query. What I am trying to do is once I can get the count function working right, I would like to update this to a tbl with a date field which is automatic. It should update only the records on todays date and not any previous...

Hi All Hope you are well!! Is there anyway that you can use the count function in the update query. When I use the append query it works fine with the count, but when I change it to an update query I can seem to get it to count. Here is the code I am using any help would be great. Code...