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