Search results for query: *

That did it! soon as I changed it to dim rst as dao.recordset it accepted the .Edit piece and ran. The only thing now is that it is replacing field1 with the number but I can play with what I have to make it work.

When I put this into my module the .Edit reference gives me an error stating "Compile Error: Method or Data member not found" I commented out the .Edit portion of the code and the next error I get is here: Set rst = CurrentDb.OpenRecordset("tbltemp") It tells me Run-Time Error '13' Type...

I have a table where I am trying to do a conditional primary key to group multiple rows (between 15-25 rows in the database) together. I would like to assign an autonumber to based on the value for field1 where field1 = 'INS'. I want that same autonumber value to be repeated until it finds...

Well in looking at the SQL Query it's now glaringly obvious that Crystal does NOT filter using the join until a field from the table is being utilized in the report. Before (with just fields from {database.claimlin} SELECT claimlin."claimno", claimlin."membno", claimlin."member" FROM...

I have two tables in my report - {database.claimlin} and {database.member} - the join between them is an equal join on a field that is comprised as such: membernumber.membergroup.sequencenumber (i.e. 1234.G001.001). However, this unique field in {database.claimlin} contains an invalid...

I'm running Crystal Reports 8 and I'm having an issue when exporting a report. I'm trying to take a report out of crystal and export it into a CSV file. The report in question has about 300,000 records (per the bottom of the bar) and when exporting using CSV, the status bar says it gets to 9%...

There's a function on the Database menu that is called "Set Location". Everytime a new table is created in the Access database, "Set Location" is used to point crystal at the table that was just created. All the other tables (on the SQL server) are never changed - just the Access one. That...

New and a bit hurried - the person responsible for this quit and left no documentation and this is way out of my realm of knowledge so I don't know what all I need to say to get good answers and yes I meant tables not the actual database that's my bad.

The report that I'm using reads from a Microsoft Access Database while joining to several unique SQL databases. It's not the way I would prefer to do it but for the time being it's how I have to do it. The tables themselves are produced twice monthly and not always on the same date - they are...

I'm running Seagate Crystal Reports 8 and I have a report that I change the database name on every month (i.e. the database for last month is “Error Report 08/01/2004” and this month is “Error Report 09/01/2004”.) Currently I use a parameter field that the database date is hand entered into but...