Recent content by epoirier

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

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.

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

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

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

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

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 =...

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

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

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

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

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

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.

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.

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