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 Wanet Telecoms Ltd 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: MilinPCH
  • Content: Threads
  • Order by date
  1. MilinPCH

    Contains or Within Query

    I think this is an easy one, but I can't seem to find out how to do it. Have a query against a field in a table that has multiple values...for each line item, the values in the field could be A or AB or even ABC or AGC or any combination of letters. What is the syntax for the criteria...
  2. MilinPCH

    What's the Best Route for Me - Advise Pleeease

    Hello... Hoping to get advise from you experts. Although I did read that 200+ postings thread about certifications -and it definitley was a downer - I think I need to go ahead and get something, but as a newbie I would like you advise of the best methods to use. In brief, I am in my mid 30's...
  3. MilinPCH

    Inventory Database - Moving Product within locations

    Hello, I have created an inventory database for my company that successfully tracks the entry and selling of widgets and comes up with a current inventory on hand form/report for the user. Unfortunatly (for me!) the users have come back and decided (after i finished building it !!) that they...
  4. MilinPCH

    Showing Dates Chosen in Box on Report

    I have a report that that the user creates based on an existing query. I have it set up so that the criteria the query runs on is based on a start date and an end date Between [Start date] and [End date] Works great - question is... how can I put the two dates selected by the user into two...
  5. MilinPCH

    AVI playing irregularly in presentation

    I have a presentation in Director 7 that closes with an AVI that I created / compiled out of 3d studio max 3. I have it set to Direct to stage with music playing at the same time - can't think of anything unusual I'm doing to it that I haven't done to any other AVI. When I run the presentation...
  6. MilinPCH

    Fade Sound Back in after event

    Hello, I have created a presentation in D7. I have a sound file looping in channel 1 throughout the entire presentation. In one section, the user clicks a button and a D7 projector (.exe) launches and runs a new presentation, with the original D7 presentation paused in the background...
  7. MilinPCH

    Unloading a Huge Video

    Hi, I have created a presentation which has a section that links to / runs a very large Quicktime video (300mb). You get to that section from the main menu of another Dir movie (In the "main" movie, you roll over an icon and then click it. on Mouseup you go to the "video&quot...
  8. MilinPCH

    Library Palette in D7

    Hello, I have recently bought a copy of D7 (the box doesn't day D7 Shockwave Studio...just D7). It works fine, but in looking at some D7 books, it seems that in the drag-and-drop library palette (I think that's what its called - where you can drag pre-built behaviors and scripts onto...
  9. MilinPCH

    Relative Path

    Probably a simple question - but I am new at this... I have a small "cover program" that when a button is clicked on it, will launch a movie. both the program and movie are burned onto a cd. Since someone's cd drive could be any letter, how do I code it so it looks for the movie...
  10. MilinPCH

    Premade Behavior Libraries

    Ok - kind of a newbie question, but that's what I am... I (finally) have a legal version of Director (7), but I have been tinkering with a copy of Director 8. I notice that in D7 I have far less stuff in the Library Palette - especially, I'm missing those in D8 for animation. I even tried to...
  11. MilinPCH

    Color Whatever is the Active Field

    Can anyone show me or point me in the direction of how I would write code (a module?) that says something like "if some field gotfocus, change the color to X, on all lostfocus fields, change the color back to default. So - whatever field the user is currently in with their mouse changes...
  12. MilinPCH

    Find Query results based on Dropdown Box choices

    Hi, I have a form that is tied to a query. on the form I have two dropdown boxes - one lists all the possible "names" and the other lists all the possible "ranks" I want the user to be able to select a value in each dropdown to search on, then click a button which will...
  13. MilinPCH

    If-Then results on a continuous form

    Hello, If you care, this is a continuation of a post I wrote on 3/12 about "Inventory Tracking..." I have not been able to make your suggestions work - I think I boxed myself into a corner because of dropdown boxes, format, and subforms. Anyway, this is my new solution to flag...
  14. MilinPCH

    Recommend Me a VBA Book

    Hello This forum has been fantastically helpful to me as an "advanced novice" Access creator - I have learned tons! I would like to ask you all for recommendations for a good reference/learning book about VBA. I am not a programmer, nor do I want to study some 800 page programmer's...
  15. MilinPCH

    Form "Refreshment"

    As mentioned briefly in a previous post, I have a macro button that executes an append query and then a delete query to "save" records that have been entered into a form - actually, these saved records are within a subform. My problem is that when the macro executes and does it's job...
  16. MilinPCH

    Hiding a Macro's Dialogue Boxes

    Hello, I have created a macro that executes an append query and then a delete query. It is executed when the end user presses a button on a form. The macro works perfectly, except I don't want to confuse or labor the user with having to answer all of those "are you sure you want to do...
  17. MilinPCH

    Running a Customized Report from a Form

    I know this is probably a no-brainer, but I've never done it before..I just need to see what the VBA code looks like and I can go from there... I have a product invoice report - based on a query that asks the user for a company name and an invoice date. It works perfectly. What I want to do...
  18. MilinPCH

    Generic Report Runs Only on Specific Form's Record

    I know this is probably a no-brainer, but I've never done it before..I just need to see what the VBA code looks like and I can go from there... I have a product invoice report - based on a query that asks the user for a company name and an invoice date. It works perfectly. What I want to do...
  19. MilinPCH

    Form Opens Automatically if Criteria True

    Hello, I am creating an inventory database. I have a form (based on a query) that indicates if the current inventory is below the reorder point- I am using an IIF statement in my query. What I am trying to do is write a macro that is attached to the startup switchboard form, so that before...
  20. MilinPCH

    String search in a table's field

    Hi, Is there a way I can do a string search in a field of a table using a prompt box? Ex...I have a field in my table of names in a format like, "Mr. and Mrs. George Bush." I would like to set up a query that pops up a box that prompts the user to enter the name/word they want to...

Part and Inventory Search

Back
Top