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!

  • Congratulations strongm 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: *

  • Users: kilt
  • Order by date
  1. kilt

    Windows Update v5

    Hi Barry - try Kb 871260. Kilt
  2. kilt

    Windows updates wont install

    Hi Rednik - could be one of many problems. here's a link that'll help you out http://v4.windowsupdate.microsoft.com/troubleshoot/ Good Luck Kilt
  3. kilt

    Sort report in groups of 10

    Ok - to simplify, I have a report like so: RefNo Name Paid Method 1 X £50 Cheque 2 3 4 5 6 7 8 9 10 11 12 etc I would like to have: RefNo Name Paid Method 1 x £50 Cheque 2 3 4 5 6 7 8 9 10 Space or line here (after every 10 records) 11 12 13...
  4. kilt

    Sort report in groups of 10

    Hi all, I have a simple report that has 4 fields based from a query. The 4 fields are RefNo, Name, Amount paid & Payment method. This report is printed on a daily basis & is grouped simply by Name ascending. On a daily basis we have a report that shows all payments from Names A-->Z &...
  5. kilt

    Retrieve lost data

    Hi Bob, I've taken both tables & did what you said. the data field Sort is the added autonumber Here are the last entries from the corrupt table Sort Tref Month Amount Sent 26480 12102 01/05/2004 £0.00 No 26481 12103 01/03/2004 £0.00 Yes 26482 12103 01/04/2004 -£7.50 No...
  6. kilt

    Retrieve lost data

    Hi Bob, I did try that last 40 method but it didn't work with my table. Of the 4 fields in the table, 2 constitute the Primary key with one of them being related in a one to many relationship with the main table of our database, which is an autonumber. That number is pulled out of the...
  7. kilt

    Retrieve lost data

    Bob, I appreciate your help, unfortunately I'm not too hot on my SQL. I understand what the code is trying to achieve but when I write & try to save it I get an error of: Syntax error (missing operator) in query expression "(B.ID) IsNull". I've also noticed that some of the data fields in...
  8. kilt

    Retrieve lost data

    Hi everyone, One of the tables in our database corrupted. It contains 4 data fields & has 40 records in it that have been added since our last backup. I would like to find the records that aren't in our backup so I can manually/ update the uncorrupted table. I know this can be done...
  9. kilt

    Remote access into .mdb

    Thanks for the replies - technome i think you're right. We only have an 0.5 Mb ADSL connection with Upstream of 128Kb/s. ( Unfortunately we can't upgrade our connection due to location ) I will add more RAM & hopefully this might increase the Remote Users experience. Cheers, Kilt
  10. kilt

    Terminal Sever with VPN and MSAccess

    Hi Romh - I had the same problem as you (& stll do). i couldn't open our access database over VPN so i started using TS. The database can now be opened but some of the larger queries make the database unstable & we have a 1.8 Gb Pentium 4 CPU & 1.5 Gb RAM + this is when there is only one user...
  11. kilt

    Remote access into .mdb

    Hi everyone, My boss & 2 others need to work on our access database, remotely. I've got them connected via VPN & TS but they're complaining that it's very slow when querying etc. I know the speed is going to be less than on the LAN but does anyone know of any way to speed up the...
  12. kilt

    Opening Access database through VPN

    Thanks for the reply. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas? Thanks, Kilt
  13. kilt

    Open access Front End through VPN

    Thanks for the replies guys. I've tried TS - it works but the end user says it's too slow so I'm looking at 3rd party applications to speed things up. Any ideas? Thanks, Kilt
  14. kilt

    Open access Front End through VPN

    Hi everyone, I set up a VPN to Remote Access into our Access XP database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article to support the error...
  15. kilt

    Opening Access database through VPN

    Hi everyone, One of the main reasons to set up our VPN was for Remote Access into our database. After a lot of "hair pulling" I finally managed to get our users, access to our Network Shares. Unfortunately we can't open our access database. It's Access XP & the Kb article...
  16. kilt

    OutlookXP Asks For Exchange Password But Won't Allow Access

    I had exactly the same problem & did the same standard fault finding as you. Eventually I found Kb 325930 which solved the issue. I think it'll work for you. Regards, Kilt
  17. kilt

    Setting new default mail folder not working

    Hi all, We’ve just set up a new LAN. We imported our old message folders from O/E 6 into the new Profiles that use Outlook XP. In Outlook I’ve changed it to be the Default mail folder, both through Tools / Options / General & through the Internet options – choosing it as the Programme...
  18. kilt

    SMTP connection to ISP

    Hi everyone, I've set up an SMTP mail feed with our ISP. I can send out mail to any email address but can't receive mail. Our ISP says that they get "connection refused" at their end when they manually try to forward our mail to us. Our smtp virtual server is setup for our...
  19. kilt

    Assign 1 e-mail address to multiple users

    Hi all, Rolling out Exchange for 1st time this w/end & I can't figure out how to assign an e-mail address xyz@xxx.com to more than 1 user. Any help appreciated. Thanks In Advance, Kilt
  20. kilt

    Snapshot of Access data

    Hi everyone, I need to know if there's a way of taking a snapshot of all data added into a database on a daily basis so that i can send it by secure e-mail. The problem is my boss lives in a rural area & cannot get broadband or satellite coverage. What I'd like to do is give him the...

Part and Inventory Search

Back
Top