Search results for query: *

Hi, I have a recurring pattern like this... </table> <br> <br> ACME Co. <br> 123 Main St. <br> Smallville...

I have a situation where I need to identify a 'primary county' based on number of offices. The logic is that if a doctor has a several offices, the county with the most number of offices is the 'primary county' in which he/she is located. If there is a tie, then arbitrarily pick a county (first...

I'm having an issue with the following code snippet. What I'm trying to do is append a list of states together when multiples are selected. So, if they select Alabama, it should just return AL. If they select Alabama and Georgia, then it should display AL,GA. (note the comma in between...

Hello, here's some code below... SELECT TblLOB.rpt_cust_name AS [Customer Name], COUNT(TblLOB.state_cd) AS [State Count], <snipped a lot of other fields> FROM TblLOB INNER JOIN TblMemCnt ON TblLOB.id = TblMemCnt.id GROUP BY TblLOB.rpt_cust_name; What I'm trying to get is the second column is...

Hello, I'm trying to clear a listbox when the user unchecks a checkbox. It populates just fine when there's a check in the box, but I can't get the list box to clear when there is no check in the box. What happens is that whatever populated when it was check stays there when it's unchecked...

Hi, I'm having a problem thinking through this logically and could sure use some help. I've got addresses, but the address elements are variable, meaning I could have any or all of the following address elements Business name Address 1 Address 2 City/St/Zip County The problem is that I don't...

After searching for the answer for three days, I'm finally posting as a question. Any help is greatly appreciated. I have a table with names and addresses. One of the fields is STATE (however, it's not always called STATE, different tables may have a different name for state). I want to...

I'm helping someone fix some forms they created. The form exceeds the screen length and it activates centered. This is a maximized form and I asked if they can make everything fit into 1024x768 and they couldn't. So the problem is that everytime the form opens, the user has to use the...

Is there a way to run a simple sql query in access without assigning a command to it? I'm more comfortable writing sql queries by hand than using the access gui to build my queries. I thought about putting it in a module, but then I need something to execute that module, right? Or can I...

I have a file that will be located on different network paths in different offices across the country. I have my code working mostly right to delete all the tables and relink them based on what office the user picks from a combo box. It works when a user picks the correct office that they are...

Normally, I'd search until I found my answer, but it looks like the search has been down for two days.... Let me start by divulging my experience level, I've had to give myself a cram session in Access VBA in the last month... I'm normally a java programmer, so many of the things that I would...

You'll have to excuse me, I'm not a Microsoft programmer, (I just play one on TV).... so please correct me if I have some funky code that doesn't make sense to you seasoned vets. I've got a button that I want to save a query as an excel doc and then launch excel with that doc open. I found a...