Search results for query: *

I understand there is a Soundex and also a Difference function available in SQL Server. I am not too knowledgeable with VB but here is my dilemma. I would like to compare two tables that have first names and last names and I think the Soundex function may be of help. I've read about the...

Hi, Maybe this problem has been beaten to death. However, I'm looking for a viable solution to a crosstab query problem. Basically, here's the SQL: TRANSFORM Count([ANCILLARY MASTER].NAME) AS CountOfNAME SELECT [ANCILLARY MASTER].COUNTY_NAME, [ANCILLARY MASTER].SPECIALTY FROM [ANCILLARY...

Hi, I have a query that has something like County, Male Percent, Female Percent, Robot Percent(kidding) grouping on the county. Can I run a query in MS Access that can MAX on the row and update a column OR give me a new calculated field? Thank you, easy to do in a spreadsheet but I'd rather...

Hi, I'm struggling with an odd problem. I have a main form that with some list boxes. These have command buttons that bring up forms in the datasheet view. Only problem is that I lose the close buttons on these forms for some odd reason. I have it enabled. Wondered- to get around this, if...

Hi, I have a couple of, I hope, not too complex questions. 1. Everytime I close the datasheet view now, the form returns to my original main form but it does not fill the entire available window. I don't need any scroll bars or min/max buttons and I've disable them but it still does not expand...

Hello, I was looking for a bit of direction on a project. I had a table that has data and it is grouped by state counties. I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form. Since there are 88 counties in the data...

Hi, apologize in advance if this has been addressed too many tabs. I couldn't see anything in the FAQ's that relate. I would like to have a crosstab query create results where the list of state counties are the columns. Then various (about 5-6 calculated fields) fields become the rows. I...

Hi, I'm a DB guy so network issues are my definite weakness. Got a real issue as I cannot use my dial up Internet service nor dial into my work mainframe. I'm using Windows 98 and so far I have: 1. Reinstalled Windows 98 and reinstalled I.E. 5.5 but get the same error. I didn't remove the IE...

Thanks in advance for any direction you can offer on this bit of a problem. I posted it a while ago in the queries section but did not get any responses--I would like to do this project in Access initially but I will then transfer solution to a web-based, SQL Server application. Basically...

Hi, I created a module from a macro in Access 97 and it gave it a name like 'PDI Search Macro' and it looks like: Function PDI_SEARCH_MACRO() On Error GoTo PDI_SEARCH_MACRO_Err DoCmd.OpenForm "Prompt Idea", acNormal, "", "", , acNormal DoCmd.OpenQuery "PDI...

Thanks in advance for any direction you can offer on this bit of a problem. I would like to do this project in Access initially but I will then transfer solution to a web-based, SQL Server application. Basically, now, I have a query that brings in Name, SSN, address, phone and then also...

Problem: I have a large text file that is about 87,888 KB and is about 200,000 records. It has about 34 fields of mostly text but has some number fields. I would think initially that it would not be too large to import into a table. However, Access generates error message "msaccess.exe...

Hello- I have a PDF that has font symbols in the body of the document. These are a small medal and a flag and are webdings. For the life of me, I can't seem to find a way to copy and paste these symbols from the body of the document to the header. The desktop publishing software I use to...

Got an odd problem that is probably more of an HTML isssue. Got some queries that search via two drop down lists. Everything is working correctly except for two types of the values in the drop down lists. After stareing at this for a while, I think I may have isolated the problem. In one of...

Got an odd problem that is totally foreign to me. Got some queries that search via two drop down lists and these access SQL Server. Everything is working correctly except for two of the values in the drop down lists. After stareing at this for a while, I think I may have isolated the problem...

Got an odd problem that is probably more of an HTML isssue. Got some queries that search via two drop down lists. Everything is working correctly except for two of the values in the drop down lists. After stareing at this for a while, I think I may have isolated the problem. In one of the...

Hi, I am working with someone that imports my SQL from Access (and the tables) in SQL Server (7.0 I think). We are working on some queries that measure distance. Basically uses a zip code table and a provider table. The query pulls in the zip code parameter and compares to all records in the...

I'd like to make a report that would print in 5 or 6 columns kind of like: Georgia Neurology Family Practice Dr. John United Dr. Joe Smith 500 Smith St 123 Augusta Atlant, 15456 Atlanta, 13524 (248) 789-8545 (248)441-2222 Internal Medicine...

Got a strange (but true) problem. I have a couple of combo boxes. Each combo box is a multi-column and all works EXCEPT THAT Whenever I choose a value in the drop down list, (the drop down list then holds the value) but it only displays the first column in the multi-column drop down. For...

Hi- Looking for some pointers or direction on this problem. I think it is pretty straight forward but here goes: 1. In my main form I want to have a drop down list of states. When one is chosen I want the other drop down list to show the applicable counties in the chosen state. 2. Similarly...