Search results

What happens to complaints that do not have some basis for investigation & thus do not become cases? Do you still record the complaint and if so where (what table)? Can more than one case result from 1 complaint?

In the attached database, I took your Extreme Use Data-Update Sent query and copied it to a new query and changed it to an update query. The query name for that new query is qryUpdate. I changed the name of your Extreme Use Data-Update Sent query to Extreme Use Data-Update Sent PREVIEW. If...

It would be best to set up your relationships first, then Access will automatically link the subform to the main form. In the structure I presented earlier, the primary key (pk...) will join to the similarly named foreign key (fk...) field i.e. pkPeopleID-->fkPeopleID Just to clarify, your...

You are describing a many-to-many relationship which requires 3 tables. The third table you need is a junction table. tblProjects -pkProjectID primary key, autonumber -txtProjectName other fields pertinent to the project tblPeople -pkPeopleID primary key,autonumber -txtFirstName -txtLastName...

Is the data type of the product description field a memo data type? If so, you may want to check out Allen Browne's site. If it is not a memo data type, your database may be corrupted. You can try to fix it using the compact & repair utility within Access.

Could you post a copy of the database with any sensitive data removed/altered so that we can take a look?

Are you getting any error messages when you run the update query? Sometimes, an action query will not run because the recordset is not updateable. This can happen if you have certain join types in the query. Here is a site that goes into details. Another way is to identify the primary key of...

Let us know how it works out.

magster06, What you described should be handled with the structure I presented in my earlier post and which jdraw confirmed in his post. You should have a table of events (or statuses) and relate the particular events to the case via the junction table. To illustrate, I have attached a sample...

Dim (dimension) is the VBA statement used to define a variable: its name and datatype. You can put in anywhere in the code prior to when you use the variable. I generally put it at the beginning of the code. That is correct. I generally use variables so I do not have to repeat the...

You're welcome & thanks for giving me the opportunity to learn about the Eval() function and its capabilities.

My apologies, I overlooked the age operator part. I thought that you could not pass an operator as a query parameter and that part was true, but I see that the Eval() function can be used to construct the entire expression and do the subsequent evaluation of that expression. I learned...

Since you left the login form open, you can reference the user combo box when you open frmHome, assuming that the user combo box's bound field holds the name you want to show on frmHome. See red text in the code below Private Sub Login_Click() 'define a variable to hold the looked up password...

Since you can only pass values to the query and not operators (=, <,>,LIKE, >= etc.), you have to use a different approach than what you have been using. You will have to build the query within code (i.e. the SQL text). Once constructed you can assign the SQL text to the record source property...

Please post back with any questions.

But the field names in your PSU table indicate that certain basic events are the same for all cases. Perhaps it would be better for you to explain the purpose of each field in your PSU table? The event table is just a table to hold generic events that have nothing to do with any particular...

You're welcome. Glad to hear that you have worked out a solution.

You have 4 tables (tblCivilianWitnesses, tblFocus, tblComplaintInfo, and tblCFDWitness) that all have similar name fields (first name, last name etc.). Why not have 1 table for information pertaining to people. From the looks of it, you have many people associated with a case (one-to-many...

I meant to separate the unique IDs with commas in the variable holding the IDs. Using your earlier data with an additional record: pkRecordID|FieldA|FieldB 1|Great big whale|Small white fish 2|The weather is great|Toby Dick is a Whale 3|Great Scott|fish Let's say you did a simple search for...

You're welcome.