The problem with this is that it changes the SourceObject of whichever is the active tab on the Navigation Form. Not really the Tab where that form is already pre-loaded.
So basically, it just acts the same way as deleting the tabs, and just having one tab in my Nav Form.
hyperpau
Last Activity: Apr 2 '14, 06:05 AM
Joined: Jun 12 '07
Location: Makati, Philippines
-
Hi Topher,
The suggestion you gave works but it is not what I'm looking for.
What it did is it closed my Navigation Form and opened the frmEmployees in DataEntry mode, as if I used DoCmd.OpenForm.
What I wanted is to go to the Employees tab of my Navigation Form on DataEntry mode.
However, I found a workaround.
I deleted all pre-loaded forms on my Navigation Form's tabs and just left out...Leave a comment:
-
Hi topher! Thank you very much for your attention.
You are correct. My concern is the second one.
The forms are already preloaded on to the different nav tabs of my nav form, so 'the form needs to be open in order for it to work' is covered. :)
So my issue really is that I want to change the data mode of my Form.
SO basically, the setup is this.
Main Form with a NavigationSubfo rm...Leave a comment:
-
Access 2010 Navigation Forms DoCmd.BrowseTo Issue
Hi All,
It's nice to be back.
I just got my hands on Access again and I was surprised that the magic is still there.
However, the new Navigation Forms in 2010, replacing the switchboard, is new to me. Nevertheless, I figured it out right away, except with one issue.
I can't seem to get the acDataMode to work!
No matter what I choose, acFormEdit, acFormAdd, asFormReadOnly, etc, access seem... -
Custom Error Messages
Before anything else, I am not a very technical expert when it comes to VBA coding.
I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com).
Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge.
I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the... -
This may be long overdue but for sake of others looking for the solution:
Use instead the BeforeUpdate event as suggested above already.
This will not set focus back but would actually prevent losing focusCode:Private Sub qty_BeforeUpdate (Cancel as Integer) If qty <=0 Then MsgBox("Please Enter Qty") Cancel = True End if
whether by pressing TAB or by using mouse...Leave a comment:
-
A table with 255 fields sound like a table not normalized to me.
You really should read that article posted above....Leave a comment:
-
All you need to do is do unbound controls on the design view of your Report.
Create labels, insert images, etc. Just don't put textboxes, combo boxes anumore, I normally just use Images and Labels, lines, and rectangles for this types of Report letterheads.Leave a comment:
-
Apply this code on the On-Click event of your button.
[CODE=VB]Private Sub cmdYourButton_C lick()
Dim stCriteria as String
stCriteria = "[ReceiveType] ='" & Me![Combo27] & "' And [CompanyName] ='" & Me![Combo29] & _
"' And [DateReceived] ='" & Me![Combo37] & "' And [ReceiveRef] ='" & Me![Combo33] & _
"' And [NewService]...Leave a comment:
-
I'm sorry. I really want to help you out on here.
But I just can't understand what you're trying to tell me... :(...Leave a comment:
-
I see, i overlooked that one, this is because the bound column of your combo boxes are bound to the 1st column which is the Primary key.
Just modify the code to tell Access to look up the 2nd column instead.
Do this as well to the ArtistID...Code:Private Sub cboMusicCategoryID_AfterUpdate (Cancel as Integer) Me!txtSerialNo = Me!cboMusicCategoryID.Columns(2) & "-" End Sub
Leave a comment:
-
The best solution I could think of as of the moment is to add a Form_Current() event to your form and use a function to compute the age of the balance. Dcount is not necessary for this only counts the number of records.
A simple calculation would do.
Lets say:
I have a form with the fields:
dteBillDate
dteDueDate
stMessage
Now of course the dteBillDate and dteDueDate should already...Leave a comment:
-
I believe the code I have given you in your other post is already the answer.
You put that on the AfterUpdate Event procedure of your MusicCategoryID and ArtistID comboboxes. and remember, use another variable string.
...Code:Dim intCount as Integer Dim stCount as String intCount = DCount ("MusicCategoryID", "tblCDDetails") stCount = Format(intCount, "000")Leave a comment:
-
No problem. I hope you find the answer.
I started like you are and I learned most of what I know now through self study using the MS Access Help, and OF COURSE, www.bytes.com
Welcome to the forum.Leave a comment:
-
No Problem. Hope you find the solution....Leave a comment:
-
Program your command button in VBA to open up the report specifying a WHERE Condition on the [DateByMonth] field (if that's your field name).
Of course to do this, you would need to have an option for the user to select or type in the month that they want to print. I could either be popup box ar more simply an Input Box, o rmaybe another field/control on the form.
Example:
[CODE=VB]Private Sub cmdPrint_Click ()
...Leave a comment:
-
I do not have access right now but I have done this in the past.
I amnot sure if it will work for you but try this.
Go to the design view of the table with the CostTxt and on the field CostTxt, apply a format and type 15 zero's ("0000000000000 00")
Then create an update query joining the two tables via the primary key and that primary key as the Criteria. Update the Costxt field with...Leave a comment:
-
What you need to do here is create a relationship for the ID in table to to the ID in table 1.
Do not assign the ID in table 2 as an autonumber field. Instead assign it as number with Long Integer as the formatting then create a lookup on that Field in table 2 to get the values from ID in table 1.
What I have been doing so far is to use the Lookup wizard in the Design view of the table. There are some articles not suggesting...Leave a comment:
-
I think you almost got the answer already.
From the looks of it, you are trying to update the query joining the table and the query itself.
My suggestion is to try to create an Update query and bind this to the table using the Date as the Criteria and the Mins column to be the one updated.
You can use Access help to find out how to create Update queries.Leave a comment:
-
Right. I overlooked that one. :)...Leave a comment:
No activity results to display
Leave a comment: