Search results

Hi, I have a database set up that we will use to record patient information when our normal system is down. I have a form set up where they enter all the information. I then have a report set up that will ask them for the patient account # (assigned on the form) and will print a sheet of...

Do you mean you want certain fields to 'appear' only if they answer a certain way, and different fields to 'appear' if they answer a different way?

Hopefully I can explain myself right. I have a table Student_Table set up with information about students...ID, name, DOB, etc. I then have a separate table Visit_Table where they will enter information...date, visit type, etc....about the visits a student makes. On the Visit Form, which...

Thought of another question as I was drawing this out on paper. I originally had planned to put somewhere in the user profile whether or not the user had email, network logon, etc. Where is the best place to do this....treat them as another application? Thanks!

Thanks, Pat...I'm glad I asked before I got too deep into it, or I probably would've had a mess. Couple questions for you. You had noted to make my ApplicationID and FunctionID a autonumber. Would it make a difference if I used a 2 character field? All the applications have an ID unique to...

I'm not really sure where to start with this, and don't want to attempt something only to find out I'm completely wrong. I'm trying to set up a database to show the functions users have access to on the multiple applications we have here. I'll have one table for general user info...name...

Ok I have one form called Call_Add_Form that opens in add mode from a switchboard button. That's the original form where they enter information about the call, and where the status is originally defaulted to "Open". Then I have another form called Call_Close_Form that opens in edit mode from a...

I have a field called "Status" in a call log that defaults to "Open" when you first enter the call. I have another form that is used to close the form, and originally I planned for the user to just change the field from "Open" to "Closed" from the dropdown menu. But they are not remembering to...

I have a database set up so that the switchboard opens first, and the user does not see the database window. I'd like to be able to make the switchboard maximize on open, but there's a lot of code all ready in the events section for the switchboard, so I'm not quite sure how to do it. I used a...

I finally got it working. Yes, EquipmentSerial was the name of both. But I had several fields that, within properties, the "Name" and the "Field" said different things. I went through the whole form, field by field, and corrected them all. And now my form runs perfectly!! Thank you thank...

Ok, well thanks for all your help! I wouldn't have got this far on my own!!

It highlights the Me("EquipmentSerial").Visible = False line. I had someone suggest to move it to the AfterUpdate field instead of the OnChange, but it makes no difference.

I realize I'm a huge pain. I know absolutely zilch about VB and got totally thrown into this. They bought me a book and figured I could wing it! One more question and I'll leave you alone. This is the code I have now: Private Sub OccurrenceCategory_Change() Dim ctl As Control...

That was exactly my problem, I was spelling it occurrance instead of occurEnce. Thank you. Now, however, once I pick a choice from the combo box, EVERYTHING ELSE on the form is invisible, except the combo box I'm in and the 1 or 2 fields I've set to be visible. Am I a major pain or what?

Thanks again, Doug. I put in the line you suggested, but still got the same set focus error. ?!?!?!?!?!?

Thanks Doug! One more question for you. This is the code I entered: Private Sub OccurrenceCategory_Change() Dim ctl As Control For Each ctl In Controls If ctl.Name <> "OccurranceCategory" Then ctl.Visible = False End If Next Select Case Me("OccurranceCategory") Case "Fall"...

I have a combo box called OccurrenceCategory, and several text boxes following it. I want certain text boxes to be visible depending on which value is picked in the combo box. For example, if "Fall" is the choice made in the combo box, I want the "IfFall" text box to be visible. For all other...

Well I understand what you're saying, but I'm not sure exactly where to enter this select statement. Within the macro? Sorry, I'm a bit dense today!

I have a form and just figured out how to get a pop-up form to open if a certain answer is entered into a field. But so far I've only had one option per field that needed a pop-up form. I now have a field (combo box) called OccurrenceCategory that the user can pick from one of several options...

Also, my VisitorInfoForm won't let me add any info to the fields once its open. My allow edits, deletes, etc are set to a YES so I don't quite understand that one. Also it's set to dynaset and not snapshot. Thanks!