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!

  • Congratulations strongm 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: *

  1. Godofhell

    MS Access 2000/2003 Text Box Question

    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 =...
  2. Godofhell

    DID displayed on caller ID

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

    Fast Rad (no answer)

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

    CallPilot Desktop Messaging Issue

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

    callpilot -vnc

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

    Looking for information on Tab Control

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

    Query to Return All Records

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

    Getting data from a field

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

    form starts at middle of page instead of top

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

    External call forwarding and calling line id

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

    External call forwarding and calling line id

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

    Call Pilot "Report Communicator"

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

    Expansion

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

    referencing

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

    Message boxes

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

    Using combo boxes

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

    Clear Combo Box Before Opening New Form

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

    Is there a way to protect only certain columns in a table?

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

    Inserting a "Browse" button on a form

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

    Passing data from a subform to its parent form

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

Part and Inventory Search

Back
Top