Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by srpatel

  1. srpatel

    How to have a scroll bar work on a Powerpoint Table?

    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...
  2. srpatel

    How to have a scroll bar work on a Powerpoint Table?

    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...
  3. srpatel

    How to have a scroll bar work on a Powerpoint Table?

    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...
  4. srpatel

    How to have a scroll bar work on a Powerpoint Table?

    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...
  5. srpatel

    MS Word Linking fields

    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...
  6. srpatel

    MS Word Linking fields

    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...
  7. srpatel

    MS Word Linking fields

    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...
  8. srpatel

    MS Word Linking fields

    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...
  9. srpatel

    report design

    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
  10. srpatel

    report design

    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...
  11. srpatel

    Fill in Column

    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!
  12. srpatel

    Fill in Column

    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...
  13. srpatel

    Query for Displaying records

    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...
  14. srpatel

    Query for Values

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

    Query for Values

    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...
See more

Part and Inventory Search

Back
Top