Search results

Primary key I have several sub databases, each with information specific for a certain section (physicians, cases, etc.) These are linked to a master DB so the principal person can analyze data across sections as a group and come up with aggregate data. tblPhysician has an autonumber as the...

Mile, For my own knowledge, what would you recommend, an unbound form with the different actions that could be taken vs. the checkboxes they want? The case number would have to be the PK, and then numbers for each option maybe? The way it works is multiple actions can be chosen for each case...

Sometime I have no control over the way a database is set up, or a new one needs to be set up. I know many of the databases I work on should be normalized, however, I am told not to change them so I have to work with what I have within those constraints. Not the best way to do things, but...

I have a group of 5 fields, each which are yes/no (as directed by the head of this project). They are actions that can be taken on a problem; multiple actions can be taken. I need to query and count totals on each action. I have done a query - if A or if B or if C.... but how can I do a count...

Pat, I used your suggestion and used the parantheses, everything is working fine and is more readable. raskew, when I tried your suggestion I got subscript out of range, and was taken to the Case 1 line of code. Thank you both for your help.

It does. The sixes mean "can't do it". The questions are like: 1a Walk 50 feet, 1b Walk 100 feet, 1c Walk 150 feet. So, What happens is if 1abc get (eg.) 1's , do the whole calculation. If 1bc get 6, Don't calculate, =0. If 1a = 1 and 1b=1 but 1c=6, then do a different calculation, which...

Input mask error not date Several threads address generating a custom error message for the form for things like date. Is there a way to generate a custom error message for a specific field that uses an error mask? For example, the ID number must be 7 digits, using leading zeros if necessary...

Thanks, it works, but I was looking for a "neater" way to handle it should I have to do something like it again.

Can someone show me the correct way to change the If Then statement below to a Select Case? Function CalcPreSpeed() 'Calculate the Pre speed using the formula (sum/57.5)*100 Dim iQ3A As Integer Dim iQ3B As Integer Dim iQ3C As Integer Dim iQ3D As Integer iQ3A = Forms!frmMain!PreQ_3A iQ3B =...

I have a macro that looks at 3 fields, 4a, 4b, and 4c. If 4a=6 & 4b =6 then the total field (4total) shows the message "You have entered 2 sixes, no calculation will be done." and fills in a 0. Great. However, if I then go to do that for 4b=6 & 4c=6, then it still calculates the 0, but can't...

Next phase. I have a case table (PK case#). At each meeting, (PK MtgDate,MDID) several cases are reviewed (and a case can be reviewed at more than one meeting). Best way to get something like qAttendance filtered by a date the user enters that lists the cases the attending docs who reviewed...

Thanks Pat, your solution was perfect and the additional aspects you addressed made for a great learning experience!:)

I have 3 tables, tblPhysician, tblMeeting, tblAttendance. tblAttendance has the joint primary keys of tblPhysician (physID) and tblMeeting (mtgID), along with a Y/N field for "in attendance". What the users want is a form that lists the date of the meeting,each physicians name (the names are...

OK, how can I send focus from that subform to the field on the other subform then?

On the OnExit event of subfrmVitalsRev I used Me.frmMainRevised.subfrmLabEmotRev.CBC.SetFocus. I keep getting sent back to the first field in the subfrmVitalsRev. Note: I do have the cycle property on that subform set to current record and don't want to have to change that. Any ideas?

Could someone tell me how to set the focus for this scenario? Main form is frmMainRevised Subform 1 is subfrmVitalsRev Subform 2 is LabEmotRev (with the field CBC I want to go to from exit on subfrmVitalsRev. Where to put the code, and what references to use, I've tried everything I can think of!

Thanks Pat! Works like a charm if you are designing from scratch without a wizard, which most of the time, I am. If I have to modify an existing form, then the suggestion for multiple select and change text alignment works fine. Thanks all!

Tried the autoformat. That seems to apply to font, color, and background, not alignment. It seems as if the default alignment for text is left aligned, but for numbers is right aligned, and I need everything to be left aligned without having to go into each and change it. Any other suggestions?

Yes, I know this, but is there a way to default it so when you create a form all the boxes would be text-aligned left at form creation?

Is there a way to default all text box alignments to left instead of general in an Access 97 FORM? Thanks!