General :: One Form With Two Custom Ribbons

Aug 13, 2013

I have converted a 2003 database to the 2010 file format. In the 2010 database, I have created the USysRibbons table with 2 separate ribbons. One of the ribbons need to load depending on what the user chooses upon opening the database. I have a form that opens with the database and the user can either choose "Premium" or "Subsidy." I'm uncertain as to why the conversion will not replicate how the database works in 2003 but if I had to assume it would be because of the ribbons. I found a small piece of VBA that I think needs to be changed but I'm not sure to what or how. As of right now, I don't have a ribbon loading, just the form to load when the database is opened. Except I noticed that the "add-ins" opens the correct menu depending on which the user chose.

I actually went into Options--->Current Database--->Ribbon and Toolbar and selected a generic ribbon (File, which just has exit because it's the same whether the user selects Premium or Subsidy).

To clarify if needed, the user doesn't actually log in. The form that pops when the database opens has the drop down of either Premium or Subsidy. So really it goes like this:

Open database
Select Premium
Click Enter
Premium ribbon loads

OR

Open database
Select Subsidy
Click Enter
Subsidy ribbon loads

Technically, if I could have just the form pop I'd be cool with that because on the form there is an Exit Application button where the user could click and exit the database. When either the Premium or Subsidy ribbon is loaded, I already have an exit in the coding.

Public Sub openRegion(authority As String, region As String)
If (cboRegion.value = region) Or (region = "ALL") Then
'open region selected
If cboRegion.value = "PREMIUM" Then
loadPremium authority

[Code] .....

View Replies


ADVERTISEMENT

Simple Custom Ribbons??

Jun 7, 2007

OK..... After searching many sites I can't seem to find any simple way to trash the new ribbon and give my apps a toolbar or Menu I want! If it were not for the free packaging and runtime I would trash 2007 all together.... If I'm thinking correctly there is an option on the XP operating system for "Classic view" why couldn't this have been implemented into Access? How bout doing a free release of the packaging wizard for 2003???? hopefully there are some sharp folks out there that will have some ways to do this.....OK.... I'm done venting..........:rolleyes:

View 10 Replies View Related

General :: Creating Custom Menu Bar For Form?

Jul 2, 2012

i would like to create custom menu bars for my forms report

View 6 Replies View Related

General :: How To Get Current User From Custom Login Form

May 2, 2014

how i can get a current user from a custom login form CurrentUser() this function always return a system user name admin as default. In my login schema i have a Hidden splash form that have a unbound field that holds user name from custom login form after login a dashboard execute and also display user name on dashboard according to user login ,this working fine for mine. Actually i want to make a currentuser stamp in every entry when a record is entered in database.

View 1 Replies View Related

Buttons On Ribbons In 2007

Jun 22, 2007

Customizing ribbons in 2007 and having a little trouble with the buttons... It seems I need the listing of the "Button idMso" and the "ImageMso"..... I think I have found the "button id" (I'll know after I try a few) but can't seem to locate a listing of the images. Anyone know? Thanks

View 2 Replies View Related

Opening Doc File Through Microsoft Access Ribbons

Feb 17, 2012

Any module that would open a word document. Also, If that module could be linked to a ribbons menu item...

View 3 Replies View Related

General :: Put A Custom Button On QAT

Mar 19, 2015

I would like to create a command button that saves a report as a PDF. Currently I am using the built in "PDF or XPS" button but it always opens Adobe reader at the end and also a dialog with the option to save export steps. I want nothing other than a simple save dialog like I can do with a VBA command, but is it even possible to add a custom command to the quick access toolbar?

I know you can add custom commands to the ribbon but the user of this database keeps the ribbon minimized due to it eating up too much of his screen space. The QAT is always visible.

View 3 Replies View Related

General :: Custom Database Icon

Oct 17, 2014

Creating and installing a custom icon for my database but I'm still seeing the access icon. I've done these things:

-I made a 32x32 bitmap in photoshop.
-I saved it in the same folder as my database.
-I opened access 2007 with my database
-I went to access options/current database/application options/application icon and browsed for my bitmap.
-Clicked on use as form and report icon.
-Closed everything and reopened my database.

I couldn't see my icon anywhere in explorer, access or my desktop shortcut for my database.I repeated all this except I put the bitmap into an online icon creator and downloaded an .icon for win vista and win 7 which I selected as above.

View 3 Replies View Related

General :: Including Custom Notes On Orders

Feb 24, 2015

I'm looking to simplify some aspects of our company's order database, including standard notes that appear on the sales orders that we send to customers. We have different lines of business and the notes vary. We currently have several reports, depending on the type of order, with the notes hard coded in labels. It's not an elegant, nor scalable, solution.

Our ideal solution: One order report only, with an option for the user to select one or more notes from a list when they enter the order. I'm thinking a popup form with a checkbox next to each note, where each checked note will print on the order report.

View 5 Replies View Related

General :: Ribbon Load Custom Image

Oct 21, 2014

I have the following xml script in my table and I want to make the 3rd button be a image that is saved in my c drive.

Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad1">
<ribbon startFromScratch="true" >
<tabs>

[code]....

I found the following getimage script but am not sure how to apply it to my button, I have seem various examples on sites but just can't get it to work.
Can I somehow set the icon path like C:Image1.png

Code:
Public Sub getImages(control As IRibbonControl, _
ByRef image)
Set Image = LoadPicture(getAppPath & control.Tag)

' Maybe something like
' Set Image = LoadPicture(c:image1.png)
End Sub

View 3 Replies View Related

General :: Custom Ribbon Always Jumps Back To First Tab

Jul 23, 2012

I've created a custom ribbon for my end users (Access 2010) and everything looks and works great except for one issue that is becoming a deal breaker for me and my end users:

I've got a number of tabs on my custom ribbon and on each tab there are a number of buttons that open various forms and reports. Anytime one of those forms or reports is opened and then closed, the ribbon jumps back to the first tab in my custom ribbon. So if you were on tab 3, opened a form and then closed it, you would be jumped back to tab 1.

Any workaround for what seems to be "by design" behavior for custom ribbons? The built-in ribbon does not do this.....

View 2 Replies View Related

General :: Custom Message For When Record Locking Is Set?

Oct 20, 2014

My database has been set with the 'All records' locking option set to prevent two or more people editing files at once. This is working fine but I wondered if there is a way to make a more personal message appear instead of the default Access one, just to maintain a uniform look.

View 3 Replies View Related

General :: Remove Or Hide File Tab On Custom Ribbon

Apr 23, 2013

In Access 2010 I made a custom ribbon.The File Tab still gives users access to features that should not be available to them such as: Compact & Repair, Encrypt etc.I spent a few hours looking for a solution but found none that works.It does not seem to be possible to hide the File Tab, but is there a way to hide the options it reveals?

View 3 Replies View Related

General :: Custom Security Permissions For Employee Database

Nov 28, 2012

I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?

View 1 Replies View Related

General :: Possible To Create Custom Security Permissions In Access

Nov 27, 2012

I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?

View 1 Replies View Related

General :: Rearrange / Move Custom Categories In Navigation Pane

Oct 15, 2014

I use custom categories in the navigation pane to make finding the right objects easier (duh) but now I have quite a lot of custom categories and they are stuck in the order they were created in.

I would like to rearrange them into some logical order (maybe alphabetical, maybe custom) so i can find the categories quicker.

View 1 Replies View Related

General :: Custom Table Based On Users Choice Of Fields

May 15, 2013

I want to create a form where by the user can select the fields he requires and the table is created.

Example: I have a table of subjects like maths, english, french, chemistry etc,

The user can choose what subjects are available in that particular school and therefore a table is created based on the chosen subjects.

Is there any way it can be done even with vba?

View 4 Replies View Related

General :: Hidden Access Shell / Runtime And Print Preview Custom Ribbon

Dec 17, 2013

I have created an application. It has a split front end and back end. I plan to distribute the runtime version. I have used code throughout that "hides" the microsoft access shell for popup (modal) windows. In every form & report I have a function to show or hide the access window. Everything works great until I get to my reports. I open reports in print preview. I created a custom table (USysRibbons) and added a Reports print preview ribbon & xml. I assigned that ribbon to my report(s), and I assigned it in options as the default ribbon. If I test the ribbon (by working in the database using "shift" open) I see my ribbon. But, in when I open app without shift or or if I emulate runtime, I can't get the ribbon.

I have multiple popups forms, several non popup forms and a couple of reports.I just want to keep all the access background stuff hidden - except for needing the ability to print.

View 1 Replies View Related

Using Custom Form For Message Box

Jul 4, 2006

I use the following code for an error message box to pop up.
I need to know how bring up a custom form I have made instead of the standard message box but don't know how to code it into the function.

Function StartUp()
On Error GoTo Err_ProcedureName

Set db = CurrentDb
Set rs = db.OpenRecordset("tblEmployeeBenefits", dbOpenDynaset)

If rs.EOF = False Then
rs.MoveLast
If rs.Fields("FlagDate") = True Then
MsgBox "You need Administrative access for this function to work.", vbOKOnly, "Serious Warning"
DoCmd.Quit
End If


Else

If rs.BOF = True Then
y = 0

Do Until x = 1
x = rs.RecordCount

rs.AddNew
rs.Fields("MeDate") = Date + y
rs.Update
y = y + 1
Loop
End If
End If
UpdateTable

Exit_ProcedureName:
Exit Function

Err_ProcedureName:
MsgBox Err.Description, vbOKOnly + vbCritical, "Function Start Up"
Resume Exit_ProcedureName

End Function

View 2 Replies View Related

Enable And / Or On Custom Search Form

Jun 9, 2014

I've created a custom search form where using unbound text boxes and combo boxes I enter the criteria for a query. I would like to enhance my form to allow "and" and "or" searches on a field. For example, a product on my database has multiple features. I would like to search for products who have "feature1 and feature 2" or "feature1 or feature2". {Note: The table, Product is connected to table, Features using table, LineItem_ProdFeature where there are multiple records in Features for one record in Product}

Right now, the search form has a combo box that lists all product features. The user selects a feature and runs the query. All products with that feature are listed in the query.

It would be so great if the user could choose multiple features from the combo box. Then the query would return all products that have all of the selected features ("and" search). It would be just awesome if the user could select multiple features, and specify if they want an "and" or "or" search of those features.

View 14 Replies View Related

Modules & VBA :: Custom Record Counter Of A Form?

Jan 27, 2015

I have a custom record counter on a form using the below code:

Private Sub Form_Current()
If Me.NewRecord Then
Me.lblRecordCounter.Caption = _
"Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount + 1
Else
Me.lblRecordCounter.Caption = _
"Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount
End If
End Sub

I think at some stage the form was saved with a filter on and this may be causing the issue. The problem I have is:

There are 1749 records. Everytime I open the form the custom record counter displays "Record 1 of 501". The built in record counter shows 1 of 1749. The moment I hit the next record arrow the custom record counter displays "2 of 1749" and if I go back again it displays "1 of 1749.".

I know it's a filter causing the problem because I have a macro that does a clear search. As soon as I hit the clear search the custom counter goes back to "1 of 501" again (even though the built in one stays at 1 of 1749).

I have Filter on Load set to No.

what I am doing wrong?

View 13 Replies View Related

Queries :: Custom Search Form Query?

Jan 28, 2015

I have made a database for work and is fully functional, but theres one thing I want to add but cant get my head around how to do it.

I have created a Form called 'Filtered Search', on the form it has multiple combo boxes for 'Auditors' 'Area' 'Status' and 2 text boxes for date range.

I want to be able to set what filters I want, and for the query to ignore any fields with no information selected/inputted (i.e. I want to see all records raised by "Mr Smith" (Auditor) that are still 'Active' (Status) in all areas at any time).

Names of items;

Table = 'Incidents'
Form = 'Filtered Search'
Report = 'Filtered Report'
Auditor = 'Combo7'
Status = 'Combo156'
Area = 'Combo5'
Date Range From = 'Text161'
Date Range To = 'Text163'

View 5 Replies View Related

Searching For Value Range On A Custom Search Form

Jun 9, 2014

I built a custom search form that uses unbound text boxes to set the criteria for a query. For example, I have an unbound text box, LastName on my search form. Then in the query, I set the criteria to Like "*"&[Forms]![SearchForm]![LastName]&"*". This returns all records if the text box is left blank or returns those records that match the text box if it isn't.

I would like to do the same thing but instead of searching a text field, I want to search a number field. And I want to search for a range of values aka >10 instead of just a single value. I still need the query to return all records if the text box is left blank.

View 8 Replies View Related

Custom Save Button On Form Preventing Subform

Jun 21, 2005

I have a main form and a sub form. Tbhidden and tbpropersave are the text boxes that govern the update procedure. The main form has two text box that i use to prevent the user from modifying the information on the main form without clicking my custom save button. the problem is that the subform should be completed after the information on the main form has been filled in. The Update code i have refuses to allow me to complete the subform without first clicking the save button on the main form. Here is the code. I wana be able to fill in info in the main form, then the sub form then click save. The sub form is a table which relates to the main form table Many to One.

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_Form_BeforeUpdate

Me.tbhidden.SetFocus

If Me.tbPropersave.Value = "No" Then
Beep
MsgBox "Please Save This Record!" & vbCrLf & vbLf & "You can not advance to another record until you either 'Save' the changes made to this record or 'Undo' your changes.", vbExclamation, "Save Required"
DoCmd.CancelEvent
Exit Sub
End If

Exit_Form_BeforeUpdate:
Exit Sub

Err_Form_BeforeUpdate:
If Err = 3020 Then 'Update or CancelUpdate without AddNew or Edit
Exit Sub
Else
MsgBox Err.Number, Err.Description
Resume Exit_Form_BeforeUpdate
End If



Please HELP


End Sub

View 1 Replies View Related

Standard Form Used To Display User-custom Query

Nov 15, 2006

Hi,

I have generated a standard form for displaying/editing of data and I have also created a form for generating Sql query statements (The form builds a string but does not execute the query). Can I execute a query and use it with that form.

So when I generate the the SQL statement and execute the query it loads the form (With Data) instead of a query datasheet. Thank you.

View 1 Replies View Related

Create A Custom Word Form Letterdoc From Access Data

May 13, 2005

For keeping record of provient fund, I have made a access/(or excel) database with many fields like ID, Name,contribution for months eg March, April,..to..,Feb,etc.It contains 50 records.

Now I have to print the provident fund statements of my 50 friends. This statement consists of some text language and some data(It is a word form letter document).The statement also shows some data which has to be calculated from the data of database eg grand total, cumulative total, interests etc.

Now I want to print the statement for all or selected no of people. What I want is to make the statement proforma in another excel sheet and then merge and print the statements for selected no of persons eg for ID 1 to 20, 50 to 70 etc. I do not want to make statement in MS word and do not want to merge it there, but I want to do it in excel just as we do in MS word mail merge.

Pl help me how can I do it in access/Excel? Can i calculate in word or should I calculate before hand in access before merging data?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved