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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. bllgnn

    Flash MX2004 Slide Presentation back/forward

    Never mind. I figured it out by trial and error. An undocumented feature is that with a parent and child relationship, only the child will appear. A parent never appears. So, to show the incremental steps, a parent (Step1) has to have two children: one identical to the parent (Step1A) and...
  2. bllgnn

    Failing DLookup on subform

    Hi dz, I'm amazed I found your reply almost 2 years later Are you still here? Bill
  3. bllgnn

    Flash MX2004 Slide Presentation back/forward

    Here is the ActionScript from the Template: Tech Slide Presentation. Would someone kindly give me a rough translation in everyday words as to what is happening here in this code? Maybe then I can figure out how to play many slides with one child in many generations one after the other...
  4. bllgnn

    Flash MX2004 Slide Presentation back/forward

    Can someone please point me to some documentation regarding how to get the next or previous slide to show? I have tried using a Template (Tech Slide Presentation), but if I insert a nested screen, it does not show its parent. I want to create a slide show showing how something is built...
  5. bllgnn

    How can user enter info on one-to-many query/form?

    Richard, That is the road I will follow if my current way fails. As you said earlier, there is usually more than one solution. I realized I was dealing with a snaphot of transactions that cannot be edited, so I created a new table from the snaspshot, added a field for user input and and then...
  6. bllgnn

    How can user enter info on one-to-many query/form?

    willir, Yes, and that is why I came to this great forum for advice. I have described, in simplist terms, what I want to do, Maybe someone else has some ideas?
  7. bllgnn

    How can user enter info on one-to-many query/form?

    willim Thanks. Your main/subform would be great for viewing all the parts in a transaction. In my reference to the one-to-many join, I mean all the transactions with the same PartID are being added together to create one row of data with PartID, Sum Of PartsIn, Sum Of PartsOut and...
  8. bllgnn

    How can user enter info on one-to-many query/form?

    willir Thanks. I'm not sure what you mean. What whould be on the parent form and what would would be on the child form?
  9. bllgnn

    How can user enter info on one-to-many query/form?

    I have a form based on a query that shows PartID, UnitsIn, UnitsOut and, a calculated field, UnitsOnHand from a query with tblParts and tblTransactions with a one-to-many join on PartID. The form shows the data on one row per PartID. I want the user to be able to enter the actual physical...
  10. bllgnn

    Failing DLookup on subform

    I was having the same problem until I read the post from FoxProProgrammer whose code included Chr(34) before and after the reference to the control. DLookUp("FilmType","qryFilmAll","FilmID = " & Chr(34)& cboFilmID & Chr(34)) Adding Chr(34) before and after the...
  11. bllgnn

    Selling my application on the internet

    I've developed an application in Access 2000 as a hobby but now it is looking like it might have mass appeal. However, I just realized that only owners of Access would be able to use it? Is this correct? If so, what would be the best way to proceed from here? Stop and rewite it in...
  12. bllgnn

    Combo box default selection

    Thank you. That works beautifully!
  13. bllgnn

    Combo box default selection

    I have a form with an unbound combo box and I want it to show one of the items on the list as a default selection when the current record appears. How can I make it show say, the second record in the conbo box?
  14. bllgnn

    Requery form using option buttons

    Sorry, my fault. Somehow, I had put my procedure SortOptions() into the BeforeUpdate event of the option box frame instead of the in the OnClick event. I should have noticed this earelier. It's working fine now. Thank you both for your help,
  15. bllgnn

    Requery form using option buttons

    No, I do not have any code in a BeforeUpdate Event.
  16. bllgnn

    Requery form using option buttons

    I'm having trouble trying to set a new RecordSource and Requery my continuous popup form called pufrmOrderParts. It's a simple form listing PartNumber, Part Description, etc. from tblParts. I'm using 3 option buttons and each one has a different query as a RecordSource for the form. The only...
  17. bllgnn

    How to show/hide flagged records

    Hi KenRaey, This is getting over my head. What do column names have to do with it? I have spent hours trying every variation of your idea I can think of. Surely I am not the first person who wanted to show/hide records with a yes/no flag. Can anyone tell me how to do it?
  18. bllgnn

    How to show/hide flagged records

    Hi KenReay, Sorry, there was a typo in my last post: I get an "Enter Parameter Value" for chkShowAll twice should read I get an "Enter Parameter Value" for chkDiscontinued twice
  19. bllgnn

    How to show/hide flagged records

    Hi KenReay, Thanks for the help, but I'm still having problems. When the form opens, it shows all records, which I can understand because chkShowAll has not yet been checked. When I check chkShowAll after the form is opened, I get an "Enter Parameter Value" for chkShowAll twice...
  20. bllgnn

    How to show/hide flagged records

    Each record in my table has a Discontinued field (yes/no). I want to give the user the choice of seeing the Discontinued records or not,with a checkbox of the form chkShowDiscontinued. I have tried a few methods, but none of them work. After the user makes the choice on the form, what is the...

Part and Inventory Search

Back
Top