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 SkipVought 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. epoirier

    Windows XP Pro with Office 97

    Hi, I Have installed Office 97 on Windows XP Pro and i have a problem with picture. When i log on administrator account is working fine i see the picture. But when i log in user account all form with picture. The backgroung picture is missing. I think is in the right of user i don't know...
  2. epoirier

    Possible To View All Users Who Have A Database Open?

    you can also use the software Net Watch come with windows nt 4 server ressource kit. You can view all share folder on station and server, see all open files by all users. Manage Shares, stop share.
  3. epoirier

    WIN_SFV32 Create CRC File in VBA or VB.

    Hi, I want to know is possible to to create a CRC file for compare file by content in VBA or VB. Where i can find a source code to include in my program like ; Generated by WIN-SFV32 v1.0 a software Total Commander http://www.ghisler.com/ Thanks you, Eric
  4. epoirier

    Create a desktop shortcut for my packaged mde

    I don't know for Windows XP but in Windows NT4.0 Resource Kit Supplement One i have a tools shortcut.exe http://support.microsoft.com/default.aspx?scid=kb;EN-US;158682 Maybe this tools exist in Windows XP version. and i use a API to retreive the special Folder for create the shortcut on...
  5. epoirier

    Custom Help File in msaccess

    Here two software for build your own .HLP or .CHM File http://downloads.auricvisions.com/cgi-bin/AvlMail.exe http://www.ec-software.com/ The best for me i think is help & manual from ec-software you can compile into word, PDF, HTML add picture made some hot spot for linking topik, free screen...
  6. epoirier

    Saving Access File Every Hour

    Backup the database when is open by user can be corrupt the database. Me i suggest to you is backup the data only a been changed or added. You can add in each table a field daterecord. This field is modify when user add or modify a record and take the system date. You can made add query for...
  7. epoirier

    Time Intervals

    You can open table with DAO and pass on each record in your table. Other solution, maybe you can do this in Query update. Private Sub Commande0_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb 'Open your table tblLogs. Set rst =...
  8. epoirier

    Time Intervals

    I need more information of your structure of your data but You can't try to make a function to return Rate of each List Exemple: Private sub Commande1() Dim iReturnRate As Integer Dim a As Date a = time 'System Time for Test. iReturnRate = MyRate(a) MsgBox...
  9. epoirier

    Time Intervals

    yes you can use Select Case select case me![TimeField] case 02:00:00 to 2:59:59 SpotRate = 1 case 03:00:00 to 3:59:59 SpotRate = 2 case etc... End Select
  10. epoirier

    Detect Corruption of mdb

    Me is use a Function when a trap a error in DAO. If you have a corrupt database when you try to open in DAO the error #3343 (Access 97) is display and description of the name and the path of database corrupted. Finaly i extract the name and the path from description i pass in the Function to...
  11. epoirier

    Extracting Random Records

    Me i suggest to return the RecordCount and made a Random with the instruction (RND) Like This Int((RecordCount * Rnd) + 1. See Rnd Function in help file. Here i made some Fast Code i Think is Worked. Dim db As DAO.Database Dim rst As DAO.Recordset Dim iRecordCount As Integer...
  12. epoirier

    Performance Question

    Other suggestion is split your database in many databases. Example: Customer_be.mdb Production_be.mdb Administration_be.mdb Etc. Connect the user only when he need information after that close the database. Each user stay in the Back End Database only for few second after that is gone. When...
  13. epoirier

    runtime error 2448

    You can't not attribute a value on field if is used for calculated in query. Try this, remove ControlSource from your field [Total_Days] Change [Total_Days] to [Total_DaysTest] on your form and code and try again the Sub DAYSLATE maybe this correct the error.
  14. epoirier

    runtime error 2448

    Check for the format of the field [Total_Days] if the field [Total_Days] used in query and is based in your current form, check your if you can add record. Note: you can not use this Field if is used in query with Expression, Regroupement check you Query.
  15. epoirier

    Back End / Front End question

    In option Tools you must have option Complement ? (Sorry my Access is in french version) in this option find Split Data Base save your data _Be (Back End) on server, after the Access will made the link table for you. The best solution is keep all macro, form , query and module in the front...
  16. epoirier

    Count Character in Control Text

    Hi, I Build Label report, in the label i have many information. I can't grow any controls i must to change the size of some controls if the information containt over 36 characters. The problem is, i use the Font Time New Roman 14 Bold, each character exemple A is not the some size lettre Q...
  17. epoirier

    Drop a Users Connection

    Hi, Me i think is possible to dropping user, but is very long programmation. First you need to connect the user only when save, modify record or need a value Qty, info,etc Transfert all information in Temporary Database for each time you need to get or tranfert record on server Back to...
  18. epoirier

    Kill Processes

    I found some program in the Resource Kit of Windows NT 4 for killing processes, Is working great like kill.exe access.exe I want to use this program to remove screensaver if is activate. i try many thing like kill.exe scrnsave.exe, kill.exe myss.scr. but i don't know the name if this process...
  19. epoirier

    Converting DOS into Access

    It's possible but you need to know a struture of your Dos database Dbase, Texte file ??? Export into a text file your data with separation on each record with coma ; Some dos Database have export option to text file if you don't have this option is really hard you need to use Open # do a search...
  20. epoirier

    Making Access Application Stand alone.

    You need to buy the run time for Access 2002. The run time is only the the access without the programmation. I never buy or use this product but i know is existing. The other solution is make your application in Visual Basic (front end program). The database of access 2002 in back end.

Part and Inventory Search

Back
Top