Search results

Pulled out a lot of records but left enough behind to play with. To reiterate, the idea is to have several levels of users: those who cannot view inactive parts in the search those who can include inactive parts but can only preview and print active parts those who can include inactive parts...

Yes/No. I also tried, using True/False, 1/0 and Yes/No.

It seems to ignore the False. Private Sub btnPrintSelected_Click() If Globals.UserAccess("Print") = False Then MsgBox ("You do not have Access!") Else Dim strCriteria As String strCriteria = "Inactive=false AND [ID]=" & [SearchList] DoCmd.OpenReport "swsetupsheet"...

If you mean does it open the correct record that I clicked on, yes. I've tried this as a test and the print preview pops up the correct ID in the preview format if the user has permission. Just need to know how to add the condition that the record Inactive=False. Private Sub cmdPrint_Click() If...

I have a report, swsetupsheet, the trouble is the Where Condition, how do I add in the additional criteria of only allowing records marked as active to print. Currently I have ="[ID]=" & [SearchList]. Also shown in the attachment.

Here's one I really need help with. I have records in my proddtl table marked as inactive. I have a search with a checkbox labeled inactive. I have a useraccess table that sets permission to this checkbox and that's all working just fine. Users without access to inactive records cannot see those...

Here's another one for you, Can I create a report that looks like the setupsheet form, picture attached, and open the form for editing or the report for printing from a couple buttons on my search form, picture attached?

It makes sense but I decided to simplify it a little and just add MACHTYPE to the search box that you helped me with. Keeping it simple until I can get a few more hours under my belt and understand a little better. Thanks again.

There's probably a better way to do this but I'll ask using what we've been working on. If I have a list like the attached, you can see that I have a number of different machines that similar parts are run on. I'l like to further filter the list by machine so my thought was to add a check and...

Well that was easy enough. Guess that's why they pay you the big bucks. Thanks again..

Sorry to come back to this but I find myself double clicking on a line to open the form rather than use the Open Selected button i have. I've tried adding code to the double click event but either get a blank form or nothing. I've also tried adding a macro but was getting the exact same record...

You're awesome! This worked perfectly. The only thing I had to do for ease of use was add a button to my form to rerun the query. Without it I had to actually edit the search criteria in order to rerun the search. With this bit of help I was able to figure out what to do with part 2 of the...

I did or maybe this is less than what you were looking for. SELECT PRODDTL.ID, PRODDTL.PARTNUM, PRODDTL.PARTNAME, PRODDTL.PARTREV, PRODDTL.MACHINE, PRODDTL.INACTIVE FROM PRODDTL WHERE (((PRODDTL.PARTNUM) Like "*" & [Forms]![SEARCH]![SearchBox] & "*")) OR (((PRODDTL.PARTNAME) Like "*" &...

Sorry, I appreciate you're trying to help but I don't know what to do with this. I added the statements as criteria under the Inactive with the correct form name but it returned no records, checked or not. Is there any way you can tell me exactly where I should enter this?

SELECT PRODDTL.ID, PRODDTL.PARTNUM, PRODDTL.PARTNAME, PRODDTL.PARTREV, PRODDTL.MACHINE, PRODDTL.INACTIVE FROM PRODDTL WHERE (((PRODDTL.PARTNUM) Like "*" & [Forms]![SEARCH]![SearchBox] & "*")) OR (((PRODDTL.PARTNAME) Like "*" & [Forms]![SEARCH]![SearchBox] & "*")) ORDER BY PRODDTL.PARTNUM; The...

Sounds like you understand where I'm going with this, I'm just too ignorant about how to get there. This is my search query. Is this where I add filtering?

This is actually a 3 part question. First, I created a search form that returns the correct records based on the criteria in a text box but now want to filter out the "Inactive" ones. I only want to Include Inactive when a checkbox is selected. Second is how do I replace the Machine code shown...

Good afternoon. I've been in manufacturing for 35+ years and am familiar with Access, as most people are, but have never done a project for myself and it's time. I've started something and it looks pretty good but now needs some bells and whistles that I can handle. After searching for help on...