Search results

I have a form that has a subform in it. Both based on queries and two seperate tables to store the appropriate data. I want to create a report from this data. I started to put my query together and clicked the run button to test it and the query works great. Then I added criteria for the...

That sounds good Rich. Im gonna try it. The other code didnt do anything. Thanks.

I have a Query that uses criteria from an Unbound form to select information to then view a report from. You select the information on the form and I have a button to view the report. What I want to do is once the report is opened, then to close the information form. Im having trouble doing...

I tried a lot on that page and can get none of it to work. My database isnt liking the "Const" Property. Any suggestions?

I posted this in the General Forum. Dont know if that was the right spot so Im trying here. Please dont offend. I want to add a sound for when someone quits the database. Sound File name - ByeBye Ive tried adding this to the Event of my Quit Application button. Me!ByeBye.Action =...

I want to add a sound for when someone quits the database. Ive tried adding this to the Event of my Quit Application button. Me!ByeBye.Action = acOLEActivate I inserted the sound file into the form. But it does nothing. Could I bother someone for some help with this? Thanks

I have a main form and a subform. This is all based on three tables in a many to many relationship. When I go to input data into the form and subform everything works great. I click to the next record and go back and the data is there. I close the form and reopen it, the data is gone. I opened...

Hi, Im having a similar problem. What was your cure for this? Thanks.

Oh sorry Pat if youre a female. Not been around long enough to know. I dont think she cant help me, I think she wants me to figure it out on my own. But Im really stuck on this. Thanks for trying. j

I have been receiving help from Pat Hartman and Im really close on solving this issue but im thinking he gave up on me..... Maybe this can help you out on exactly what I have here: http://www.access-programmers.co.uk/forums/showthread.php?threadid=39000&goto=newpost I figured out how to...

Relationships and Queries I created a simple 3 table relationship. The third table is a junction table. All three are related to each other. Now I built a query for a subform. I put the subform into my main form. I went to add data into the subform and this error popped up: Cannot add...

Pat, If you could please help me once again with this I would be very grateful! Im almost there with understanding how the many-many relationships is working. I built the database exactly the way you say to. I have trouble with linking the two tables together in the query for the subform. I...

I need to smack my head against the metal cabinet corner For the subform query this table has me confused: tbl Daily Foods How can you have 2 primary keys in the same table as you diagrammed? DailyID - Primary Key - Field 1 FoodID - Primary Key - Field 2 Thanks for any clarification

Please help....getting desperate....

Now that Ive got the formula to work in the subform thanks to all of you, how can I get the formula to sum up in the footer of the subform? Ive tried these 2 to no avail: =Sum([Combo14].Column(2)*[Servings]) and =Sum(Nz([Combo14].[Column](2)*[Servings],0)) I keep getting the pesky #error...

Sweeet! Got it! The field that the data was being stored was called Food. The combo box itself was Combo14. Thanks, would of never saw that before this forum. J

Just tried got the #Name? error. I think im outta luck here. Thanks for advice j

Thanks for the replies but neither way worked. I tried column numbers 0-3 and all came up with the #error or Name# Are there any reasons why this would be? Thanks. j

I have a combo box and a text box. The combo box has 2 columns. I want to multiply one of the columns from the combo box and the number that is in the text box. Heres the formula Ive been trying to get to work and dont know why it isnt. =([Food.Column(2)]*[Servings]) and tried...

Pat, I seem to have a mental block here: Once the subform is created and I have a combo box inside with the food and calorie count Food = Column 1 Calorie = Column 2 How do I go about creating the formula to add up the second column in the subform. So far I created a unbound box for the...