Search results

  1. S

    Option Buttons and Combo Boxes

    I have a Data collection program that has option group with 2 buttons. Say, Retail and Wholesale. When I choose Retail option than the combo box should populate from tblRetail by using the drop down menu. Once the selection is made from the tblRetail and other fields are entered Save button...
  2. S

    Date and Time Picker

    I am looking for Date and Time Picker for Access 97. Is there a posting somewhere I could find it? Would appreciate. Thanks.
  3. S

    ActiveX Error

    I'm working with Access 97 on a windows XP environment and I have a simple create database connection snippet that is giving me the following Error: "Run Time Error 429" ActiveX component can't create object. This is failing on the the line reading: Set Brent = OpenDatabase("c:\abc.mdb") Dim...
  4. S

    Calculations for lbs. and ozs.

    I have a Form where these calculations are done for additive to be added to the product. User enters the name, weight of the product and at the Click of the Calculate Button calculations are done. I have been using the following code: Dim lbs As Double Dim ozs As Integer lbs =...
  5. S

    Error while Updating the Table

    I have a Form that I use to enter the data into the Table. I have the code posted below. When I click Add Record some text Fields change to "False", others change to "0" and date fields end up changing the dates to 1899, etc. I cannot update the table. I am stumped ! Need all the help I can get...
  6. S

    System generated Message Boxes on Update

    I have this Database program I am working with. The program works fine but when I click Add Record button it INSERTS the data into the Table. Howerver, before it appends it displays this Message Boxes warning that you are about to append a row, etc. Is there any way to control these system...
  7. S

    Search a Record in the text box

    I have a Database where Item Name is stored in a table. Item Name could have 1 or more Items. How would I go about doing a search of the Record to locate any of these Items ? Appreciate any help. :confused:
  8. S

    Upper Case for first letter

    When data is entered in a text box and Add Record button updates Table how do I make the first letter to show in Upper Case ? Thanks :confused:
  9. S

    Error in Append Query

    I am having trouble with this QA Tracking Program I am try to get it going. When data entry form is filled correctly - all fields entered - by the user and Add Record button is clicked I am getting the error message as follows: Microsoft Access can't Append all the records in the Append Query...
  10. S

    Problem with Append Query

    I have trouble with this Tracking Program I am trying to get it going. When all the fields are entered correctly in the Data Entry Form and I try to Add Record to the table some fields convert to False and the record date and due date change to 12/31/99 in the table. It does not correctly add...
  11. S

    Access 97 and Windows XP

    I use Access 97 on Windows NT 4.0 platform at work and I use Access 97 on Windows 98 platform at home. VBA Development at home and work have had no problems. Both ways it works fine. My question is that if I upgrade my system at home to Windows XP platform and use Access 97 will there be any...
  12. S

    Date Difference

    I have a form where there are several dates entered by user. Record date is entered by the user. How do I add 30 days to that date in the next txt Box. Thanks.
Back
Top Bottom