Search results

  1. R

    Batchfile for backup with timestamp

    I got this searching on google might be helpful echo off set file=%1 :: If no file is given on the command line then use :: this filename as an example if [%file%]==[] set file="Cabinet Budget.pdf" set amp=& if not "%amp%"=="&" set amp=^^^& set TmpFile="%temp%.\tmp.vbs" >%TmpFile%...
  2. R

    protect data

    i have a users table where i save usernames and paswords. So anyone who has access to the users table and has little know how of access can read the passwords of other users. So I have encrypted these passwords. Now no one can read eachothes passwords but if someone has acess to the database he...
  3. R

    Linked tables.... db structure changes

    If i make minor changes in the backend db structure (eg add a feild, change properties of a feild in a table,). These changes are not reflected in the frontend. how can thses changes be reflected in the frontend usig the simpest method.
  4. R

    Batchfile help date time stamp

    I'm using a batchfile for backup of the Backend. i'm using the following command to copy the backend folder to the desired location: I want that each time the back end to be copied witth a different name e.g Timt-DATE-MyDB how can i do this using a batch file.
  5. R

    Securing Backend like webserver database and linking via odbc or roaming user profile

    On a webserver certian files are stored above the root directory. Therefor the user of the website can never access those files directly. But he is utlizing that file. For example: We use Hotmail to see our mails. but we never download the complete database. So is there a method that we can...
  6. R

    Auto Backup

    I was thinking of an idea to backup the database in a multiuser (FE/BE) environment, without disturbing the users. Please comment on it as if it has any drawbacks. And also soemeone please help me do this, if its does not contain drawbacks...
  7. R

    Image on Access indow Backgroud

    I was thinking of a way so that we can change the Backgorund or Set a picture on the Access Main Window. E.g Change background Color By Ghudson as in this example we can chage the color of the window, is there a way that we can set a picture as background ??
  8. R

    Increase ToolTip Time

    When we move the mouse over a thread in the index, it displays the body of the thread , but the time duration is very low. Can this be increased ????
  9. R

    Display Resolution - Hertz Problem

    Im using the following code to change the display resolution: Option Compare Database Option Explicit 'ghudson 08/30/2002 'I am trying to reduce the repetitive code but it is not working. 'http://www.vbcode.com/asp/showsn.asp?theID=6142 '*** These two lines to be added if OS is Windows...
  10. R

    Commad Button Incon + Text

    I want Command Buttons to have Icon and Text both. ???
  11. R

    Help Hide Menus Code

    I'm using the code by Ghudson Hide Menus But after the execution of this code, Right click does not work even in other databases. I have to unhide the menus using that code again to make right click work in other databases. How can i resolve this issue
  12. R

    Notification On mobile number

    I have my mobile email address of the format myCellNumber@Provider.com I tried to change my email address to this one but was unable to activate this email adress, due to the limitation of sms message length. If the confimation mail sent could be shortened in length then it would be possible to...
  13. R

    Computer Identification - Security

    In my Frontend, i use parameters like: 1) computer name 2) a certain file's existance So i'm sure that the front end is being run on an autherized computer. i have hardcoded these values in the vb code and password protected the project so that no one knows about it. what other parameters...
  14. R

    Strange - Linked tables invisible - USB

    Today I noticed something strange. I had the back end on USB Flash Drive on drive E:\DB_BE.mdb when i opened the linked table manager in the front end the list of linked tables was empty. so i'm stuck . How can I change the location of back end, as the list of tables is empty.
  15. R

    Date Time Calculation

    Hello friends, I have a table for "Production Orders" ie. work orders. there are feilds : start date , start time based on these feilds i want to calculate the remaining time to start production. but what i want is if remaining time is > 1 day then give results in the format " 1 day...
  16. R

    listbox add remove

    access 2000 does not provide additem and remove item method for listbox . is there a way to perform these actions in access 2k.
  17. R

    null empty "" 0 ......

    what is the difference between null , "" , empty, nothing etc. how to reset variables (string, integers, dates etc) eg: dim abc as string abc = "This is a string variable" abc = ?? empty or "" , null , or what
  18. R

    Sorting Form Like Reports Wizard

    I want to make an unbound form that has the functionality like the form found in access for reports wizard. I want the user to be able to select the sort order dynamically for a report instead of a fixed sort order. But i'am unable to sort out my own problem :mad: plz check out the...
  19. R

    Set refference through code

    Is it possible to set a refference through code ?
  20. R

    backend backup

    is it alright to backup the backend while the database is in use by other users connected through front end or users must log off before the backup
Back
Top Bottom