How can I write sql statement to find the last transaction of persons in a database ie the last date on which each pers has bought items from the general...
Can you give us some more information, because it IS possible, but can't really give accurate help without knowing, at least a little bit, about the data that...
Thanks Stevens Suppose there are 100 persons in the database (in a table) and each of these 100 persons have visited certain general store at least once to buy...
waitng for reply.... riz Thanks Stevens Suppose there are 100 persons in the database (in a table) and each of these 100 persons have visited certain general...
I am new to this group but I might be able to give you a hand. You are looking for a Query where each record in the table (users) indicates the last time they...
It's still more of an sql issue, than a VB help issue... Basically you'll need to build a subquery. select * From MyTable tbl1 Where VisitDate = (Select Top 1...
Hi Group, I am trying to make a "grocery list" or something like a line by line report, for a parts program I have been screwing around with for a while now....
There are 2 ways that I can think of to deal with this problem. One, is to have a table in your db (OrderedParts or whatever), that you post data to every time...
How do I get Setup to run a shell or batch command from the installation directory? I need to run a command to quietly register a component at the end of...
Hello Guys, You might be able to help me here... I have a MS Access database (containing customers information) that is located on our local web server sitting...
Hi Avi, ... No. If you've got any data validation errors within your code, an employee (or anyone else that has access to that web servers public face) could...
Hi Larry, ... You can edit the actual PDW installer package (which is a VB project) from within VB. Add the shell() call or whatever is necessary to make it ...
I am working on an application and I need to control another program via hot key commands. Scenario is I have my application running, either minimized or a ...
<snip> ... be ... Thanks Shawn, that's what I thought. However I'm not sure how to implement that as far opening a database which reside on our local web...
... Something to look at while you're waiting for Shawn's advice on some sample coding... http://www.vb-helper.com/index_database.html (use your browser's...
... machine ... fetch ... ASP page ... need to ... applications ... database ... database ... False, ... web ... connection ... I didn't find what I'm looking...
I have written a VB6 program that stores records on an MS Access database. It is working, but I am trying to improve it! Hitherto, to amend the Record, two...
i m create a small project for deleting files. and it is working but there is a one problem. when i run the program and delete the file, one error is display...
... Have you considered that it might really be in use and that deleting it could cause problems? Error messages aren't simply an annoyance to deal with, but...
... If your application will have permission to bypass any native firewalls, then it's often as simple as rs.Open with a URL as a parameter. One of the samples...
Hi Bill, ... Start by looking at the Vbnet examples here: http://vbnet.mvps.org/ You'll probably want "A Basic TCP/IP Winsock Chat Program" from the Internet...
In my mind (not fully aware of what I am trying) what I need to do is : Query What Applications are running Select the one I want to send commands to When I...
If it is a global HotKey(and that is what most people assume a HotKey is), then you should not have to bring focus(Activation) to that other app. Just sending...
Informaton is stored in single table.another example could be of when did a particular user last log on to a particular site.I shall be obliged if any one...
I am using VB6. The main page had 8 command button on it; say, cmdButton1, cmdButton2, etc. Everything was - and is - working fine. Most of the command buttons...
When you double click on the button in design view, where does it go to? On Tue, Apr 15, 2008 at 10:02 AM, Michael Hodge < ... -- Don Roberts - don@......
... cmdButton2, etc. ... Form. I ... - and ... problem when ... anything! ... I'm not sure I'm understanding the syntax (again). Is there a specific reason for...
Many thanks! I have got round the problem by making cmdButton9 a Control Array with cmdButton8 - not my preferred route, but it works! As for my dot at the end...
Guys, I need help and guidance.I have a column "name" and in that column we have full name now I need to transfer all those names based on first name and last...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
