Search results for query: *

Hi all, you can install the Access 2002 runtime without package and deployment wizard for sure. Just two files are needed: ACCESSRT.MSI OFFICE1.CAB Doubleclick the first one and the installation starts. A far better (and free) alternative to the Package and Deployment wizard is Innosetup. I...

Justin (and other interested readers), after rebooting and checking the entire harddisk for errors everything works just fine again! (I hate it when this turns out to be the solution, although I'm very glad the problem's solved). Thanks for thinking with me! Keimpe

Hi Justin, thanks for being so helpful. Unfortunately, telnet could not make a connection, so I guess the port thingie is not the problem. I have setup two servers almost identical, and one of them is giving me this problem. The main difference between the two servers is that one of them is...

Hi Justin, thank you for replying! Unfortunately, I know nothing of Telnet. Could you give me some instructions on how to check port 10.000 using Telnet? Thank you! Keimpe

Hi All, I use Veritas Backup Exec 9.0 for Windows Servers and cannot make backups because the service called "Backup Exec Remote Agent for Windows Servers" has the status "Starting" all the time. And since the "Backup Exec Job Engine" is dependent on the Remote...

Hi everyone, I have the strangest of problems: I have an Access database that runs an update query containing a JOIN between a remote SQL Server table and a local Access table. The primary key is a uniqueidentifier field (GUID). The update query runs just fine on regular Access, but fails on...

Hi Cris, is your problem solved yet? I get the same error when I try to send a message to people whose addresses I fetch from a database, but only when the email address is in any way 'wrong' in such a way, that if you would send the message manually in Outlook, it too would refuse to send it...

Hi Ivo, I noticed your question from a while ago. I am looking for the exact same answer. Did you find it eventually? Please post your experiences. Greetings! Keimpe

Hi everyone, I have created a Crystal Report (in VB.NET) based on invoices. I can't figure out how to get that report to open and show me just ONE invoice. It always shows me all invoices in the invoice table. Do I have to call the report with a certain parameter? Or do I have to change the...

Hi DonQuichote, thanks for correcting me! Keimpe

..."dd") & "/" & Format$(vDate, "yyyy") & "#" DateSQL = sDateSQL End Function And I use this function as follows: strSQL = "SELECT * FROM ORDERS WHERE ORDERDATE = " & DateSQL(datStartDate) & " ORDER BY ORDERNUMBER; Greetings, Keimpe

Hi there, if you create your SQL string in VBA, don't forget to include the # around the date, like: #11/01/2002# To see how this works, simply create a query in query design view that selects records based on a certain date and then switch to SQL view. Then you'll see the 'behind-the-scenes'...

Hi everyone, I have solved my problem! Thanks for everyone who came up with ideas, buts and suggestions! My problem was: how to distribute a database program on CD-rom and run it on people's computers, who may or may not have Access installed, without installing any databases or program groups...

Hi Bastien, I'm afraid that 'Application.DisplayAlerts' is an Excel command, because it doesn't work in Access, even when I make a reference to Excel. Did you get it to work in Access? And if so, what references do you have in your modules? Greetings, Keimpe

Hi Bastien, Thank you for your reply! Where do I put that code? Greetings, Keimpe

Hi everyone, I have a VB.NET application and have created a report for invoices. Now, how do I open that report for just one invoice? In other words, how do I pass a filter/parameter to a Crystal Report so that it opens with only 1 record, instead of all records? And, while I'm at it, can I...

Hi everyone, I am running a database from CD-ROM. Every time I start it, I get a message saying that the database is read-only and that I cannot make any changes. Is there a way to keep this message from coming up? Thank you! Keimpe Wiersma

Hi Jeremy, Yes, that oughtta do it, BUT, 1) I don't know the drive letter of the CD-rom drive, so I can't make a reliable shortcut 2) I will still need an autorun.inf file on the CD to kick of the Package and Deployment wizard, because some clients will have Access installed and other won't...

Hi Jo, I understand your concern, but I already have it running. That's not the problem. There's a CD with a database on the cd-rom, and I can double-click it and work with it and it all goes well (it's a product catalogue, so there's no need to write any data, because ofcourse I know that a...

Hi Garth, the .LDB file is not the problem: all I have to do is open the database read-only or exclusive. Then it's no problem to run a database file from CD. The problem is how to make the installer know that the client doesn't want to run the application from hard disk but from CD. Now...