Search results

Thanks for your reply. Why did the control wizard place a picture of a small printer in the button and does not allow me to add text to the button instead of the picture? I do not know VB so your code is a bit intimidating to me. Thanks again for your help

I created a form called "Client Printout" that is a tab on my home page. On this form I created a text box to enter the date as mm/dd/yyyy. I also created a button that when clicked on by the user will print the report. This button, no matter how I try, will only display a small picture of a...

Thanks you always bail me out. I really appreciate your help Jim

I have a subform in which the user enters the number of menbers in his family next to the date that they attended the food pantry. The subform now sorts the data in ascending order on the date attended field and the user enter the next visit date and # family members. I was able to change the...

Looks great. Thanks so much Jim

Isskint, Thank you for your suggestion, I will see if it acceptable to the users. Actually, this example was just a section of a form that took data from a table and used the section I displayed to record food usage for the following 3 weeks. Sorry for the confusion, I just wanted to simplfy the...

________1_ 2_ 3_____________ __1__2__3_ (visits) Beef,Grnd | | | | Juice, Apple| | | | Beef Stew | | | | Macaroni | | | | Carrots | | | | Peaches | | | | When I create a label box to try and enter the above information I am having many problems. If I depress the enter key, to try and enter the...

:) Thank you all for your help. I get it now:)

Thank you, thank you, so much for your help. Am I reading this query correctly? DELETE if there is no record at all in VISITS?is that what NOT EXISTS means? or This is what I'm not clear on: If VISITS has for example 3 records that match Clients and today is 09/01/2012 The records in...

The first table is the CLIENT table: ClientID Lastname Firstname There is only one record per client in the CLIENT table. The second table is VISITS table: ClientID DateVisited (mm/dd/yyyy format) There are many records in the VISITS table, one for each time a client visit. I want to...

Thank you I now have a good road map to follow. I appreciate the help JIM

I am really new to Access so my questions to you may sound lame. How do I know what the error number is, it does not show when I see it. What" VBA goes here" what code should I put there? Lastly, Where does all this code you gave me go, where do I put it? So Sorry for not knowing these items...

Is there a way for me to issue my own more descriptive error message then the messages issued by Access? For example, I defined a unique compound index and a user enters a duplicate, access will display a message like "a primary key or index contains a duplicate ETC....." I would like to say to...

I made the two fields a compound index like you suggestedand that did the trick. Thank you Thank you Thank you I really appreciated your help. Jim

Thanks, but I tried that and it did not give what I needed. I can have the same date in the table, but I cannot have the same date for the same Customer in the table. 'Thanks so much for your thoughts Jim

Yes it is set up as a datasheet and now seems to be working just fine. Thank you so much I really appreciate all your help. I put up a new post regarding an issue with dup dates maybe you could give me your thoughts on that issue Again Thank you much Jim

Context: I have two tables a Customer Master and Attendance Master The Attendance Master is a subform within the main form. The user will select the customer to be processed and all the dates that the customer has attended will be displayed in the subform. The subform is now added with the new...

It seems that scroll bars only appear on the form when the are needed. What I mean is, once I added enough records in the subform, the scroll bars then appear, because they are now needed. I am programming in Access 2010. Can anyone confirm this guess? Thanks JIm

When I look at the main form and look at the subform area in design view I do not see any scroll bars??? But the subform does in fact define them. Perhaps I did not design the main for correctly to contain the subform?

the subform does have scrollbars = Both When I look at the properties of the main form in the subform area it does not show a scrollbar entry other than scrollbar align which is set to system The data for the subform comes from a query that I wrote and displays all subform entries wih a matching...