Search results

Ok, got the database all set up and it's attached. qryFullInventoryTE is the base query that pulls out the data. qryTEConcat is the query that concatenates the data from qryFullInventoryTE.

Sure, give me a minute to sanitize some data. I'll zip it as a 2003 format (it's 2013) now.

How would I sort October 2011 TE, March 2014 TE, February 2013 TE To March 2014, February 2013, October 2011 If I sort in the query, it doesn't sort the items in each result, it just orders all the results in alphabetical order.

I cannot sort the concatenated result by maintlistdate. This is my initial code date Concat: concatrelated("tedate","qryFullInventoryTE","qryFullInventoryTE.GeneratorInfoIDPK= " & [tblgeneratorinfo].[generatorinfoidpk])and it produces this result: February 2013 TE, March 2014 TE, October 2011...

I have three tables: 1. A table of generator information (back up power generators). This is the 'main' table. 2. A look-up table of maintenance lists that encompass the generators. Every year or two, a new maintenance list is generated by a 3rd party. This is a listing of every...

I have a bit of code I've used to generate an email based on a date field in a form. Mine is set to generate the email via command button but I'm sure you could automate it. (I slightly edited it to remove PII). It generate a block of email address for each class based on that particular date...

I only receive the error when I search for something that doesn't exist, otherwise, it functions normally. So if I search for "test", I receive no error because I have a record with "test" in it. If I search for "fat whale", I receive the error because "fat whale" doesn't show up anywhere in...

I have a search form that's slightly modified search form modeled after the one available here on this site. It's a main form with a list box. I use the listbox to narrow down the results I want from the search function. The search details are shown in a sub form that contains sub-sub forms...

I tried putting a me.refresh in the code manually and nothing. Tried setting focus to the listbox then refresh, nothing. This is what I have in my listbox_click event: Me.frmInputWaste.Form.Filter = "[CurrentCYIDPK]= " & Forms!frmWasteSearch.SearchResults...

Well, it filters my subform appropriately, but I don't get the line that highlights the row in the listbox indicating which record it's on. that's what I was wondering about. e: I'm on 2007 right now.

Thank you for the reply! After fiddling with it and not getting it to work, I realized that "filterform1" is basically being used as a unique identifier for my Form2 and I'm not supposed to actually try to pass my record ID through it. Is there a reason why I don't pass my record ID through...

I have three forms: Form1 that contains subform1 and Form2 which is totally separate. Form1 contains a listbox that I use as a search form. When a record in the listbox is clicked, it populates Subform1 with more details. If I am in Form2, I would like to be able to click a record which opens...

Sorry, I guess I misunderstood your first post. Sorry! Yes, this makes sense. I did not realize that access worked in this fashion. So what type of code should I research to revert the 'new record' to an actual new record?

I assume the default value is getting set when I attempt to duplicate the record via button. If I click 'go back/cancel' or when I click 'new record' the default values are not cleared at any time. The default values change based on which record I select in my search form. This used to...

You're right, the default values isn't getting cleared out. I assume that the correct path forward is to have the 'back/cancel' button clear those out. Is that right?

That's the 'back button' code. The code for the duplicate button is in post #1.

So I figured out the problem but not the solution. If I click the 'duplicate' button it works as intended. however, if I decide I don't actually want to duplicate the data I have a 'back button' that exits the new record and just goes back to previous record. Back button code: If Not...

:banghead: I somehow missed that. Ugh.

Created a button through button wizard that is supposed to open a form to add a new record, but all of the fields don't clear out. Only some fields clear and other fields actually populate data from another record. Snip1 shows my form with a record selected. When I click the 'New Waste'...

That's also part of my problem - I have no idea what my client is authorized to spend nor do I know how much the sub-contractor would charge for it. If I was able to get any of that info I wouldn't be having such an issue with this right now.