Recent content by BRIANVH

dhookom, Thank you, your suggestion worked. Problem solved.

Below is the sql code for the query, but the trouble I am having is with the VBA code in the associated report. I am not having any trouble with the query. SELECT [SYSADM_CUST_ORDER_LINE]![CUST_ORDER_ID] & "/" & [LINE_NO] AS JOBORDER, IIf([CUSTOMER_TYPE] Is...

Yes, [USER_2] has always existed in the tables, but I added it to the query to make it usable in the report.

I just added a field that already existed to a query. The query runs off our ERP system tables. The code is pretty simple, it just controls whether a logo is printed or not on a label. I just need to change the code so it will use the field I added to the query. The following is the code...

I am attempting a minor modification to VBA code used in an Access 2000 report, but I know little about VBA code. I added a field to a query used in the report, and I attempted to modify the VBA code in the report to use the new field. In this case, the VBA code just controls whether a logo is...

I have an Excel 2000 spreadsheet that gets external data from an MS Access 2000 query. The MS Access query gets some data from Access tables and some data from an ODBC data source with tables linked to Access. This all works fine some of the time. However, some of the time we get the...

I'm working on an Excel Template that gets external data via an ODBC query. That part is working fine. I'm trying to make the template refresh the ODBC data (run the query) automatically when the Excel file is first opened. I am thinking I need an Excel macro that is set up to run when the...

Is there a way to have a cell in Excel control the criteria used in Microsoft query to pull data into Excel from a MS Access table (Office 2000)? In this case, only one record (row of data) is needed from the Access table for each Excel file. There will be many Excel files, created by copying...

Thanks Duane, you got me headed in the right direction, and now I found a workaround that seems to work ok. I am now using =[TotalSales]+25000 in the sorting and grouping dialog box, which in this case is large enough to eliminate the negative numbers for sorting purposes and then the report...

I believe the data type of the field is decimal, and I don't beleive I can change the type since it is being pulled from an ODBC linked table. When I tried either CCur or CDbl functions, the query starts running but then I get the "This expression is typed incorrectly or it is too complex to be...

I did not have any luck with the suggestion to use a CDbl([field name]) function in the sorting and grouping dialog box. I could not get the function to work here (syntax problem?) I did try putting [field name]*[field name] in the sorting and grouping dialog box, but that yielded a sort order...

For some reason, my report is putting negative numbers at the top of the list in a column that is sorted descending and contains both negative and positive numbers. This is a sales by customer report sorted so the customers with the highest sales come at the top of the report. I modifed the...

Is there a way to allow data entry into the header of a form, or is the header strictly for printing?

Access 2000 I have a new server that will be dedicated to our ERP database (sqlbase), and I have a test copy of my database functioning on the new server. Now I am trying to get my existing Access Reports working off the test database on the new server. I tried changing (and also deleting and...

Thank you, that does the trick.