is there a good way to create an edit mask ala MM/YYYY for a text box?
tia,
mcnewsxp

I have a tempory table to which a lit of part number are pasted from Excel.
I need to validate these numbers for being Known or New parts
I have the following code that finds "New" part numbers and inserts them in
the "tblnewparts" table - this works fine.

Thanks in advance.
I'm looking for form code that will generate new, unique customer numbers
when a new record is added, and replace the CustNo field with the new number.
The function or procedure would need to find the largest existing customer

I have populated a list box from a query and have two buttons with code to
sort either by LastName or MembershipNumber. It works fine on my PC where I
developed it. A membership Number would typically be XX_001 or YYY_002 and I
want it to sort on the numerical value

I am using Stephan’s latest code to extract OLE field (containing Photos) to
disk. In the function ‘fGetContentsStream’ in module ‘modGetContentsStream’,
the code returns false if it finds out the ole is a linked object. In the
same module, there is another function ‘fInventory’, ...

 My situation:  IE:  My form is comprised of a cmd button grid, A1 thru D10.
When you click on cmdButton A1, it populates a cell ([txtGrid]) on the form
with the value "A1".  I have a standalone query  ([qryCellProduct]) that
bases it's filter off of the contents of  [txtGrid], ...

I have a for that has a command button which runs an update query. When the
query is finished I want a message box to say "Update complete" and on
clicking the OK button I want the for to close. I have added this to the end
of my code but am not sure if this will appear before ...

I have a problem with creating a form from tables involving a junction
table. What I learned from this group is: Create a form based on one
one-table and a subform based one many-table, and have the combobox in
the subform be based on query on the-other one-table.

I have copied some code from the Northwind sample database and amended it to
suit, but the code won't work for Case 3.  Can anyone help?
Sub PrintReports(PrintMode As Integer)
On Error GoTo Err_Preview_Click

I wright macro1 for "After Update" event for a text box [or combo box]. When
I am finished changing the value for the box, macro1 runs. But if instead of
me another macro changes the value of the text box, macro1 does not run after
update. How should I do this so no matter what ...

I have read numerous threads on this subject but nothing has worked for me
yet.  I am using Access 2003.
My current code for the combo box named ProgramFilter is:
Private Sub ProgramFilter_AfterUpdate()

I have one table " Invoice register" where i enter all inv details .(one
record for each invoice)
also in this table , there are fields for draft details.
after issue draft i have to enter number , date etc. for each record in the

I have a combo box on my form populated with records from a table.  I would
like another field on the form to populate with data from the same table but
a different column.  I am new to access and having trouble with this problem.
Thank you for any help you can provide.

I am attempting to put in place a message box that loads when conditions are
not met between two fields. If the conditions do not match I would like the
current form the user is on to refresh, upon clicking a button from a msgbox.
Thus far my code is as follows...please be patient ...

I have a form with one listbox on it.  This form is populated from a table
that contains one field.   The user can pick one or more company IDs from
that table, hit continue, and then data is pulled from another table based on
that company ID, and transferred to an Excel ...