Recent content by Profector

On the temp folder, where the pdf is saved, I changed the permissions to allow 'everyone' full access. After running the batch file started to the message Then I created a new task and this time I changed "configure for" to "windows server 2003, Windows XP, Or Windows 2000". And it looks to...

Hello All Just got a new Windows 7 computer and installed Office 2013. I have a report that saves itself as a pdf in a temp folder and then attaches the pdf to an email and sends it out. I use a macro to run the report and everything works fine from there. I have a VBS file that runs the...

Update: The final query was based on other queries. I exported the data I needed to new tables and ran the final query against those tables; now it finishes within seconds. I just need to add a few lines to clear the table and update it before the final query runs and I'm golden. That won't...

There's about a dozen or so countries and a little less then 1000 items. The data has the items listed more than 100,000 and the country is list once for each of the 8000 orders, using round numbers. The way I put together the cross tab query didn't display the data the way I needed it. If...

I thought I had it using the function from the first link. It looks like the data populates correctly on the screen when it's ran, but it just sat there and never seemed to finish. I couldn't select anything and query process bar at the bottom wasn't there. I trying to export it to excel now...

So create a function and call it in the sql query. I can do that ...I think :) Thanks for the links.

I'm working getting the countries we've shipped to listed by item. It's was pretty easy up to the point where I was asked to list all of the countries for that item on the same line. The way it's listed now is Item1 Description Country Item1 Description AnotherCountry Item1 Description...

I dont know how it works, but it works. '//Name : AttachDSNLessTable '//Purpose : Create a linked table to SQL Server without using a DSN '//Parameters '// stLocalTableName: Name of the table that you are creating in the current database '// stRemoteTableName: Name of the...

I tried something different and got "Object required (Error 424)" on line: Set tdfCurrent = Currentdb.CreateTableDef(dbo.vICLocation) Private Sub Form_Load() Dim Currentdb As DAO.Database Dim tdfCurrent As DAO.TableDef Set tdfCurrent = Currentdb.CreateTableDef(dbo.vICLocation)...

I couldn't get it work. I get an error that reads "expected end of statement" on the line that starts with "tdfCurrent.Connect =" and everyline after that till "tdfCurrent.SourceTableName = dbo_vICLocation". What am I doing wrong? Private Sub Form_Load() Set tdfCurrent =...

Thanks for the link. The source article is a good reference too. http://support.microsoft.com/kb/892490

Hello all, I'll trying to query a linked SQL table, from SQL Server 2003. Everything works fine on my computer. I have the data connection on my computer and have using these tables for a couple of years. When I share the front end with other users it fails to connect when they try to run the...

I would also have to delete the record if the user clicks cancel. Thanks for the replies. I'll give it a go. The code should be easy enough now you've helped me think it through.

So what I hear you saying is. On Load create a record using the txtOrderNum (that will create the primary key too). This would be the a place holder of sorts. Then finished writing the rest of the record went the user clicks save? I think that make since.

I agree. I just wanted the user to know the order number while the form is open so they can write down or communicate to someone else for later reference.