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: *

  1. ApplePirate

    Shift bypass

    I know this is a regular topic in here. there is a way to disable the shift key and prevent users from opening the database in design view. But is it possible to assign the bypass to another key other than shift?
  2. ApplePirate

    moving attachments from outlook

    im hoping someone can help me, Im new to VB and cant seem to get this code to work, the code is available elsewhere on this site but im trying to get the code to only look in a specific folder the folder "scottish southern" is in my inbox in outlook...
  3. ApplePirate

    moving attachments from outlook

    Someone please help Im new to VB and cant seem to get this code to work, --------------------------------------------------- Function Item_Open() dim objNameSpace dim objFolder dim objItem dim objAttachment dim intIndex dim intIndex2 dim strFiles dim DefaultFolder set DefaultFolder =...
  4. ApplePirate

    stripping outlook attachments

    Ive obtained this code from another thread, option explicit Function Item_Open() dim objNameSpace dim objFolder dim objItem dim objAttachment dim intIndex dim intIndex2 dim strFiles set objNameSpace = Application.GetNameSpace("MAPI") set...
  5. ApplePirate

    Outlook VBA

    Im using this bit of code to move attachments from outlook to a specified folder. ------------------------------------------------------ ------------------------------------------------------ option explicit Function Item_Open() dim objNameSpace dim objFolder dim objItem dim objAttachment dim...
  6. ApplePirate

    adding file name to each record on import

    I have a module that i use to import a number of files from a set location. Is there a way to tag the filename onto each record as it is imported so i know where the record came from. this is the code im using ------------------------------------------------------- Function importXLS_files() Dim...
  7. ApplePirate

    getting a BMP image out of a form

    Ive got a main splash form on my database, the form contains a .bmp image. in the properties of the form the picture property shows a path to a linked image but the file does not exist, and if the link is deleted the picture dissapears from the form, the picture type property is 'embedded' but i...
  8. ApplePirate

    boot problem

    I have installed VPC 6 on os 9 on my ibook, everything worked fine, windows installed great and i even installed office and used the ibook for number of weeks without any gliches, until i installed osx, then it kept crashing, so I cleaned the drive did a full install of 9 and x and installed...
  9. ApplePirate

    Folder/File browser

    Does anyone have an example database that has a form which can browse a users directory listing all folders and/or files. then return the full path of a selected folder and/or file to a text box on the form. ive been trying all week to build one using the codes ive found here but had no luck...
  10. ApplePirate

    Change Special Effect

    Does anyone know what the code would be to change the special effect of a box from raised to sunken Never ever, bloody anything, ever
  11. ApplePirate

    checking table for existing data

    ok, this is what im doing:- I have a table of customer registrations, the registrations can come from a number of sources and are loaded into the database through an input form by a number of bods. what i want:- is to have the primary key checked once its loaded and a message box to appear if...
  12. ApplePirate

    Importing text file. Access not recognising CR

    I need help fast. i have hundreds of files which i need to import into access, they are all text files but access does not recognise the carriage return within the file so i get one record from each file, e.g:- &quot;Field 1&quot;,Field 2,&quot;Field 3&quot;->blacksquare<-&quot;Field...
  13. ApplePirate

    reset a variable

    how do i reset a variable? Never ever, bloody anything, ever
  14. ApplePirate

    Resetting a variable

    How do i reset a variable? Never ever, bloody anything, ever
  15. ApplePirate

    Criteria - Containing text

    this is probably very simple,,, how do I set the criteria in a query to only return records where a certain piece of text is contained in the field. i.e Like &quot;*Front Street*&quot; Never ever, bloody anything, ever
  16. ApplePirate

    macro If Then Else Problem

    Hi I need a macro that is part of a bigger macro to look for a value. i.e. the username. so:- If username=&quot;me&quot; then openform1 else openform2 but i cant get it to do this. the actual function of the macro is to open a word document which is located on a shared drive, but i want to...
  17. ApplePirate

    Route number

    Does anyone one know of a way to insert a record into a table and then assign it a delivery route number, im building a database for a friend which will manage his milk deleivery route, i need to insert a customer in the delivery route and then reassign a delivery route number to all the...
  18. ApplePirate

    '' isnt an index in this table. Look in the indexes collection of the

    I am getting the following error message :- '' isnt an index in this table. Look in the indexes collection of the TableDef object to detarmine the valid index names. the database is then not opening, and i cant import into a new database shell either. please someone tell me what i need to do...
  19. ApplePirate

    Refresh form data

    I have a form which holds data, data on the form can change at any time and i want a refresh action to happen at regular intervals, but because i have linked another form to open on the on timer event i cant have the form close and open in one sweep. so i need something that will just refresh...
  20. ApplePirate

    Convert Access 2000 to 97

    can an access 2000 database be converted to 97? Never ever, bloody anything, ever

Part and Inventory Search

Back
Top