Search results

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!

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

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

Hi! Is there a way to prevent users from entering in new records when a form is open in Edit Mode? Thanks!!

Can records be sorted so that the last record entered comes up first in the edit mode. Thanks

Is there a way from preventing user to launch the db window(F11)? I'd like for all functions to be performed by using the Navigator provided? Gracias!

Can a LogiTech- scroll (mbb48) mouse be used to scroll through records in a combo box? [This message has been edited by Sol (edited 06-22-2000).]

Hello! I have 3 combobox fields and a memo field on a form. In the memo field, I need to concatenate Fields 1-3 and allow for the user to modify and add to what appears in the memo field. I set the control source of the memo field to =[Bank]+" "+[TitleCompany]+" "+[Attorneys] but I am unable...

How can i hide fields in ADD mode and only show them if the form is open in EDIT mode? Certain fields I have are only relevant in EDIT mode. Thanks A ton!

How can I use the values of one control (radio button) to determine the values displayed in a ComboBox? For Example, I have a radio button for Type of Server(NT or Novell. When Novell is selected, I'd like only to display Novell Servers in the combo box? Thanks. [This message has been...

I have a main form with a subform. When I set the tab order from Main form to Subform, it adds a new record to the subform even though the Navigator and Record set button are hidden? How can I prevent this? I only want the user to enter one record into the subform. Thanks!