Search results for query: *

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

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

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

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.

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

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

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

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

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

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.

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

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

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

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

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

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

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", _...