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 SkipVought 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
  • Order by date
  1. Modex

    How to Close Desktop Application Windows using VBA

    Hi Andy, Fully understand that and wouldnt do it if it was for more thatn just for me. It's for a personal database purely for me and it's just so frustrating to load a database and search for the pop up screen as I usually have other windows open most of the time. Just want to say many...
  2. 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...
  3. Modex

    How to set up the startup directory for a shell statement

    Specialkfx, Bjd4jc. Thanks guys, much appreciated for the pointers. Specialkfx, I was using batch files to do it all first of all and it it does work perfectly as per your advise, however, I was trying to get the whole thing working from just one exe, created by VB6 with no batch dependancies...
  4. 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...
  5. Modex

    Analysing with Excell from a form using a command button

    Thanks PHV I didnt know that one, Just tried it and it works a treat. Many many thanks ModeX
  6. 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...
  7. Modex

    Making a combo box that lists fields in a Query

    Hi JerryKlmns and PHV, Many Thanks for your anwsers they both worked a treat, when I get back to work, I'll put them into action. Thanks Again ModeX. Also for SUEPee what you could put in the query parameter in place of like [Enter PM Name] you could put Like * & [Enter PM Name] & * That...
  8. 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...
  9. 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...
  10. Modex

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

    Hi Earthandfire, Thanks for that, worked a treat. I had to work out where best to place the code, but I got it working. Excellent Thanks ModeX
  11. 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...
  12. Modex

    Volume Control Component

    Hi Ya Aceman1, Thanks for the info, I did have a look at this and it looks pretty good, however I only really wanted a very simple little slider to go on the form and as its just a personal project, I really dont want to shell out $40.00 for a whim. I suppose I'll have to continue to search...
  13. 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...
  14. 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...
  15. Modex

    Adding or Subtracting a Date by 1 Day

    Hi Mike and Paul Many thanks for that, I appreciate the responses, you were right is fairly simple, I was trying to just +1 to the date. I feel embarassed, I'll just put it down to the fact Ive just turned 50 and the old brain cells aren't what they used to be. Again, thanks alot guys, much...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Part and Inventory Search

Back
Top