Log Off Automatically

Oct 16, 2006

Hi,

I want the system to automatically log off if user has not used it for 5 min. I am not sure how to detect that no button is pressed/ mouse has not moved.

Any suggestions please.
B

View Replies


ADVERTISEMENT

Automatically

Jan 31, 2007

Hello,

Is that possible to set the attributes so that when I enter "Mr" to a "Title" field the "Gender" field will automatically change to "Male"?

Or is that just a data duplication?

Regards,

View 2 Replies View Related

Not Save Automatically

May 28, 2007

Hi.

I got a problem...

How do i put access to not save automatically. I want it to save only wend i click on the save button i put on the form.

How do i do that?

Thanks.

View 1 Replies View Related

Assign A Value Automatically

Apr 17, 2008

Hi Im making a database with a form,

The thing that I dont know is how to do this:
I have two fields in the table , one is a text and the other is YES/No

I want that in a form, I will use a barcode when The value was enter in the form automatically the assign YES in the other field and save it

I need help urgent

View 3 Replies View Related

Run Query Automatically

Nov 23, 2005

hey guys,

i'm very new to access and its functions. i need to run/update query, say weekly, and generate a report to be dispatched via email. is there any way i can do that automatically, preferably triggered by system calendar?

thx

cheers!:D

View 1 Replies View Related

Automatically Add A Record

Feb 17, 2006

I have a table that pulls data from a linked text file daily with an append query. The data pulled is RecDate, Description, Count, Code, Type and Category.


I'd like to pull the first two characters from the Description field to insert into the code field.

Also, every days data should have a record for each code A, BS, E, M, N, O, and RB.

If it doesn't, I'd like to automatically add a record with that code.

Thanks.

View 1 Replies View Related

Re-linking Tables Automatically?

May 3, 2005

In our company, passwords expire every 90 days (NO EXCEPTIONS) for DB2. This means that all my linked tables can't be accessed. There are many other users using the DB's and when I have to reset my password, I get locked out a lot because I can't seem to re-link the tables fast enough. It also seems that "refreshing" the tables from the Linked Table Manager doesn't work very well.

Is there an easier way??????

View 14 Replies View Related

Automatically Allocate Stock?

Aug 25, 2005

I have a database for taking orders for books, leaflets etc, what i want to do is this:

When I receive a delivery of stock I enter how many of each ‘Product’ I have received, I then want Access to allocate these to the various orders to make then ready for collection.

For example, if five people have all ordered 3 of ‘Product Guide’ and I only receive 15 then the first three to order are allocated three each.

Not got a clue how to do this, guessing I’ll need to code it?

Hope it makes sense

View 4 Replies View Related

Moving Text Automatically?

Jan 31, 2006

I have five text boxes with a separate box for the date that automatically inserts when I enter something in the text box. Is it possible to have it set up to only allow me to enter information in the first box and at a later date when I enter more info in, automatically move everything down to the next box, and so fourth.
Sorry if this is in the wrong section, but I am not sure if this is something simple in the box properties, or if I need code.

thanks

View 4 Replies View Related

Automatically Importing From Excel

Jan 30, 2007

Hello all,

Hope this is the right section to post this question. I thank all for any assistance in advance.

We basically have a supplier's access database that contains one table of prices.
In addition, there also exists an excel file that contains applicable discounts against the supplier's items. There's a common key, the part number.

There's a need to unify these on an on-going basis as supplier sends updates to their database, and our finance department (who will not move away from an excel worksheet) update their records. What I'm thinking of doing is creating another database with two tables; one whose characteristics are same as the supplier's table and another with fields matching the excel file. And write a script or something that when you execute it, pulls data from (predetermined location) database and excel file to the two tables. Queries can then be constructed using the relationship between the tables.

How can this be achieved? Did a search and no sugar. Or is there a better way. The users are access novices and would like to minimise their "workload".

Cheers

View 4 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related

Automatically Assign Primary Key

Aug 15, 2005

Hi

I've compiled a make table query and would really be happy if I could automatically assign a primary key to one of the fields i.e account ref.

Any ideas, suggestions gratefully appreciated

Cheers
paul

View 1 Replies View Related

Automatically Put In Current Date

Dec 13, 2005

How do you automatically put in the current date in a table?

View 3 Replies View Related

Automatically Clearing Data

Feb 1, 2006

I have been tweaking my friend's database for him. I included some sample data in the main table (ficticious names and addresses etc.) and in a linked table.

I want to leave the sample data in so my friend understands how the database works. However, once he has tested it, he will want to blank those tables (not all tables, though), and reset the primary keys to start from 1 again.

Can I have a button on a form that will do this? Obviously with an OK/cancel message box. If so, how?

The tables are called Main and Workshops.

Thanks in advance for any help!

View 5 Replies View Related

Automatically Increment To Uppercase, How?

