473,836 Members | 1,419 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

User Forms to Search, Display and result

88 New Member
Hello Everyone.
I have a question and i would appreciate if any one can help....
Attached is a user form with 3 Search critira. I would like it to seach the worksheet display result in text box and on update that filtered list add a number(From the userForm)into in a column that says ppo #. any guidance in this will help.
Oct 21 '11
25 3172
Guido Geurs
767 Recognized Expert Contributor
As promised, attached is a tool to standardize the data in the sheet.

There is a note of Bytes in which they ask to close a call once an answer is accepted as a solution for the call.
If you have an other question (even in the same project), please open an other call.

For this call: I must still look at your last question for the modification of the "search User form".
But if there is a problem with the "Standard" tool, please open an other call.
Attached Files
File Type: zip New user form_v8.11.zip (1.41 MB, 132 views)
Nov 22 '11 #21
Guido Geurs
767 Recognized Expert Contributor
For your last question with the file "Bytes.zip" : there is no Userform2 in the VBA environment !?

Please if this is a new search form, place it in a new call (see previous answer)
Nov 22 '11 #22
sandy armstrong
88 New Member
Wow thanks Guido!!!! this is a great tool that we can use to Standardize new data. this is perfect!!!!!! thanks guido i really thank ful you could help me with this I knew we were going to run into troble if we didnt have everything standardize.
Nov 22 '11 #23
Guido Geurs
767 Recognized Expert Contributor
This is a new version of the tool.
- Easy to use
- The possibility to change more than one wrong data at once. (like: "#NY", "NY##", "Ny", "ny", ... to "NY")
- Save standards to file for later use.
Attached Files
File Type: zip New User Form v9.9.zip (1.43 MB, 161 views)
Dec 1 '11 #24
sandy armstrong
88 New Member
Hello, GUido thanks for this tool I was trying to use the user form that is used to add the PPO# but i keep getting an error on
ARRDUMP = Range("G2").Res ize(ROWlastREC, 2)- this line
But this is sooo cool Im in love with this! thanks soo much
Dec 5 '11 #25
Guido Geurs
767 Recognized Expert Contributor
I think we have to pick up the user-form "Search" again because I have seen that the code is NOT OK.
We have stopped to develop it because we had first to standardize the data and develop the tool for it = user form "standardiz e".
Now that we have standard data, we can continue with the user form "search".
I will pick it up as a next project.
Dec 6 '11 #26

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Greg Brady | last post by:
How to display result set in random order? Thanks.
by: devccon | last post by:
Hi all, I'm quite stuck with this problem here. I have a search form (search.aspx) and I want the results to be displayed in another form (result.aspx). So far so good, I've implemented a datagrid and and the data shows up the first time. Now when I want to implement paging it can't find the next page. Obviously, because the querystring is empty. I also tried caching, it worked but I'm afraid of the memory overload and that the user...
by: paavani krama via .NET 247 | last post by:
(Type your message here) I am using two forms.From the first form i need to getinformatiom.After performing necessary calculations,the resultshould be displayed in the 2nd form.i am storing the results inpublic variables in 1st form.I want the 2nd form to access thepublic variables in the 1st form and display the same in thesecond form.How can i do it? -------------------------------- From: paavani krama ----------------------- Posted by...
by: Dursun | last post by:
Collegues, is it possible to do the foloowing: Let end user draw specific shapes (a circle that has a number within it and a connector that points to a specific area on the background image) using Windows Forms and controls. To be more specific, I want to design a VB.Net Windows form where end user will mark damages on an airplane picture (which might be background picture of the form) using a marker object that has a circle (with a...
by: johntarr | last post by:
I hope I am not asking about something that has been done before, but I have searched and cannot find an answer. What I am trying to do is to run a query, and then perform some logic on the rowcount and then possibly display the result of the query. I know it can be done with ADO, but I need to do it in Query Analyzer. The query looks like this: select Var from DB where SomeCriteria
by: Terry Olsen | last post by:
I have an ASP.NET web page that can display about 25 columns of data from an SQL database. I have it right now using a CheckedListBox to allow the user select the columns for display in the DataGrid. I have hardcoded 3 columns for filters and allow the users to type in to a TextBox the filter data. Are there any Query Builder GUI examples that I might use to allow the user to build their own query using any and all the columns?
by: gunanallasamy | last post by:
hi Folks, i came across a situation for which still i couldn't get a solution. i have table like below(some other columns are also there) option value ------- ------ 100 1 101 200
by: =?Utf-8?B?QW5pdGhh?= | last post by:
Hi, Currently for Announcement library a custom column "publish start date" is added and under the search result webpart changed the xslt by filtering the result based on the publish start date .Publish start date is not mandatory. if the publish start date <"" and publish start date <= today then the item get displayed under the search results else the item won't get displayed.
by: metparker | last post by:
Hi everyone. I am trying to create a web form that will let search for records. the form will display the results on a screen that will enable the viewer to edit the record and then re-save it or cancel if wanted. I have the database. its has sample data. I can see the sample data from another machine. 'ssh'd' into the server and running mysql with appropriate commands. I have forms to retrieve the data and display the data on the screen...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.