Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Modex
  • Content: Threads
  • Order by date
  1. Modex

    How to Close Desktop Application Windows using VBA

    Hi Everyone, I am using Access 2010 64bit I'm somewhat stumped by this and not sure how to proceed, if of course it is even possible. I want to be able to load a database where the Access application window is hidden and the user is presented with just a pop up menu form. This all works...
  2. Modex

    How to set up the startup directory for a shell statement

    Hi All, I wonder if someone could help me please, I am in the process of writing a little menu program in VB6 to run on windows 98 which will load up some of my classic old time games that do not run on XP any more. The trouble I’ve got with one particular game is that it want to start running...
  3. Modex

    Analysing with Excell from a form using a command button

    Good Morning all, I have a little problemette which I cannot wrap my head around and wondered if anyone could possible help. Basically I have a form that looks very much like a table view, it has six columns and 6 combo boxes, each combo box above each column allows the user to select a field...
  4. Modex

    Making a combo box that lists fields in a Query

    Hi all, I cant work this one out, I wonder if it can be done. I Have a query with a number fields and a form with blank unbound boxes, I would like to use the combo box to select what fields to use in the form. But I just do not know how to list the queries field names in a listbox/combobox...
  5. Modex

    Drag and Drop Problem

    Hi All, I have a strange problem here at work that is causing a bit of a problem Basically I have a number of people who drag and drop a second instance mail item to a file system folder get a message saying file already exists, do you want to overwrite?, and then I have another lot who when...
  6. Modex

    How can I get a query to display 0's and not Null

    Hi All, I wonder if someone could please help me out of this dilema. I have three queries each of these queries performes a count, basically one counts how many eipsodes there are in a TV series. The next Counts how many I have got and Finally the third counts how many I have not got. I then...
  7. Modex

    Volume Control Component

    Hi all, Does anyone know of an Active X or some other type of control that can go onto an ACCESS 2000 form that would allow the user to raise and lower the volume of music playing. I know you can click on the speaker icon in the taskbar, but for asthetics I would like a control on a form. Any...
  8. Modex

    Sorting Multiple fields on a Form.. I just can't work it out.

    Hi All, While I'm in Access mode, I wonder if I could ask one other question that has been troubling me for some time. I need to be able, on a click of a button to firstly sort a primary field ie "The Date" and then I need to be able to do a secondary sort on the "TIME". Very much like...
  9. Modex

    Adding or Subtracting a Date by 1 Day

    Hi All, I have a little problem with date manipulation. Basically I have a button on a form that is called [TODAY], if the user clicks on this button then only the records for today are shown on the form (using the filter option in code). However, what I would like to do is have a couple of...
  10. Modex

    Getting a field from a non underlying query

    Hi all, This probably quite easy to do, however I cant seem to work it out. Basically I have a form and on it is a unbound box which I want to show the results of a query that has nothing to do with the form. The query is Basically a count of differnet disk numbers in use so when the query...
  11. Modex

    How do I filter on a Filtered Field....

    Hi All. I wonder if anyone could help me with this little puzzler. I have a form that lists a TV Transmission Dates, TV Series Title, A Season/Series No and Episode Numbers amongst others. On each of the columns I can filter and sort however what I can’t do is seem to be able to filter on...
  12. Modex

    How do you update a field from a second element of a query

    Hi all. I have a couple of questions on this thread,Ive been trying to fathom out how to do them, but it just keeps eluding me. Anyway First Question. I have a Combo Box Field on a form that looks up a [Epsiode Name] which is based on a query that contains two fields which are (EPISODE) and...
  13. Modex

    FindRecord Problem when no record Found

    Hi All, I have a text box on a form where a User can type in a name of a unit and expect to jump to the record containing that unit. I use the very simple code:- docmd.gotoontrol "Units" docmd.findrecord TextBoxName This works fine if the unit is found, however if the unit is not found then...
  14. Modex

    How to test to see if a form is open

    Hi All, I wonder if someone could help me on this, I have had a real hard search through Tek-Tips but I probably am not using the right words for the search criteria. Basically I have a number of forms that a user can go in and out of depending on what they are doing, but on some occasions...
  15. Modex

    Problems running a UNC command from a button

    Hi all, I have set up a small database that records details about a number of machines and would like to be able to jump to the C: drive of any selected machine. I tried doing this via this code, but nothing happens. Could anyone please help me. Many thanks ModeX Private Sub...
  16. Modex

    Syntax problem, could someone please help.

    Hi All, I'm fairly new to this VB scripting and am having a problem with this little piece of code. Basically I want to run IPCONFIG /ALL to a file and then read the file. It runs IP config, but wont output to a file. Any help would be really appreciated ModeX SCRIPT...
  17. Modex

    Some Help on SBS Server 2000 Please

    Hi all, Apologies if this is a very backward question, but Im having major problems in setting up a Small Buiness server 2000 for a small office network. All I want to do is set up one server and 12 workstaions in a simple Domain like "JSP" for instance. Firstly when I build the machine, it...
  18. Modex

    Simultaneous connections

    Hi All, I wonder if someone can help me please, or point me to any information that may help. I look after a small company that has always used Workgroups using a "Windows 2000 Professional" machine as the "server", file repositry etc. The problem is now the company has just taken on some...
  19. Modex

    Finding an EXE file and retrieving Path

    Hi all What I would like to do is search a system for a specific EXE file. The Chances are it would always be in the same place such as “C:\program Files\Winvnc.exe” however there could be times when on certain machines the program may exist elsewhere on the disk in a different directory. So...
  20. Modex

    Strange error in query relating to 'Mid'

    Hi All, I have little problem, which I cannot understand at all and I wonder if anyone has come across this before. Basically I run a query with this “Update to” criteria Mid(Left([Old Filename],Len([Old Filename])-4),myInStrRev([Old Filename],"\")+1) The problem is, this has worked fine for...

Part and Inventory Search

Back
Top