Search results for query: *

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...

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

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...

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...

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...

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?

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...

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?

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...

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...

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...

Thank you. That works beautifully!

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?

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,

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

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...

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?

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

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...

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...