Search results for query: *

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 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 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...

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...