Search results for query: *

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...

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...

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...

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...

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...

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...

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...

I'm looking for a way to test if my application is already open when a user tries to open it. Here's what is happening........on the unload event of my mdi parent I'm unloading all forms. However, we've had users try to open the application after they thought it was closed and nothing happens...

I'm probably not thinking this through.......but here's my question. I have a form with an assortment of text boxes. I create an ADO recordset through code and bind the text boxes to the recordset with the datasource & datafield properties. What I need to do is refresh the form and recordset...

We have a data report with text boxes bound to a data environment............what we would like to do is be able to print a data report showing only the labels; or create a data report that isn't bound to anything and print it showing the labels. We need the ability to print these reports for...

I have MS Data Report that I'd like to be able to print without any data, showing only the labels and lines on the report. I.E.....I need to basically print a form that the user could complete by hand if necessary. Thanks for any and all suggestions!

We're hoping somebody can point us in the right direction......... A CAT5 line is installed in 3 rooms in our church. We have 2 PC's, one with WIN XP and one with WIN 98. We ran the WIN XP network wizard on the XP machine and took the floppy and ran it on the WIN 98 machine. Here's what we...

We're hoping somebody can point us in the right direction......... A CAT5 line is installed in 3 rooms in our church. We have 2 PC's, one with WIN XP and one with WIN 98. We ran the WIN XP network wizard on the XP machine and took the floppy and ran it on the WIN 98 machine. Here's what we...

I'm new to using MS Data Reports and I've noticed that even if I set my top, left, right, and bottom margins to 0, the report still prints with 1/2" margins. I have a couple labels I need to put 1/4" from the left and top margin. Any ideas or suggestions are appreciated!