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 Wanet Telecoms Ltd 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: carlp69
  • Content: Threads
  • Order by date
  1. carlp69

    runtime error 2448 on Access 2003 SP3

    I have a DB thats working fine on Access 2003 SP2. I have installed Access 2003 SP3 on a couple of machines and now i get the runtime error 2448. i'm sure the same problem occurs in Access 2007. Any ideas without going into details? Cheers in advance.
  2. carlp69

    You can't assign a value to this object - 2448

    I have a project created in Access 2003, when I try to use it in Access 2007 I get the above errors. The code is fairly simple, so I can't understand why it works fine in 2003 but not 2007. A couple of examples of the code Are :- Me!EmployeeID = RS!EmployeeID Me![CancelledForm] = False Any...
  3. carlp69

    Database Moved, now will not function properly

    I have detached a datbase from an SQL 2000 Server, moved the files to a new server and attached it to a SQL 2005 Server. We have an Access 2003 Application that accesses the database, I have changed the connection to the new server but one of the forms returns the following error from the VBA...
  4. carlp69

    KMS fails to register with DNS

    Installed KMS on 2003 Server and activated it no problem. No errors where reported on the install and the licence state is active. On the Vista Clients an error comes up the event log "Publishing the Key Management Service (KMS) to DNS in the '<Domain Name>' domain failed.". On checked the DNS...
  5. carlp69

    Remembering previous file versions

    On Vista Machines we have a database. When I copy an updated version of the file to the local machine and execute it, it comes up with the previous version! If i run a compress and repair on the file it then loads the correct version. If I reboot the machine it then loads the correct version...
  6. carlp69

    Change default exchange name to new server

    We are installing a new exchange server and want to know if there is any way, either through group policy or scripts, to change the Exchange Server in the account setting of Outlook. I don't want to have to go around to each machine a change it manually! Thanks
  7. carlp69

    Internet access blocked when IP issued from 1 DHCP but Not the other!

    I have a problem that if a computer gets and IP address from one DHCP server the internet works and if the address is issued from the other it doesn't, comes up with Spoofed Source Address on FB! I am trying to migrate our network from one domain to the other and shut down the old domain and...
  8. carlp69

    Cannot execute .exe over shared/mapped drive

    We are setting up two new servers on a new domain. We have svr1 that was the 1st DC in the domain and has a share on the hard disk called support. The 2nd server svr2 is the 2nd DC and again appeared to be no immediate problems. However; when we create a mapped drive or browse the network to the...
  9. carlp69

    Calendar Control for Outlook 2007

    I have coding that updates the Outlook calendar from an Access form and works fine in outlook 2003. In outlook 2007 it come up with the error "Object library feature not supported". I have looked at the VB references and it has changed the "Microsoft Outlook 11.0 Object Library" to "Microsoft...
  10. carlp69

    Cannot change data in link table query

    I have set up a linked table to an table stored on our SQL Database via ODBC. I can open the table and edit the data directly in the table no problem. I then set up a query to query the linked table but cannot edit the data! Any ideas
  11. carlp69

    Revision Number - Database Property,Access 2003

    How do I setup and use the revision number in the database properties. When I look at the properties it has nothing in the 'Last saved by', 'Revision Number' or 'Total Editing Time' on the statistics tab. The database is an .ADP Project. Any Ideas
  12. carlp69

    Searching outlook task for specific item

    I have an access DB that creates tasks in an Outlook 2003 Public folder. My problem is that the tasks can be duplicated. How can I stop the tasks duplicating OR how can I search the task to see if the entry already exists before I create the new entry?. I have unique identifiers currently set...
  13. carlp69

    Renamed Account can no longer access emails

    We have renamed a user in AD Users and computers and the user can no longer access the emails and the user name does not appear in the address book. We have renamed users in the past with no problems. In AD Users and computer the Email Addresses Tab has disappeared, but the user has an mailbox...
  14. carlp69

    Create Calendar item in public folder from access form

    I want to create a calendar item in a public folder from within an access form. I want to include the basics such as subject, start date and end date. Anybody any ideas Thanks in advance
  15. carlp69

    New Records are being deleted when other users add records

    I have a form that when you go into it creates a new record using the "DoCmd.GoToRecord , , acNewRec" in VBA If I go into the form it creates a new record, say '1000'. If another user goes in and creates a new record, say '1001' and then comes out of the form before me, my record 1000 disapears...
  16. carlp69

    Delete mail from SMTP Mailbox

    I basically want to know if this is possible. If I have an Access Database that posts requests for leave into a single mailbox on an Exchange 2000 server and give authorised personel access to the mailbox. Each request contains a link back to the database to approve or reject the particular...
  17. carlp69

    Need to update records immediatly

    I have a form with an option box "Frm_PayMethod" that has two option buttons. The option box has an 'OnClick' event. The event has the following code :- If PayMethod = 1 Then me!Status = "Pay In Full" If PayMethod = 2 Then me!Status = "Pay SSP Only" Me!Frm_PayMethod.SetFocus When I click on...
  18. carlp69

    Email Report that needs to be filtered

    I have a report that opens from a button click with the following code : Dim stDocName As String stDocName = "rpt_PO_Main" DoCmd.OpenReport stDocName, acNormal, , "PONumber = " & Me!PONumber I want to email the same report directly from another button click, but when I apply the...
  19. carlp69

    Runtime Error 2001 You cancelled the previous operation

    This is so annoying for such a small DB I have a link table "dbo_qry_Admin_ExternalAPP" which contains basically EmployeeID, FirstName, Surname and other info on that employee. I have created a a form "Form1" with the Record Source as "dbo_qry_Admin_ExternalApp" and added to the form all the...
  20. carlp69

    Upsized DB - Need to create search query

    I have upsized my Datasbase in Access 2003 to a SQL2000 server. (I have notupsized the application due to the size and complexity of the forms, so all the tables have been converted to link tables). When doing a find (ctrl+F) the responce is exceptionally slow. looking at previous threads, they...

Part and Inventory Search

Back
Top