Usage Of Enter Key

May 26, 2005

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

Usage Help Please...

Mar 29, 2006

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.

Like...

Time

Morning: Afternoon: Evening:
2 3 1

Thanks.

View 2 Replies View Related

Query Usage

Sep 26, 2005

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?

Thanks

View 2 Replies View Related

General Query Usage

Jul 9, 2005

hi Guys,

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

View 1 Replies View Related

Parameterized Query Usage

Feb 19, 2008

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 9 Replies View Related

Logging Usage Of Records

Jun 21, 2005

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 1 Replies View Related

Can I Calculate Peak Time Usage?

Mar 29, 2006

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 1 Replies View Related

Track Form/Query/Report Usage

Jul 25, 2007

Hi

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.

TIA

View 3 Replies View Related

Converting To 2007 From 2003 - High Cpu Usage

Dec 11, 2007

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 2 Replies View Related

General :: Find Instances Of Field Name Usage

Jul 21, 2013

I have written a large database for the school I used to work for. In the main table there is a field named "Active" which is text with yes or no choices.Is there a way to find in what objects this field is being used in the database?

For the life of me I can't remember why I put this field in or if its even used now.This database has had many versions over the years.

I have searched many of the queries but can not find where this field is used.If there isn't a way I plan to backup, remove field from table and test all the features of the program to see which crashes. However I'm hoping there might be a quicker way.This was one of the first DB I wrote and didn't pay much attention to mapping or keeping notes back then.

View 5 Replies View Related

Reports :: Memory Usage / Enforce Garbage Collection

May 1, 2013

I have build a database with which I can create quite a lot of reports. When creating them I run out of memory with run time error "2004".

When investigating I detected that a lot of memory is used when creating the reports in PrintPreview mode. When closing the reports the memory is not automatically freed.

Is there a way to enforce garbage collection? Local variables of called routines I set to Nothing.

View 3 Replies View Related

General :: Split Database - Cannot Edit Table Design Despite Snapshot Usage

May 27, 2014

I have a split database made in Access 2007. Each user gets their own copy of the frontend from a script. I wanted to be able to edit the design view of the backend tables even if people were using the database so I made all the forms use snapshot source and only allowed data updates through VBA macro update queries. Having any form open locks the backend source table from being edited. In fact, I've found that just having a normal snapshot query open causes the message "Either an object bound to table 'whatever' is open or another user has the table open. Do you want to open the table as read-only?"

Is there some way to have a table be the source for a form or query, but still have it designable under most circumstances?

Attempted to late-bind a recordset on form load; result was the same:

Code:
Set rs = CurrentDb.OpenRecordset("Select redacted as ft from tblRedacted ", dbOpenSnapshot, dbReadOnly)
Set Me.Recordset = rs
Set rs = Nothing

View 3 Replies View Related

Where Do I Enter A Query?

Aug 11, 2005

I want to be able to simply type out my query. It's faster for me than using the GUI.

Where in Access can I just enter a statement?

View 1 Replies View Related

Enter Parameters

May 3, 2006

Hi,
I have a Data Access Page which is generated on behalf of a query.
Query uses one parameter field ,so when is started it promts with the form named Enter Parameters in which I have to input parameter value.
So before the DAP is opened, first is displayed parameter form.
I would like to change dimensions of that form(height, width) but I dont know how.
I already tryied by opening DAP in design view & then in microsoft script editor but i couldn't find anything about this pop-up parameter form.
Any suggestions are wellcome:rolleyes:

View 1 Replies View Related

Cannot Enter Data

Sep 3, 2007

I have built a database which has been running OK for 3 or 4 years. Something happened the other day (error - rebuild d/base) and now there are certain fields that I cannot enter any data into. Others are fine and I can see what is already there.
Any suggestions very welcome.

View 2 Replies View Related

Enter Parameter Value

Jun 8, 2005

I have a form and it is related with a query and by clicking ok I got the required results in Access 97. But now I have converted to Access 2002 and whenever i enter values in the form and click ok I get a Dialog Box "Enter Dialog Box". I read MKB article but it did not help me at all. Please help me out I am not getting any idea at all to solve this problem?

View 6 Replies View Related

Enter Parameter Value

Jun 1, 2007

I have searched other threads and cannot find one that helps solve my problem. So, I hope someone can help.

I have a query which runs ok until it is filtered. I have tried using criteria to filter the info I need but this returns an 'Enter Parameter Value' message. Running the query without using criteria works okay but using a filter in the report itself returns a 'Data Mismatch' message.

The report filters fine on fields until it gets to one that has been changed from text to number. It also includes an Nz formula. The formula in the is field is: CLng(Nz([order_no],0)). Other fields related to this also appear to be affected.

