Search results for query: *

I have a combo-box on my switchboard in which I can select a particular record in a query or table that has an associated OLE (pdf) file. I would like to select the record (aircraft type) in this case and either preview or print the associated pdf file (brochure). So far, all I can figure out to...

Sorry...it does not need to be dynamic. Using the above three fields (color, weight, country), how do I construct a single query that returns a summary value of each recurrent entry or selected criteria? Example: Japan, Blue, 2 lbs. Japan, Blue, 2 lbs. England, Red, 1 lbs. Norway, Green, 5...

I have three fields. One for color, one for country and one for weight. I can see in a query how many blue units were sent to Japan that weighed 5 lbs. I can do that with simple criteria 'blue' under color, 5 lbs. under weight and 'Japan' under country. I can also select another column and pick...

What about a secondary query that totals the records found in the first query?

I'm working with a query and have the following three data fields - color, country and weight. I have selected a range criteria for weight of between 5 and 10 lbs. I can get the query to display that criteria (only the entries between 5 and 10 lbs) but I want to have another field that simply...

Nah,I was wanting the actual checkbox function but it's not critical and I can live with the 'X'. Thanks though! -Jason

Tony: Evidently that's the problem - I was using the active 'X' checkboxes. There's no way to change the Active 'X' size then? I wanted a check-mark but not an 'X'. Any ideas on that?

I cannot make my checkbox in MSWord any larger. I've followed the instructions in the MSWord help index which says to double-click the form field and then select 'exactly' under checkbox size and then specify the size. However, when I double-click the form field, there is no option for size. I...

Never mind! I'm an idiot. All I needed to do was click the picture, click 'Format' and then 'Send to Back'. Sorry for the trouble.... -Jason

How do I select 'send to back' or 'bring to front' for pictures and graphics in MS Access like in MS Word, Powerpoint, etc? I know I can set text box transparencies etc. but my pictures still display in front of them and block them out on my report. I have a blue box with rounded corners that...

Hello: How do I layer pictures in MS Access 2002? What I mean is, I have an embedded .jpg and I want everything else to be in front of it. Watermark or text box transparency doesn't work. The picture (.jpg) still covers the text boxes in my report. I want to be able to select 'send to back' or...

dhookum: YOU ARE AWESOME! Works like a charm! Why are such simple things so difficult!? I've been looking to do this for some time. Hey, are you aware of a book or webpage that I could go to for easy formulas like that? I think a cheat-sheet with shortcuts and stuff would be wonderful. Thanks...

Yes. The details for each customer service comment, then the summary of negatives, positives, neutrals and their respective percentage of the total. Something like this: CUSTOMER FEEDBACK REPORT .......... Comment Disposition: Positive Note: Customer felt pricing was good Comment Disposition...

Leslie: Thank you for the information, but where am I putting this information? In the table or report and how do I open the SQL View...remember, I'm good at structure and function, just not the language part of it. Just to summarize, I want to pull from my 'tblfeedback' the information in a...

MS ACCESS: I have a text field in my table called 'Disposition'. I use a combo-box on a form that picks one of three answers from a separate table for this field. Either 'Positive', 'Negative' or 'Neutral'. Now, how do I count the number of Positive responses, the number of Negative responses...

THANK YOU! THANK YOU! THANK YOU! Both posts above gave me EXACTLY the information I needed. Why isn't Microsoft this easy? Their 'example' to do the same thing had about 2 pages of code and I still couldn't get it to work! I'm definately coming back here. Have a great day both of you. -Jason

Wow! See? I told you it was simple - LOL. Thanks for the post! Trying it now..... -Jason.

OK...now I'm lost. I can't find any table named MsysObjects but when I tried to create one with that name, it said it already existed!? (I didn't replace the existing one). How do I display the table MsysObjects? I'm using Access 2002. Is there a magic button somewhere? My hair is almost gone...

Thanks Paul...I'll try that. I'm OK with Access but not an expert...expect another post later if I can't get it to work! Have a good evening. -Jason

Paul: Lyonmt was asking this question on my behalf. What I really need to do is create a List or Combo box on a form that will display the available Reports I have created. I would like to select one of the Reports in the List or Combo Box and then click a Command Button to print that particular...