Search results for query: *

Denny, thanks for the quick reply. They are DB2, Access, and Sybase.

As someone who isn't overly literate with SQL Server 2005, this might be a simple question. Is there a way to create a linked server to an ODBC connection that is on a PC as a system DSN? I have a number of system DSNs, system data sources, on my PC. I'd like to reference these from within...

Hi, I'm struggling with the VB Data Report. I've successfully placed a couple labels in the page and report header sections; created a connection without using the data environment; created a recordset using a stored procedure; and populated the labels in the headers with data through my code...

Thanks for the quick reply. Is it more efficient and better practice to store them separately and only store the hyperlink to the file in Access?

This is a newbie type of question because I don't work with MS Access to frequently... How (and can) a .pdf file be save as part of an Access database? We will be creating numerous .pdf files and a current Access database was selected to save these .pdf files if it's possible. Thanks in...

We needed to create a report where 1 page is portrait and 1 page is landscape. Our approach was to create 2 reports. The query that the reports are based on returns about 1,750 records. What we'd like to do is start the printing process and have page 1 of the first report print followed by...

Tranman, Thanks for your reply. We updated our version of DB2 for Windows client and that seemed to do it for us. Thanks for the suggestion on the file DSN. We're going to use that as you suggested. Ron Rollingmoose

Here's what we're trying to accomplish. We have about 50 PCs on our network and we want to create a system DSN that allows a connection through ODBC to a DB2 database. When creating the DSN in the ODBC Data Source Administrator, it works smoothly on some machines. On others, when we get to...

We're occasionally receiving a -2147217871 Timeout expired message when running a VB application that inserts and updates a SQL Server database. Most times the application runs and performs the inserts and updates in less than 5 seconds. But every now and then the updates and inserts don't...

Here's what we're trying to do. We are using the command object to execute a SQL Server stored procedure that receives 21 input parameters. We collect this data from a form and in many cases the user will leave the text box empty. We need to send a null value in these instances as a...

Yes, sort of. What is happening is when I get to the last page of my report, there are no records remaining in the detail section. Since the detail section isn't displaying any records, I want to hide a couple labels and show a few others. So I'd like to be able to test if there are any...

I hope I explain this correctly... I have a report where I hide and show labels in VBA depending on the page of the report. What I'd also like to do is hide and show labels depending on the number of records in my detail section for that specific page. For example, if no records are in my...

It's an MDI application. I'm also unloading some child forms.

I know this will probably a very simple answer, but I'm stumped for some reason and couldn't find it in the forum archives. When I exit my application, I unload approximately 35 forms and data reports. The screen flashes rapidly while the application exits. I think it's the unloading causing...

Thanks for the quick reply. Yes, I did compact and repair but unfortunately that didn't fix the problem.

I'm not proficient in Access, so perhaps I might be missing something that's right in front of me. I created a query that ran correctly, and then created a report based on that query. When I attempted to open the report in preview mode, Access closed. Now whenever I try to run any of the...

Here's what we're trying to accomplish. We have an insert trigger that fires when new data enters a table from another server. The trigger creates a join to another database to extract a piece of data that updates a field in our table. However, if that join can't be created an error occurs...

Actually, the string to remove could be located anywhere in the field which has as many as 78 characters in it. I wish it was always in the same location though...Thanks for the reply.

We have concatenated a large number of fields and records, about 350 and 700,000 respectively. What we ended up with is a field that contains data such as DF15ED20WS15. What we need to do is remove one of the data elements that was concatenated. For example, if we have data as shown above we...

I'm not sure where to ask this, but I'm hoping someone can point us in the right direction. We would like to scan the body of email messages received in Outlook and send automatic replies to the sender based on the frequency of certain words appearing in the body of their email. Any...