Search results

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

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

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

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

I have 2 tables "tblEmployee" and tblEmployeeCourses; they are joined by EmpId. tblEmployeeCourses, simply shows "course code", "course name", "institution", and "date taken" fields. From this table, I can determine which employees have taken which courses. But how do I determine which...

Hi, Is there a way to search for queries that use specific criteria? Let's say I have 60 queries in total, but only 35 of them use the "Province" field as criteria. The criteria is set to retrieve all records that are in Province AB, SK, ON. Suddenly we need to also include Province MB to all...

I have a query that uses an odbc table. The query prompt for a date: [Enter Date] After entering the date, I get error: "ODBC Call Failed" Yet...when I set the criteria to the date I want: #01/01/2005# I can retrieve the data, no problem. Any idea why I get the ODBC Call Faile error when...

I have found a function in an inherited database I am working on. I don't understand what it does. Can someone explain: This is the function: Public Function GetArgs(strArgs As Variant, intNumber As Integer) As String 'Arguments must be separated by a ^ Dim intCount As Integer...

I am wondering if there is a quick way to find a database object (table, query, form, report) other than having to scroll through them in the database window. E.g. I have many many queries and when I need to find one to make changes to it, it often takes me a while to find it when scrolling...

I have some code, which opens a report containing a subreport. The recordsource for the subreport is dynamically set with the on_open event of the subreport. On the click of a button on my form, the report opens and the subreport displays the correct information as per the recordsource...

I am having trouble setting the recordsource of my subreport using the On_Open event of the Main report. Here is the code I am using to set the recordsource: [Reports]![rptMainReport]![srptSubReport].RecordSource = "SELECT * FROM tblEmployee WHERE Index = " & intIndex & _ " ORDER BY...

Can someone please help me with this...I am spending too much time on this simple thing: I have a DLookup Function that I need to make work using values from text boxes on my form instead of the actual values. This works: x = DLookup("[Index]", "[tblMain]", "[LastDayWorked] = #12/03/2004# AND...

Hi, I have a form with an unbound control on it. The record source of the control is a DLookup function, which works fine. When updating the table (on which the DLookup Function is based) through different form, my unbound control on the other form that uses the DLookup Function does not...

Hi...can you help? I have a multi-user MS Access97 database application. It is causing one of the users (and I have only once had the error message myself) the following error message: "There isn't enough free memory to update the display. Close unneeded programs and try again." This error...

Hi, Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted. Thanks for the help in...