Search results for query: *

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

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?

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

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

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

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

I am having the following problem: When I tab from box to box after I lose focus on the box that I ask the user to enter the childs date of birth, a runtime error, "Error 13" occurs (a data type mismatch error). If I manually click in each box and don't tab, this problem does not...

If I have a command button that I want to bring up a form that was designed in Access, what code to I write for it. The Access database is saved on my desktop. Thank you!

The following code doesn't allow letters to be entered. Private Sub txtChildNumberInFamily_KeyPress(KeyAscii As Integer) If KeyAscii < Asc(&quot;0&quot;) Or KeyAscii > Asc(&quot;9&quot;) Then KeyAscii = 0 End Sub However the backspace character also has an ASCII code that will be ignored...

First Question: How to I figure out the date difference between two dates, for example 7/8/01 and 8/8/02? Second Question: How do I figure out a persons age based on their date of birth, and that it will constantly update itself as the date changes? Thank you!

I am having the following problem. At run-time I mask the mask edit box date format mm/dd/yy (&quot;##/##/##&quot;). However if the user enters an invalid date such as 99/88/77 then I want to clear the mask edit box. This is what I did Private Sub maskDate1stLetter_LostFocus() If Not...

I know there is an option in Access to input mask something, for example a phone number. Using the input mask the user would only be able to enter a number in the format of (###)###-####. When the user clicks on field to enter the number it looks the following (_ _ _)_ _ _ - _ _ _ _ Is this...

I am writing a program that is to be connected to a Microsoft Access Database. The user enters information on the form and that info should go into the database. When should I update all the information into the datase, when the control box loses focus, or when then user finishes with the form...