Search results

Can you upload a copy of the database?

Hi You do not need Vacancy_tbl_1 or Candidate_tbl_1

1 way would be to have a Form for New records. A search form that lists all existing record. Then a Click event on a specific record to allow edits.

You can Export the data to a Word RTF file

Can you upload a copy of the database?

Private Sub cmdPrintReceipt_Click() Dim response As VbMsgBoxResult response = MsgBox("Print Customer Receipt?", vbYesNo + vbDefaultButton2) If response = vbYes Then DoCmd.OpenReport "rptPrintCustomerReceipt", , , "[ContractNo] = " & Me.ContractNo End If End Sub

Hi Can you upload a copy of the Db?

Hi John Upload what you have so far and we can give you further guidance.

Ok No problem. I would recommend not using split forms are they are very limited.

Hi I could not replicate your problem. I created a new Form named "Delovodnik" and applied conditional Formatting. See attached.

Hi You have just sent a shortcut to the database. I need the actual database in zipped format

Can you upload a zipped copy of the database?

Hi Karim Your tables have some design issues. You should not use Lookup Fields in table. Check Google for "The Evils of Lookup fields in Access Tables" You have not set referential integrity between tables. You should not set the Format of your Autonumbers to 000 You should not set the record...

It might be a better option to explain your more complex case.

Can you upload a copy of your database?

The attached is another way of doing it.

Can you upload a copy of the Db?

Hi See the modified Order Form in the attached. Now when you create a New Order and add multiple items you can then Click the Command Button "Preview order"

Well you learn something everyday.

Hi Ken Please ignore my ignorance but I was always under the impression that if you have a ProductID as the PK Long Integer Autonumber you would not be able to have a 0 value