Search results

ok I don't know if I need a snack type table and a snack ordered table. The type of snack they could ask for is infinite so I would just have them type it in. Would that mess anything up? Also is there a way for the ID on the master table to automatically be the same as the linked ID for snacks...

Ok so I think I did it right. I have snackID in the master list. Another snack table with the primary key, snack type and snack time. I have "snackID" from the master list linked to the primary key from the snack table. I still can't seem to get a form where I can pick a patients name from a...

Would this work the same if one person was getting 2 10AM snacks, another getting one snack at each time and another just getting one snack at 3pm?

What is the best way to design a form to add snacks to my 10am, 3pm and HS snack tables? I need the name and room number in the form to know who I am adding data for since my snack stables only have a key and foreign key linking it to the main table. Preferably, it would be one form to add to...

Sorry they are set up the same way. I was trying this one of 2 ways. Either have 10amsnack 1-3, 3pmsnack 1-3, HS snack 1-3 on the master table and use the above code to hide the irrelevant results. Or have a separate table for 10am, 3pm and HS snacks, create a query to join the room number and...

SELECT [Master list].room, [Master list].PatientName, [10amsnack].[10am] FROM 10amsnack INNER JOIN [Master list] ON [10amsnack].[Pt ID] = [Master list].ID;

I think you can just open the old database files in Access 2010 and then save them as the new version.

Not sure of how to best show you. I uploaded a screen shot of the 10amsnack query and the others are set up the same.

Thanks for replying. I have tried that. The problem is that I have 3 snack times 10am, 3pm and 8pm. Some people do not get any snacks and some get multiple. I have to have a separate label per snack. I end up with 3 separate queries that I do not know how to put on 1 report. So I was hoping that...

Perfect! Thanks

I may be going at this the wrong way but I have this code in the onformat event under details for a report: If IsNull(Me![10amSnack2]) Then DoCmd.CancelEvent I am trying to make labels for snacks but if the snack field is empty I want it to skip to the next record so that I don't waste my label...

I have this statement in the control source of a text box =IIf([room] Between 100 And 220,"9AM","10AM") Which is basically what I want to do but I didn't think about the fact that some rooms are 101a and 101b. How can I rewrite this to work with these rooms? Is there a way to write it so 9AM...

Hi, I have been trying to figure this out for awhile. I know the basics of Access and nothing about codes. Basically what I am trying to do is make one label report from multiple queries to save time and paper. My queries are based off of 3 tables I have for snacks. 10AM, 3PM and 8PM snacks. I...