I have some code that sends email for ACCESS using Winsock.  All was well
until it switched to a new mailserver that requires a userid and password to
send the mail. I can't figure out how in the code that sets up winsock to
supply the username and password.

I expect this is a very simple question, but I am new to writing VB code.
I currently have a button on a form that runs a delete query that deletes
all the records in a table (tblStudents) where the primary key is StudentID.
I would like to make a SQL statement in a VBA module to ...

I want to use a single date obtained from the user on each record in a
current data entry session.  The date is captured in a dialog box linked to a
one field table.
I have placed code in the data entry form's ON LOAD event to assign the

Hi all, i got a problem which i hope you guys will help me on. I created
several forms, the main form with command buttons that leads to other forms
where users can key in their conditions for queries, i.e. parameter forms
After building the SQL string using createquerydefs

I have a custom menubar and with the following code I can refer to the 3rd
menuitem :
  Set v = CommandBars("mainmenu").Controls(3)
So far so good.

Hi all i'm just having a little trouble.
What I have is a search form called [Searchfrm] with critera on it,
tick boxs and stuff. On this form I have a subform called {subsearch]
the feilds in this table are linked to a query. Down the bottom of the

I have an ActiveX Calendar control I use to set dates. I am now calling this
control from more than one form and have it transferring the graphically
selected dates back to text controls on the calling form. I have tried:
Forms.Parent.[DateIN] = Me.startdate

Can someone please explain the difference between:
Forms!<TableName>!<FieldName>.value
and
Forms!<TableName>!<FieldName>.text

in the past days, John show me how to run a shell command from VB, now what
im triying to accomplish this:
- Run a shell script
- Run a SQL query, store the result in a variable called "k"

I have multiple forms with several data input controls that default to zeros.
Calculations are made from these controls and if the zero is deleted the
results error out.  In the past I have added to following afterupdate code to
each control to prevent the error.

I have used the following  code for a frm where a field must be completed by
the user.  However the user clicks ok when the message box appears and it
closes the frm, they then have to open it again and reinput full form again.  
Any way I can get it to just close the message box ...

I have a form frmPatientSelection with a command button cmdFindPatient, that
opens another form frmPatientEntry using the following code:
   Dim TempFilter As String
   TempFilter = "[MedicalRecordNum]=" & "'" & Me![txtMedicalRecordNum] &

I am trying to Filter data to a Master Form based on criteria contained in a
Sub Form. At present, there is an unbound Combo Box on the Master that Lists
the values found in the Field on the Sub Form.  I want to make a selection
using the Combo Box, and filter the Master Records ...

I have referred to the website http://www.mvps.org/access/forms/frm0028.htm 
in order to limit the content of Combo box  “Product” after selecting the
content of Combo box “Supplier”.  Both the field “supplier” and “ product”
are included in a table named “Supplier”

I have created a code to autofill a form once a combo box has been selected.  
In the combo box I have the column cout set to 12 for all the field types.  I
have also set the default value of the combo box to "".  I have all the
autofill fields set as unbound.  I have the combo ...