Search results

Thanks for response. The real problem is that the date the user enters on the form to run the report is NOT being passed to the query that will retrieve the data. In other words: expr1: [Forms]![HomePage]![NavegationSubform].[Form]![DateofBook] in the field line of the query is not being...

I have a form that is displayed for the user to enter a date. I wrote a query that I want to use this date(parameter) to calculate the number of days from that date. For example: Now()-Max(Date of Distribution,DateAttended) <=180 This would take todays date and subtract the largest...

That did the trick!!!!!! Thank you so much I can't tell you how much I appreciated your help Jim

I have two tables: 1. Client Info table which contains the following fields: Clientid LastName FirstName 2.DatesDistribution table Clientid DateAttended The relationship is one to many for these tables. I have been trying to create a query that will show the following: Clientid LastName...

JHB, I figured out what I was doing wrong. I should have create 3 forms Main form Form 1 Form 2 Then in the Main form I have to DRAG Form1 onto Main form Next I DRAG Form 2 onto Main Form Since all of the items above are forms, I could then set the properties the way I wanted for each of my...

JHB, Thanks so much for responding I am really stuck. When I bring up the main form, it contains the 2 subforms. The first subfom has the Entry prompt with today's date as I want. Does not have any scroll bars or record navigation items, so it is great the way it is. The 2nd subfrom when it...

I have a form that I designed that contains two subforms. The first subform is an entry subform so you can post the current client visits. The second subform I want to just display all prior client visits and make updates or deletions if needed. Now my problem: It does not appear that I can...

Dale, I believe that would prohibit the user from seeing the prior history entries in the visit subfile. You would in effect make the visit history file entry only. Thanks jIM

The main form has a drop down box for the user to find the client record he wishes to add new visit data in the client visit history subfile. When the client is found, a history subfile is loaded which has all of the prior client visits. The history in the subfile contains two pieces of...

Thank you so much you are the best. I really appreciate your help. Jim

The user clicks the client name in the combo box and the subform is filled. I want to set focus to the record after the last record in the subfile(actually that would be and add to the subfile table), Not sure where that event is? Thanks

Thanks that info is helpful. I still not sure how to implement. Which event should I use and what commands, in what order, do I need to code to make this work. Thanks for your reply. Jim

I have a combo box in which the user selects the client he want to update. The top of the form has descriptive data for the client ie. name address etc. The linked subform (on ClientId), below that descriptive data, displays all of the visits the client has made to our pantry. The fields are...

Thank s much for your input. Jim

John Thank you for all your help and most of all your patience with a rookie. I am a volunteer at my church's Food Pantry and was asked to develop a system for them to improve the operational flow. I have never used Access to program before. I am now retired and for many years I was a...

Can anyone suggest a book that I can buy to help a beginner in VB interface with Access 2010. I feel a little lost in trying to understand some of your solutions. Any thoughts would be appreciated. JIm

I am new to access 2010 and never programmed VB to interface with my Access database. I would like to learn how to do this and am looking for some text to help me learn VB as it relates to Access 2010. Any suggestions would be appreciated Jim:o

Thank you both for a direction for me to follow. After I study your suggestions perhaps I will be able to implement the enhancements. One quick question is how do I then return back to the original or calling form? Thanks so much Jim

:confused:I have a form (ClientVisits form) that records the number of family members for each client that visits our food pantry. When the composition of a clients household changes I want to be able to click on a button to call up the UpdateHousehold form to add or delete family members...

I have fields that are set to entry equal NO and access automatically fills the background color to a dark gray. It is very difficult to read the data that is displayed in these fields. After trying various things on the property sheet, it seems to take the change, but when I try and display...