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: peryan77
  • Content: Threads
  • Order by date
  1. peryan77

    If folder exist don't allow to create

    How would I go about allowing a user to create a folder in a given directory, but only if it does not already exist?
  2. peryan77

    Cannot open associate xbase file !!!

    MV040603.CDX MV040603.DBF MV040603.FPT I tried to open the above DBF file with access and I get an error saying cannot open associated xbase memo file. All the files are their. I can open it in excel, but certain fields (prob those memo fields I need) are scrambled up. Does anyone know the...
  3. peryan77

    Problem with apostrophe in Name Ex: O'neil

    I have a combo box on my form and when I select a record from it (employee name) it goes to matching record in subform. However, i get an error when i select an employee name with an apostrophe in it. Syntax error, missing operator in expression. Here is my code..it works fine with all the...
  4. peryan77

    DTPicker Control to Current Date

    I am trying to set the DTPicker control to current date. Here is my code: Dim CurDate as Date CurDate = Date() Me.DatePicker.Value = CurDat The error I get is that the property is read only.
  5. peryan77

    Adding file to database without inflating

    About 5 months ago I saw an access database that showed how to add a file to the database without inflating it. Does anyone know how to do it, or possibly know what site it was located on?
  6. peryan77

    Ways To Speed Up Split Database on Network

    I have a split database on the network, unfortunately it is too slow. Are there ways to speed up the connection?? Some users access it using WAN. Unfortunately, they will not let me create a SQL Server Database.
  7. peryan77

    Microsoft DateTimePicker Control - Change Event?

    What Event would I use to initialize my code right after the person changes the date in this control? I do not see a change event for this control when I look under it's properties.
  8. peryan77

    Unlock all controls on Page 1 of Tab Control

    I want to unlock about 12 controls (textbox and combo) on page1 of a tab control. What is the best way to do this?
  9. peryan77

    Emulate Hyperlink - Changing mouse icon.

    Is it possible to change mouse pointer to hand? I am not familair with API yet. Can someone point me in the right direction.
  10. peryan77

    Sending E-mail

    I want to create ONE module that I can call from the onclick event of any text box on my form that will send an e-mail to the value in the textbox. I have 3 text controls that have different e-mail addresses. I do not want to rewrite the code 3 times. Is there a function that could do this...
  11. peryan77

    Need Help With Query

    I would like to return those records where Action = "Change Plan" for 3 months in a row (past three months) for all the users. These are the users where we have to change their plan because it has been recommended to do so three times in a row. One record would look like this...
  12. peryan77

    Help Programming Outlook Forms

    I created a Custom Outlook form and I need to know how to make certain controls invisible/visible based on the user selection from a combo box. I don't know VB Script, can anyone give a quick example? Thanks.
  13. peryan77

    Convert Week/Yr to Month/1/Yr

    I need help converting Week/Yr to Month/1/Yr. I have the week/yr in a table. Thanks.
  14. peryan77

    REALLY WEIRD

    I have a tab control on my form with 2 pages. There is a subform on page2 related to the recordset of the main form. When I use my mouse to navigate around I see the related records without any problems. However, when I tab between the 2 pages, all the related records in the subform...
  15. peryan77

    Update Visual Data in Shape

    I have my org chart connected and linked to a database, and the fields within the properties are updated without no problem, however it does not updated the visual content of the shape. The only way I can do this is if I individually select each shape and then I choose 'Select Database Record'...
  16. peryan77

    UPDATE ORG CHART

    I created an Org Chart with Visio 2002 Professional, by linking it to an Access Database. However, I cannot find out how to update the current chart when the database is updated. DO I need to program it in with VBA or is their an option that I do not see? Patrick
  17. peryan77

    Returning Records Based on Indiv Cell Clicks

    Here is my Subform in datasheet view (Based off a sub-query) Buildin Internal_FA Internal_PC MAASH 20 25 MABRO 143 142 MADAR 24 24 MADED 257 166 MAHIG 1 MALEO 21 20 MALOG 47 40 MAMAV 1 7 MANKT 4...
  18. peryan77

    Code for Scanning # of PC's on Network

    Can anyone point me in the right direction on how to create a program to return the # of PCs connected to the network? Also, what factors do I need to consider when programming this. I am new to C#. (VB Progammer, yuk!) Thanks
  19. peryan77

    Active X

    Does anyone know of any good/free activex controls we can use with access other then those that already come with Access? Thanks a whole bunch!
  20. peryan77

    Copying Files from network

    How would I go about automatically copying a file from a network source (non-mapped) to a folder on my computer? Also, if possible I would like to return when the file was created so I can determine whether it is a new version. Patrick

Part and Inventory Search

Back
Top