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

Outstanding! Thanks.

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

Does anyone have any ideas on how to get this callback function to work? I really need some help. This will prevent the operator from having to press <SPACEBAR> and then press the test start button on the control panel. I will be able to detect the test start button being pressed. Thanks in...

I went through similar issues just this week. Only I was having Keycode problems. I found the right doc on Business Objects to walk me through setting the keycode. I also had to include the correct version of merge files since I had CR 9 installed and VS 2003 .NET on the development machine...

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'm having the same issue. It worked fine for several weeks though. It will print once then at the next print job, it will freeze and give the memory access violation. I've deleted the printer and reinstalled it several times with the latest driver (Sato CL408e label printer). The app works...

This link doesn't work anymore. It sounds exactly like what I need. Can anyone give an updated link or other solution? I have a replicated database. The linked tables that existed when I created the first replica are replicated but new linked tables are only local. I have to create the new...

This is the code currently: DoCmd.OpenReport "PrintSerialLabel", acViewNormal, "qryPrintSNReport", "SerialNumber =" & NextSN Here is the query SQL: SELECT TempSN.SerialNumber FROM TempSN; I append the SN to the tempSN table so that the query has something to lookup. I want to bypass all...

No error message at all. Thanks for reviewing my issue!

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

Kenny, I use a similar method to link scanned invoice files to a record. I created a hyperlink field in my table. The user scans the invoice to a specified folderpath and names it the invoice number. The user then enters the invoice vendor, date and number into fields on a form. After update...

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

Well, it took a lot of trial and error, but I got it working the way I wanted it to. It took a combination of form_keydown() and form_keypress() procedures to make it work. I had to capture the active control in the keydown() procedure in a global variable then do the key checks in the...

Thanks for the replay VBSlammer. Forgive me, but I don't follow the line Me.Controls(ctl.Tag).SetFocus in your code. Is the Tag property set somewhere else? How does this line set the focus to the next control?

How can I distinguish between a needed CR (one after data)and one after field movement?

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

I have upsized Access 2000 dbs to SQL 2000 via the Upsize Wizard in Access. Be advised, I couldn't do it using Office 2000. I was able to using Office XP though. It is a step by step wizard, really easy. It links all of the tables in Access to the SQL database so the Access db works exactly...