Search results for query: *

I am having a problem with setting the Data Source when it is set to CurrentDB. If I set the path to c:\test\mydatabase.mdb it works fine. Why will this not work, does anyone have an idea? Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet =...

I need to have a Select Query show up in a textbox and return everything back in the text box from the query. I tried to put the select Query in the Control Source of the textbox, but this did not work. Here is the Query SELECT qManagerQuery.Q8 FROM qManagerQuery; Q8 is a memo field; it will...

How do I make a call to another query to do a Sum of all the Q1's that equals 1? Currently the Record source for the report is one query qManagers and this gives me 90% of the data that I need and I also need results from another query called qEnterpriseQuery. Here is what I was thinking, but...

I am trying to do percentages on my report in the expression builder, here is what I did: =Round((([text67]/[text60])*100),0) & "%" It does work, but does not look pretty. Is there a better way to do percentages? Thanks, Darkhat01

I am getting a Run-Time Error '13': Type Mismatch. The Set db_data = NewConnection is what is highlighted in yellow. Would anyone know why this is happening? I got the code from: http://www.tek-tips.com/faqs.cfm?fid=5250 I am trying to learn how to import a csv file into a access table...

I am having problems on how I can browse for a file and return the path of the file selected by the user. Example a user will be in Access on a Form, click the Browse for File Command button, locate a file on the C: drive in a folder called test2 and the file name is test.csv. I would want it...

I am trying to count the records that are in a query that I created. I am doing this with a Cross tab query. If I put "Like [Forms]![Company_Reports]![txtPortfolio]" in the criteria to filter the query I created, it still works fine and does filters what I need, but the cross tab that I...

I am trying to use a string filter in the criteria in the query, but I can't seem to get the if statement to work correctly, any ideas would be great on what I could try next? The [PortfolioName] in the report [Rtest] is an invisible text box on the report, the value is selected by a choice on...

Is there away to build a “Fuel gage” like chart that will move a needle from one side to the other when you enter in numbers? E would be 0% and F would be 100%.... My boss said this can be done in Excel and I have no clue how to do this... Thanks....

I am confused on where to start on this project. I have 3 queries that are doing counts for different things. They count High's Medium's and Low's. I would like to build a query that takes the totals of all three queries that counts different things and combine them into one query that Adds all...

I would like to move the backend of our Access DB. However there are MANY links for the tables that will need to be reestablished. Is there a way to point the front-end database to the new location for the backend and all the links will be reestablished? Or do I have to go through each one...

I would like to move the backend of our Access DB. However there are MANY links for the tables that will need to be reestablished. Is there a way to point the front-end database to the new location for the backend and all the links will be reestablished? Or do I have to go through each one...

I am trying to create a crosstab query that is the average score for each Line of Business. I thought that this would be simple. But I am running into problems. Here is what I would like it to look like. The number must be between 0 and 2 with two decimal places. LOB1 LOB2...

This works: In the Criteria box I have: Year([TARGET_DATE])=2007 This returns all the dates with the year 2007. What I would like to do is have a box pop up and ask for the year to report for,The user would enter 1/1/2007 would be for 2007. Here is what I have tried and is does not work. The...

I have a field in a sub-form that has the default value set to 99. But when I go to the record in the table it does not show up. However if I change the value to any other number the record is written to the table and shows up. Why is this? How can I get this sub-form to write this value to...

How do I make the cursor start in the field I would like it to? Example: Currently it starts in the last name, but I would like it to start in the first name. Thanks, Darkhat01

Ok I have a problem, I have Windows 2000 Server and I had to move a folder to a new Hard dirve because of it's size. The problem is I have many things pointing to the origianl place the folder is. Is there a way that I can create a point to the new location and make it look like it is still...

If I use the following code should this disable the field on the form so no one can enter anything in it only if it has been compiled or creat an MDE? Also could someone explain what Me! means? I don't understand why there has to be a "!" after Me. Private Sub Form_Load() If...

Hi I used the Hyperlink Address in the properties of a command button to go to a website, but I get an message box that comes up: Opening http://www.whatever_the_link_is.com Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this is from...

Need some help on what I might be doing wrong? I tried to put a Error handler in it and it did not work. Currently the Error handler is commented out. From time to time there will not be a data and it will be Null. How can I tell it to skip this if there is a null??? Run-time error '94'...