Mar 31, 2006

in an initials field... i want it so that it could automatically increment the 3 letters to uppercase... how? if it can't be done in a table where can it be made (i.e. in a form, query etc)

View 2 Replies View Related

Date Being Entered Automatically?

Nov 26, 2006

Hi all,I'm working on a library database for a small collection.I have two fields, 'Date Out' and 'Date IN'. Is it possible that whatever date is written for the date taken out, I can set the 'Date IN' to be 7 days later than that date?Thanks in advance.

View 4 Replies View Related

Enter Date Automatically

Oct 23, 2007

Can anyone tell me if the following is possible in a table or do I need to use a form.

I have a check box in a table that when I check it I want it to automatically enter the current date. I also don't want to change the dates that have already been entered manually and that date should only display the date on which the check box was checked. :confused:

It is a database that hold the details of IT equipment and when it is disposed.

I think I may have to use a form but I would like someone to confirm this if it is possible to do in the table could someone also help me implement it.

Thanks in advance

View 4 Replies View Related

Automatically Fill Fields

Nov 7, 2007

hello all, any help greatly appreciated.....

I have two tables in the same Access 2003 database.

Table1 is called "Clients" and has address type fields, e.g. street_name, postcode, etc. It also has a field called CYPAN_area.

Table 2 is called CYPAN_Postcodes and has two fields; postcodes and the CYPAN area that postcode belongs to.

I want to create a function so that when someone enters the postcode in table1, the database searches Table2 and identifies which CYPAN area that postcode belongs to and automatically populates the "CYPAN_area" field in Table 1.


any tips greatly appreciated

Harry

PS I'm only a novice so I don't know anything about VBA etc, but I understand excel type formula

View 3 Replies View Related

Automatically Change A Criteria

Nov 3, 2005

Hello to all the xperts out there,

I have a query with this criteria for Date field:


Where (([tblList].Date)>=#11/1/2005# And ([tblList].Date)<#12/1/2005#))

Is there any quick way, besides creating a form and run the query based on it, to have this criteria updated itself when it's a new month? I've gotten tired of changing it every month.

Thanks in advance

View 2 Replies View Related

Automatically Running Query

Jan 23, 2007

Behind a command button, i have 3 queries being run. 2 of these queries are append queries, copying the specified record into another table (criteria set to ID of the main form) and the other query is to delete the record from the current table once it has been copied. This is then followed by another delete (not query)

When each of these are run, boxes pop up asking if you're sure you want to do it. I was wondering if it would be possibly to bring up my own box to ask if the user is sure they want to continue, and when they click yes, all the questions that the query asks about wanting to do it, are automatically chosen as yes.

I.E there is only one option box, yes and no, and no others appear.

Is this possible, if so, how?

Thanks
Aidy

View 4 Replies View Related

Query That Refreshes Automatically

Dec 11, 2007

I have a database where students use a Form to sign in for computer help. I would like to have a queue displayed on another screen that shows the students what position they are in for help. How would I go about doing that? I thought that having a query on a seperate screen (with no keyboard lol) would be a good way of displaying the student's order, provided I can get a query screen to update automatically or refresh say every 30 seconds. Is this possible, or am I way off base?

View 3 Replies View Related

Form Closes Automatically

Feb 8, 2005

I created a form with an "exit" button and a "return to main menu" button on the form. but when I am on the last data and press tab the form closes automatically.
what could be the reason. Do I have to put some condition on the macro I have created for the two buttons listed above. I have just put "action" without any conditions on both the two buttons.

View 1 Replies View Related

Automatically Asign Data

Jun 6, 2005

Hi,

I am trying to create a form which involves 3 tables. The 2nd table (CaseRef_Case_Control) is the junction because I needed many-to-many relationship between “CaseReference” and “Cases” tables.

All I want to do is automatically fill in the fields in the “CaseRef_Case_Control” table when I add data to “CaseReference” and “Cases” table. Check the relationship diagram attached to make more sense. Can someone please help me with this?

Thanks.

View 1 Replies View Related

Automatically Refreshing My Listbox

Jun 23, 2005

My main form that displays the records also has on it a listbox for easier navigation to records. What i would like is when i delete the records, they automatically become removed from the listbox.

Currently what happens is that i have to close the form and reopen it in order for the deleted records to be removed.

I would like a line or two of codes that i can add to my delete record buttont that updates my quicksearch listbox.

View 1 Replies View Related

Automatically Fill In Field

Aug 12, 2005

Hi everybody,

I have a table that has 4 columns as shown below:

(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)



-------------------------------------------------------------------
Store Name Invoice Number Customer Name Customer Address
Store1 1 Bob PO Box 55
Store1 2 Joe PO Box 789
Store2 3 Chris PO Box 1254
-------------------------------------------------------------------
On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.

I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.

Does anyone have any ideas?

-Chris

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved