Recent content by eelsar

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

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

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

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

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

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

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

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

How do you selct multiple choices from a combo box?

Thank you! It now works!

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

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

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!

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

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