Search results for query: *

You could create a recordset in where you retrieve the records from the table that match the value on your text box, then count the recordset and add the value to the txtEquimCount. myRecordset = Connection.Execute("Select IDField from tbl-EquipmentData Where Fieldtolookfor =...

We had this issue come up and discovered that Verizon had stopped sending our Caller ID. Verizon was capturing our caller ID and changing it to the main billing number. We had to submit a written request to have them remove the restriction since they claimed it was a goverment requirement that...

If you are getting a handshake and the connection fails, then the problem is the modem initialization string. Try using a different string, drop down the baud rate. Here are some strings you can try. Modem does not respond to Remote Tools (but does to other communication programs). - The COM...

HERE IS THE FIX: Update your Microsoft Office Software. This problem only appears in Microsoft Outlook XP 2002, performing the office updates by going to http://microsoft.com/officeupdate and grabbing all the available updates, resolves the problem. We run accross this issue and the fix has...

We use VNC on Callpilot, OTM, and web messaging server and no issues.

If you are running forms on the tab control, then you can requery the data to match only the record that you are currently working with.

Simple type Select * from your Table when constructing the SQL statement

Pass the values on to a variable in the Click Event for the form: Dim myText as String Dim myCombo as String Sub myButton on_click() myCombo = CardType.value myText = CardNo.value End Sub Then when constructing the SQL statement use myText and myCombo as the values for the query.

Have you checked to see if you have a hidden control on the form that is set to be the 1st control selected when the form open. Try changing the tab stop sequence.

The problem we started seeing after the upgrade is as follows: Call comes in through a PRI to a DID phone that is forwarded to a cell phone and using a PRI to forward the call. Before Upgrade: The cell phone would see the Caller ID of the parted that called the DID of the forwarded phone. After...

Did anyone find a solution to this problem? I am having the same problem after upgrading to 25.40B

That same process will work for Windows 2K and XP. Type msconfig in the Run box and go to Startup and remove the check from the Communicator, reboot, and click on the do not show message again after you boot and you are set.

SilverBean, I created a small database with what you are trying to do, unfortunately I can not find a way to attach it. If you want to get it let me know. The idea is to set the criteria of the details used to work with igther the combo box value or the list box value. I set my list box so that...

syntax should be Forms!a!b.Recordsource Forms!MasterForm!SubForm.Recordsource

You might want to enhance your code by giving the control that was empty back the focus. I also noticed that you where using unnecessary (IsNull(Company)), the line can be writen as shown below since the syntax for the IsNull is IsNull(Expression to be checked) and the If Then statement does not...

Are you pulling the Information for the Room Combobox from the Classes Table? My feeling is that you are and since the Room can be assigned to multiple classes you are getting the same room number 2 times. Your tables should look like this: tblClasses ClassID =Autonumber RoomID = Number (with...

You could type code on the on_click event of the Add New Record button. Simple enter comboxname.value = "" Docmd.OpenForm "Name of the form you want to open" Note: You will still get the popup box reporting the text entered was not in the list. Where comboboxname = the actual name of your...

Why are you letting users enter data directly on to the tables. This is a very bad design flaw.

Chris1603, the following will give you exactly what you need. I tested the code on a test access 2000 database and it worked great. 1. Open Your database 2. Add a command button to Your form. Set both the Name property and the Caption property to "Command1." or any name you want for the button...

You can also use any of the following 3 lines of code, replace the names accordingly. This code passes a value stored in the sub form field PhoneNumber to the Master form field named txtTest, the Master form is named frmMaster, the sub form is named frmSub. Forms!frmMaster!txtTest =...