Disable Automatic Change Of Tab Order Index?
Nov 26, 2013
When I create a new control, or change the location of an existing one, the tab order index is changed for almost all the controls across the form.
I have many controls in this form. The controls are a combination of textfields and comboboxes. I have carefully selected the tab index for each control manually, and the user can now tabulate through the fields in the correct order. If I later change the position of just one control, or add a new one, all the manually set tab indexes for the controls automatically change so the order is horizontal across the form.
How do I stop the automatic change of tab order index? It is frustrating to manually set this for all fields, when just a small change is needed.
View Replies
ADVERTISEMENT
Oct 2, 2014
I am trying to come up with automatic line numbers for each specific order. So for example, I have job number 123456 that has ordered 3 items, what I would like is that item 1 has a field with a 1 in it automatically, and item 2 has a 2 in the field and so on. But the trick is that when order 123457 gets entered and has 5 items entered, I would like it to start over at 1 and go to 5. Does this make sense? Is it possible to do this in a table? Or can this happen on the form? That I assign a value to a field. I am using Access 2010, have been for a few years now, but I have lots to learn.
View 14 Replies
View Related
Jan 19, 2007
I have a query that allows the user to see how many hours we've flown, sorted by month for the current year.
Problem is that in the query I have to manually put in the criteria "january 2007" or "february 2007" or etc....
What I would like it to be able to do is based on the current year (2007 for instance) set the criteria by itself. Someday I might not be around to reset the year in the criteria so therefore it should be automated.
Anybody have an idea what I'm talking about and a simple solution a hack of a programmer could figure out?
Thanks.
View 9 Replies
View Related
Mar 4, 2014
I have a training database that I have set up and utilize to track attendee data and who is registered to which course.I have a course registration table that has a course title field which is a drop down list populated by course titles from the courses table, and a trainee id field.
For whatever reason, when I view reports or queries that draw from this table, access will make changes to the first record in the course registration table course title field i.e. it will take whoever is in the first record, and change the course they were registered to.
View 10 Replies
View Related
Jan 17, 2014
I created a query that shows the Student ID, First Name, and Last Name.I then created a split form from the query.Finally I added an unbound text box called search with a button next to that has a macros within it:
Code:
[LastName] Like "*" & [Forms]![SearchID]![Text14] & "*" Or [FirstName] Like "*" & [Forms]![SearchID]![Text14] & "*"
1. I love that it searches for the name you type in and displays the record
2. What I don't like is that you can edit the record.
I tried to set the AllowEdit in the form properties to no but that also took away the ability to type in the search text box. Is there a way to allow typing in the text box but not allow changes in the record?
View 3 Replies
View Related
Nov 29, 2004
How do I change the sort order to display on a form using an option button?
Thanks!
View 1 Replies
View Related
May 8, 2005
I have a subform embedded in a mainform which contains loan payment details over a number of months. The record starts with the payment period number ie 1,2,3 etc. The problem is that every now and again the subform changes the display order of the records so that I get 4,5,6,1,2,3.
When I look at the underlying table the order is OK as is the non embedded sub form. I cannot see any reason for the change and it only happens randomly (apparently).
The numbers are not autonumbering but manually input.
Hope someone can help please.
View 1 Replies
View Related
Mar 30, 2006
ok. here's the deal
Private Sub cmdsave_Click()
On Error GoTo err_handler
Dim lnglaptime As Long
lnglaptime = Me.txtLapNumber.Value
Me.Dirty = True
Me.lstAll.Requery
Me.lstAll.Value = lnglaptime
exitpoint:
Exit Sub
err_handler:
MsgBox Err.Description, , "Error in cmdSave"
Resume exitpoint
Resume
End Sub
I don't no whats happening, the error is apprently in the "me.dirty = true" but i dont know. Help?
View 1 Replies
View Related
Apr 22, 2013
I have a query with a float/delta column which is the expression:
Code:
Float: [Date1] - [Date2]
When I try to change the order by in the column filter drop-down i get a data type mismatch in criteria expression error.
View 1 Replies
View Related
Nov 28, 2014
I have a column graph I created for a report.
The Y axis has number of days.
The X axis has Member ID.
When I make the column graph the data seems to not be in any order. The report is in order by the number of days in ascending order.
How can I have the columns with the largest number show up first and the columns get smaller. I would like the largest column all the way to the left, proceeding the next one in size so it goes from largest to smallest.
View 5 Replies
View Related
Aug 28, 2013
I have after much stress gotten my comments history field to appear on a form.
The following code gives me what I needed
Code:
=ColumnHistory([RecordSource],"LastUpdateBy","[ID]=" & Nz([ID],0))
I have only one simple thing left, that is perplexing to say the least.
Some comment fields will be many short notes, spread over time.
My desire is to change the sort order of the results so the most recent (rather than the initial) comment is at the top.
View 5 Replies
View Related
Jul 23, 2013
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
View 4 Replies
View Related
May 15, 2006
hi
when creating indexes for databases what needs to be indexed? is there an article online that explains it??
View 5 Replies
View Related
Apr 21, 2006
i
i do a sum on a field..... if i put an index on this field
does query will be faster?
thank
View 1 Replies
View Related
Aug 23, 2005
I created a help file for a using a db I created, though I am thinking it would be nice to have it "look more professional" something similar to the Contexts and Index help option found in IE.
I am think a form would be the easiest to do with a subform for each element in the contents, so when the user clicks on an element on left form (which is the contents) the detail of that page appears in the right form the subform (perhaps just using the visible property)
There are tab options for a form so I can use that to make the contents, Index, search, favorites
some questions come to mind though...
0) how would I create collapsible menu (like a tree menu) see the contexts and Index help option found in IE.
1) how to create a search field to look for anything in the db except the code (i.e. part of a record, a description of the record, etc.) ?
2) how would I create a favorites section (a place to save help topics viewed) ?
3) how do i create a navigation system (back and forward through the subforms) - it seems I would need to track which forms are displayed and when then use that to navigate back and forward ?
4) how create various options such as stop or refresh search queries, and perhaps turning on/off select highlight
Finally is there something similar to this already out there that I can just customize various options off of, perhaps even a tutorial.
thanks for any direction you might be able to provide.
View 2 Replies
View Related
Nov 23, 2005
I have ID field data type is auto number
I need to initilize it to zero after deleting all the records.....
tell me a way to do this
View 1 Replies
View Related
Jan 21, 2007
I have 2 fealds ( Id and date ) they are primery keys in the table , I want to prevent duplacte id to the same date . ( MSGBOX after update the date )
View 7 Replies
View Related
Feb 21, 2008
When I load a spreadsheet I can't add an index because it is a linked table, so I want to save it in MDB format so that I can add an index and then export it to SQL. However, when I save the file as an MDB file the data is all still linked as a spreadsheet and I still can't add an index. (I would add the index at the last step in SQL, but Pervasive SQL is very temperamental.)
Basically I just want to export an Excel spreadsheet into SQL and add an index.
View 3 Replies
View Related
Feb 7, 2005
Can anyone tell me why access puts the primary key field in the index list twice for the same table? For example i have a primary key called CustID, when i go into design view and click on the index button on the toolbar, i see it listed twice, once as primary key and then again as its own field?!
I dont see the reason for this but often times with many of my databases i see this happen to many of my tables. :confused:
View 2 Replies
View Related
Jul 6, 2005
I have a beginner Question....How can I set an unique Index on a field in a table if all the four fields are using duplicate values?
View 3 Replies
View Related
Apr 6, 2007
Have the situation where a database backend is on a number of sites and if changes have to be made to the design structure of the backend database I would like to run a VB generated report to check that all indexes are correct. While this is not an issue with single field indexes, I have issues with multi field indexes.
Has any one got some ideas on reporting on this?
Thanks
View 11 Replies
View Related
Apr 18, 2008
Hi,
I want to have an index such that the combination of "line no" and "calving date" are unique.
I have tried:
CREATE UNIQUE INDEX index1
ON [main table] ([Line no], [Calving Date])
;
And
CREATE INDEX index1
ON [main table] ([Line no], [Calving Date])
WITH PRIMARY;
but I get a unique index on Line no
Any suggestions?
Regards
lactaman
View 2 Replies
View Related
Oct 19, 2006
Don’t Understand why , tab index change’s
All 55 fields are in the same order as the tables.
The field is custname the frist fiels.
Go to my Customer form
Thery are 55 fields,
The frist field is ( custname )
I go to the properties
Then I go to tab index
And I type in 1
Then I exit.
Save form
Then I open the form and the cursor is not on the
frist field ( custname )
I go back to the properties
And back to tab index
Now it is 44
I have don e this procedure several times.
And the tab index changes sometimes it is 44 , sometimes it is 49
And other times it is 36.
How can I keep the fields in the same order that I set up the tables..???
What can i do about this.
John527
View 3 Replies
View Related
Jan 4, 2007
Hi,
I don't know why, but my Microsoft Access 2000 Help's Answer Wizard and Index Tabs are completely empty! These pages are completely blank, with no dialog boxes or anything. How can I fix this?
Thanks,
Jean-Guy
View 1 Replies
View Related
Mar 2, 2005
Hello, I keep getting this error when opening up a database. What can I check to find and fix the problem? TIA
View 3 Replies
View Related
Jun 3, 2005
Can't figure out why I can't create a one to many relationship between two tables:
TableA uses a composite key as its primery key (field1, field2).
The table has a unique index comprised of these keys. The index even has a name. The table also doesn't contain any duplicate information, so the fields comprising my Primary Key are unique. The table I'm joining tableA is unpopulated at this time.
TableA
FIELD1 FIELD2
99999 ABCDEFG
99999 HIJKLMNO
Any help will be greatly appreciated.
View 2 Replies
View Related
