Search results

Adp I am working with an .adp. Is there anything I can do to disable the shift key in this case?

Which method is better? ghudson: which is the better way to go, the tool or your code?

Thanks, Gumby. I have not been able to look at it again until today. The part about the active x is indeed greek to me. If you can dumb it down a little more, I would appreciate it. Take care.

Thanks for taking a look at this, GumbyD. The question fields are labeled by survey section (i.e., II), then by competency (i.e., Comp1), and finally by a keyword in the question (i.e., curr=curriculum). The datatype on the question field is long integer (although I am not sure why). Re: my...

I have attached two screen shots as the db is too large to send. Let me know if there is anything else I can send. Thanks so much for your help.

I already posted this under reports and was directed to queries; sorry in advance for reposting, but this post will be more specific. I have a table with one field for each of 75+ survey questions. All survey responses are either 1, 2, 3, 4 or 5. Ultimately, I need a report that will tell me...

Help I have tried a group by in my query but am unsure what field to group by. I want to find out what percentage of respondants answered 1 (or 2 or 3 or 4 or 5) to each of the questions. I have not been able to figure out how to organize a query to get this data. All respondants are...

Where do I start?

I have a form that collects student survey responses to about 75 questions. Each response is a value between 1 and 5. What is the best way to get averages, counts, and other statistics from the table?

No luck. The issue isn't the page being too wide (I can drag the right edge to 4''), but rather the inability to place headers over the second of two printable columns. I am stuck.

I did that. As soon as I add more headings to the page header, the page gets wider, so I end up with data under the first Name/Phone heading pair, no data under the second, data under the third, etc.

I tried doubling it, but that only made the page wider.

How do I create a subreport?

I have a simple report of names and phone numbers. I have used the page setup to put them into two columns to get as many on a page as possible. Is there a way to repeat the headings "Name" and "Phone Number" at the top of each column? Would I be better off exporting this to excel or word?

Thanks. I hadn't renamed the control to match the control source name. A rookie mistake.

Thanks. I hadn't renamed the control to match the control source name. A rookie mistake.

I am trying to make certain controls visible on a form for both "on current" and "after update" conditions. I started with this: Private Sub Form_Current() If Item = "Monitor" Or Item = "Printer" Or Item = "Telephone" Or Item = "Scanner" Or Item = "Workstation" Then SerialNumber.Visible = True...

Here it is.

Rich: Thanks for pointing me in the right direction. I have read a number of articles this morning, and I am spiraling into an abyss of confusion. Thinking I understand the five normalization rules is one thing; being able to apply them to my tables is another. I have attached the db. If...

I have an invoicing form (frmInvoice) for computer purchases with a primary key of "InventoryID." frmInvoice has a combo box where I identify the type of equipment purchased (i.e., monitor, printer, tower, etc.). I also have separate tables for each type of equipment where I store the...