Search results for query: *

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

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

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

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...

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...

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...

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...

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...

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...

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

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...

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...

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.

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

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

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.]...

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.

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 ...

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...

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...