Search results for query: *

Hey all! Here is my problem - I have a crosstab query that is grouping data by week ending dates (Fridays) for a year's worth of dates. I then export the queries to excel and have some graphs set up to display the data. My problem is that sometimes there are 53 week ending dates in a year...

Hey all, Here is my problem. I have a subform that displays data from a query. I want to be able to select a record in the subform and click a button that will set a text box to the value of the id field of the subform. How do I do that? Textbox123.value = ???????? Thanks for the help, Josh

Hey all, I want to make the top & bottom 10% of the records of a report bold (if there are 100 records the first 10 and last 10 records will be bold). Is there a way to do this??? Thanks in advance, Josh

Hey all, I am using a cell reference to populate the title of a chart (='Call Data'!$F$1:$F$2). This grabs the type of data from one cell and the client name from the other cell. I want to have each show up on its own line in the title but am unsure of how to do this. Essentially I want to...

Hey all, I need to import a CSV file located at "C:\Temp\Results.txt" into the "Results" tab of an excel file located at "C:\Simulation\28DayInputs.xls". I need to use VBA (due to the requirement of software called Simul8) but have a very limited knowledge of VBA. Any help that you can provide...

Hey all- I have a DB with about 950,000 in a table called "Tallies". Within this table is information broken out by customer (about 400 of them). I currently export information for each customer to excel spreadsheets with 10 different queries. Each time I export a customers information I...

Group, I have a somewhat complex problem to explain so bear with me. I have a table called "TallyName" that shows every tally name that can occur in my database (each tally name occurs only once). I have one query called "CurrentTallies" that sums the number of tallies by tally name and source...

I am running the following bit of code in the on click event of a button: If IsNull(Me.UseZip) Then Msgbox "Please Note: 'Use zip code/Acct number opening' must be scored before continuing!" Me.cmdGetNewFileInfo.SetFocus Me.UseZip.SetFocus End If I get a runtime error 2110 that...

Group, I have information stored in an Access 2000 DB and need to be able to post various graphs/tables/reports to the web. I am looking for input as to the best way to do this. Is there any software out there that can be used to pull the data from Access (or Excel)? Or is there some good way...

I would like to set up an automatic search that sends me an email each time a new item is posted to the web that meets my criteria. Is this possible and how does one go about setting this up? Thanks Josh

Looking for a little help to do the following: I have a file called template.xls that I need to copy to a location on a server. The template file is at //mars/shared/iedept/webportal/template.xls and I will need to copy this file to //mars/shared/clientreviewdocs/##/$$$-template.xls. ## = a...

I am trying to compact an Access 2000 DB (which is 795 MB)and I keep getting the following error: Could not find field 'Description'. There is not a field in the DB called Description (and never has been), so I am not sure what this is referencing. Can anyone help? Thanks, Josh

I am trying to create some static charts of various types of metrics and am having a hard time finding a product that can do everything that I want it to. I currently have the data stored in an Access 2000 database. I need the following functionality: 1. create a chart that will display the...

I am trying to run a query that will be able to list the top 10 values (this is the 10 transactions that occurred the most by percent). I have one query (called transsum) that sums up all of the transactions by transaction type, then I run another query (called trans%) off of transsum that will...

I have an excel spreadsheet with about 40 charts in it (as individual tabs). I am going to publish this spreadsheet to the web and want to have a button on each chart that will go to the next chart. For example, if chart 1 is called Data1, chart 2 is Data2 and chart 3 is Data3, then on Data2...

Here is my problem. I have a table called "tblemplInfo" with the following fields: Employee ID Name 001 002 003 004 005 . . . 099 All of the fields with a number name are Yes/No fields. What I want to do is search each record in the table and each time there is a "yes" or...