Thanks for the Help NeoPa
Apparently all I need to do was turn the Order By On Property to “Yes” as I had already set the Order By Property to the filter I wanted. Almost had it!
My confusion comes from using the Access-level filter to filter on a field that is in my Main Table instead of a Lookup Table. When you do that it retains the sort order of the Query that runs the Main Table and you do not need to...
Redbeard
Last Activity: Sep 2 '16, 03:25 PM
Joined: Oct 3 '07
Location:
-
Hi zmdb
I have tried to make this as clear as possible…
So, I have figured out what is happening but don’t know how to fix it. I have a Main Table and several “Look up” tables, as you suggested. I have a Main Form which I use to enter any new records, which is run by a Main Query that incorporates the Main Table and the Lookup Tables. The Main Query is sorted ascending by the Unique Code field in...Last edited by NeoPa; Jan 19 '16, 06:08 PM. Reason: Reformatted text in an attempt to make it human-legible.Leave a comment:
-
Sort Order on Filtered Recordset
Hi zmdb
Sorry it took so look to get back, it took me a while to find time to work on this project. It has taken me a week but I am almost done normalizing the database. It has took quite a while as there were more fields then I realized that needed to be done. It seems to be working out quite well; however, I am having an issue with the new tables and filtering. When I did a filter on the Permanent Location Site field on my main form... -
I will update when I get a chance to resolve this problem as it is a big task and will take some time. Thanks again.Leave a comment:
-
Thanks zmdb this is great! I guess I have a lot of work to do as this will affect at lest 6 fields on my main form.Leave a comment:
-
Ok, so what you are saying is that I create a separate table that has all my Permanent Location Sites in it, so let’s say 100 entries. Then link that to my main table’s Primary Key to my Permanent Location Sites table, so each site is a numeric value in my main table. Now I change my Combo Box field on my main form to read the 100 values from my Permanent Location Sites table, so that it is not running a query every time. However, when...Leave a comment:
-
Here you go
Code:SELECT DISTINCT Description.[Permanent Location Site] FROM Description WHERE ( (Not (Description.[Permanent Location Site]) Is Null)) ORDER BY Description.[Permanent Location Site];Leave a comment:
-
Hi zmbd
Sorry for my late reply, when someone answers my questions I used to get a response via email, which I am now not getting? Not sure if it is a spam filter on my end but I never received notification that you replied. I did check back on my question for the first 5 day and then gave up checking. Again sorry for the late reply.
Back to your question, the record source is pulled directly from my main table onto my main...Leave a comment:
-
Moving between records in a Form is slow in certain Combo Boxes
Hi All
I am using Access 2010. My Access Database is slow when moving between records on a form when my cursor is in certain Combo Boxes. When the cursor is in any other field, weather it is a Text, List or another Combo Box, the records move at normal speed. When I put the cursor in one of 3 Combo Box fields on my form, the records slow down to a good 5 sec or more between records as you advance through them. This only occurs when I have... -
No worries zmbd... I am just about to go off on a long weekend and will not be back to this till next Thursday. Enjoy the time with the kids.Leave a comment:
-
So I have made some progress… I have added this to the Print Selector button code:
At the start
and at the endCode:Me.txtRecordDisplay.Enabled = False
And I have added this to the “On Current” of my form:Code:Me.txtRecordDisplay.Enabled = True
with an "EndIf" at the bottom.Code:If Me.txtRecordDisplay.Enabled = True Then
The “txtRecordDispl ay” is my unbound textbox that displays...Leave a comment:
-
Hi zmbd. I tried removing “clone” as you suggested and it takes me to the last record on load. When I try to move off that record it gives me a message that “I can’t go to that record and puts me back to the last one. After doing a bit more hunting around on the internet I have clean up my code and used what seem to be more stander as I have found multiple post of similar code (see below). I also found a couple of post that say you need...Leave a comment:
-
Ok, I will try an explain better. First I am using Access 2010 and have been for a few months now. Everything was working fine then I created the new record navigator to replace the small one Access provides at the bottom of the screen. It has a forward, back, move last, move first and new record buttons with an unbound text box for the record count. It also worked with no issues on my form. However, when I filtered down to 20 records that I would...Leave a comment:
-
Conflict with Record Counter and Print check box selector
Conflict with Record Counter and Print check box selector
I have created a new navigation bar for my form, as the one Access provides is very small and hard to read. The problem is with the Record counter code is conflicting with a Print Selector button that already exists on my form. I use the Print Selector button when I have filtered the form down to say 20 records that I want. Then when I click the button, it automatically checks a bound... -
Thanks zmbd for all the help! I will add the "Me." and continue that as my practice.Leave a comment:
-
So does that mean that "Me." is now not needed in the code since it will pick up any name that is listed on the form and use it? Or would there be an instance where you could get fouled up by not using "Me."? I would like to use best practices, to avoid any problems in the future.
By the way zmbd, thanks for following through and investigating this, it is appreciated.Leave a comment:
-
Hey no problem... I know what kids are like.
Here are the value that I got, they are exactly what I typed into the unbound text boxes:
From Imput#1 = print
From Imput#2 = black
From Imput#1 = print
From Imput#2 = null
From Imput#1 = null
From Imput#2 = print
From Imput#1 = john
From Imput#2 = smith
Code is still running fine.Leave a comment:
-
Hi zmdb
I have put your code in the appropriate place and I can't get your code to run... it keeps getting stuck on Line 2. Specifically on "Nz" it is highlighted and I get a “Compile Error” that reads "Wrong Number of arguments or invalid property assignment". When I hit <CtrlG> it goes to the “Immediate ” window but nothing comes up? I assume that is because it won't go pass the “Nz”?Leave a comment:
-
I am running Access 2010 if that makes a difference. The options under the “Editor” tab that are checked are all of them. They are: Auto Syntax Check, Require Variable Declaration, Auto List Members, Auto Quick Info, Auto Data Tips, Drag-and-drop Text Editing, Default to Full Module View, Procedure Separator, Auto Indent and Tab Width: 4. I am also posting my completed code with the changes below. I have add a few more steps but it all runs...Leave a comment:
-
Hi Zmbd
Thanks for your help. I did read the link you sent and I did run “Complie” and nothing happened. So I have now just done it again and nothing happen? It does not flag “Imput1 or Imput2” as undefined and the code works fine without putting “Me.” in front. I also don’t have “Dim Imput1 As (classtype)” in my code. So I guess one, I am confused as to why I didn’t have a problem without using either of these methods?...Leave a comment:
No activity results to display
Leave a comment: