Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

Sponsored Links:

Related Messages:
Submission Of Samples
Hi All

I would just like to find out how long it takes before a sample submitted to the samples forum is approved. I submitted a database about 2 days ago and I see that nothing has shown up on the forum.


View Replies !   View Related
Usage Help Please...
How do you calculate usage? For example...
If I've got a field named Time, then a drop-down box with "Morning", "Afternoon" and "Evening"
How do I make a query so it displays the number of each time...
For example...

There's two times for Morning, three for afternoon and one for evening.

I tried using the 'Sum' total and the criteria of "Morning" but it says data mismatch. That was merely a guess, so I would like to know how to do it.



Morning: Afternoon: Evening:
2 3 1


View Replies !   View Related
% Usage
how do i use a query to calculate % usage of a particullar feild. ive got a total box and a current amount but i need a query. thx in dvanc

View Replies !   View Related
Query Usage
Over the last 12 months my database has grown in size.

I'd like to delete queries that are no longer used. Is there a utility I can use that will list where all my queries are used, ie used in other queries + reports.

Does anyone know?


View Replies !   View Related
Usage Of Enter Key
I have a continuous form with an unbound text box (for search critera) and a command button to kick off the search, which simply applies a filter.

When a user enters text in the unbound text box and hits "Enter", I want the search to be kicked off (instead of having to tab over or mouse over to click the "Search" command button. This is the default functionality of an HTML <form>, so users kind of expect it. But I'm having trouble implementing it in MsAccess.

I've tried using the KeyDown property of the unbound textbox, but no luck, since the KeyDown method occurs before the data in the box is saved. I'm guessing this is related to detecting what key has been pressed but my issue seems to be the order of events occurring on the form.

Any suggestions? This *must* be common situation, but I've found no related topics in searching the forum.

View Replies !   View Related
Audit All Objects Usage
We have an access app for reporting using a mixture of local tables and linked table in Oracle, Access queries, Forms and Reports.

Ther app has grown over time and has become quite cumbersome to work on.

We want to strip out parts that are not being used but need to identify what is being used first.

Is there a way to keep an audit trail of all object usage within the app? The audit doesn't need to be complex, just object name, timestamp and user.

Thanks in advance.


View Replies !   View Related
General Query Usage
hi Guys,

need help in using query, plz let me know that how to use designed query in Reports ?
thanks in advnce.

View Replies !   View Related
Parameterized Query Usage
So I have a query which prompts the user for a username to search by, GetUsername.

Im used to TSQL usage which would be something like:

exec GetUsername 'blah'

My goal is to generate about 10 reports based on this query but with different (hardcoded) input. I do not want to prompt the user while generating these reports.

How would I invoke this query with a hardcoded parameter? (Id rather not save 10-20 versions of it).

View Replies !   View Related
Logging Usage Of Records
I have a form from which people view records out of a db.
I would like to log the date/time and the key record they view into a table
The usage table has a date/time field & a string field for the viewed record.

I can run an append query to update the Usage table but can't figure out how to get the date/time into the table ?

Is it easier to write the whole lot out to a file ?

View Replies !   View Related
Can I Calculate Peak Time Usage?
Hello All,

Is it possible to generate a query that can calculate the 'TotalMins' that an event covers our peak times?

I.e. Our peak times are 0700 to 1000 if we have a start time of 0600 and a finish time of 0900 is it possible for the query to work out that we have covered 120 mins of the peak period?

Thanks for any help provided!:)

View Replies !   View Related
Track Form/Query/Report Usage

About 10 years ago I wrote an Access application which is still in use. Over the years certain parts have become superfluous and new parts have been added by a variety of users. Thankfully they have stuck to the original ideal and only used macros and queries - and not modules of badly written code.

However, the system is beginning to creak and I have been asked to rewrite the system from scratch with a shiny new interface, cutting the dead wood and incorporating those new features that did not have a half life of one report.

I would like to be able to monitor the use of the system in order to be able to determine just which tables, forms, queries & reports are being used. I'm not interested in auditing who added what to which table, so a 'normal' audit system is not required. Can anyone tell me how I would record which of the above are being used and how regularly?

I have asked the users and (of course) they don't know.


View Replies !   View Related
Converting To 2007 From 2003 - High Cpu Usage
This is very strange. I have converted two computers from 2003 to 2007. I have also installed 5 2007's on to new computers. All of these are Professional XP sp2 setups. I copied over a database to woek on those computers. Originally the performance was very good, on all of the computers (but not the lowest specified converted laptop ) exitting from a form containing a subform takes 37 seconds. The word Calculating... is on the status bar. The laptop takes 3 seconds par with what it used to do.

I have transferred the 'Data' database, the 'Apps' database, Utility.mda and another .MDA. I have also transferred all the Reference executables to one of the other computers. This has not made a jot of improvement.

Has anyone any pointers. I have exhausted all the resources trying to find a solution to this one.

View Replies !   View Related
Table Link And Multiple Combo Box Usage
Could someone help me ?

I'm really experiencing problems ...

I will need those tables : tblCostumers , tblSystems , tblRepair

tblRepair will link through its unique CostumerID primary key, as you said but,
is it through a foreign key ?

I will need a "tblSystems" too, witch will contain all the details about the computer systems each costumer has at home or work.
How to link this to each costumer ?

Another doubt :

At the "tblReapir" I'm thinking to use combo box to select all repair procedures like combo boxes follow, so future statistical analysis will be made easily :

Replacements combo box

. . .

Software combo box

. . .

Problem is : A repair service may need several
items to be selected from the same combo box
( in example : Replacements -> HARD DISC + POWER SUPPLY and
Software Installation -> WORD + ANTI VIRUS ) but each new item
I select from the same combo box must be stored on a different field on the repair table ( If I'm thinking well ) .
As each combo box is located into its own field and associated with it, how to do this ?

Can I make appear a new combo box at the right side of each one I use,
so I will have so many combo boxes from the same type as my needs of selecting new items from the same type ?

My idea is :

1. Initial visible combos are:

Repair Software

2. I select a item from repair and visible combos are :

Repair Repair Software

4. I select a item from Software and visible combos are :

Repair Repair Software Software

Will this solution create combo boxes that although they are necessary for one repair service, they may be unnecessary to other repair services, being there anyway, as different repair services share common columns ?

Anyway, if this is a valid idea, how to implement this ?

Or ... Is that another way to approach the problem ?

Lots of thanks in advance,

Miguel Garcia

View Replies !   View Related

Copyright 2005-08, All rights reserved