Search results

Can anyone tell me why it is when I try to add values to the subform I get an error that states I cannot assign a value to this object? I have attached a the database. Thanks ahead of time.

Yes, I have the main form based on the complaint table. jz, I know this is a stupid question, but you mean to populate the combo with the names of the complainant? or the autonumber from the ComplainantID? So, there is no way to just pull the value (autonumber) from the subform textbox...

Hello all, I know this subject has been asked before, but I seem to be having a hard time getting it to work. I have the following: tblComplaint pkComplaintID/autonumber fkComplainantID/number tblComplainant pkComplainantID/autonumber I have a main form with tabs. On one tab, I...

Hey guys, I have changed some things around and wanted to see if I am headed in the right direction.

Rainlover, The other tables are ones that I use to populate my combo boxes. I thought that they could left on their own and not linked to other tables. I will change this. I am not ignoring any advise; trust me, at my experience level, I need all the help that I can get. I was not quite...

I must be tired gemma, I meant that I was able to input new data to 3 different tables with the one form. I think I am still going with a tabbed form, but I will use subforms to input and update data into the different tables.

I did not know this. The weird thing is up until 3 days ago I was able to update 3 tables from the single form (using inner joins), it finally stopped working when I tried to add tables 4 and 5, lol. This is for work and unfortunately we have zero professional help available. It is just me...

Again, thank you everyone for taking the time to help, even though I think I may be a lost cause. I have attached a new pic of my tables. I know not much has changed, but I have changed the naming conventions for the better (I hope). Also, added the fk where I did not have any before. I am...

I apologize for my ignorance. I see what you are saying about the dates. In my case, the user never will input the event, only the dates for each event. I am sorry that I am not getting what you are trying to explain.

jz, I should have clarified, I meant date fields and not text boxes. If you look in my example db that I posted earlier, you will see the tab "Time Line" where the users input dates into the date fields via the date picker.

jz, in your example you used a series of combo boxes for the events, but can this be changed to input through textboxes instead? If so, then how would it look? I dont want a user clicking on the wrong event for the date tracking.

I had a terrible feeling that you were going to say something like that. Oh well, I guess I will just try to trap the error. Thanks for the replay John!

Do you mean hiding your search form or closing it? Closing the form: DoCmd.Close acForm, "form name to close" Place this in the on load event of the form that is opening.

Hi John, I have an issue with input into the search textbox. http://www.access-programmers.co.uk/forums/showthread.php?t=240269

Hey John, I am having another issue with the search. The search works great, but with the exception of when I try to type an " i " into the search box. I receive a 2110 error "Cant move the focus to the control SearchResults" Any ideas why this only happens with the letter " i ". I have...

jz, I apologize. I left out all of my fill tables for the combo boxes to reduce the size of the db. I have tables for most of the fields that you have mentioned... Allegation, Action, Complaint Origination, etc... The junction thing still confuses me, but I will give it a try. Do you...

Here is the stripped down version. I am in the process of creating a table for the time line and one for the complaint details.

jz, I posted a message in your profile

jz, would you mind if I sent you my db, maybe it will give you a better understanding of what I am trying to do. It is far too large to post in the thread. I would have to send it via email. Let me know. Dave

At this time, PSU does not keep a record of complaints that do not have enough information to move forward with a case.