Search results for query: *

I have just converted an Access 2000 database to Access 2010. The reports all had the current date printed in the page footer (=Date()). The 2010 version prompts me for "Date" and then prints "#Name?" in its place. If I delete the date field from the page footer and try to insert "Date and...

I am new to writing xml code. I am linking two tables and I want to select the first table records whether or not there are linked records in the second table. When I enter the following code the report give me errors: <table type="left_outer_join"> <table type="table"...

Hi All, I am using xml code to retrieve records from a database and will display them in a report. I only want to select records where the 5th character in "VP_Permits.TypeCode" = "G". I can't seem to figure this one out. Can anyone help? Thanks, mrBill

Some of our Access databases (Access 2000) seem to automatically generate copies of themselves. What causes this to happen? Not all of them do this. Thank you, mrbill

I want to create view A then read view A and create view B. When I try to do this within a single query batch file I get an error at my second "create view" statement that says "'CREATE VIEW' must be the first statement in a query batch." Do I have to create these views with separate query...

We have moved an SQL2000 database to a new server. We recreated the ODBC to point to the new location. The database has an MS Access front end that allows updating the database and uses a DBO account. Since moving the database to the new server the access database can update some tables but...

Access 2000 I have a "make table" query that contains a field called "Line_number". The input table for the query does not contain a value for this field. I would like it to number the records sequentially, but can find no way to do this. If I delete the records in the output table and...

I am using Access 2003. I have a main report that opens only one table named CompanyInfo. The subreport is a multi column report that opens only one table named Categories. The main report is grouped by CompanyInfo.CompanyName and is linked to the subreport via CompanyName (the field...

Counting Once for Each Day a Record Spans For any given Month/Year, report how many records were open for each day of the month. Each record has an Open and Close date. Data: PO # Opened Date Closed Date 1234 1/10/06 1/14/06 1278 1/13/06 1/18/06 4567...

Hi all, I have a small 1 table Access 2003 database. The table is a linked table to a delimited txt file. The database also contains 1 form and is used for printing invoices each month. We are currently copying the txt file to a history folder and renaming the txt file with date it was...

I am trying to insert records into a history table. One of the columns in the table must be set to a specific value in the first record inserted and then incremented by 1 for each new record inserted. The column is not an identity column. In the code below I have commented out the "insert"...

Sql Server, Crystal vers 9.0 I am new to the Add Command function of Crystal reports. I can add a command ok and it seem to return correct results. However, when I try to add a parameter to the command object, the parameter disappears as soon as I click "OK" out of the "Command Parameter and...

I have a pdf file that was converted from a Word 2003 document. The Word document has check boxes that were created using the auto shapes tool. When I open the converted pdf version of the document in Acrobat 7.0 the check boxes are not visable and they do not print. If I open the pdf...

I have a Word 2003 document that has check boxes drawn on the document. When I use Word to convert to Adobe PDF, the PDF document does not have the boxes/drawings. Any ideas? MrBill

I have a vendor table and a vendorCommodity table that has a one to many relationship. I need to export the data with some of the vendor table fields and one new field that contains all of the vendor's commodityCodes (from multiple records) into one field separated by a comma. I thought I...

Sql Server, Crystal vers 9.0 I have a report designed to export data. It exports one text field made up of many concatenated fields. I also have a sub report in the report footer that has the identical layout - one text field made up of concatenated fields. When I export as type text, all the...

We are converting from Crystal vers 8.5 to 9.0 and I am trying to create a running total on a formula. My formula is as follows: //@AmtTax If (Not IsNull({ESAINHSV.LINE_TYPE}) and {ESAINHSV.LINE_TYPE} = "T") and (Not IsNull({ESAINHSD.LINE_TYPE}) and {ESAINHSD.LINE_TYPE} = "I") then...

We are currently moving from vers 8.5 to 9.0. In version 8.5 date parameters always defaulted to the current date and showed the current date in the parameter discrete value box. The user did not have to enter anything if they wanted the current date as their parameter response. They simply...

We will be converting our Crystal Reports from 8.5 to 9.0. A few of our reports have subreport that pass values but are shrunk down and do not display any data. I am trying to eliminate to small section in the main report taken up by the subreport. I was hoping the "Suppress Blank Subreport"...

I am adding a linked txt table named TblCustInfo to my mdb. The table is automatically downloaded from the main frame to the network each night. The database reads the linked table just fine. I have set up a table relationship between the LINKED table (TblCustInfo) and one of my mdb tables...