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 derfloh 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: brettatexplace
  • Order by date
  1. brettatexplace

    Access Program fails to start! NT4 vs WK3

    I have started to migrate users from NT4 to Active Directory/WK3 Server. When a user under NT has an Access app open (creating a lock file), and, as a Active Directory user, I also try to open the app - NOTHING HAPPENS! But when I open access, and point to the app through file open, it works...
  2. brettatexplace

    VBA code to Export report as Snapshot or Word doc?

    ...report y from the x info export y as snapshot to file location c:\files if eof exit else go next end loop Is there a simple VBA such as DoCmd.Export "y", *.snp , "C:\files" Also what is the syntax for the eof condition on a form?? Thanks to all in advance!!!
  3. brettatexplace

    Protect Access database

    Try not using any queries. Go into them, and view them as SQL, then copy the line to the DataSource of the form, then delete the query because it will no longer be needed.
  4. brettatexplace

    Protect Access database

    You can also turn off the menus in the Tools -> Startup screen. For you to turn them back on, hold down the shift key while starting up the app.
  5. brettatexplace

    Protect Access database

    Compile the Access Database as an MDE. Under Tools - Database Utilties - Make MDE File. They will not be able to go into design view of rpts,frms etc.
  6. brettatexplace

    Get UserID or Group from the OS

    What's the simplest way to call the MS XP OS to get the User Name or their group into my Access2002 App?
  7. brettatexplace

    Reference Books Access2002 or 2003

    I am using an old MSPress Access97 ref book. Can anyone suggest a newer reference book for Access/VBA Application development? (especially the newer stuff like Web Pages linked to the Access Database)
  8. brettatexplace

    Create Multiple RTF Reports using strFilter

    ...= "rptGOData" DoCmd.OpenReport stDocName, acPreview, , stFilter DoCmd.Minimize DoCmd.SendObject acReport, stDocName, "SnapshotFormat(*.snp)", , , "", strTitleLine, , True, "" DoCmd.Close acReport, stDocName ' go to next but this is a snapshot output, but should work the same
  9. brettatexplace

    Report shows differenent data on different pcs

    I would check to see if the Regional Setting on both pcs are the same (especially if anything is using dates)
  10. brettatexplace

    Copy Record to other database before clearing some fields?

    Sorry, it is Access2002
  11. brettatexplace

    Copy Record to other database before clearing some fields?

    I have a form that displays a record, and it has a "clear" button on it. When the "clear" button is pressed, I wish to secretly copy the entire record to an identically structured database (using VBA), and then clear most fields displayed on the from to null. ie. Everytime the clear button is...
  12. brettatexplace

    Deleting using Command Buttons

    If the query is made from at least two tables, the displayed line may represent a combination of tables, and you will not be able to delete the line (since it is not a single record in a table).
  13. brettatexplace

    Background Color to Alternate with Each Detail section?

    Excellect, worked great. Thanks. (I didn't know weather the last detail would remember what color he was so I could just alternate)
  14. brettatexplace

    Background Color to Alternate with Each Detail section?

    It seems that you are filling a box behind??? My detail sections are not fixed heights, but grow or shrink depending on content. (as per line on page == details that fit on page) I tried it but got something weird.
  15. brettatexplace

    Background Color to Alternate with Each Detail section?

    I have a Detail section that I would like to alternate the background color when it is formated. (from gray to white so that this is used instead of putting a line between each detail) Can anyone suggest how to do VBA on the OnFormat section of the Detail. ie: Detail.BackColor = grey I would...
  16. brettatexplace

    Concatinate values from a column into a single line??

    Problem SOLVED! THANKS TO ALL, I actually found a Cacatenate function about three listings under mine on another persons question just after I sent mine. (The one dhookom sent me!)
  17. brettatexplace

    Concatinate values from a column into a single line??

    Help! Is there something simple to do this. If I have a qry like this... ID# Time 6 X 6 Y 6 z 7 g 7 b 8 e how can I run a query/vba to get it grouped for my ID# so that it looks like this... ID# Times 6 x,y,z 7 g,b 8 e I am...
  18. brettatexplace

    Copy/Rename/Delete Files from within Access using VBA

    Need a little help remembering. I need to copy, rename and delete files in a folder on the network, from within Access using VBA linked to a button. I can't get the shell command to work! Can someone please provide a example of the syntax. Thanks in advance.
  19. brettatexplace

    Function to retrieve UserName in VBA?

    Told you it was easy! Thanks everyone.
  20. brettatexplace

    Function to retrieve UserName in VBA?

    Easy question, but I can find it in the help files. I want to get the userID name retrieved from the network login. Is it something like??? Dim strUserIs as String strUserIs = Environ("UserID") Thanks in advance!

Part and Inventory Search

Back
Top