Search results

Hello, Trying to put together a query that has all my data. However when I get to the this table the query no longer works, has just the titles. When I add tblCallCredit the query stops working. If I remove that table I get the data that the query is supposed to fetch. I am not sure if its...

Ok. I have normalized a database I am working on. Now when I append the data from the one table to the several tables do I have to append the PK's in each one? If that even makes sense. I have one table that has several fields. When I append the data to about several different tables does...

Hello, ACCOUNT_NUMBER SHORT_ACCOUNT_TITLE CONTACT_COMMENTS CONTACT_TYPE_TEXT ENTERED_BY INITIAL_CONTACT_DATE DATE_ENTERED These are fields that are imported from Excel. I have to import 500-1500 rows each week which contain the data I need. Then I must, by using a form, go through these...

Hello, I have this so far: TRANSFORM Count(tblclientcontacts.ENTERED_BY) AS CountOfENTEREDBY SELECT "Count" AS [ENTERED_BY+OFFICER1+OFFICER2+OFFICER3] FROM tblclientcontacts GROUP BY "Count" PIVOT tblclientcontacts.ENTERED_BY; However I need this to show data that is for a certain date. I...

Wondering since there are a lot of people on here from UK did anyone go? I am a big Giants fan, its just too bad that the weather wasnt better. The game was more or less like backyard football, with better weather it would have been more exciting. Plus the grass was more or less soccer grass...

Hello, I have looked at numerous threads here and have some confusion with subform requery. I know thats what I need because when I change the search selections in my combo boxes the subforms do not update, only after hitting design and then preview. Does the requery code go into the subforms...

Hello, I have a search function for my database. I put in the search criteria and matching criterian open in a new window. I would like to add a sub form to this and have the results open in the same form...if that makes sense. Here is the search form: Private Sub Command12_Click() If...

This is strange but not sure why this is happening. This link will not open in excel worksheet. However if I save the worksheet as a .htm page it will open. Is there a way to force a hyperlink to open with Adobe Reader? To see what I mean try the following. Put this link in a worksheet and...

Hello, I was wondering if anyone know why this may be happening or a way to prevent from happening. Every so often the shortcut that all my users use for the database will change location. It recently happened when we upgraded to IE 7. Is there a way to fix this so it doesnt happen anymore...

Hello, I am having this error when I use a form on a database I am building. What it is this. I have a search form that search's a table for specific information that I put in the search criteria field on the form. Like name, dates, account number or whatever type of data I query. Now it...

Hello, I was wondering is it possible to have a link that somehow will email a password to a user if that user forgets their password. More a less something that looks like this as seen in many programs. Forgot Password? Searched but didnt find anything but didnt know.

Hello, =IF(AND(I6>1,SUM(SUM(I$7>1,I$8>1,I$9>1,1),SUM(I$7=1,I$8=1,I$9=1))=4),F$6/(SUM(I$7>1,I$8>1,I$9>1,1)),"0") I have the following for Excel and was wondering if I could use it for an Access form. What this does is the following. There is a text box for a dollar amount. There are 4...

Hello, Found this here and was trying to do the following. Delete rows in my table that are dupicates and put them into a new table. Keep getting a syntax error. SELECT DISTINCT * FROM tblRaw INTO tblClientcontacts Anyone know why? I have a table that has 12,000 rows. Out of those rows...

Hello, I have a database which every week I have to import an excel spreadsheet. Now this spread sheet will always have rows that repeat and will have somewhere between 700-1500 rows. What is my best option to delete the rows that repeat? Meaning if a rows 1-10 have the same data then delete...

Hey, I know most of Europe and several other nations around the World dislike the death penalty and constantly harp on the US for having such a bad policy. I came across this interesting study that says the death penalty saves lives and would save more lives if death row were quickend up. Now...

Well who said GWB couldnt do anything right? "The Dow Jones index of leading US companies has closed above the 13,000 mark for the first time in history, powered by strong corporate results. Sentiment was further boosted on Wednesday as Pepsi's latest profits rose 16%, while Boeing's increased...

Hello, I have been working with PHP over the years and have become quite familiar in how it works, however I want to learn more about ASP. Anyone know of some good websites to learn some information...tutorials and such. Thanks.

Hello, I recorded this macro via Excel and it has a compile error anyone know why? It runs a SQL for me, here is the section that highlights as compile error- syntax: .CommandText = Array( _ "SELECT AC_BI.ACCOUNTANT, AC_BI.ACCOUNT_NAME_FIRST, AC_BI.ACCOUNT_NAME_LAST...

Hello, I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while... Anyone encounter functionality breakdown due...

So anyhow seen it on opening day I thought it was awesome, but some people thought it was overhyped and all... Anyone else see it?