Search results

  1. KeithG

    Table Setup for a Treeview control

    I am designing a form with a treeview control and am looking for suggestions on how to setup my tables to store the information for the nodes. The issue is that a child node, can have children. So the Child can actual be a parent. So two tables with a one to many relationship doesn't seem to...
  2. KeithG

    Change COM 1 to a USB Port

    Does anyone know how to change COM 1 to a USB port instead of a Serial port? Can this even be done? Thanks in advance for your help.
  3. KeithG

    Event for reports similar to the forms Current event

    I have report thats show one record per page. I want to hide some controls based on a value of a control. I have tried the format and print event but these event seem to fire for the record after the condition is met. Any ideas?
  4. KeithG

    Create a Shortcut for a ULS Secured DB

    The attached Word document contains a userform in which you can enter information to create a shortcut to access a DB with User Level Security. This utility will be useful if you ever move your secured database or work group file becuase you old shortcut will not work.If you find this document...
  5. KeithG

    Access 2007 User level Security Articles

    Has anyone seen any good links to explain why Microsoft discontinued User Level Security in Access 2007? If so can you post the links. There is a debate at my work and I want to get all the infomation possible. It is my understanding that the beefed up the encryption on the standard password so...
  6. KeithG

    Send Left Arrow Key Keystroke

    Hello, Does anyone know how to use sendkeys to send the left Arrow keystroke? Or an altenative method to place the cursor in a texbox in the middle of the charactars with in the textbox? I am trying to create an auto populate function for textboxes similar to this type of feature in a combobox...
  7. KeithG

    Limit subform to one record

    Hello, I have a form with a subform displayed in single form view. When a user tabs into the subform and fills in the required info and tries to tab back out to the main form the subform will create a new record, therefore the info just typed is not visible anymore. How can I limit the subform...
  8. KeithG

    Linked tables from a db secured with work group security

    Does anyone use linked tables form a db that is secured with workgroup security? I just changed an existing db from the standard password protection to workgroup securtiy. I have some of the tables from this db linked in another db. Now when I try to access the linked table I get an error...
  9. KeithG

    Calculate Business Days - No Holiday Table Needed (including MLK day)

    Calculate Business Days - No Holiday Table Needed Public Function BusinessDays(dteStartDate As Date, dteEndDate As Date) As Long Dim lngYear As Long Dim lngEYear As Long Dim dteStart As Date, dteEnd As Date Dim dteCurr As Date Dim lngDay As Long Dim lngDiff As Long...
  10. KeithG

    Calculate Business Days - No Holiday table needed

    Below is a function I wrote to calcualate business days in a given time frame. The Begining and End date must be in the same year. A co-worker helped with the calculation to determine the date of Easter. Public Function BusinessDays(dteStartDate As Date, dteEndDate As Date) As Long Dim...
  11. KeithG

    Ad Hoc Query Writer

    I am creating a db at work that basically is a user interface to write a pass through query for our AS400. I save the query definitions to various tables so that it is stored an will be able to be modified. I have an elements table, a Criteria table, and a joins table (along with other tables...
  12. KeithG

    A single company can be calle numours names

    I have a db at work where a user will look up a company name and retrieve the CustomerNumber and PayCode (these two values change monthly) to input the numbers into our mainframe program. The users retrieve the company name from documents they are keying from so naturally different clients give...
  13. KeithG

    Data Entry Unbound Form

    I am creating an ubound form for data entry in the FE of my db. Once the user enters the data and presses the update button the form needs to add records to upto 8 tables. Is it more efficent to open up a recordset and use the add new method. Or use docmd.openquery to open an Append query to...
  14. KeithG

    retrieve textbox Handle

    I am trying to use the EnumWindowsEX API to retrieve the handle to all of the controls of an Access form but the EnumWindowsEX fuction does not retrieve the handle for any of the controls? Also I know I am passing in the correct handle for the form. Are controls on an Access form actuall a...
  15. KeithG

    Attachmate Macro's

    Does anyone out there write macro's for Attachmate? I am just curious there seems to be steady work where I am employed and was wondering if anyone else writes macros for Attachmate sessions.
  16. KeithG

    Must use File Open Command in Access to Achieve record locking

    It just read in Access Help that if you have open db using record locking checked that you must open the database using the File=> Open command from the MenuBar. Does anyone know anything about this or can anyone comfirm this a s true?
  17. KeithG

    Is Auto Number PK more likey to produce Locking errors in a multiuser db

    I have a db split into an FE/BE with about 15 users. Original I desinged the db with an AutoNumber PK's because I am a believe that a PK should have no meaning. When we started using the db on a daily basis multiple users were recieving errors that the record was locked but I know in fact this...
  18. KeithG

    Connect to a Text file (.txt)

    Hello, Is it possible to connect to a text file via ODBC with an Access database. I have tried with a pass thrrough query but I get an error stating you can not use ODBC to link to an external Microsoft Jet or ISAM database table. I know I could import the file but this would put my database...
  19. KeithG

    Cics

    Is it possible to connect to a CICS mainframe with an ODBC driver or an OLEDB provider? If so can you tell me the name of the driver or provider that I would need to use.
  20. KeithG

    The Microsoft Jet database engine stopped the process because you and another user ar

    I have created a db that is used strictly for data entry. I have one main form with about 6 embedded subforms and the db is broken down into a FE/BE. I currently only have one user in the database and sometimes when the user tabs into one of the subforms the will receive error 3197. I have...
Top Bottom