Search results

Hi All, I am using the following code (thanks ICEZEBRA) to spell check certain fields upon exit. Private Sub YOURFIELDNAME_Exit(Cancel As Integer) Dim strSpell strSpell = YOURFIELDNAME If IsNull(Len(strSpell)) Or Len(strSpell) = 0 Then Exit Sub End If With...

Okay...I was afraid of that. You are correct, the tables are separate. The Main table contains case information (dates, locations, type of case, etc). The personnel table allows the user to assign any number of people to the case and has a Name field and a function field (investigator...

my bad.... tblIntakeMain is the main table. tblIncidentDetails and tblPersonnel have a one to many relationship to the tblIntakeMain using the fields I listed. Thanks.

I have spent the last couple of days trying to figure out how to make this work. I have three tables. tblIntakeMain [IntakeMainID] tblIncidentDetails [IncidentdeatailsID] tblPersonnel [PersonnelID] On the main form I use subforms to link tblIncidentDetails and tblPersonnel to...

SQL and I are only lukewarm friends at best. Not sure about a passthrough query. I thought about building the SQL query dynamically, but could not get it to work. Any help you could offer me would be appreciated more than you could know.

I cannot say what is in the database. However, all of the fields are text (even the dates and other numbers!!) which causes problems. The size also causes problems. If you run too broad of a search it will take it two and half years to run. I did read in this forum somewhere that you are...

Grrrr....I forgot to mention that the back end is SQL(my bad). As such, when I tried your suggestion it gives me a OBDC failure error. I am not sure why. Any more thoughts? This is driving me crazy....

Thanks! You Rule!!! Thanks. I knew someone had come across this problem and found a solution. Thanks again.

I have a form called "Search" on which there are a number of unbound text field. The idea is this: the user types in information on a subject (like first name, last name, Date of Birth etc) and then hits search. The form calls a query named qMasterSearch. The search results are displayed in...

I am working on a timesheet database. By date, you can select an employee and the shift that the employee will work. Shifts are defined by a start time, end time, and a specific color. Using an Afterupdate event, the background color, left property, and width of a textbox are changed to...

I am trying to send a report via email that is in the body of the email not an attachment. In addition, I only want the current record sent, and not the entire database. Every time I run it, however, I get an error message that says "An expression you entered is the wrong data type for one of...

I am trying to send a report via email that is in the body of the email not an attachment. In addition, I only want the current record sent, and not the entire database. Every time I run it, however, I get an error message that says "An expression you entered is the wrong data type for one of...

I have a database that is used to log daily events. Sometimes, these events require that a group of people be notified via email. I have a number of checkboxes depending on which group or groups should receive the email. I could hard-code the emails; however, the groups of people change often...

Thanks! Thanks all. I got it working. You guys rule!

I have an unbound combobox on a form that filters it according to the selection of the user. I would also like it to sort the form by the "Last_Name" field and I cannot get it to do it. I am sure this is a simple fix, but I cannot see it. Can anyone help? Thanks. Here is my code: Private...

Here is my problem: I have two databases. The first one, call it "A", is accessed by a small group of people and houses personnel information that is updated hourly. The problem is I need to grant access to some of the information to a host of different people...too many to make using the...

Sorry that I was not very clear. I have an OLE Object field called AdjWorkDoc. To this field, I want to link pdf, doc, and text files so that the user can recall this docs as needs be. What I would like is a cmd button that does the same thing as the insert object command and just opens a msg...

I need to create a cmd button that lets a user attach a file to record. I would like it to open a msg box that lets the user select the file to be linked to that record. Please help. Thanks.

Thanks...works fine...should have thought of it in the first place.

This is a stupid problem, but I just can't seem to figure it out (some days I am smarter than others). I have a form with three unbound comboboxs that are synchornized so that what you select in the first combobox changes your options in the 2nd and 3rd boxs. My problem is that I want to...