I need the CLng formula as the field is needed to calculate other fields using a zero instead of a null which would otherwise cause an error. I was given the formula on this forum yesterday, (thanks Bob Larson and AlanJ10), which was great in solving the other issue but is this is what is affecting filtering, (ie. a confusion between text and number?!?!) I have also tried converting the result of the calculation I want to filter back into text using CStr but this does not make any difference.

I have checked the field names and also renamed fields that were 'Expr' (as in default names for calculated fields), and cannot see any problems.

Thanks

View 5 Replies View Related

Enter Parameter Value (need Help)

Sep 29, 2007

I have a query and one of the fields/headings i have it create is a "cost" total where it does a dlookup from a defaults table.

I then have a "listprice" which is antoher field in the querry of which the data table sits.

I want to take the [listprice] and minus the [cost] without re-creating the dlookup function...

I need this to help with an APR calulction using the RATE function which if i have it do all the dlookups it says I have exceeded the limitiation and will be trumcated. So if i use the name [cost] it works but i have to hit enter because it says "Enter Parameter Value".

Any ideas how to get around this?

Thank you.

View 1 Replies View Related

Enter Parameter Value

Jan 26, 2008

I have the following query that gives me this halt. If I enter without responding to it it opens in Datasheet view as intended. It wants me to enter Query2.EmpID. This is my SQL statement.

SELECT qryPolicyByDriverName.CWSPolicy, qryPolicyByDriverName.EmpID, qryPolicyByDriverName.DriverName
FROM tblTrainingPoliciesNotCoveredDrivers INNER JOIN qryPolicyByDriverName ON tblTrainingPoliciesNotCoveredDrivers.CWSPolicy = qryPolicyByDriverName.CWSPolicy;

I don't know why this is happening. Thanks for looking at my problem.

View 2 Replies View Related

Enter Parameter Value

Jul 9, 2005

ok im am not sure if this is in the right place but it seems to be a form problem.
i have a form that has a textbox(text1) which is used to enter a supplier name, the user then presses enter and another form opens up with all the supplier details.ok.
the code i have to do this is on the afterupdate of text1 which is unbound is
DoCmd.openform"SupplierDetails",,,"[Supplier Name]=" & Supplier name
when i use this code and the enter key is pressed an `Enter Parameter Value` dialog box appears with the supplier name under the blue title bar.if i then enter the supplier name again it opens the second form and displays all the details i want.
If i use the code
DoCmd.openform"SupplierDetails",,,"[Supplier Name]"= me.Supplier_name
it opens up the second form without the dialog box but it doesnt display any details.
is ther any way to adjust the first code so the dialog box isnt displayed and just goes straight to the second form and displaying the details.
i have gone through as many posts as i can but cant seem to find a fix.

any help would be appriciated thanks

View 14 Replies View Related

Tab, Enter In Textboxes

Feb 2, 2006

Hello all,

Thanks to all the folks that have helped with my posts in the past.
I have 2 questions.
I have a form with textboxes.

When I tab from one textbox to the other, the tab goes to one of the buttons on the page. How do I tab from one textbox to another.

Also, I have a textbox for memo. I would like to press enter and go to the next line in that textbox.

Thank you very much.

View 6 Replies View Related

How To Enter More Than 255 Charaters

Jun 14, 2006

I created a form to let user enter project summary. However, the maximum charaters is 255. What can I do to allow more charaters be entered in the form? I already set up "can grow" as yes.

Thank you.

View 2 Replies View Related

Onkeypress? Enter?

Oct 20, 2004

I have a text box next to a button that takes the value in the text box and performs a search with it. I'd like for the search to be performed when the user hits Enter after entering the value in the text box (when the focus is still on the text box). I assumed that i'd need to use the onkeypress event to run the search function performed by the button, but i'm not sure how to do this. help anyone?

thanks,
Jason

View 2 Replies View Related

'Enter Key Disable????

Mar 9, 2005

I have one form where I want the 'Enter key to be disabled. What is the best way to disable the 'Enter key for this one form without disable'n it for the entire database?

View 1 Replies View Related

Using The {enter} Key To Run Code

Jul 8, 2005

after entering data into a text box I need to run some code (i.e. sql update the table) by just pressing the {enter} key, what code is required? how do I go about doing it ?
any info would be appreciated.

thanks
jabez

View 3 Replies View Related

Enter In Form...

Mar 31, 2006

Here's an awkward problem that i'm experiencing...I've created a form and everytime i hit the Enter key, any data that i've inputted disappears . I've noticed on the bottom right corner where it displays form view when i hit enter it say's calculating...and then poof , data gone...i've created a test record, #3738...Any help will be greatly apprecitated...i've attached form for a better understanding...

View 3 Replies View Related