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

  • Users: PizMac
  • Content: Threads
  • Order by date
  1. PizMac

    error 3027 database or object is read-only

    I copied a database from a colleague and got the above 3027 message. I edited its properties and unchecked (I can't quite remember) a box about "from another machine" - and unblocked it. It is NOT read-only I cannot overcome this and now an older copy that I created is also giving the same...
  2. PizMac

    bug in a left join in Access 2013

    I have simplified my problem to the basics - 2 queries from a simple table - here is the table:- Input ID ctry 1821 China 1822 1823 China query 1: (IM) SELECT Input.ID, Input.Ctry, 6 AS Pts FROM [Input] WHERE (((Input.[Ctry]) Is Not Null)); result: ID Ctry Pts 1821 China 6 1823 China 6 query...
  3. PizMac

    2013 findfirst not found

    I have converted a 2003 mdb to a 2013 accdb and now my modules won't compile. I get (for findfirst) - "method or data member not found". Do I need new reference libraries or something? code below:- mySQL = "SELECT * FROM [5-4AveSchoolBySector] ORDER BY [SID], [Sect];" Set myPercs =...
  4. PizMac

    reset an empty counter/autonumber to 1 without compacting

    I have a table with an autonumber/counter which has all records deleted (through code) and I wish it to reload the table starting at 1 (again through code). If I copy and paste the table (structure only) in the database window this has the desired effect but I can't find a way of coding this. I...
  5. PizMac

    Run-time error 3011 when repeatedly opening form which exists

    Access 2003. I have a form which constantly loops calling another form (Import_Export) every n minutes (parameterised - set to 5 minutes at the moment) to process files which the user has dumped in a folder. It runs happily for days and then eventually crashes on the form open with the message...
  6. PizMac

    Smartsuite 1-2-3 release 5 and Windows 7 hangs

    I've had to re-install smartsuite release 4 ( I only actually use 1-2-3 release 5.0) and now, although it opens wk3 files and some wk4 files without problem, it hangs when I try and open most of my wk4 files - any help appreciated
  7. PizMac

    filesearch.execute stops working after some days

    I have a program that loops forever picking up files and processing them every 5 minutes (in an outer loop) but after some time (not fixed but usually about 6 days) it stops picking up the files - I have found the problem to be that the filesearch.execute is eventually returning 0 even though...
  8. PizMac

    alphas rejected on import excel initial numeric column

    I've seen various posts re this subject but can't find a solution out there that doesn't involve either amending the registry (and I can't do that at my client's site) or manual intervention (and we don't want that). I am importing an excel file via transerSpreadsheet in code behind a form, and...
  9. PizMac

    transferspreadsheet row numbers

    I am importing an excel sheet with the transferspreadsheet command and I need to be able to reference the original Excel row number - is there any way I can add an autonumber key as I can when File-importing (specify "let access add primary key" and it gives an autonumber ID) ? Without the ID it...
  10. PizMac

    Reading Outlook emails in Access VBA

    I am writing code behind a form to read emails from a specified outlook folder, download attachments and do various other processing. I am unable to find the code to get the sender's email address. I can get the recipient (the TO name) with .to (although it requres permission to be granted). The...
  11. PizMac

    Reading an Outlook attachment in VBA - 2nd try - please

    I asked this question back in March and got no replies - I'm still wanting to do this - so am trying again... I need to read an attachment to an email in Access - VBA on a form. I can get at my inbox with File-Import/Attach but this only tells me IF there is an attachment or not - I actually...
  12. PizMac

    OPENING AN OUTLOOK ATTACHMENT FROM ACCESS

    I can link to/import my outlook folder contents but I need to read the attachment and this command only tells me if there is one there or not - surely there is a way to actually open and read the attachment?? Any help gratefully received
  13. PizMac

    OPENING AN OUTLOOK ATTACHMENT FROM ACCESS

    I can link to/import my outlook folder contents but I need to read the attachment and this command only tells me if there is one there or not - surely there is a way to actually open and read the attachment?? Any help gratefully received
  14. PizMac

    missing references?? in 2003 - worked in 2000

    I have some old code that has worked for years (up til 2000) but now gives me "invalid procedure call or argument" in 2003 Dim dbs As Database, rst As Recordset I have tried DAO.Database/Recordset and still get the error I have the same references as before including Microsoft DAO 3.6 Object...
  15. PizMac

    automate download of outlook attachments

    does anyone know if you can write code (in VB or anything else!) that can automate the dowbnload of an attachment - when a certain e-mail comes in the user would like to press a "button" and automatically have the attachment downloaded to a specified folder.
  16. PizMac

    scripting and deletefile and McAfee

    I am using the following code to delete a file and then copy another to it - my problem is that the scripting causes McAfee virus checker to prompt the user to continue - is there an alternative way to do such operating system related tasks without causing McAfee concern please? Set fs =...
  17. PizMac

    Loop around files in a folder

    I would like to code a procedure that (given a known folder name):- loops around a routine which imports file beginning with "xyz" (of indeterminate types) appends file to a combined table moves said file to sub-folder (named archive) the import (once I know the file name) and append I don't...
  18. PizMac

    Variable substitution

    I want to declare an array of variable names and contents and then code a loop which sets them e.g. set var1 to "a", var2 to "x" using an array like dim a(2,2) as string a(1,1)="var1" a(1,2)="a" a(2,1)="var2" a(2,2)="x" 'and then for i=1 to 2 &a(i,1)=a(i,2) loop but...&a isn't right -...
  19. PizMac

    Read Only Form

    I want to open a form sometimes as read only - I have tried both me.allowedits=false, openform.........acReadOnly BUT it only sets this after going to a subform and back - I can change the data on first entry, but as soon as I switch (the form loses the focus?) and come back then I cant change...
  20. PizMac

    Maximizer OLE to VB

    Does anyone out there use OLE to interface with Maximizer? I have a very simple piece of VB code that hangs off a maximzer toolbar button. It returns me the current company information no problem. I then want to loop through all contacts for that company and I can't find the commands to access...

Part and Inventory Search

Back
Top