Search results

I really appreciate the help/info everyone has been providing. One more issue I'm having is I can't sort my records between 2 dates. I'm still using the coding as seen here: http://allenbrowne.com/ser-62code.html but I end up with a Runtime error 13: Mismatch. I'm not seeing where the...

I Hope everyone is having a great Holiday season! So I addressed the relationship issue, and now have them pathed properly (to the best of my knowledge). My Search form works ok. I do have issues with trying to search for multiple equipment. If I search with using only 1 of 4 equipment boxes...

Here's my DB. frmLgBk is the main form where records are added and reviewed. frmSortRecords is what sorts the displayed records of frmLgBk

for clarification: My Line field has multiple lines in it ranging from 70-85, with some having letters in it as well. So I have records that may apply to a single line or multiple. Not sure if this helps

I'm years out of practice which doesn't help, but Thank you VBA_php. I see now that I didn't declare the variables ([Shift] etc)as I need to. A new question to go with this. the Line field is a multi value field. Because of that it doesn't like using it in a where or having clause. What...

Hi all, I have a form that the user can use to sort records on another form. Using other examples found on here I made Coding to do so. From what I can see it should work, however when I run it I get the following message: Run-Time error '3075: Extra > in query expression '([Shift] =...

Bob, my form is in Single form. My main form is a logbook for maintenance items, which includes a subform already. There's no more room on the screen for it, and I don't want to enable scrolling to have to scroll.

Unfortunately a sub form won't work due to the amount of information the main form provides. I don't mind coding, I'm just not sure what that would look like.

Hello, I'm looking to make a form that will allow me to sort records in another form. I want to be able to limit the records viewed by a date range that the user can choose, as well as by area and team (fields on the main form), hit a "go" button, and the main form to open up with the user...

exactly like that, except (using there example) each city may be associated with 1 or up to 35 names.

I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field...