Search results

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

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