Search results

I apologize if I'm not providing enough info. The way I have it set up and working now is that you type in the printer's info into my form's textbox and it then runs the correct queries. The issue comes down to the fact that you can't easily just copy and paste a record without copying the field...

Hi again CJ, So far, I have created a button on the form to open the inputbox, however, I cannot get it to run the query and show the results within the input box. Also, it needs to populate the entire record, not just one field. Is this possible? My code: Private Sub cmdFindprinter_Click()...

Hi, I hope that this is the correct place to post this. My VBA knowledge is expanding, however, this is way over my head in terms of technical know-how. I have 3 queries that provide the same printer information. Each one is queried by a different field: IP address, asset tag, and serial...

Hi CJ, I apologize for the long delay. I ended up being pulled into a whole different direction on a different project. The way that I ended up going was using the combobox, that way we can modify the values if we need to and not affect the user. Thanks for your help! Nate

The names of the fields will be Template, Skim, Printer, CI, Priority, Other. I want the user to select only one option and not multiple options. It is my understanding that the checkbox option is not setup to function that way. The reason that I do not want to use the option value in a...

Hi all! I was wondering if there is a way to take the selected OptionValue from an option group on a form and have that value check a box in different fields on the bound table instead of just placing a value in one single field. For example, I have a form that users will use to report...

Thank you! I was pulled away to work on something else, however, I will try it on Monday.

Hi all, I am attempting to create a form (Access 2013) that will include buttons to open the hyperlink menu to add a hyperlink into a table. It works if you click "Ok" without issue, however, if you click "Cancel" or click on the "X" I get a "Run-time error '2501' - The RunCommand action was...

Wow! I come back from lunch, get some other work done and end up with quite a few responses! Thank you everyone for your assistance! Roku, The first set of code in your most recent post is exactly what I needed! I now see what you meant by utilizing the counter. It works perfectly for what I...

Hi Roku, I mention the text box because that is where the user inputs the search data. Then the "Find" button is clicked to run the VBA code to return the appropriate queries. Please excuse my ignorance regarding VBA, my knowledge on the subject is quite basic. How would I structure the code...

Hi, I am not sure where to start or go about creating message box that would display "No results found" if my queries return no results. My search of the forums hasn't been fruitful. :confused: I have created one form that has a text box and a button that works as a search function to run...

Yes!!! I totally forgot to set the Event Procedure!! Gina, you are a machine! The queries are working!

I created 2 more queries, it works, however, all 3 queries pop up even though only one of the fields was queried. Not sure if that makes sense... I am hoping to be able to have only one query pop up. The other queries that have nothing to with the Xerox tables do not open if the text in the text...

I'm back!! I would like to expand my previous question to include having multiple field names. In other words, how do I have the following DCount include multiple (short text) field names, not just [IP Address]? If DCount("[IP Address]", "Xerox Assets Query") > 0 Then DoCmd.OpenQuery...

Thank you!

I wrapped the text for the IP field in the DCount and it worked perfectly! I couldn't have done it without you, Gina! Thank you! :D Edit: This is the resulted code: If DCount("[IP Address]", "Xerox Assets Query") > 0 Then

Ok, so I figured out what field you are referring to, and it is working except for when I query the Xerox table. I believe that the DCount is throwing an error because the field that it is searching is IP numbers that have 4 octets separated by decimal points. Any idea as to how I can make it...

Hi Gina, Thank you for your prompt reply! The code for the macro is as follows (not sure if it will show up correctly or not): Private Sub Find_Click() On Error GoTo Find_Click_Err DoCmd.OpenQuery "HD Manual Query", acViewNormal, acReadOnly DoCmd.OpenQuery "SDDocumentation Query"...

Hi, I am creating a "knowledgebase" for my company. Each table will contain records with hyperlinks that point to a PDF or other file. Currently, I have 1 search field on a form that also contains 5 combo boxes and 16 hyperlink buttons. My question is regarding the search field. I have it set...

Hi, I am a Systems Analyst for a large company in Pittsburgh, PA. I'm familiar with Access, however, there is much to learn! Please bare with me if I have some ignorant questions. :banghead: Nate