Recent content by jvanderw

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...

Thanks for all of your help. I ended up replacing the subform with a multi select list box. Then put a button on the form that calls a function: Call GetBankDepRecord(BankDepList) where BankDepList is the name of the list box Here is the function: Public Function GetBankDepRecord(ControlName)...

Thanks for the tip, but I tried this: Forms.[test].[ID].Value = Forms.BankDepSortsubform.Controls("ID").Value and it didn't work. I tried us me. instead of forms. as well. It gives the error "Run-time error 438. Object doesn't support this property or method." Any idea why I am getting the...

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

Skip, This solution won't work because I am using an Access DB to populate the Excel document with on clients info, copying the document to the server with that clients name, then repeating for all other clients. The client name is changed each time the document is updated. If the chart title...

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...

Thanks for the tip. I tried the macro recorder and am able to get the code to open a text file in a new workbook: Workbooks.OpenText FileName:="C:\Temp\RESULTS.TXT", Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _...

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...

THANK YOU!!!!!!!!!! The bang (!) worked! Josh

Thanks Zameer, but I still get the same error. I am about at wits end with this problem! Josh

My mistake, I should have deleted Me.cmdGetNewFileInfo.SetFocus before I copied the code to the forum. I was just trying to set focus to the button that has the "on click" event first. The code would still bomb out on Me.UseZip.SetFocus. Any other thoughts? Josh

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...