Search results

Hello guys, Again, I am very new at this and I still do not have a grasp on Access yet. Yes, every case generates a Case Number and once a number is generated, then it will be in the system forever. I will look at this when I get back into the office on Monday. Whenever a complaint is...

jzwp22, After looking at my tables, it still looks like I just need another table for my "time line" and can do without the junction table. I probably did not explain things as well as I could have. Each case will have its own set of dates. No dates will cross over to other cases. I am...

Yes, you are correct. The date tracking is the same for all cases. I will try to implement what you have suggested. lol, I thought I had almost completed my project :banghead:

I knew it would. I am very new at this. I appreciate you taking the time to give me some pointers. Each case is unique and does not have any bearing on other cases. Can the pkEventsID be the Case Number? or does it have to be another unique identifier? The following are used to help...

Hello All, I have a database that has a few tables and I was wondering if anyone would be able to tell me if I am close to having a Normalized Database. I have attached a pic of my table relationships. I think I need to have a FK for CFD Witnesses, Focus, Complainant, and Civilian...

Thank you Jiri!!

How would I modify the code to reset to zero at the beginning of each year?

Thanks for the quick response guys! I have not had a chance to implement the suggestions, but I sure they will work (as they usually do).

Hello all, I am back with yet another question, lol. I have a case number that I want to auto generate with the date + number. I also want this case number to be incremented by one when ever a new case is started. Me.txtCaseNumber = Year(Date) & "-" this is what I have so far to...

UPDATE: Yes, that was indeed the problem. Thanks again!

John, not only am I an idiot, but I cant seem to read as well. I dont know how I missed that bit of instruction when you clearly stated it in a couple of places. I will try that tomorrow, but I am sure that is where the problem lies.

Ok, will do when I get to work tomorrow. Please excuse my poor attempt at explaining what I was trying to describe. I knew that when I typed a "Case Number" I would not receive any results, but when I did place the Like "*" & [forms]![Case Search Form]![SrchText] & "*" in the criteria, the...

I am using John Big Bootys code for searching fields in a listbox am having a problem. Here is Johns original thread http://www.access-programmers.co.uk/forums/showthread.php?t=188663 My issue is this: When I try to select a field that I have not attached the search criteria to, everything in...

Will do John

Hi John, I have a question about the code you have for searching a listbox. I cannot find your original thread to post my question to you.

I found another thread that had the answer. I am not sure how I missed it, but I did.

Hello all, I have a form (Case Search Form) with a listbox. The listbox populates from a query (QSearchAll). I also have a textbox that I am using as a search field. The listbox populates as it should and the textbox works as it should by searching the listbox. What I want to do is that...

pr2-eugin, It works great! I have also changed out all of the Chr(13)'s as you suggested. As always, thanks for the help. It is greatly appreciated!

I'll give it a try, thanks! UPDATE: I gave up on the idea due to the fact that I have one form entering data into 2 tables and it seems like I would have to change too much. I will give it a try on another project. I ended up placing a "Cancel" button to undo any entries. I am not sure if...

First of all, sorry for all of the questions, I am a newbie at Access. Is there a way to enter data into a form and this data not be saved into a table until a user clicks a command button to save the info? The reason I ask is because I have a form where a primary key is auto generated and...