Search results

  1. C

    Filter Subreport based on Deacon's ID

    Can anyone help with this? Let me know if you need more info, or need me to clarify...
  2. C

    Form is slightly broken at start up

    Hello, I have a member's detail form that shows all the information we have on a member. At the top is the member's name set up like a title; the control source is set up as "=[GoesBy] & ' ' & [LName]". There's also a drop down that shows all the members, so you can select a member to go to...
  3. C

    Filter Subreport based on Deacon's ID

    Oh btw, I feel I should let you know how a few of the tables are set up... MembersTable - EnvNum (PK), connected to FamilyTable via FamID# (Many - One) FamilyTable - FamID# (PK), connected to DeaconTable via DeaconID (Many - One) The MembersTable and DeaconTable are not connected directly. For...
  4. C

    Filter Subreport based on Deacon's ID

    Hello, So I have a form that shows the member's information; and there's a tab for if the current member is a deacon. If he is a deacon, this tab will become available (which I was able to get set up, for the most part) and show all the families assigned to that deacon. The sub report does...
  5. C

    Last Modified Date

    Ok I'll try that thanks!
  6. C

    Last Modified Date

    Hello, I was wondering how do I set up a field so that when the record has been modified, the field is automatically filled in (or replaced) with a date? In other words if I open up my member's detail form, and go to Sally Smith and edit her information on 11 July 15, that date is saved into a...
  7. C

    Usable Calendar Form

    Thanks, I was hoping there was an easier way to do it. I don't know VBA and what I have been able to do so far is just modify what scripts I've found through tutorials. I'm taking VB in the fall, so I'll work on that part then. Thanks again for the help.
  8. C

    Usable Calendar Form

    Do you by chance know how I can make the "frmAppointments" form display a message if someone tries to schedule an appointment for the same time of an existing one? (Apparently the Start Times are unique identifiers)
  9. C

    Usable Calendar Form

    Ok, I was dumb it wasn't an add-in. I imported it and it works great! Thank you so very much!!
  10. C

    Usable Calendar Form

    Is it an add-in? I assumed it was and saved it in the add-in folder, but when I try to use it I get a pop up: "The add-in could not be installed because it is missing a USysRegInfo table." In the mean time I'll try opening it as a regular database and see if that gets me anywhere. Thanks again!
  11. C

    Usable Calendar Form

    Thank you!! I'm in the middle of something right now, but when I finish up I will check it out. Thanks for the help!
  12. C

    Usable Calendar Form

    Well, mostly it would be the pastor, the youth minister, the secretary, the music minister, the children's minister, and the head of each of the 14 committees we have (so they can add their meeting date/time, and any other events they have planned/proposed), and of course myself. They would all...
  13. C

    Usable Calendar Form

    This is for my church, and currently most of the people who will use it don't have Outlook. As far as I know only the pastor has Outlook. The pastor wants to be able to track everything in Access (and I do mean EVERYTHING). I haven't really talked to him about the calendar, but I figured he'd...
  14. C

    Usable Calendar Form

    Hello, Can anyone point me in the direction of a tutorial or add-in for a calendar? I thought about making one with a form, but I don't know enough to make it automatically generate the dates each month. Ultimately what I want is a calendar that shows a colored symbol (or one symbol with a...
  15. C

    Filtering out a based on a filled field

    That works perfectly! Thank you!
  16. C

    Filtering out a based on a filled field

    Hello, I have a form that I want to filter out certain records based on if a field has data in it or not. I tried using a macro and putting the field equals "IsNotNull", but that didn't work. I just asked me what "IsNotNull" is suppose to be. Can anyone tell me the correct way to do this via...
  17. C

    Date is incorrect

    Thanks! That works perfectly!! XD
  18. C

    Date is incorrect

    So I have to text boxes, one for month and one for year. Below is the control source for each box. When I go into Report View, I get January 1905....This is definitely NOT January 1905....I've checked the date on my clock, it says today's date... Can anyone tell me what's wrong...
  19. C

    Autofill Form base on first and last name

    Hello, I've got two tables, Member & VBS. They are linked (many to one) via the EnvNum. I have a form that has all the information I need for VBS. I was wondering how could I go about typing in the first and last name (each in their own field) and having access find the EnvNum and...
  20. C

    Drop down shows both columns when selected

    Got it! Thanks! (Sorry for the late reply, was sick yesterday)
Back
Top Bottom