Search results

Thanks for the link! I'll see if I can get a sample database up here if I can't get this solution working. I think I see what you mean by the changing the focus and will give a few things a try.

I'll see what I can find about creating my own search. Thanks for the suggestion! And as for the focus, I'm wondering how to move the focus back to the form in order to let the scroll wheel work again. As of now, I can't seem to do that. Once a textbox is clicked, there is no going back...

The search button I used is the "Record Navigation > Find Record" button in the wizard that appears when you place a new button on the form. How do I do that? **If you mean by clicking on the form background again, the cursor still stays in whatever textbox it was in and the scroll wheel...

Thank you for the information on that. It's certainly something that I can explain to the user and let them know that a work around would be extensive and not completely worth while. As for my other questions about the search box and scroll wheel... are they easier to solve? Thanks again!

This is kind of an abstract thing I imagine, and I understand if there's no easy solution (or none at all.) I appreciate any guidance you might have anyways! First thing: I have a navigation form that leads through 5 subforms on my database. One is a data entry form, the rest are various...

Thank you! This worked. Now it makes sense as to why Access was giving me those seemingly random results before. PS: If I go through my column names and eliminate spaces, will those name changes be automatically reflected in my queries and macros? I'm fairly sure I'll have to manually...

Ohhhh, I didn't even think about that. Good catch and thank you! I'll give that a try

It's an unbound textbox and the "Text format" is set to "Plain Text." I didn't see any date in there. Format is "Short Date." How can I set this as a date field? Pardon my inexperience. I'm learning as I go. Thanks for the fast help!

Hi again everyone. I have a query that "sorta" works, but doesn't seem to abide by one of my criteria. I am trying to search by two criteria in this query. First, I want the query to select records based on what "System" they relate to. Next, I want it to sort those tickets by "Release...

This worked out well. I wish there was a more automated way of doing it, but for now this was what I needed. Thanks!

Thank you! I didn't know that I should use a join and update query. I'll give that a go and let you know if it works tomorrow

This may have been asked before, but I looked around and couldn't seem to locate it. I need to import an excel sheet containing updated tickets to my access ticket database. They have unique IDs in the form of a "Ticket ID" field. I could just use an append query to add the new...

Thank you! This works

I searched around the forums but couldn't quite find this question. I have a ticket database where tickets are added to access with no priority scores on them. Over time, meetings and discussions, those tickets are given scores through a form on my database. What I would like to do is...

This worked out very well! Thank you! All I had to do was add IIF(IsNull(... instead of just having IIF((... and then ...=0,[Manual Field]... It's working perfectly now, thanks again!

I'm a bit of a beginner with Access. But if I understand you correctly, you're saying that this new field would simply be added to the calculation? As in, the calculated total comes up as 0 when the individual category fields are empty. Therefore, we simply add another number to that in...

This particular function will really only be used in datasheet view. Should a ticket not require individual priority categories, a user will go into the datasheet and enter a manual total priority into a field. Preferably, the calculated total field will pick this up. The calculated total...

I have an interesting question for anyone who'd like to help me tackle this. I have a calculated field that is a total based on 5 other fields. These fields are rankings of priority on individual categories, while the calculated field is a total priority ranking for the entire record. (A...

This worked! Thanks!

Hi, I'm new to the forums and have a question. I looked around and found some similar questions, but couldn't quite grasp how to utilize them for my issue. Sorry if this has been asked before. I have a database containing 10,000+ trouble tickets identified by a unique field called "Ticket...