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!

  • Congratulations gkittelson 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: *

  1. GolferJohn

    how to disable auto bulleting.

    Editing a list of items in word 2000 document, I regularly like to do a).... b).... etc, but am using a 3 column layout. after a).... <return> word automatically starts a buleted sequence with pre-set indents which are wrong for my column. How can I diable this auto-bulleting feature to allow...
  2. GolferJohn

    LCD backlight is on, but no characters

    I wonder how likely it would be for both inverter boards (the one on my original LCD, and the one on the 'guaranteed not DOA' panel I purchased on E-Bay) to be bad. The original was working until I fried the MOBO. Would a bad BIOS flash be likely to kill the inverter board? The panel I bought...
  3. GolferJohn

    LCD backlight is on, but no characters

    yes tried that. thanks, John
  4. GolferJohn

    LCD backlight is on, but no characters

    Thanks, I actually had'nt thought of that, but no joy! John
  5. GolferJohn

    LCD backlight is on, but no characters

    Hi. This is with my latitude LM P133 The problem started when I fried the motherboard flashing BIOS A06 (from A11). I got a new MOBO (actually two) and now the system boots up normally, but the LCD shows no characters, however the backlight is on.(It seems a little dim, but I do not know how...
  6. GolferJohn

    Outlook 2000 - moving personal folders

    Thanks for your help. I have been able to take your suggestions and play with it for some time, and was finally able to achieve it! Thanks. John
  7. GolferJohn

    Outlook 2000 - moving personal folders

    Hi. This should be a simple thing, but ?? I have partitioned my HD and would like to store my personal folder on drive D: I found MS knowledge base article 257836 - How to move your personal folders, and tried to follow the steps, however when I try to copy c:\windows\application...
  8. GolferJohn

    query fails on combobox update

    Thanks John
  9. GolferJohn

    query fails on combobox update

    Hi Paul, Yes I have solved my problem and all works well. In this instance however I did not use a command button, rather as xlbo suggested, I used the 'after update' property (found on the event tab) of my combo box. Double clicking to the right of the entry area of the 'after update' event...
  10. GolferJohn

    Access 2000 EOF problem - simple problem, simpler programmer!

    Sorry - momentarily brain dead there, now got it working with If Not (Me.NewRecord) Then 'If then statements' End If Thanks, John
  11. GolferJohn

    Access 2000 EOF problem - simple problem, simpler programmer!

    Hi. Thanks for the suggestion. I'm Sorry, I guess I misled you. My code above correctly calculates the share balance & populates the unbound 'ShareBal' textbox. The problem is preventing the If Then Else statements from populating the two bound textboxes, thereby initiating a new record (with a...
  12. GolferJohn

    Access 2000 EOF problem - simple problem, simpler programmer!

    This must be a simple problem, but is driving me mad!! (I am a newbie, as you can guess). I have a form 'Stocks' with an unbound textbox 'ShareBal' and two bound textboxes 'IOwn' and 'OpenOrder', filled by the following code which calculates values from my transactions in the 1 to many child...
  13. GolferJohn

    Errors with DSum(fieldname,tablename) - should be simple right??

    Hi - OK I played around and I found that I need to enclose the arguments in brackets as: Text111 = DSum(&quot;[ratio]&quot;, &quot;[rollbacks]&quot;) Sorry to bother all you busy people. John
  14. GolferJohn

    Errors with DSum(fieldname,tablename) - should be simple right??

    This should be a very simple problem, yet it eludes this simple newbie. I have in my main table a numeric field 'ratio' and an unbound textbox 'Text111' on my form. I entered the following code: Private Sub Form_Current() Text111 = (ratio) End Sub and lo and behold! the same value in...
  15. GolferJohn

    query fails on combobox update

    Thanks, I guess I'll have to do a little study. John
  16. GolferJohn

    query fails on combobox update

    Hi. Thanks for your suggestion. From your reference to variables, it sounds like you are suggesting I need to accomplish this using VBA scripting. Is it not possible to do it any other way? Should I do the script in a button? I have done a little programming in Delphi, but no VB. John
  17. GolferJohn

    query fails on combobox update

    Hello all wiser than I. I am getting closer to my goal. Perhaps you can advance me further. In access 2000, I have constructed a query that will use the value selected in a combo box on my form as criteria, and will return the correct record the first time I open my database, but when I change...
  18. GolferJohn

    Access - how to use combobox value in a query

    Just dropped a couple of new text boxes on my form and typed in '31/12/96' and '01/04/00' then changed my criteria in design view to Between [Forms]![Rollbacks].[text133] And [Forms]![Rollbacks].[text135] (double checked textbox names) and still get no records returned (well, actually one blank...
  19. GolferJohn

    Access - how to use combobox value in a query

    Arghh! Now something else strange is happening! I continued to play around changing dates etc & got an error message 'Error 3088' Too many expressions in ORDER BY clause' I opened my query and saw 30 or more columns with the field 'date' selected, most with 'decending' selected, but some with...
  20. GolferJohn

    Access - how to use combobox value in a query

    Hi, Thanks for the reply, some progress, yet still some problems. (I know so little) My form is 'Rollbacks' and I have unbound combo boxes named 'Before' and 'After' and a button 'Apply'. In the CB's Row Source Type, I have 'Value list' and in Row Source I have dates like...

Part and Inventory Search

Back
Top