Search:

Type: Posts; User: bwallis9; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    15
    Views
    2,107

    Re: Linking Fields on a Form (Access 2003)

    Hans: I downloaded and opened your spreadsheet with the search unbound control. Unfortunately, when I try to select another Customer, it gives an error. But, not to worry as you've answered my...
  2. Replies
    15
    Views
    2,107

    Re: Linking Fields on a Form (Access 2003)

    Pat:
    You're right; I do have an aversion to VB; I've taken a few courses in it and I discovered it wasn't my "friend". But the macros in this database are part of an exercise I was conducting. ...
  3. Replies
    15
    Views
    2,107

    Re: Linking Fields on a Form (Access 2003)

    Thanks Hans; I just didn't scroll far enough down the page. I believe the zipped attachment is posted ok. Just a minor detail that doesn't affect the problem; the subform is created by merging the...
  4. Replies
    15
    Views
    2,107

    Linking Fields on a Form (Access 2003)

    The scenario. There are 3 tables in an mdb: Customers - One table (PK is Customer ID); Orders: - Many table (PK is Orders ID Foreign key is Customer ID and it's a combo box); Materials - Many table...
  5. Replies
    15
    Views
    2,107

    Re: Linking Fields on a Form (Access 2003)

    Sorry Hans. I do have the mdb down to 87kb but I don't see a place on the post page where I click to add an attachment. Having never done this before could you advise? Thanks.
    Bob
  6. Re: Separating Label from Text boxes in a Wizard F

    You're right Hans. I deleted a field, then re-inserted it and it came with the large moving handle in the top left corner of each box. However, I'm thinking we shouldn't have to replace each field...
  7. Separating Label from Text boxes in a Wizard Form (Access 2007)

    It appears on my installed Access 2007 that, when a form is created using the wizard, I can't move the Label or its associated Text box independent of one another; try to move one, they both move...
  8. Replies
    1
    Views
    1,182

    Using F6 in Table Design View (Access 2007)

    As we all know, in Access 2003 we could use F6 to move to the Properties of a field in Table Design View; then we could quickly get back to the top portion of the Design View by pressing F6 again. ...
  9. Replies
    2
    Views
    463

    Using Cover Pages (2007)

    In Word Options you can change the Ruler Bar from centimeters to inches. Is there a way to do this in Power Point and Excel without going into the Control Panel or....is this Microsoft's way of...
  10. Replies
    4
    Views
    1,098

    Re: Combo Box for Searching (Access 2007)

    Thanks for all your input gentlemen. However, I overlooked one item in Access 2007; I forgot to change the setting in the "new" Security Bar to "Enable this Content". Now all three options for the...
  11. Replies
    4
    Views
    1,098

    Combo Box for Searching (Access 2007)

    I'm slowly converting to Access 07 and have run into a brick wall. On a form that contains thousands of items and you want to search for 1, in Access 03 you'd put a combo box on the form and, using...
  12. Formatting a C Drive (Windows XP or Vista)

    I purchased a laptop about 6 months ago; it had Vista and all the other inherent problems with this OS. So, I decided to erase/format the hard drive where this OS resided. From there, I thought I...
  13. Replies
    6
    Views
    369

    Datbase Functions (Excel 2003)

    Apropos my post yesterday. Attached is a different file but with the same errors for DAVERAGE. I've checked what you pointed out to me yesterday Hans and, there don't appear to be extra spaces and...
  14. Re: Excel Database Function Errors (Excel 2003)

    Thanks again Hans for your ever-present vigilance and keen eye; one tries to check for everything but, sometimes you can't see the tree for the forest!!
    I'll no doubt have more coming your way in...
  15. Excel Database Function Errors (Excel 2003)

    Please check the attached Excel file. For some reason the formulas appear correct in cells G21 & G22 and yet the results are wrong. Any ideas what could cause a wrong result (zero) and the #DIV/0...
  16. Re: DVD/CD Drive Suddenly Doesn't Work (Win XP Pro

    Yes it did crash the system. But, later this afternoon I figured I needed an upgraded version of Roxio Creator and it was on sale so I picked it up. I loaded the CD files onto a USB Key using a...
  17. Re: DVD/CD Drive Suddenly Doesn't Work (Win XP Pro

    Yes Doc. I should have mentioned that but, lo and behold, I went to try to Restore the computer to an earlier point but, for the first time since I've had XP (since it's been out), there was no...
  18. DVD/CD Drive Suddenly Doesn't Work (Win XP Pro)

    My computer is about a year old and, up until about a month ago, everything worked fine. Didn't change anything or download new software; then, all of a sudden, the DVD/CD drive stopped working. I...
  19. Replies
    2
    Views
    1,019

    Re: Printer Offline (Word, Excel 2003)

    Hans: You're the best source of info I've come across. I visited the Netherlands when my father was in the Canadian Air Force in 1964 and, I must say, what a beautiful country!! I'd love to go back...
  20. Re: Refencing and inserting another cell (Excel 20

    Thanks Hans. Works like a charm. You certainly are the guru of Microsoft. I have another quick question, if you don't mind. In Word, you've created a table that goes to a 2nd page and, in the...
  21. Replies
    2
    Views
    1,019

    Printer Offline (Word, Excel 2003)

    I have installed an HP multi-purpose printer a couple of days ago. It worked fine until it ran out of paper. I inserted paper and, no matter what I do, it continues to show the printer is offline. ...
  22. Refencing and inserting another cell (Excel 2003)

    I have a spreadsheet (please see attached) that goes from B5 to J13. The range B7:B13 contains Row labels. The range D5:J5 contains dates. D7 to J13 contain numbers, some of which are negative. What...
  23. Replies
    2
    Views
    309

    Error Message on Startup

    Although I know this probably isn't Windows related but perhaps someone could assist and give me an idea what the following message means and what can I do about it. This just started to happen this...
  24. Changing Word 2007 to 2003 Version (Word 2007)

    I was wondering if there's any way you can change Word 2007 to be Word 2003; like WinXP could be made to 2000? Any info would be appreciated. Thanks
  25. Replies
    3
    Views
    251

    Re: Forms and Calendars (Access 2003)

    Thanks Hans for your solution. I tried it on a form with a Date field text box. However, after selecting a date (say, March 13, 2007), the last date in the box doesn't change to the this new one. ...
Results 1 to 25 of 113
Page 1 of 5 1 2 3 4