Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. keimpe

    I have Office XP Developer. Anyone

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

    Remote Agent service keeps 'Starting'

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

    Remote Agent service keeps 'Starting'

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

    Remote Agent service keeps 'Starting'

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

    Remote Agent service keeps 'Starting'

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

    Access runtime can't update SQL tables with GUID fields

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

    Outlook does not recognize one or more names

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

    Date/time picker events

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

    How do I open a report based on 1 record???

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

    SQL Date Format

    Hi DonQuichote, thanks for correcting me! Keimpe
  11. keimpe

    SQL Date Format

    ..."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
  12. keimpe

    SQL Date Format

    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'...
  13. keimpe

    Getting Access runtime to run from CD?

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

    How to disable 'Database is read-only' message

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

    How to disable 'Database is read-only' message

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

    How to open a report with one record

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

    How to disable 'Database is read-only' message

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

    Getting Access runtime to run from CD?

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

    Getting Access runtime to run from CD?

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

    Getting Access runtime to run from CD?

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

Part and Inventory Search

Back
Top