Search results

James That is not a very polite reply. Here you have someone who is willing to help you and simply asked a question that may be beneficial. We don't get paid here at AWF. We do it simply to help others who are new at the game. I hope your future replies contain some respect.

The solution is don't do that. Your design of the tables in question and I would assume the other tables are all wrong. Can you post a pic of your relationship window.

If that is not the answer have a look at the default file locations. They could have been played with by someone who shouldn't be touching things.

Thanks Brian but that is not it. Tomorrow I will build a new Database from scratch and try again. It is too close to my bed time to start now.

Brian You are correct. I also have 2007 for AWF and for testing. I still don't like it. So no Brian it is not a mistake. Thanks for pointing it out though.

You will have to put the Format code back into the Query. I cannot save while it is there. A Copy of the code is in the Remarks of the table. Now this is strange. I opened this post in advanced mode and got all these </p>. These do not show up when the post is displayed. Perhaps I have...

I get an error message. It says that it contains a syntax error. Could it be because I am Formatting a Field that I got directly from the Table. I will send a copy in a minute or two. Just need to cut this one down.

I have no idea what I am doing wrong here. I have a Query. DateTracked is a field from the Table. It is of Data Type Date/Time, Formatted as Medium Date. There are other Fields. Like Breakfast, Lunch and Dinner. Problem. I want to display in a separate Column "DateTracked" as a day of...

I don't believe you can do that. What you have is a single Form that is repeated/Displayed many time. If you change the design you are changing the only Form, so naturally what you see is the new design repeated.

Lookups should not be used in Tables. Get rid of all of them. Lookups are good when used on a Form and nowhere else. You could Google "The Evils of Lookups" if you need a full explanation.

You could try using the wizard to build the Combo for you. This may help. Column 1 is the second Column. Column 0 is the first.

Guys I believe that I have misunderstood the problem. Therefore some of my advice is incorrect. YPMA has the correct understanding and is just a little way off solving this problem. I shall now proceed to stand aside and watch you sort things out.

I downloaded twice for each file. Did not have a problem.

This file is just for testing.

ypma I downloaded both attachments. The first I could not open because I only have Version 2003, and I opened the second successfully. The second did not show at that time a count of downloads. I still do not see the purpose of the Database. What do these figures represent. Cars, sheep...

ypma The testing I was suggesting was to upload the Database and display it as though you have finished your post. Then download it to a Temp drive of your own and test that it opens and does what you want. If you have done this then you are one of the better few who does this. Back to your...

ypme I did not intend to push you out. If you have something then please jump in. I think we are going to end up with a Cross Tab query which I am not very good at. Perhaps you could handle that part of the solution..

Try this; Meals: [Breakfast] & ", " & [Lunch] & ", " & [Dinner] Your sample had a group of 3 so that is what I catered for. If you want anything up to 18 groups then I do not know how to do that. But I can say that I feel that your design is incorrect. I would need to see the table before...

Not quite. Just use the before update. The after update has nothing to do with saving. Best to do a search as this has been explained better by others.

I could not open it either. One should always test any upload by doing a download and proving that it still works as intended.