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: EBee
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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
  6. 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...
  7. 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
  8. 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
  9. EBee

    syntac error Help

    ERROR: Server: Msg 170, Level 15, State 1, Line 19 Line 19: Incorrect syntax near '@TableName'. --======================================================= BEGIN DECLARE @LastFullUpdate datetime ,@LastIncrementalUpdate datetime ,@LastUpdatedDt datetime...
  10. EBee

    openquery - linked database

    the code below works but I have about 20 tables I wanted to update in the UpdTables. I am hoping to just past variables to the openquery and grab the information. However, this errors out when I replace it to SELECT @BeeDirectCountTransactions = Count(*) FROM OPENQUERY(sbdatabase1,'select...
  11. EBee

    primary key violation-- need to insert new record error

    I am trying to insert records in the RateIncrease table for all subscriptionid. I need to insert the subscriptionid only one time. my source table (Transactions) have many transactions for one subscriptionID. I only need to grab the first payment after 7/31/05, and insert it into the...
  12. EBee

    How to check compiler

    How can I verify the type of c++ compiler is installed in our SunOs 5.8. Our vendor wanted us to purchase new C++ compiler since they said that SunMicrosystems discontinued Sun Studio One 8 compiler. Sun now provides Sun Studio 9 or 10 which is compatible with Solaris 8,9, or 10. . I need...
  13. EBee

    How to open another Access database form

    How do you open another MS Access database form from your current form. And, using a button on the current form. I tried the button wizard and it only opens .exe files. Thank you.
  14. EBee

    Report file name change help

    I am printing the Access reports to a pdf printer and wanted to change the default report file name that appears when the user is prompted to save the pdf. Currently, the user must append a date and time to the file. I would like to automate this process so the user don't have to type any...
  15. EBee

    delete table > 30 days

    I am trying to find out how I can drop these tables in VBA that are 30 days old. But with a specific table name +dates+time. ex. tblAllAddresses_05052005_152010 tblAllAddresses_04052005_182010 I have this code that renames tables and appends datatime to it. DoCmd.Rename...
  16. EBee

    listbox to tab over items

    I am trying to populate a listbox and I can not figure out how to tab the items over 1 325.00 54.00 2 326.00 84.00 . . . and I need to 1 325.0 54.00 2 326.00 84.00 Dim decLoanAmount As Decimal Dim intYears As Integer Dim decInterestRate As Decimal Dim...
  17. EBee

    ASP.NET and Crystal Rport as webservice error

    I am trying to link a Crystal Report on a ASP.NET page using VS.NET CR v9. However, I am getting this error when I view it in the browser. CrystalReportViewer error %@ Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral...
  18. EBee

    delete table after certain number of days

    How can I delete the table after a certain days or >= to the certain date. Thank you Private Sub cmdImportData_Click() Dim Response As Integer Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection Response = MsgBox("Are you sure you...
  19. EBee

    Module RandomID lock error VBA

    When I run this program for 12k records it gave me an error of something like "lock optimistic max. . . ". Then when I looked at the table records. . it populated about 9k records with randomID and nothing on the rest. When I tried to run it again it gave me an error " Current Recordset does...
  20. EBee

    DoCmd.TransferDatabase, acImport

    Is there an issue using the command below? It's giving me an error " The Microsoft Jet engine could not find object tblAllAddress. . ." the code is in a MS Access 2000 while the PaidPlus.mdb is a MS Access 97. Could this be a reason? DoCmd.TransferDatabase acImport, "Microsoft Access", _...

Part and Inventory Search

Back
Top