Search results for query: *

After searching around, I found and used this SQL in my query. It works; however, I have a new problem in that my report information is cut-off (truncated). I'll have to write a new question for help on that. SELECT DISTINCT Table1.ID, Table1.KSAQ AS Expr1, Table1.DSAQ AS Expr2 FROM Table1...

Amicron - Thanks for your response. Based on your suggestion I built a sample DB using your scenario and SQL. I inserted the WhereStr code as a general declaration, and SQL statement into the query and get the following msg when I try to run it - "invalid outside procedure". Also, I don't...

I've designed a Form (Form1) in MS Access that contains multiple checkboxes representing general skill areas and a Command Button. I also have a table (Table1) that has three columns populated within in it, i.e. ID, general skill area (Gska), and detailed skill area (Dska). I also have a Query...

I solved the problem and this thread should be closed. I appreciate everyone's input and effort. Thanks.

SkipVought - Yes, my UserForm name is TestForm. rmikesmith - I understand about the data range comment and used the code as originally suggested. combo - How can I test if the row pointer is pointing to a row in the spreadsheet? I appreciate all the help, I'm really trying here. Any other...

Thanks Combo!, I appreciate the leg-up on the code. Ok, I'm getting a run-time error '1001': Application-defined or Object-defined error. The debugger is pointing to my Macro command below: Sub Show_UserForm() TestForm.Show End Sub I think the problem is in the SetSource code? Don't...

I am trying to design a Userform that I can advance through existing spreadsheet data with Next and Previous command buttons. Data was originally entered into each cell of the spreadsheet. The spreadsheet has three column headings – “NAMES”, “ADDRESS”, and “PHONE”. The Userform has three...

I am also looking for a solution to a similar problem. The data is already populated in the spreadheet, and I'd like to open a UserForm to display, scroll through rows, and edit cells in that row. Any simple examples would help.

First, I really appreciate all your help so far. I may be over-complicating this for my purposes. I've decided not to try and do this as part of this query. When I could not get your SQL statement to work, I tried disecting it to understand the structure, etc. Admittedly, I'm over my head...

I can't figure-out how to incorporate the expression you suggested into my SQL statement? Whenever I try changing "valuefield" to either the field being summed (OBL) or the new field (TLVAL) in the query, I get syntax or other errors, etc. Below is my original SQL - can you please help...

I have a MS Access query with a total value sum field (tlval) that returns dollar values in varying string sizes, i.e. billions, millions, thousands, etc. How can I reduce the length of the string? If the dollar value is in Billions or Thousands, I want to both round down and show these...

What is the best way to link and show the results from an MS Access Query in Powerpoint? Ideally, I'd like to execute and bring-in (import) the query table w/vertical scrollbar after a click command in PPT; however, I can't find any solutions close to what I need. Too many records for a...

Thanks again PHV - it worked like a charm, and I was able to expand it to cover more kinds.

I'd appreciate just one last bit of help with counting-up 3 different entries in an additional field in my table named "KIND". Kind info can be "1", "2", or empty (null). What's messing me up is trying to specify the value to be counted-up - Can you please help me again. SELECT CUSTNm...

Thanks! - It worked great!

I'm trying to use MS Access Query to aggregate "count" and "sum" contract data for each customer. I have six customers, but thousands of contracts. The field names are "CUSTNm", "CONTNo" "$VAL", and "$BAL?. Is there any way to design the query or SQL Statement so it returns six row showing the...

I have a map on a PPT slide and list of office names (text boxes) on the right. I am trying to change the color of shape (representing the map location) on the slide after the text is clicked, etc. Also need to reset the object before the next office name is clicked. What is the best way to do...