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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bronc
  • Content: Threads
  • Order by date
  1. bronc

    desktop menu

    I recently saw Windows 7 screen with a desktop menu using "Access Forms"?. Brightly coloured tastefully iridescent even. Bout 5x 8 cm tucked into the rhs top of the screen. THey have options for entereing Customer Joc details start date of the job etc. Ive got no idea what they were and how...
  2. bronc

    garbled comments

    I am trying to make sense of some code that I downloaded but the comments appear garbled eg: /*--------------------------------------* Ãû ³Æ: patternDetect2 Êä Èë: ¸ÅÂÊA,B,C,D,E Êä ³ö: ÊÖÊÆÀàÐÍpattern ¹¦ ÄÜ: ¸ù¾ÝÊÖÊÆÐòÁÐÔÚÄ£ÐÍÖеĸÅÂÊÀ´ÅжÏÊÖÊÆÀàÐÍ...
  3. bronc

    alter report data at run-time.

    I can create an unbound text box in the detail section of my report. This text box refers to another control on the report called "Person" when I place this expression in the unbound text box... =IIf([Person]="ed",1,2) .. sure enough it gives 1 whenever the Person control is "ed" and 2...
  4. bronc

    modify a report

    I have produced an report/invoice from the table of data. (It contains some subreports as well.) After the report/invoice appears, I might like to modify the data on the report itself- and then maybe save it as an individual modified invoice. Any ideas how to modify the contents of a report??
  5. bronc

    printing code in colour

    I want to print my Access VBA code in colour. I usually copy the code - module by module and paste it into Word where I have written a "Pretty Print" routine to automatically print it colour code formatted. This takes ages when I have lot of modules. I got a bit excited when I noticed that...
  6. bronc

    formatting contols

    I want to format lots of text boxes which are already on my form to .423 height and Font Tahoma size 8. The format painter does the height only. Is there a way - maybe from code (but presumably in design view) of applying formatting in one go to text boxes for example that I place on the form...
  7. bronc

    Field Heading Colours

    I make a "Datasheet" form based upon a table in 2007. The field heading of this Datasheet form are a light brown. I want to print the form. When I Print Preview it, the colours change slightly but I still have the light brown headings across the top. Are they some sort of "system" colour? Is...
  8. bronc

    What good are Relationships

    We can 1. set up relationships between two tables eg a one to many and eg set the join type to 1,2 or 3 and save this layout. We can then 2. make a query for the same two tables and maybe choose a different Join type. I don't understand why we need to perform 1. above. Does this just set...
  9. bronc

    current event

    I have a form and a subform. I wish to update a combo on the subform for each new record. The current event seems to be extravagant since it seems to fire more that once for each new record. Is there a better way of updating the form each time? Or ccan I use something like a static variable to...
  10. bronc

    protect a form

    Hello I'd like to prevent/allow edits and additions to a form by using a toggle button with the code: Private Sub tglDataEntry_Click() Dim tf As Boolean Select Case tglDataEntry.Value Case True tglDataEntry.Caption = "All Data" tf = True Case False tglDataEntry.Caption = "Edit Data" tf = False...
  11. bronc

    subforms on another pc.

    I'm sorry to be vague but my 2007 d/base was working fine until i placed on another PC (2 others actually). The call to the subform code came back with an error message saying that it now couldn't find the subform - or at least the controls on that subform. I just wondered if there were any...
  12. bronc

    determine control index

    We can determine the name of a control by using its index: MsgBox Controls(3).Name but how can I determine the index of a control using code? Thanks
  13. bronc

    northwind

    Is there a description of the operation of the new Northwind sample d/base - in particular the VBA? I notice that there is not much commenting in the code. To save some time I've tried Googling without success as yet. Thanks
  14. bronc

    merge from Access

    Hello I have an Access 2007 database. Of course i can merge to Word from that. Is it possible to merge to an Outlook email? ie is it possible to place Fields in an email just as we do for Word?
  15. bronc

    Filter By Form disables all controls

    I place a button on a form to make a filter using DoCmd.RunCommand acCmdFilterByForm After choosing the filter by checking the boxes etc I would then like to Apply the filter using DoCmd.RunCommand acCmdApplyFilterSort in another button or checkbox or whatever. The only problem is that it...
  16. bronc

    dynamic text boxes

    Hello: I would like to dynamically place some text boxes on a form at run time.
  17. bronc

    userform always on top

    I made a Userform - from Word as it happens. If I click on the Word app it won't come to the top ie the userform is always on top. If I start Excel , i can click on it to bring it to the top but not the Word. I saw a Windows API caled SetWindowPos but also read that the userform is not a child...
  18. bronc

    keyboard event

    I wish make Excel to repond as soon as i enter a character into the sheet ie a Key Press event of some sort. I see a Worksheet_Change event but that only fires after leaving the cell. I can't even see an API i might use. Any ideas please?
  19. bronc

    automation

    If I write this code in an Excel Module and run it: Option Explicit Dim xl As Word.Application Sub Import() Set xl = New Word.Application End Sub I get: "Run-time error '430' Class does not support Automation or does not support expected interface." The strange thing is that it runs OK on...
  20. bronc

    ordinal numbers

    I have a document dated 20th August 1999. The 20th is dispayed with the th as superscript. This feature of course can be turned on and off in Office 2000 & 2003 but can anyone tell me please if this feature was available with Ofice '97 which was presumably supposedly used to write this...

Part and Inventory Search

Back
Top