Recent content by Sol

I would need to store this unique number each time as a Customer #. Do you know how I can create the 6 digit Number? The 6 digit part should be a sequential number incremented 1 one each time. Thanks!

Hi! I need to create a 10 digit Customer Number which in which the first and last 2 digits come from fields on the entry form. The 6 digit part should be a sequential number incremented 1 one each time. Do you know how to go about this? I realize the the number would have to be created on...

Besides formatting, what are the differences between mail merge via MS- Word and Reports? Also, is it possible to use MS-Word for mail merge with SQL Server backend (queries are referred to as Views) and Access front -end? Thanks much!

When reviewing/adding records in a form, the record selector is always at record 1 of n. How can I set it so when the user opens the form, they are at a blank record? Thanks! Sol

On a form I have a combo box for Member ID (not required). The user selects Member ID and if it exists, the corresponding fields are auto- filled based on a query and cann;t be modified here. Is is possible to add the functionality that if that member does not exist then a new record can be...

Hi, Is it possible to assign partial security to a form based on user ie. a use has access to select fields and not others? Thanks! Sol

How can I make a field be required only if another field is not null?

Hello. On the after update event for Customer Name, I auto-fill in Shipping & Billing Contact name. There are times when the user may go back in a just need to change the Customer Name, it will change Shipping & Billing too. Any ideas on how to do this different? Gracias!

From the navigator I'd like to open a form and auto-fill the created by & time fields. I've tryed using (in comments below) me.field name and formname.fieldname and both error out? Any suggestions... Private Sub Command45_Click() DoCmd.OpenForm "frmCustomer", , , , acFormAdd...

I'd like to have a command button on one form to open another form -How can I open a form in Add mode? Thank you!

Thanks, that did work. Do you know if there is a way to distinguish between Created By and Modified By? I need to keep track of both. Thanks!

Do you know how I can automatically fill in who a form was modified by based on a users Access login? Thanks much!

Thanks! This worked...

Is there a way to count the number of times a report is printed? Thanks much!

Is it possible to set a default size (i.e 11 X 17) for a report or is this just set during printing? Thanks! [This message has been edited by Sol (edited 07-19-2000).]