Search results for query: *

I'm aware of the feature to convert the PowerPoint presentation to a word Doc but I will have about 100 to do. I am looking for a way of automating this process. Thanks Paul

Hi all Is there a way of converting a batch of PowerPoint Slides to Word docs with the notes below the slides Thanks Paul

Thanks for your response Gerry It was a little test to see if i can do what I want. Which is Have a front user form for selecting sections of a static document and creating a new document from the selection. test1 and test2 are bookmarks in the testlist document. There will be a fair few...

I have a simple bit of code. All it’s doing is checking a check box for a tick if it has one then insert a bookmark from a file see below. My question is the structure. Yes this works can you do it in a better way? I’m sure you can Private Sub CommandButton1_Click() Select Case testing...

Hi everybody I have 3 simple if statement that say if a field = 1 then concatenate a few fields. This is displayed in the details section. The purpose of this is to display different address in different columns. My problem is that ifa field that is in the concatenate formula isnull then the...

Longhair not all the fields in the query are indexed just the key search fields. All of the data is local to the database. They are simple but in some cases large select queries. Some of them are also being used to produce forms. Today alone the file size grew to 180mb. When I compacted it...

Hi all Can someone explain to me why an access file will grow by a hundred meg when all i have been doing is running queries? No data has been inputed. I'm guessing maybe wrongly that it use's the disk space when running the queries and doesn't give it back. A compact and repair reduces the...

Thank you Massive Help

Hi all I am using Office 2003. Is it possible to ammend the default shortcuts on the left of the Open/Save dialog box's? If so how can this be achieved? Cheers Paul

Hi all I have Crystal v11 Dev edition. I'm looking to intergrate this with access 2003. I want to be able to build reports in Crystal and display/run them through access 2003. Could you give me some pointers on this or a starting point. Cheers Paul

Hi all I have several crystal reports reporting on an access database. I have found there is a Crystal ActiveX Report Viewer Control 11.0 and first thought was use it. My question is how do i go about using this on a form to diplay the results of a Crystal report. All help will be much...

Hi again I found out what the problem was. Instead of [Forms]![frmorderitemssingleform]![Item_No] I used the i declared it field through the main form [Forms]![frmorders]![frmorderitems Subform].[Form]![Item_No] All now works Cheers Wills

Hi all I'm trying to get a filter working on a macro. I have a main form with subform. I'm trying set it up to double click on a record in my subform(datasheet) which opens another form that displays the info from the subform in another single form. I have a macro that i was trying to filter...

Hi all I am trying to workout the difference between 2 dates Using datediff and exculding weekends and bank holidays. I have the example below to exclude weekends. DateTimeVar d1 := {Orders.Order Date}; DateTimeVar d2 := {Orders.Ship Date}; DateDiff ("d", d1, d2) - DateDiff ("ww"...

That is awesome much appreciated Ace Man. That will get so much use. The combo box thing is all sorted now. I was undecided whether to build in some admin tables to store the report names and categories or to type in the values in the combo box control source. Having had a word with myself I...

Cheers Ace Man I'm good. That works fine. I still counldn't see the calendar objects using the expression builder. This is why I assumed(wrongly) that it had to placed in another object. Cheers again Wills

Hi Everyone I'm building a form structure from which reports will be run. Currently I have a combo box from which the user selects a report they want this will either run (using a conditional macro) it or give them another form from which parameters are then selected, either by combo box or...

PH Thanks for the reply but i think you have misread my question. Cheers Paul

Hi every body I'm using Access 2000. My question is, is it possible to automatically link a postcode in an Access form to a website such as multimap which in turn shows you the map of the area? Hope you can help Cheers Paul

Hi all Is it possible to display the parameter selection on a report? Cheers Paul W