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!

Register Log in
  • Congratulations Rhinorhino 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: PerryG
  • Content: Threads
  • Order by date
  1. PerryG

    A code writer, but not a PYTHON Programmer

    We get supplier data dumps from our suppliers about twice a month as text files. Some of these dumps can have 50 to 80 fields in them, of which we use approximately 30 in a std. text format file. Rather than have people do the ugly cut-n-paste thing, I'd like to develop something that can read...
  2. PerryG

    PC reboots whenever MS software is started

    Let the jokes begin....seriously, a friend of mine called with this problem. She has run all kinds of anti spyware and has the normal virus protection stuff. Whenever she tries to run anything in her Office Professional series, her pc reboots. Any ideas? By the way, if this is the wrong...
  3. PerryG

    Opening a 97 database from 2000

    Is there anyway to keep an Access 200x user from converting a Access 97 database to 200x (either deliberately or inadvertantly)when they open it? I looked in the FAQ but didn't find this. Thanks.
  4. PerryG

    In Access97

    I'm having trouble with a TableDef....keeps throwing a runtime error 3265 when I try to add it to the collection. I'm recreating a table substituting more meaningful field names for the convenience of the QA group. Here's the failing code: Set db = CurrentDb Set rst =...
  5. PerryG

    How do I return the report pagecount before printing the report....

    and give the user the option to cancel after they see the report may be 1300 pages long.
  6. PerryG

    Can you embed a browser in a form

    Using Access 2000.....never tried this and it seems information is limited. Thanks.
  7. PerryG

    copy url link

    I have an Excel 2K spreadsheet that has a value in a cell that is a hyperlink to a website...example: a1=001 and the link is to google.com. Can I copy just the url link to b2 without taking the visible value of the cell too, i.e. b2=http://www.google.com? Thanks.
  8. PerryG

    Replace and Substitute Functions in Access 2K

    People in my group aren't able to use the above functions. It's gotta be a reference thing. Does anyone know right off hand which references need to be set to make use of those two worksheet functions? Thanks, everyone. PerryG
  9. PerryG

    Corrupted db

    I can't open my database....I keep getting the following message: The Microsoft Jet Engine couldn't find the 'MSysDb'.... Any ideas where I can find this or how to salvage my db? Any and all help greatly appreciated.
  10. PerryG

    TransferText in Access 2000.....please bear with me

    I know this topic has been covered before in one of the forums, but for the life of me, I can't find it and I can't get the recommended solution to work. History: Using TransferText in Access 2000 to import or export you can receive error messages, and if you want to use a schemi.ini file for...
  11. PerryG

    Export spec file

    I'm trying to use the specification file with the DoCmd.TransferText. I'm supposed to be exporting a pipe-delimited, no-text-qualifier but all I get is the default comma delimited "" text qualifier. If I walk thru the wizard I get what I want but not with the docmd route. Help...
  12. PerryG

    Please bear with me....

    It's Monday.... How do I get the SUBSTITUTE worksheet function to work in Access 2000? When we run it, Access returns an error message saying it isn't a valid function name. I'm guessing it must be a references thing, but I'm not having much luck on my own right now. All help gratefully...
  13. PerryG

    Is it possible......

    to change the field index number of a table programmatically, i.e., change field(2) to field(6)? Seems like you should be able to, but I've never attempted it and I thought I'd ask before I wasted a lot of time (and raised my blood pressure to new heights) trying to do something that is not...
  14. PerryG

    Again...problem with sql

    DoCmd.RunSQL "INSERT INTO FILEEXTRACTS (supplier, [part number], afn, filename, filedate) SELECT DISTINCT [" & strTbl & "].supplier,[" & strTbl & "].[part number], """ & strFunction & """, """ & strTbl & ""&quot...
  15. PerryG

    What is wrong with this SQL

    It keeps throwing a run-time error 3141 DoCmd.RunSQL "INSERT INTO Resent_FileExtracts ( SUPPLIER, PART_NUMBER, AFN, DATE ) SELECT [" & strFullName & "].Company, [" & strFullName & "].[Part Number], """ & strAFN & """, """ &...
  16. PerryG

    I should know this, but.......

    Why doesn't this bit of code work (Access97)? If db.Containers("Tables").Documents(intI).Name = "AFN*" Then strFullName = db.Containers("Tables").Documents(intI).Name End If The variable keeps coming up empty. Any help appreciated.....time is short and the water...
  17. PerryG

    Can I do this?

    I have a folder on my C drive that has 130 Excel files in it. I want to write a vba script to go to the folder and get each of the Excel file names and write them to a table in Access so I can call them from another routine later. I'm using Access 2000 on xp. Again, can I do this and any help...
  18. PerryG

    embedded assembly??

    Is it possible to embed assembler code in delphi? Thanks. PerryG
  19. PerryG

    Access 97 update query

    Is there a way to run an update query referencing the fields in a table by their index instead of their name? We get tables from several suppliers; structures and data types identical, but with different field names. Thanks for the help. PerryG
  20. PerryG

    Probably not the place for this question, but......

    how's the job market for Access developers in your city? It's essentially non-existant here in Denver. There may be a move in my future. Thanks.

Part and Inventory Search

Back
Top