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!

Register Log in
  • Congratulations Chriss Miller 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. eelsar

    report calculation questions

    Wemeier, the idea of taking the absolute values of the sum of checkboxes was a great one. It worked. thank you
  2. eelsar

    combo box question

    To add code to the OnNotInList event sounds like it would work - could someone help me out with the code it would be very appreciated. thank you
  3. eelsar

    report calculation questions

    Thank you both for your responses - I tried both ways and it worked. I have another question, how would I get a total based on a control, for example how many children attending event based on a checkbox called children that are all checked off as yes. (this is in addition to the total...
  4. eelsar

    report calculation questions

    1. How would I put in the footer of the report the total number of records in this report? 2. I have a text box on my form that the user enters how many family members are attending a specific event. How would I put on my report - a total of everyone attending this event (a running total of...
  5. eelsar

    combo box question

    I have a combo box where I added to the "Value List" a few names of cities. How do I make it possible that when the user enters a name of a city that doesn't exist in the drop down value list of the combo box,it gets added to the list so when future users use this combo box this city...
  6. eelsar

    runtime error 94' - invalid use of null

    I have the following problem: On my subforms I assign the first name + last name (from the master form) to a text box in the form_current event of the subform. It works for the current record, however for a new record I get "runtime error 94' - invalid use of null" The database that...
  7. eelsar

    Startup - The forms should fill up the whole screen

    Thank you for your quick response - I tried it and it worked correctly.
  8. eelsar

    Startup - The forms should fill up the whole screen

    I set the Startup Option to start up with one of my forms. However, when I run the program the form (and any form that is opened up in the program) does not fill up the whole screen. I tried going into the properties of the form to see if there is an option to do this - I didn't see any. I...
  9. eelsar

    selecting multiple choices from combo box

    How do you selct multiple choices from a combo box?
  10. eelsar

    I'm confused w/ code - please help - not sure how to describe problem

    Thank you! It now works!
  11. eelsar

    I'm confused w/ code - please help - not sure how to describe problem

    I created a master table with ID(autonumber)as a primary key. Then I made a few tables with ID as their primary key, and it's a foreign key to the master table. In the relationship window I connected the relationship (it's a one to one relationship) I then created a masterform for the master...
  12. eelsar

    Compacrting and Reparing Database on a Network

    Is it possible to compact and repair on close for a database over a network?
  13. eelsar

    Sorting Dates in Access

    I know that one can sort Ascending or Descending however when sorting dates (by selecting Ascending or Descending) in the standard format dd/mm/yy - it gets sorted by year automatically. How can I sort it by month, and within month by day and in order of year. Thank you!
  14. eelsar

    SQL Question #2

    When writing to a database, what SQL keyword do I use after opening the recordset. I tried to do the following and it's not working, can anyone help? Private Sub cmdSave_Click() Dim rst As New ADODB.Recordset rst.Open "INSERT INTO * PersonInfo", cnn rst.AddNew...
  15. eelsar

    SQL question #1

    How do I do the following; I have a form where a user selects from a combo box an Item name. However the item name is not from the table that's connected to the form. Instead it's ID# ( as a Foreign key) is connected to the form. But I want the program to read in the Item Name into the combo...
  16. eelsar

    How to FIND or SEEK in a database?

    Please Help! I'm not sure how to find the records for a specific name selected from a combo box? When I added the names to the combo box I added their primary key as an Index - so when I find it I should search for it by the index that is unique. Does anyone know some code for how to do this...
  17. eelsar

    Input Mask in VB 6

    Use the maskEdit control For a phone# for example Private Sub maskCaller_GotFocus() maskCaller.Mask = "(###) ###-####" End Sub This will force the user to enter it in the format of (123)456 - 7890 If you will be reading in from a database you will notice that the mask...
  18. eelsar

    Why does it disappear

    I have a maskEdBox for phone numbers. When I read in information form the database it reads in correctly and appears as (123)456 - 7890 , like it should. However when I would tab around from box to box on the form the phone number would disappear and in its place would be (___) ___-____. To...
  19. eelsar

    How add items to combo box from Access DB

    How do I add items from an Access DB field to a combo box in visual basic?
  20. eelsar

    I'm not sure what this problem is? It occurs when lose Focus

    I tried your code addition and it worked. Thank you!

Part and Inventory Search

Back
Top