Search results for query: *

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

Hi PH, Thanks for that! It worked perfect! srp!

Hello All Hope fully some one can help on this query i would like to run: I have a table with the following fields: tblFormFieldProperties FormFieldEnableID PK EllipseAssetTypeID (cbo) FormFieldID (cbo) Enabled CheckBox Taking an example EllipseAssetID contains records such as Chimney and...

Hi PH, That SQL query worked sweet! One thing though is that when I change the unique ID, the AssetNumber field does not get updated. e.g. I choose Line then Unique ID then I DO get the relevant asset Number, BUT whilst testing, I noticed that say in case a user made a mistake in choosing...

Thanks for that PHV, But I have just had an update from my clients and the text box needs to be a combo box now. I have managed to work out the first two combo boxes by having this in the row source for cbo2. But i cant seem to have the the relevant asset number appear in cbo3 as all of them...

Hey AceMan, I read up on the DLookup Aggregate function. this is how mine looks: =DLookup("Asset_Number", "tblAsset_Numbers", "Asset_NumberID"=Forms!frmT4MAssets_B&S!Asset_NumberID") and i get the following error: The expression you entered has an invalid string A string can be up to 2048...