Search results for query: *

Will command buttons work with a touch screen, or will they only work with mouse clicks?

I hope someone can help. We have recently "upgraded" to Office 2002. We use Access as a front end to a SQL Server 2000 database. Under access 2000, whether in a view or a table itself, the records scrolled smoothly. Now, under Access 2002, in a table or view, once data is either...

I have a stored procedure that works fine on it's own, now I need to call it in the before update event of a control on my form and save the output in a database field. I've searched MS knowlege and this site for an answer first, but cannot seem to find it. I may not be asking the correct...

Hello, I have a stored procedure that works fine on it's own, now I need to call it in the before update event of a control on my form and save the output in a database field. I've searched MS knowlege and this site for an answer first, but cannot seem to find it. I may not be asking the...

I have the following code in the After_Update event of a field on my customer form. Each time the code runs I get a run-time error 2757, There was a problem accessing a property or method of the OLE object. When I go to debug, the Dlookup rows are the source of the errors. I use Dlookup on the...

I have a formula field (@TotalFaxBack) in a report that calculates commission as: if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} < 2000 then 25 else if {@FaxBack} = &quot;Yes&quot; and {#OrderTotal} > 2000 then 50 else 0 This is displayed for each order in the report. I need to create a...

Through DTS I created a package to export some data to a text file. Is there a way to append the data to the file instead of overwriting the file?

Through DTS I created a package to export some data to a text file. Is there a way to append the data to the file instead of overwriting the file?

Hello, I am exporting some date through DTS ot a text file and can't get the date to append to the file, is there a way to do that? Am I missing something in the configuration of the package? Any help would be greatly appreciated, thank you. Drew

I need to write a stored procedure to output some data to a text file which (hopefully) will not be too much of a problem. The question I have is do you have to use strictly 'C' language code in the procedure or can 'C++' code be used. I have not used either in a number of years, so would only...

There may be an easier way to do this, but I'm pretty new to Crystal reports. I'm trying to format a string of numbers with the following (input is 1234567890, output is (123) 456-7890): Join (MakeArray (&quot;(&quot;,ToText (Left ({FaxCover_View.Fax},3)),&quot; &quot;, ToText (Mid...

In a report I have created, I need to group by account number to keep order information together, but sort the output by date. Is there a way to do that?

Is there a way to open a specific form in an access database from VB 6?

From what I can gather (my boss couldn't tell me) it is a Nortel model 61C PBX. What I am to be responsible for is creating screen &quot;pop ups&quot; that either bring up data from the database on a current customer, or a blank form (with the phone number and caller id coming from the phone...

Has anyone integrated a predictive dialling phone system with their SQL server? I am going to have to do this in the near future and was wondering if there are any text or online resources available to help me, as I've never done this before. Any info would be greatly appreciated.

I'm having difficulty saving the contents of a field on a sub form to a field on the main form. The field on the sub form is a calculated total which I want to save in the recordsource for main form. The sub form is a datesheet that displays a customers ordered items. the name of it is OrderSub...

I'm having difficulty saving the contents of a field on a sub form to a field on the main form. The field on the sub form is a calculated total which I want to save in the recordsource for main form. The sub form is a datesheet that displays a customers ordered items. the name of it is OrderSub...

This may be an easy problem, but I'm having some difficulty saving a total from a subform to a control source in the main form. I can reference the subform total in the main form, but I cannot save it. I tried the fix suggested on the MS Knowledge site, which is using a macro to set the value...

As I am not too conversant in network and internet protocols, I hope this is enough info. I am trying to replicate (SQL Server 2000) to our warehouse through a VPN over the internet via an ASDL connection (yes, it's very slow). The internet connection goes through a 'Sonicwall' firewall at each...

I am trying to make a view for a Crystal report that places a check beside products a customer ordered. When I create the view, I get an entire customer recordset for each product ordered, which creates a separate set of reports for each product. Is there a way to access all the products ordered...