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...
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...
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...
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.