Search results

Another question. Staying with the suffix example, should something that mundane be in its own table with an AutoNumber as the PK and the suffix as a field or should it just be a Value List combo box in a form? I lean toward a tbl of its own for ease of updates for a suffix I might not have...

Thank you very much for your input. I am reconfiguring my tbls now. I think those lookup fields are the whole reason I am having to revamp my db in the first place. You have helped me immensely and I cannot thank you enough!!

Perfect example: In tblPERSONNEL I have a 'Suffix' field. Should that field be a Combo Box Value List with Jr;Sr;II;III;IV;V; etc or should it be a straight out text field with a combo box included in the data entry form and a table relationship established?

I suppose what I mean is when creating a field in a tbl, shld that field be bound to another tbl, or shld it just be a txt field? I know I want a fk in most of my tables to relaye records, but am not sure if I shld just bidn them thru relationships and/or queries or thru look up. I suppose you...

I have a db that I am revamping. My question is more along the lines of proper development procedures. Generally speaking, is it better to include combo boxes programmatically in the tbl or should all combo boxes be incorporated in frms only? Does having a combo box in a tbl cause problems...

You are an absolute genius! That worked like a charm. Thank you so very much for your help.

Actually, the query is tied to a print yes/no option. However, the report should return employee regardless if there has been an incident or not.

I really appreciate your help. However, I tried the above steps. Same result. Removed incident info from main report. Tried both DISTINCTROW and DISTINCT in the SQL view of the query. Still does the same thing. Main report is linked to sub-report via Empl#, not incident number. Could that...

Why, yes...yes I do. One listing of Empl# and Empl name for every incident.

Source: Report.subCHRONO_FILL (name of the sub-report) Master: Empl# Child: Empl# Does that help?

Confused. Source object?

I am grouping by employee number. I need a printout of each employee with a complete listing of incidents. Do you think I should group by incident number? I will give it a try. Thanks!!

I have a report with a sub-report that lists incidents. Basically, when an employee has an incident, it is recorded in one table. The report is built off the main personnel table and the incident table through a select query. The problem is this, the report runs fine and displays everything...

I have a report in which I have data displayed in a spreadsheet type format based off of a cross-tab query. The top row headers I have set to vertical, but the text is diplaying "upside down" so to speak. The last letter of the label is at the bottom of the label box, and I am trying to get...

Will do. However, I am no where near the Access Master that you are. If you haven't figured it out, chances are I won't either. I will try, though, and if I get it, I will post it. Thanks again.

I was more commenting on the help you have offered me on more than one issue. Perhaps the system would stand. This is by far the best forum I am a part of. honestly, I have stopped using all the others. As to my previous question, I appreciate the help/info. The question then becomes, is...

In this, my naming convention will be altered in that I will have to remove all of the underscores and replace with spaces. I thought this practise was rather taboo in Access. Will there ever be a time where this will cause an issue when renaming my reports? I know it would never work for...

I have a secure db and am trying to use Mail Merge. Each time I try to connect, I get the same error: "You do not have the necessary permissions to use [the db (.mdb)] object. Have your system administrator or the person who created this object establish the appropriate permissions for you."...

Ha ha!! That makes me feel better! I appreciate your help. I will try to better audit my code before posting my inabilities on the internet. Ha ha!!

Why, yes I did. I feel completely inept. Thank you for showing me the error of my ways. I suck!