Search results

  1. J

    expression is too complex message?

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

    expression is too complex message?

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

    getting the most current date for each client

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

    getting the most current date for each client

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

    dealing with customized subforms

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

    dealing with customized subforms

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

    dealing with customized subforms

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

    eliminate scrolling to find add a new entry

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

    eliminate scrolling to find add a new entry

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

    How do I position cursor in a subform

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

    How do I position cursor in a subform

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

    How do I position cursor in a subform

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

    How do I position cursor in a subform

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

    Question Can anyone suggest a book to lean VB

    Thank s much for your input. Jim
  15. J

    How do I call another form

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

    How do I call another form

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

    Question Can anyone suggest a book to lean VB

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

    How do I call another form

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

    How do I call another form

    :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...
  20. J

    how do I change the background color on a NO entry control

    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...
Back
Top Bottom