Search results for query: *

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

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

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

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

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

Hello All, I have two combo boxes on my form and about 10 text boxes. Combo box 1 has 6 lines e.g. Line1, Line2, Line3, etc. Each line has a [COLOR=green]uniqueID and each unique ID has an [COLOR=green]Asset Number. I want a user to select the Line in cbo1 then able to select the uniqueID’s...

Hello Everyone, I am pretty new to access Vba development. I hope someone would be able to help me with my database design. My Questions are all grouped at the bottom with regards to the issues. Brief Design Spec[\b] My clients have provided several excel templates. Each template has about...

Hi Everyone, Can some one please help me with cascading combo boxes. The structure of my database is below. tblAsset_Numbers Asset_NumberId AutoNumber Asset_Number PK Text LineID Number (Went through Look up wizard to get data from tblLine) tblLine LineID PK AutoNumber Line Text...

Hi, Am a beginner with access development and require some help. I have a form called 'frmSelectCode' which has Two Text Boxes and a Checkbox. The text boxes are bound to the values from Table 'tblAllCodes'. In total there are about 66 fields. On the main form, there is a Cmd Button...

I have my tables structured in the manner displayed below. I am having difficulty in created the second sql query for the 2nd combo box to display data which is dependant on what the user selects from the 1st combo box. Please see below. ************************ tblLUPAssetClass ClassID...

I have 2 tables that I have added to an existing database. Table 1 contains all the description values in one the columns. Table 2 contains 5 entries which are the group or categories that the descriptions belong to. For example: tblDescriptions Column Headers: - DescID, Description...