I have a Main (Home) form that has a sub navigation form (frmNavigationSubform).Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form.
Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3.
NavigationButton 2 Navigation Target Name = 1 (frm #1).
NavigationButton 3 has no Navigation Target Name. This is passed on when user picks Option1 or Option2 form options pop screen.
Now I can pass the name to the Navigation Buttons2 but the subform does not show it. I have to click on the Navigation Buttons2 again for it to show. What I want is when the user makes the choice in the options screen the name is passed and form 2 or 3 should load/show.
I have an Access 2010 Database frontend to SQL Server 2008 Backend. So far there are 3 Tabs in the Navigation System. The first one is the primary Data Entry form which has a tab control with 3 subforms.
Here's the problem. The database is designed to track potential members based on different types of Ads. The primary Data Entry form holds all of the demographic data for the person that called in response to an ad. The first tab has a subform to track how many times that person has contacted us. The second subform tracks which advertisements the person is contacting us about and the third tracks which Events that person attended. There is no correlation between contacts, Ads and Events.
On the Advertisements we have about 7 different types of Ads we do and each ad can be run multiple times on different days. We want to be able to track which Ad the person contacted us about. The Advertisement subform has a comgo box for the Ad type and a combo box for the ad date. the source for the combo box for the ad date includes the combobox for the adtype as the criteria. That criteria is what's giving me the problem. I've used:
I have a 2010 Access Database with a Navigation Pane. When I click a Navigation Button to view another form I lose the position and record I was on in the first form. It's almost like the first form refreshed when I click the navigation button to view the second form. Is there a way to setup the Navigation form so when I click on various navigation buttons it won't reset the previous form I was on?
I have decided to move away from Switchboard in Access 2010, to what I find to be more user-friendly; the Navigation Forms.
However, when I attempt to export any of the data from my navigation forms, the result is a blank Excel sheet. I can easily go into the forms themselves on the left navigation panel and export from there, but when myself or a user attempts to do this from the navigation forms themselves; well, the blank Excel sheet is the result.
How do you create a work-around, so that it is possible to export to Excel from these navigation forms?
Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".
By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?
I have a database in Access 2010 where I've created a navigation form, and I want a regular user opening the database to enter a password and only have access to that form, and not the actual tables or the navigation pane. They should only be able to view, add, edit, and delete data through the forms I've prepared, and I don't want them to be able to get to the tables themselves unless they have an admin password. I tried looking up how to do something like this, and I tried splitting the database, but it seemed like I was still able to go right to the tables and edit them from the navigation pane even in the front-end, and if I removed the navigation pane links to the tables from the front-end, the forms I made wouldn't be able to display anything from them anymore, and that's not what I want either.
So, I want one password to give access only to my navigation form and nothing else, and then a second password to grant access to everything else.
i am running some code from vba to add a linked table and the do some lookups, then delete the linked tables.
When the linked table gets added, the navigation pane gets displayed. I have set it to do not display in the settings and it does not when it opens but when this code runs it opens and then stays open until the db is closed and reopened.
I am trying to use my db as a software and I really do not want this to show.
I have also noticed this in a database I have which has update queries and was fine in access 2000 but does what i described above when using in access 2010.
I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.
I have a textbox where the Control Source is set to this field of the query.
The textbox does not display the data correct and I believe this is because it is in Plain Text mode.
When I try to change it to Rich Text I get an error message.
If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.
I am not able to disable NavigationButton when i login navigation form using login form. I am using MS access 2007 - 2010.i am using below code but getting error.
I have navigation form with 2 tabs I'd like to limit access to users with certain type of account.
There are 2 tables in database that contains user names and types of accounts (tblSecurityLevel and tblUser), and they are used to set user name, login and security level.
It works this way: when you open form, it checks if PC name corresponds to name in UserLogin field (tblUser), if it does it gives appropriate access level depending on set user security, if PC name is not on the list user will be logged as guest.
So far, I used this code and it works great for limiting access to 1 tab:
Code: Private Sub Form_Load() Dim UserLogin As String Dim userLevel As Integer UserLogin = Environ("Username") Me.TxtLogin = UserLogin
[Code] ....
Is there a way to expand the code and add second tab (or even third) with this table structure (I'd like to be able to keep login which 1st checks for pc name).
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim strCriteria As String Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM qryContractListSummarybyDateContract3TYPEBREAK WHERE qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri Masonry NSW');'
We recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.
I have not used access since Office 97 so, I see many changes. A while back I used Access to create some minor tracking databases. Now, with 2010 I'd like to modify the database that I am currently using. I have a main form that tracks daily trips or tasking(s). Within the form are two sub forms that track:
1. People assigned to the trip through a combo box; and 2. Itinerary for this trip.
I have been asked to add a Trip justification(s) through a combo box which will have several selections avail that can be chosen and would apply to each trip. These can be added to by double clicking the justification (figured that one out). What I would like the sub form to do for each new trip that is entered is to display only these values as a single selection rather than 12 times (example) if there are 12 trips that have the reason justification as part of the trip/tasking.
I just can't seem to make this work. The personnel one and itinerary one work just fine (previously existing). I just can't seem to get the new one to work. I have checked that the new table is connected through the relationships. In the exact same manner. The new form has the ID (Key) OPID (to link each trip separately) and justification text field.
When I import a form with the Navigation control on it The following attributes of the navigation buttons are changed to #FFFFFF:
Hover Color, Pressed Color, Hover Fore Color, Pressed Fore Color
I was hoping to be able to automate the updating of customers databases by sending them a database which would export the required objects rather than the whole front end database. I can think a way around this by including code in the form so that it changes the attributes to the desired values, which are:
Accent 1, Accent 1, Background 1 and Background 1. But I would rather not have to do that.
It is interesting to note that the Border Color attribute is not changed on importing.
disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field?
I am very new to Access (I started two weeks ago). One problem I am having is I have a multiselect box on a form in Access 2010 and I want to base the value of a text box on the user's selection. However I would like the textbox to just be based on one of the choices and to allow the user to select any other of the choices along side this selection. How would I input this into the code?The line of code I am interested in looks like:
If Me.Reasons_For_Choosing_Physics.Column(2) = "No other ideas" Then..Could I add something like "No other ideas" + "(*)" to allow other selections alongside "No other ideas"?
I'm working with an old database and I am getting this error. I have have access 2010. I starting to receive this error after I unlinked one of the tables.
Private Sub Command9_Click() On Error GoTo Err_Command9_Click
Dim stDocName As String Dim stLinkCriteria As String
I have a unique "CustomerID" that is an auto number (this is how I link tables, forms, etc.), and "CustomerNumber", "CustomerName", "CustomerSubNumber" that could be null and could have duplicate values.
The first form I have is a Contact Info form where users will enter the contact information such as customer numbers, names, addresses, phone numbers, etc. This then links to an order form. My order form has a place to carry over the "CustomerNumber", "CustomerName", "CustomerSubNumber" values from the ContactInfo table. I would like these fields to automatically populate based on the CustomerID unique number as well as only show the information for that customer ID (including listing out any previous orders).
I have a form design where to enter a new "system" (what we call a new group of members) you have to specify the representative (the member that will represent the system).
If the system is new AND the representative is new, then both need to be entered. Typically this will be done through the "New System" form that has a combo box for you to choose the representative (but the representative won't be there!). If the representative is new as well, then the user clicks "Add New Rep" which is located next to the combo box.
This is where things get tricky, I'd like to use only 1 form to load a new rep. My idea was to use an openarg on the docmd.openform method that specifies what the control should be.
That is the code that is called when the user click "Add new rep" and in the on load event I have this code:
Code: 'Use this version if the ID is text Dim x As Variant Dim strControl As String Dim strID As Long 'If parameters exist, use them
[Code] ....
My goal was to pass the value to the combobox and turn it off, that way they can't change anything about it. This was nice because if the openargs is null (there were none passed) then the combo box would be enabled and the user could select the school that way.
But this doesn't work, for some reason, the combo box has NOTHING done to it (I have the control name correct).
Is this due to the way comboboxes work? Or am I missing something?
I should point out that the on-load event was not my idea, I found that online but makes perfect sense. I was trying something similar but was trying to use global variables because I wasn't aware that OpenArgs was a valid control!
I am trying to create a database to manage IT assets, most of the structure is done, I'm now trying to get the details done.
The issue I am currently trying to tackle is to get a control button on one form to create a new record in the sub form that sits in the main form via another pop-up form.
So I have :
>PeripheralsViewForm - that has 4 control buttons (Edit Quantity, Edit Description,Add an Item and Exit)
>> PeripheralsSubForm - (Datasheet) which is referenced to PeripheralsQuery
The Edit Quantity and Edit Description open a separate form which allows the user to update only the quantity or description respectively (I have done it this way rather than allowing edits in the data sheet as I feel that it is too easy to hit a key incorrectly and overwrite data in the datasheet view) Both of these functions work perfectly (to my amazement) - I am using the id field in the subform to link to the pop-up form which then has unbound text input boxes, which I then write back to the subform.
e.g from edit button on click event: DoCmd.OpenForm "perquantform", , , " ID=" & Form.PeripheralsSubForm!ID and then from the pop-up form "perquantform" on the "Exit & Save" button I have :
This allows the user to select the record in the datasheet form and then click either the change quantity or description button.Also also the other reason I did it this way was because I just couldn't get the subform to requery when I had the two edit popups linked to the table or query.
The problem now is that when I click on the "Add an Item" button, it overwrites whatever record is currently selected !
The code I have is this:
From the "Add an Item" button on click action: DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec DoCmd.OpenForm "addperform"
And from the form "addperform" - "Save & Exit" button on click action:
the line "DoCmd.GoToRecord , Forms!peripheralsViewForm!PeripheralsSubForm.Form! , acNewRec" is what I have added to try to solve the overwrite issue, but when I run this it comes up with the error :
"runtime error 2498 - An expression you entered is the wrong data type for one of the arguments"
I have put this line in the "addperform" exit action and it comes up with the same sort of error.
Why Access 2010 will filter some dates and not others?? When I try to filter 12/02/2014 it will not work and I have to use 12/feb/2014 but if I use 13/02/2014 it is fine...
I have a access 2010 split database and i need to modify one form on the front end (it is an accde file). However, when i open the Front end, i cannot find the possibility to go into the form design mode.
How do i need to do it? do i need to restart from the unsplit database?
The both the front end and the back end are password protected.
I am trying to create a Cascading Combo Box for my Form in Access 2010. I ahve written the code:
Private Sub Combo11_AfterUpdate() cboCombo13.RowSource = "Select TblAcc.SubFamily " & _ "FROM me.TblAcc " & _ "WHERE me.TblAcc.Family = '" & cboCombo13.Value & "' " & _ "ORDER BY me.TblAcc.SubFamily;" End Sub
But keep getting the same "Run time error message 424: Object required"
And when I define the error it says "Identifier under cursor is not recognized" (the yellow arrow comes up and is pointing at the "ORDER BY" line.
I would like Combo Box 13 to give me the SubFamilies of the certain Families choosen from Combo Box 11. (Each Family has different SubFamilies). But if I ignore the error, Combo Box 11 lets me choose a Family and Combo Box 13 gives me options to choose any SubFamily in my DB.
