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

    Access 2003 opening notces

    Hi, Just started to use access 2003! How do I stop the annoying notices before access opens? It drives me up the wall! Thanks Romnew
  2. romnew

    Open barcode software from Access

    Hi all, I wish to open Barcode software from Access 2000 and print a barcode label from detail data in Access. I am not familiar with the "shell" of other softare from Access. Any help appreciated. Thanks
  3. romnew

    REPOST:How can I Print saved SNP files from code?

    Hullo Kchernak and everyone, Kchernak, you wrote in your post, the same name as above, the following: I spent some time looking through the snapview help files and ended up having to create a form with a snapshot control where I could manipulate the snapshot path property using code, and then...
  4. romnew

    How to print a snapshot report from access in VBA

    Hullo everyone, I am sent a snapshot report by email. How do I print this report from Access using VBA? Another question please: How does one import a table into a Database from another database using VBA? Your help is greatly appreciated Thanks Piet
  5. romnew

    Access to Excell

    Hi everyone, I have code (snippet below) which creates a excell sheet from an access recordset. After the process it shows the sheet and a prompt to save changes How can one prevent this happening. With objSht .Range(.Cells(1, 1), .Cells(conMAX_ROWS, _ intLastCol)).ClearContents...
  6. romnew

    Repost:Outlook Code move attachment

    The following code was suggested by fumei who assisted greatly.But there is a slight hitch. pleaHi Gerry, I have adapted your code slightly(you will notice where) but it comes uo with an error type mismatch at the line, marked****. Any ideas why? Thanks again for helping Piet The code: Dim...
  7. romnew

    Outlook Code to save attachmnet to a folder

    Morning all, I have tried to set up code from other code obtained from the net. to save an xls attachment to a designated folder from a command button. my intention is to read all unread emails and save the attachments My code boms out with error message Object required at line For Each objAtt...
  8. romnew

    Change table names programmatically

    Hi everyone, Can someone please help! Acc2000. Here is the scene. I have a similar database use by several users in an agricultural type of operation. Certain information from this database is extracted and created in another database which is then emailed to a central point where by manual...
  9. romnew

    Child nodes! How to expand treeview

    Hi all Access97 The code tv.nodes(tv.nodes.count).EnsureVisible expands the treeview nodes but not the child nodes. What do I use to make the total tree to expand? Idont see the "trees" for the wood Please help
  10. romnew

    Code closes mysteriously? Please Help

    Hi, Question: Access2000 I activate the code below from a form. The code does what is aimed at.Although the particular e-mails are created the code does not finish. A dark grey square forms itself over the form from which the code was activated. The code as can be seen closes this form but does...
  11. romnew

    Outlook code seem to not close

    Hi, Question: Access2000 I activate the code below from a form. The code does what is aimed at but although the particular e-mails are created the code does not finish. A dark grey square forms itself over the form from which the code was activated. The code as can be seen closes this form...
  12. romnew

    majority value

    Hi ye programmers, I need to find the majority value of a certain field of the last ten records within a table. Finding the last ten records is OK but it totally escapes me how to find the majority value of the field just using a query or code.Please help Thanks.
  13. romnew

    Creating properties

    Hi all, I have created new fields ia a table using code with the function createfields. I wish to create the properties, Format and DecimalPlaces for these fields, but...am at a total loss of how I do this. Any code direction will be greatly appreciated. Thanks again for a great site.
  14. romnew

    Nodata event

    When a report has no data the no data event can be used to give a message that there is no data to report on. When I use this, however, a runtime error 2501 comes up saying "The openreport action was cancelled" How do I get rid of this dialog coming up. Your assistance is greatly...

Part and Inventory Search

Back
Top