Recent content by srpatel

Hi, Skip thanks for your suggestions. I may think of trying to use that. Combo, what is the purpose of the web browser? Is not to open the excel file within the browser itself as opposed to opening the actual file in MS Excel. The version of Excel and Powerpoint are 2007 but I can use the...

Hi Many Thanks for all the help above. Combo, I added a WebBrowser control and a command box. However everytime i click the commnad button, a windows box pops up requesting me to open the excel file. If I click cancel the browser has the Page not Displayed error. If I click open the excel...

Hi Skip, In Microsoft Powerpoint 2007 I go to the Insert Tab on the ribbon and select Insert Table. Drag my mouse over the number of columns and rows and the table gets populated. If the table option does not work do I need to create a table with Vb code? Or is there a way of using an Excel...

Hello, I need to create a table in Microsoft PowerPoint 2007 which is capable of having a vertical scrolling bar. When I go Insert a table, I can't seem to integrate the scroll bar which is available in the VB toolbox with the table. I have tried searching for solutions but have struggled to...

Hi I tried what you asked, and yes it does work, but only if they are both within the same cell or line. The way the template has been designed, the RefNo, is in a different cell from the Location. If you highlight the B071 and hold down CTRL key to select the Location in another Cell, it does...

Hello, Thanks for the reply. I have mastered the Auto Text process. I have also implemented my Auto Texts so that they are only available to the template. I need to figure out how to link the RefNo to the Location so that when the RefNo is entered the location gets populated automatically...

Hello Gerry, My apologies for a very vague topic note. Right answers to your questions: AutoTextList is a feature in MS Word that enables users to lookup words. Insert>AutoText. I have created 3 different styles for other parts of the template e.g. the Product Name. I used this as...

Hello, I dont know if I am in the right place, but I am pretty sure the task that I want to do needs some VBA in it. I am a beginner with VBA skills. I currently have a customised Word template that is used on a daily basis which I have tried to make more user friendly by adding Auto Text...

Hi Tom, Thank you for the valuable links full of information. I managed to work out the count of each group by placing this in the Group Header: =Count([Line Desc]) Thanks for your help! Srmp

hello I have had to design a report that looks relatively similar to my form. At the present the report layout is in the following manor: Page Header GroupHeader0 Detail Page Footer The data is currently sorted and grouped by the Line Description and the Location. The Line...

Hello, Thank you for your help with queries, rjoubert and mp9. I will test these out and see i get on. Thanks SRP Have an Awesome day!

Hello all, I need to update my table which has about 2000 records in it. I need to update a column depending on what Location is in the record. Below is my table structure: tblLoc LocID LineID LCCode LCDesc LocType AssetLocTypeID tblLine LineID Line tblALLBS BS_ID Asset_Num LineID...

Hello All, I need some help on enhancing my queries/sql statements. I have a table called tblDTTAssetFunction. Table Details: AssetFunctionID (PK)[tab]LocationType (text)[tab]DTTAssetFunction (Text) 1009768[tab][tab]Station[tab][tab]Lift There are different location types used as well...

Hi Jerry, Abit new to access, could you give me an example please? thanks

Hello, I am hoping for someone to help me out with a query I need to run on my MDB. I have one master table that collects all the information called ALLBS. There are other relevant tables that the ALLBS relates to get information from. Currently when I export data from the ALLBS table, to...