Search results

Hit the nail on the head, that's what I want.

That's exactly what I needed to tie up the loose end, thank you!

Okay the title might be confusing so I'll explain in greater detail. I have a form in which a user can input information into comboboxes and then run a query to pull up the data they had input. For example if I wanted to run a query to search a student name, I would input the student name and it...

I'll try to clarify a little better here, I want to see items one week overdue overall (for example: If an item goes overdue on monday I want to be able to see it on the query tuesday, wedensday, thursday and friday and then after that period I no longer want it to show up) not just the items...

I'll consider it, although what you've outlined other than loan number and the special characters (yeah I was dumb to stick special characters in there but I was just starting out with access) wouldn't make sense. Item ID is a completely seperate thing and can be letters and numbers, and some...

This works, but what I was trying to say (and I'm sorry I did not communicate it more effectively) is I want to be able to view items that are specifically one week overdue as staff will often chase down the students who do not return the items but after about a week give up as it is too time...

That's exactly what I wanted! The only problem now is that if the field for username is null everything on the page disappears due to the filter, is there anything I can do to avoid that? Keep in mind the people I am making the database for aren't the most inclined with access. Thank you ever so...

Where should I go about putting that code? I apologize for my lack of knowledge I have just started working with access recently. I appreciate the response!

In the "Items In and Out" form I would like you to explain to me how I can go about pulling up a students information by simply clicking or typing their username into the combobox labelled "Username". Effectively I want the Username section to be what will bring up student email, student number...

Actually another quick question if you wouldn't mind! I have multiple fields that can be null when running the query, there is also a combobox for the staff member who signed out an item (this field is usually going to remain null as items are typically signed out by students). After adding that...

Here is a sample of what I'm working on, it has everything I've worked on up to now. The query I am trying to get to work is the Overdue Items query. I appreciate the help thus far!

You are an absolute gentleman and a scholar. I have been trying to useso many different methods and the IsNull() function for the longest time now to no avail. I didn't realize how cut and dry it was. Thank you ever so much!

Okay, DueDate is defined as a date like so month/day/year. DueDate is typically defined as the end of a semester as it is a database tracking loans to students. The table that DueDate is pulling from is called Dates and Item-In/Out (bad name for it in hindsight). Here's what I have tried thus...

Hi! I am trying to create a query that will return only items that are a week overdue. I have tried using the Date() function and the Between function but to no avail. Is it possible to do a range? Like Date() = DueDate +7,+6,+5,+4 etc.? Any help would be greatly appreciated! Thanks.

I changed the students data to protect their information, all usernames, emails and etc. are made up. Anyway here it is. Let me know what you can come up with. Thanks for all the help!

For whatever reason I can't seem to attach the database file, it says "extension not valid" or something to that degree, what can I do to post this?

Hi! I have a form that searches my database for specific fields and returns what you have chosen from a combobox in the form of a query. I have been using this line of code and it has worked for almost everything and returned proper values: Like "*" & [Forms]![Database Search]![cbx_Item] & "*"...

Not using lookup field no, the Username field is however indexed, I can see what kind of sample I can cobble together quick that won't give away information for students. Thanks again!

I get a type mismatch error when using the third option of the combobox. Is there any way I can connect the Username combobox to the other comboboxes? For example, when I click a students name or type it in the combobox it pulls up the information from the query in the student number, student...

Actually, I'll ask a completely different question if that's okay. I have the Username combobox associated with a query called "Student Info". Would there be a way when I click on a students username in the combobox to bring up the information associated with that student (i.e. student email...