Recent content by BJS

I have an Access 2003 database which contains hundreds of tables and queries. I need a fast way of getting the following information about the database: 1. List of all tables used by each query 2. List of all fields used by each query where underlying table name begins with "tblSQL" Does...

I have 2 versions of Access installed on my system. I have a vbs file that opens the mdb file via the vbscript file....this worked fine as long as I only had one version of MS Access installed, now that I have A97 and AK3 I need the vbscript file to use the A97 EXE to open the mdb file, since I...

Hi...I am outputting a report via VBA to Excel. I would like the column headings of the report to output with shading. Can this be done? Any ideas are appreciated. Thanks bjs

Hi...I hope someone can help with this....it would sure be appreciated! I have an Excel spreadsheet, which is output by MS Access. I can't get the Average amount to output, so I'm wondering if I can get the averages to calculate once the spreadsheet opens for the user. The calculation for the...

mamma mia! No help yet...please someone???? Gurus...where are you? I've been working on this for 1.5 days so far. I have managed to get some results but not all. Here is my situation: In the detail section of the report I have bound fields as follows: [Week1], [Week2], [Week3] .....[Total]...

Hi...I have an Access report that is grouped. In the group footer, I have an unbound field that calculates the total. When using the "Analyze it with Excel" from MS Access all the bound fields output with their respective field names and values into the Excel spreadsheet. I can't get it to...

I have a report based on a query that is based on criteria entered on a search form I created. I would like to display the most frequent pay rate for an employee. E.g: The report displays the following: John 15.00 Mark 15.00 Jane 20.00 Jan 16.00 Jone 14.00 Jack 15.00 I would...

I accidentally posted this in "general"...so I am posting it here under "forms", since it is "form" related. My intention was not to double-post...sorry. Summerwind had posted an example to auto populate a combo box. The code below follows his example, but is not working for me: The fields I...

auto populating a combo box I am following Summerwind's example below to auto populate a combo box. The fields I have on my form are: cboCompany cboLocation cboCompany is based on tblCompany( with fields CompanyName, Location) When I update the cboCompany field, I want the cboLocation combo...

Thanks RuralGuy! That's what I thought....I better get working on doing this the long way!

I can't get my "undo" code to work on my form that uses unbound controls. Is this not possible with unbound controls? Is there another way? Here is the code I have tried: DoCmd.RunCommand acCmdUndo I also tried: e.Undo Also, the "Undo" command is not available in the menu. Any workarounds...

Thank you everyone! The problem was an invalid date (09/31/2004) in one of the records. The month of September only has 30 days. Problem solved!

I checked the data, there are no null values in the "Current Date" field. I would post a sample of the db with the query, but it uses ODBC connection to DB2 tables. Here is a sample of the sql: SELECT Table1.NAME, Table1.EMP_NO, CDate(Format([CUR_MON],"00") & "/" & Format([CUR_DAY],"00") &...

Hi Wayne...thanks for looking at this! I should have mentioned that the "Current Date" field in the design grid of the query looks like this: Current Date: CDate(Format([CUR_MON],"00") & "/" & Format([CUR_DAY],"00") & "/" & Format([CUR_YR],"00")) I can get the same error message when sorting...

I am getting the error "Data type mismatch in criteria expression" when I put sorting on the following field in a query: 3 Month Date: DateAdd("m",+3,[Current Date]) If I remove sorting the query works fine. When I add sorting to this column in the query design grid, I get the error message...