Search results for query: *

I have a button set up on the bottom of my database with the following code to send the form frmSIR via email. Private Sub Command64_Click() On Error GoTo Err_Command64_Click Dim stDocName As String stDocName = "frmSIR" DoCmd.SendObject acForm, stDocName...

Hello all, I am done with my Security Incident Report database except for one thing. I need it to auto generate a case number for each file as they are entered in. The format for the number needs to be NM1234. The two text characters will be dependant upon which location they choose from a drop...

I have my Security Incident Report database completed, but I have a small problem. I designed this in access 2000. My manager wants it in access 97. The problem is a small one. In the form that the security officer will use to enter in records, there is a combo box to enter the post. When they...

I am creating a Security Incident Report database in Access2000. I have been working on this database for approximately two weeks now and I finally have all the bugs worked out of the forms and tables and relationships, they all work great now. My problem now is that incident reports can have...

I would like to thank those of you who helped me on my Incident Report Database. I may still finish the project, however, I just sent an email to my manager letting him know that Access cannot handle the large scale application to which he wishes to apply this database. If he wants me to...

OK, I am still working on my Security Incident Report database. In my form frmSIR I have a text field called [Parties Involved:]. This text field is bound to tblTable1. What I need is after the user Types in a party involved in the Incident, the database needs to prompt them and ask if there are...

I am creating a Security Incident Report database (similar to a police report) I have a combo Box in Table1 and under the field [Report Subject:] I have a combo box. My goal is to get the combo box to display the list of subjects in the table [ReportSubjects] as well as add any new data to the...

I have a Security Incident Report database I am working on. The Posts table has the Name of each Security Post, Address, State, Postal Code, and Country. The Name field is the PrimaryKey The rest of my info is stored in Table1 On my form I have my [Post:] field accessing the table named...

My next task in working with my database is to Set up a drop down Combo box which I have already done with its source type being a value list. What my manager wants is when I pick a job site from the drop down box, he wants the address to automatically populate the address field. I have no clue...

I have created a database in Access 2000 for filing security incident reports. My manager wants me to have some of the fields be drop down combo boxes, ones that any new data that is entered, if the new data is not on the list it will automatically be added to the drop down list. I have tried...