Search results for query: *

I am using a Crystal Report to print a label from my VB.NET application on a Windows XP machine using the code below. It prints fine but over time I have noticed the C:\documents and settings\username\local settings\temp folder is almost 2GB in size and is full of .rpt files. One machine has...

Is there a way to use IIF or the like to perform aggregate function based on the value of another column? I use this successfully in Access: IIF([Department]=80, SUM([Uptime]), MAX([Uptime])) I get an error about IIF not being recognized when using it in an expression in a view in SQL...

I am converting an app from VBA to VB.NET using VS .NET 2003. I have an I/O card that has an interrupt function that will execute a provided callback function. In VBA I could pass the addressof myCallBack function. VB.NET requires a Delegate to point to myCallBack function. I wrote my code...

I want to print a serial number onto a label from VBA. This db is multiuser and all are adding serial numbers regularly. I am currently storing the values in a temp table and passing the value to a query based on the temp table. The report is based on the query and it prints ok. There must...

How can I get the local computer name in my Access VB code?

I have an Access form setup to accept user input as static information. I then have an I/O card installed (PCI-7224 from ADLINK) to aquire pass/fail results from a RunCheck/PLC system. I want to create records using the form data and aquired results. The I/O card has an interrupt function...

I am using a keyboard wedge scanner to input data into my Access form. I want to keep the user from having to use the keyboard or mouse. I enabled keypreview on the form and coded some non-alphanumeric keys to move the focus to certain fields or reset the form. I barcoded these symbols and...

I am linking to SQL tables from Access. I setup a file DSN on the server where the Access db resides and the linked table in Access uses this DSN. The SQL table uses host_name() to fill in a field. It always records the computer name of the computer that the DSN was created on rather than the...

How can I make the default value of a field in my subform start with 'A' and increment for each record? Thanks in advance, Brent

I can email a query by scheduling a command in scheduled tasks that runs a macro to send object. The only stipulation is that I have to be logged in with Outlook open for it to work. I want to run the task on a server with SMTP installed without having to be logged in and be able to send the...

I made some global changes to records in the design master while a user made multiple changes to some of the same records in the replica. When I synchronized the two, I got 808 data conflicts in one table. The conflict viewer is incredibly slow! The db made the correct choice on data to keep...

I created a replica of a secured database and put it on a laptop. All objects are read only. I cannot edit anything. User will be traveling a lot so I wanted him to have a copy that he could enter his customer contact data without having to connect via dial-up to a database. Help much...

I can email a query by scheduling a command in scheduled tasks that runs a macro to send object. The only stipulation is that I have to be logged in with Outlook open for it to work. I want to run the task on a server with SMTP installed without having to be logged in and be able to send the...

I'm trying to build a price calculator. I need to be able to raise a value (1.1) to the power of the value in text box [Large]. Text box [PrePrice] calculates the price based on the price table, given the selected size of product. [Large] is a number of size increments above the listed sizes...