Search results

I have this working now and the TRUNCATE on the pass through works perfectly. Finally I can make use of Sage tables without having to use the horror that are the Sage tables. Thank you all. ~Matt

Thank you. I shall learn this now and see how I get on. ~Matt

How would I do this from access though? I need this to be able to be done on any client FEs that need to do it. ~Matt

Truncate doesn't work in MS Access, not that I can find. With regards to the import, I have 2 queries and use a make table to move the data locally, then append the local table my SQL table. These 2 queries run faster than trying to append the Sage table to SQL. Now I just need a working VBA...

Thanks Maj, I now have the import working in flash. The issue now is deleting the data from the SQL table. I need to find a way to TRUNCATE TABLE in access as the delete function takes upwards of 20 minutes each time. I have no reason to log the records that are being deleted as they are only...

Hi Pat, The data I am appending already has a TransactionID. What I am trying to do is append them in smaller batches, rather than a single query doing them all in one go. I want a query to loop through 1-1000, then update my label, then run through 1001-2000, then update the label, and so on...

Hi Minty, Thank you for your reply. There is an ID field and breaking it into 1,000 or even a 10,000 loop wouldn't be an issue. Yes, the Sage ODBC is the bane of my life. ~Matt

Hello all, Is there a way of doing an append query, but a single row at a time to enable the creation of a counted progress label. I have a table in Sage50 that I want to append to an SQL table so I can use the data faster. It is a transaction log that I use for some reports and it grows...

Thanks Pat, I installed that just as your reply came through. Jet lag from my holiday slowed my brain today and I couldn't find it when I looked earlier. ~Matt

Thanks Pat, I have actually managed to get it sorted, but would prefer to create my tables in access the "upsize" them. I know MS Access no longer has this as an option, but is there another tool that will do this for me? If I have to create them in SQL, I will, but as the tables are all...

I have a well established database with this as one of the modules. Feel free to message me if you want to bounce some ideas. ~Matt

Hi all, I am looking to move some of my larger tables onto SQL server, but I have been unable to find details on how to create a new server. Our Domain controller has 2 SQL Servers registered at the moment, but I wanted to create my own one instead of a new database inside one of these. I have...

Sorry to post this here, but are there any Crystal Reports wizards on these forums? ~Matt

I was just logging on to close this as solved. I tried the Val and it worked. I found it on an older thread. ~Matt

Hello Forum and a happy new year, I have a query I am trying to create with 2 tables. The issue I have is that one field is currently part of an SQL table and is Short Text. The data in here is a number though and I want to link it to a table Number field. Is there any way of getting the query...

I have tried the report footer, and the page header. And the detail. I get the same result whichever location I put the code in.

I have put it in both the Format and Print events, please see opening post. ~Matt

It is strange. After previewing it, the export to PDF works. I am not that fussed now until the new year as I finish in 40 minutes :)

Hi June, If the PrintPreview option is the only solution, then I will do it this way. I was just hoping someone might know if I have put the code in the wrong event to make it work. ~Matt

Hi all, I have a report where I want to hide/show the report footer depending on a single field. When I preview the report, the code works fine. But if I direct print, it fails, unless I have previewed it first. This is an issue when I export to PDF and email as I do not preview the report...