It worked!
Thank you so much, your directions were perfect.
I kept looking for the "OnKeyPress " property of the Details section of the form when I should of been looking at the properties of the form itself (which by the way for other newbies can be viewed by right clicking in the little square on the upper left-hand corner of the form in design view). I added a "highlight box" to show up when the control...
luvgis
Last Activity: Oct 27 '09, 09:54 PM
Joined: Jul 16 '08
Location: Southern California
-
Using keystroke to select an option from an option group in an Access form
I have an Access form to be used for data entry of returned bus surveys. The survey consists of 15 questions and several of the questions will be options groups in the form. For example, question 1 is “When you boarded the bus today, where were you coming from?” The available options are (1) Home, (2) Work, (3) Shopping, ect. I want the data entry person to be able to either select the radio button with the mouse OR be able to tab through... -
No worries, talk to you soon.Leave a comment:
-
Let me do some better explaining. Basically I have one table that I want to update, the "Nodes" table. This has about 7,000 traffic signal nodes which each have a responsible "Agency" and an "OCTA_ID" number. All of the OCTA_ID's < 9101 are correct and do not need to be changed. All of the OCTA_ID's >= 9101 are not correct and need to be changed - these amount to about 190 records. (I know it would not take...Leave a comment:
-
This is what I've come up with so far, as pseudocode for what I want to do, I think I can figure it out except for what I want to do in step 2, is there a feasible way to do step 2?
Definitions
Table_IN – All of the records that need updated, all Nodes with ID_OCTA >=9101 (191 records)
Table_OUT – All of the same fields as Table_IN but empty, contains no records
MaxOfID_OCTA –...Leave a comment:
-
Got it. I am having difficulty with the joins though and this part:
Max(IIf(tO.Agen cy Is Null,tA.Num,tO. Num+1)
Wouldn't the tO.Agency always be null because starting out there is nothing in tO?Leave a comment:
-
So would I start out with the same data in both TblIn and TblOut? Then would I run SQL commands only or do some kind of loop?Leave a comment:
-
Yes I would like to update the records in place, in the same table - the table I'm working with is already a copy of the original, so there is no worry about messing anything up. But either would work for this situation.Leave a comment:
-
For reasons unknown to me the data looks like this right now (although there are many more than this many records for each agency... hence the need for some automation)
AGENCY ID_NUM
ALISO VIEJO 9102
ALISO VIEJO 9104
ALISO VIEJO 9103
ALISO VIEJO 9107
ALISO VIEJO 9110
BUENA PARK 9111
BUENA PARK 9115
BUENA PARK 9117
BUENA PARK 9118
BREA 9119
BREA 9120...Leave a comment:
-
Update Query to Renumber a Column with a Starting Number
I'm trying to find a simple way to update a column with sequential numbers without using a recordset. Here is the catch, each agency has a range such as Anaheim - 6,000 range Buena Park - 7,000 range... most of the records have already been numbered but there is a set that is not and the renumbering needs to start where the other set left off. So the Anaheim would start at 6,292. I have 29 different agencies, each with a different starting number... -
luvgis started a topic DLookup - Finding matches of two fields of different records and grouping results...?in AccessDLookup - Finding matches of two fields of different records and grouping results...?
Hi All,
I am fairly new to Access and the forums but I would appreciate any insight into this question of mine...
I am working with transportation data and I have a series of trips each with a unique trip idea. The trips all have a "Start_Plac e" and "End_Place" (the geographic location where the trip begins and a different location whree the trip ends). These is what I'm working with:
...Code:TRIP_ID
-
Conversion and Subtraction of Military Time in Access
I'm new to Access so bear with me. I've found several other versions of this question in the forums but no posts that relate to my specific question. I have a table of bus trips with start and end times (from a DBF file in GIS, to an Excel sheet then into my Access DB). I am trying to figure out the elapsed time between start and end times. It seems simple enough but my start and end columns are in "number" format and when I try to...
No activity results to display
Leave a comment: