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

    Assistance with where clause coding

    I have a module that will manipulate "appointments" in an Outlook calendar. The calendar entry has a reference number that is keyed to the Access database. Unfortunately, I cannot use a custom field to hold this reference number as there are other restrictions which prevent this. I have this...
  2. theConjurian

    No administrator rights after upgrading to Windows 11

    I updated from Win 10 to Win 11 at the end of December and have since discovered that I have no administrator rights. This is a single desktop machine with no other users. There are only two accounts on the machine: administrator owner Neither have passwords. The last thing I checked/found...
  3. theConjurian

    DoCmd.Close not working

    My app has been running for years and all of a sudden my line of code to close and save a report has stopped working. I am running Office 365 on Windows 10. I have attached the relevant subroutine to this post. What do you think? Ron...
  4. theConjurian

    Outlook Calendar creating duplicate entries when synced to iCloud

    I run Microsoft Office 365 and have Outlook connected to iCloud in order to sync to several mobile devices. This is on a Windows 10 machine with 32GB RAM. I recently discovered some random entries had been duplicated and in each case one of the entries cannot be deleted; when trying to edit the...
  5. theConjurian

    Access slow to start

    Some time after upgrading to a new (and very fast i9) computer running Windows 10 and Office 365, my Access applications are VERY slow to start. It takes around 20 seconds to start the application directly BUT Access itself will start immediately. Opening any of the applications from there is...
  6. theConjurian

    Creating Outlook calendar items in an iCloud folder

    I have a CRM type of application that manages contracts for an entertainment business. One of the functions creates a calendar object in Outlook. This has been running just fine for a long time. I am trying to implement synchronization via iCloud to my phone and tablet. Unfortunately, this...
  7. theConjurian

    Database engine cannot find the input table or query

    I have an application that has been performing a mail merge successfully for some time. I recently performed the following structural changes to the database: 1. I converted from .mdb to .accdb 2. Later I split the application and database to frontend/backend which reverted the types to .mdb In...
  8. theConjurian

    Missing MAPI OCX

    I am in the process of transitioning an Access application from version 2007 (running under Windows XP) to version 2010 running under Windows 7 (64-bit). I cannot find the mapi*.ocx object to include in the references. Does anyone know where to find the appropriate OCX or what the replacement...
  9. theConjurian

    PPD Compatibility

    I just added an iBook to our Windows network, and have just about everything up and running the way it should. The one missing piece is the printer which is connected to a print server. The OSX 10.3 install does not include a PPD for our ("mature") printer. During the configuration I...
  10. theConjurian

    Can't find field 'Forms' referred to in your expression

    DoCmd.OpenReport "Booking Information", acViewPreview, wherecondition:=strWhereCond DoCmd.SendObject acSendReport, "Booking Information", acFormatHTML, strAddress, , , _ "Booking Information", strMessage, True DoCmd.Close acReport, "Booking Information&quot...
  11. theConjurian

    Dynamic Query for Mail Merge

    In the application I have developed, I have a series of dynamic (program generated) queries based on user-selected options and parameters. Right now these queries are realized as a form. I simply haven't figured out how to take the resultant SQL statement and realize it as a query. What I...
  12. theConjurian

    Public Function

    In a post in October, 2001, MangroBongacello wrote ... First make the event procedure you want to call public (replace the word Private with Public). Then in your general module write: dim x as New Form_YourFormName x.cmdOpen_Click I have been trying to apply this to a project I am...
  13. theConjurian

    Output is all black

    I have a scanned graohic image that I have edited in Photopaint 10. When I try to print it, it comes out ALL black. The printer is a Lexmark Optra R. When I change printer drivers (from PCL) to Postscript it prints OK. Although it's been a while, this image has been printed before! Does...
  14. theConjurian

    Control Limit Reached

    As part of my application I have a form with a tab control (2 pages) and a subform (continuous form). I have reached the VB limit of 255 controls. The error message suggests, "If you have deleted controls from this form or report in the past you may be able to rename the form and add more...
  15. theConjurian

    Where are my fonts?

    I am starting to migrate an application from Access 2000 to Access 2002 and have run into something of a roadblock. I cannot access any fonts under 2002. First of all: System 1: Windows XP Office 2000 original development system System 2: Windows 98 SE Office XP migration system When I...
  16. theConjurian

    Access 2000 Reports Don't Run Under 2002

    I developed an application under Access 2000. Opening the db in Access 2002, everything looks fine in terms of the forms and the VB code that I wrote. However, none of the reports seem to run. All I am seeing is blank pages. What am I missing?
  17. theConjurian

    Debugging Locked Dynaset

    I am working on an application for a talent agency. The top three tables are customers, event, entertainers (think customers, orders, order lines). The primary keys are as follows: Customers: ContactID Events: ContactID, ReferenceNo Entertainers: ReferenceNo, LineNo The Customer detail form...

Part and Inventory Search

Back
Top