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 derfloh 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: EBee
  • Order by date
  1. EBee

    disable mouse roll on form

    thank you very much. the modMouseHook module is great. . worked like a charm. cool. . Thank you. . you gotta love Tek-tips. . great talented people
  2. EBee

    disable mouse roll on form

    I have a form and with New record button next record button previous records button SAVE button. . . . etc How can I disable the mouse wheel so it won't move to the next or previous record? Thank you EBEE
  3. EBee

    continious form with checkboxes

    thank you both . . . the users just have to deal with that i guess. . . moving on to the next feature. .
  4. EBee

    continious form with checkboxes

    I am trying to disable some fo the checkboxes on a form that is attached to a query. The form is a continious form with 2 checkboxes and a label next to each checkboxes Private Sub Form_Load() If Me.SubZip.Value = "Mariposa" Then Me.chkMail.Enabled = True Else Me.chkMail.Enabled = False...
  5. EBee

    Label on form

    I got it to work now. . thank you Since this is a checkbox and I wanted to change the forcolor when checked and put it back the way it is when unchecked. How do you toggle back and fort depending if cheked or not Here is what i have so far Dim db As ADODB.Connection Dim rs As New...
  6. EBee

    Label on form

    Dim db As ADODB.Connection Dim rs As New Recordset Dim strLblName As String Set db = CurrentProject.Connection rs.Open "qryZipSelected", db, adOpenKeyset, adOpenDynamic Do While Not rs.EOF strLblName = rs.Fields("Forms!frmPreprintorder!lbl93611C") 'labels names...
  7. EBee

    Label on form

    I have about 72 labels on a main form . . like below I have a query that will contain this label records. I wanted to change the color and do special effect(Raised) when the label name is one of the records in the query. 96311 63614N 63615 635463 26346 12512 26325W 63621 262213 25366 96311...
  8. EBee

    form reference to another form

    frmPreprintorder.txtQuantity.Text = txtGrandSubZipDraw I have textbox in a subform that I want the numeric value display into another form the code above is in the click eventprocedure of the checkbox. However, it is giving an error of object error. what is the proper syntax to...
  9. EBee

    select all button to check all checkbox

    Thank you for your response. . I end up creating an update query, then, added this code with the refresh at the end for dynamic form update. Private Sub cmdSelectALLMail_Click() DoCmd.SetWarnings False DoCmd.OpenQuery "qrySelectAllMailLocalSub", acViewNormal DoCmd.DoMenuItem...
  10. EBee

    select all button to check all checkbox

    I have a continues form that have checkboxes that is attached to a qry. I need to create a button to check all the checkboxes. Since the checkboxes are not bounded, I have not idea how to code it. Any help or direction is greatly appreciated ET
  11. EBee

    Linked server script

    select * from openquery(sacdev,'Select * from pub.occupant') where lastname ='Smith' select * from sacdev_cmaddress..pub.occupant where lastname = 'Smith' Thank you for your response. . is there a big difference between this two. Is one more efficient that the other. And does it get...
  12. EBee

    Linked server script

    I tried to see if there is a good website or book that tells me more about linked server scripting. I am able to create a linked server from SQL 2k to a Progress database. Now, I am trying to create stored procedure, views. . etc. to to view data out of the linked server. I don't see much...
  13. EBee

    snpp module help

    How can I send page using snpp input file has the following pager # message date/time ..etc and use snpp in our sun solaris box. We page carriers for customer information and want to use snpp protocol. we need to read a file for paging and have it automated as the input file comes in.
    • EBee
    • Thread
    • Replies: 1
    • Forum: Perl
  14. EBee

    syntac error Help

    it works now. . great !!! thank you very much
  15. EBee

    another mail client for sun

    SNPP is it more reliable than mailx client for Sun Solaris. we are looking for a better paging service from a Sun box. any suggestions out there. Please
  16. EBee

    syntac error Help

    I got this error: Server: Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'Carriers'. [OLE/DB provider returned message: Deferred prepare could not be completed.]...
  17. EBee

    syntac error Help

    The problem I have is that, the variable @TableName is not allowed in a linked server. the localserver database works just fine, Howerver, The link sever will not accept a variable. I has to be a straight SQL string.
  18. EBee

    syntac error Help

    this is ugly. . but this is what I have. . working. Create Procedure UpdateRecordCountOnUpdTables AS DECLARE @BeeDirectCountTransactions int , @BeeDirectCountRoutes int , @BeeDirectCountCarriers int , @BeeDirectCountSubscriptions int , @BeeDirectCountAddresses int ...
  19. EBee

    syntac error Help

    ERROR: Server: Msg 170, Level 15, State 1, Line 22 Line 22: Incorrect syntax near '+'. ========================================================== BEGIN DECLARE @RecordCount1 bigint ,@RecordCount2 bigint ,@sqlRecordcount nvarchar(200) ,@sqlCreatedDt...
  20. EBee

    syntac error Help

    I need a count on a linked database. . I just noticed that we have been working on assuming that it is native to the current database. However the code below does not work because OPENQUERY does not allow passing variable. . . any thoughts --It has to be something like this: SELECT...

Part and Inventory Search

Back
Top