I currently have two forms. One being my main form and the other being a pop-up form to update e-mail addresses. On my main form, I have a button that is currently programmed to generate several e-mails. Before those e-mails are generated, I would like the pop-up form to appear asking for any updates to e-mail addresses. Once the pop-up form is closed, I would like the code on my main form to continue.
View RepliesI am using to select and append data to an output table. Everything is working fine until the last step. The last step appends all the data to an output table from the initial table. The intermediate steps select the data to output.
"AddExpenseToOutput()" is stopping about halfway through the list of criteria. Initially I thought there might be a null in the list, but it doesn't look like there is after dropping everything into Excel to manipulate.
Code:
Option Explicit
Dim rstAccount As DAO.Recordset
Dim rstAccounts As DAO.Recordset
Dim CAccounts As String
Dim Item As String
Dim AccountKey As String
[Code] ....
I have a form that contains an autonumber field. Before any data is entered into the form that field displays the word "(Autonumber)".While it does this the subforms on my form that use that same field to run their querys are empty
Code:
Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec
[Forms]![InvoiceForm]![CreateNewRecord] = True
Me.AllowAdditions = False
[CreateNewRecord] is just a invisible tickbox that is used to enter some data on the form; I don't want to use it but haven't found another solution.
Anyway. When the user opens the form they have to press this button Unless a new record was previously created and that's confusing. I'd like it in the form load event except I can't "see" the value of the field while it displays "(Autonumber)".My code for the form load is:
Code:
If InvoiceNumber.Value = Null Then
Command82_Click
End If
Where invoicenumber is the autonumber field and command82 is the new record button.
On my switchboard i've got several forms, whenever i click a link to a new form that form opens in a new window, how do i stop this so that they all open in the same window?
View 2 Replies View RelatedI created a basic database in Access 2013 to keep up with jobs, and each job has a job number assigned to make each job unique (Primary Key).
At first I had it where I had to enter the new job number manually for each job. I have updated it and now it takes the last job number and adds 1 to it and then fills in the Job Number field automatically.
The problem is when I clicked the Last Record button, it will go to the last existing record, but if I click the Next Record button while on the last record, it will create a new record. It creates a new job instead of stopping at the last record. I assume it has to do with the auto numbering I have setup for the job numbers, since it didn't do this before, but I am not sure why. I ONLY want to be able to click the New Record (Blank) button to create a new job, NOT by also clicking the Next Record button.
Is there a way to force only the New Record button to add a new record? I still need the Previous and Next Record buttons to maneuver through the existing records. I just don't want to create new jobs accidentally by clicking the Next Record button when I'm at the end of the existing records. It should just stop, or say last record or something similar.
I have a form that contains a combo box, I used the access wizard to make this combo box select a record from a table of customers and display that record on the form.
The user then has the option to print that record.
This works fine.
I now want to be able use the same combo box but with a different table so I can select Records from a list of suppliers.
Is there a way I could use a toggle button to change the rowsource of the combo box and then use that same combo box to select records from my supplier table.
I have VBA to send multiple reports to a group of people depending on a toggle button selection. what I'm wanting to do is have it loop through the e mail process until all 5 toggle buttons have been selected and the reports have been E Mailed. Is this possible. Toggle buttons are named toggle1, toggle2 and so on.
View 4 Replies View RelatedI'm quite new to Acces (2010) . Currently, I'm working on a form in which certain fields are set to invisible. I'd like to toggle fields to visible based on the button clicked.
Example:
Field 1: O No O Yes --> When No is clicked Field 2 (containing a date) becomes visible
--> When Yes is clicked Field 3 and 4 (both yes/no fields) become visible
I have built a end user form with multiple toggle buttons with "Yes/No" properties. I am wanting to link the buttons together, so if all have been selected/pressed it will read "pass" in a text box, but if even one is not selected it will read "fail". I was successful with the programming for one but not sure how to link them.
View 2 Replies View RelatedI created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.
View 3 Replies View RelatedIs there a way to show the toggle buttons in an option group as NOT selected when the form first loads up? I've cleared all the default value properties in the table and the form but it always loads as showing one of the buttons pressed/selected. I want the form to load and both buttons in the group look the same.
View 3 Replies View RelatedI am making a specialty form where it must toggle on or off when the user clicks on a boxed area. Since toggle backgrounds cannot be set to transparent, I need to do it some other way. I thought of either using a button to control a hidden checkbox, or just writing code altogether. The problem is that I don't know what code to use to programmatically change the state each time the box is clicked.
View 14 Replies View RelatedI am attempting to create a toggle on a form that would instruct a query which criteria to use.
Specifically they are date criteria. I want to be able to toggle between evaluating on a start basis verse a ship basis.
If the toggle is set to 'Start Date', the query would use the start date as its criteria. If the toggle is set to 'Ship Date" it would use the ship date.
The other complication is that within the query, "Start Date" and "Ship Date" are two separate fields always contained in the query, so how do I write the query so that it only applies criteria to the appropriate field based on the toggle setting?
I would like to create a command button on the header of a form. The button should perform a toggle switch: click once to activate the task and click it again returning original state. I can create the command button to perform a task but do not know how to return to original state. The button should have indicator showing which state is in.
View 2 Replies View RelatedI have a form with about 40 Toggle buttons on it. I want the form to populate from a table. This table stores the status from rooms.
My table name is [Room]
Fields [Room] and [Room_Status]
I want to call the button BtnBS1 (Room BS1) and if the status for that room is occupied the button when loaded will be RED, and if it is available it must be green.
I want the form to be an graphical overview of what rooms are occupied and what rooms are available. By clicking on a green room I want another form to open to allow me to fill it with data.
How do I point to the table when I load the form?
I have a form with about 10 subforms on it, all of which have queries as source objects. All of these queries are based off the same table which contains a field for Customer. What I would like to do is have a toggle button on this form that, once pressed, essentially adds a "not like" criteria to each of these subforms' queries EXNot Like "Customer_A"). When depressed, the queries/subforms should exist as is.
My first issue is that when I add a toggle button, the control wizard does not start. It starts up fine for any other control, however. For example, I imagine that on the After Update event of the toggle button I would requery each of the subforms, but I'm not sure how to add the "not like" criteria to each of the underlying queries.
I have a form. On this form is a tab control with 5 tabs. Four of these tabs have subforms on them. The 5th tab is sort of a "settings" page. What I would like to do is have a button on the 5th tab, that toggles the subforms on the other four pages between the regular form view, and datasheet view.I know I can use the "DoCmd.RunCommand acCmdSubformDatasheet" to do this, however I am unsure as to how to apply it to the subforms on the other tabs. They aren't "in focus" so the command won't work properly.
View 1 Replies View RelatedI have a tab control at the bottom of my main form, and some of the tab pages contain subforms. On one of the subforms I have created a filter to divide the content into "complete" and "incomplete." I have also added a toggle button option group to the subform to toggle the filter (one button for "complete" and one for "incomplete"). I'm using a macro to apply the filter, but it isn't working. The filter does work properly if I use the "Toggle Filter" button on the Ribbon, but I want to create something a little more user friendly.
I have :
Main form: Search_by_name
Subform: Action_Items
Underlying table: tbl_Action_Items
Subform control: sfctlActionItems
Toggle button option group: tgl_Complete_Incomplete
Here's the macro as it stands right now:
If [tgl_Complete_Incomplete]=-1 Then
ApplyFilter
Filter Name
Where Condition =(([tbl_Action_Items].[Completed])=True)
Control Name [Forms]![Search_by_name]![sfctlActionItems].[Form]![tgl_Complete_Incomplete]
Else
RunMenuCommand
Command RemoveFilterSort
End If
I get the error message "The 'ApplyFilter' action requires a valid control name that corresponds to a subform or subreport."
If I remove the content of the Control Name field and open the subform independently (i.e. not as a subform), everything works fine.
I have a form with data fields and a list box, data is coming from a query. When I add a toggle button to apply a filter to the data on the form, the data in the fields are filtered, but the list box still shows all the data items. How do I use a toggle button or something on the form that when activated it filters the data in the list box and the list box only shows the filtered content.
View 14 Replies View RelatedI have a routine than has been working perfectly up to now. My save routine was called by clicking a Command Button called cmdAdd.
I tried to change this Command Button to a toggle button by deleting it then creating the toggle button, naming it cmdAdd and clicking on the event property to link it to the existing procedure. PS It is an UnboundForm
BTW, I've done this for several other commands without a problem but with this particular case I get the following error
Run Time Error 2115.
The macro or function set to the Before Update or Validation Rule is preventing Access from saving etc."
It seems likely that I need to do something to the toggle properties.
It allows the docmd.save but still says "You must save the current field before you run the Requery action"
The system is looking to save/update and something is stopping it. Funny though that this doesn't occur with Command Button
I have tried decompiling, compact and repair, commenting out every line that involved updating a field or variable (Except for a recordset operation that does correctly do the updates required)
BTW the Toggle button has no Before or After Update events - Only the On_Click
I have a navigation form with a combo box. The combo box has a running list of manifest numbers. I select a manifest number, then click a button that brings up a new form with data related to the selected manifest.
However, I have to click and unclick the 'Toggle Filter' button on the new form to show the correct data each time I open the form.
I have an option group with two toggle buttons. Is it possible to set up the option group such that only one toggle button is visible at any given time (i.e. the unselected option) So the group has a default value. Clicking the visible button should switch the value, hide the button (option) associated with that value and show the alternate button (option) for the alternate value?
Basically only having one visible button at any given time which toggles between the two values (but I'd like to retain it as an option group, rather than as two independent buttons, as that gives me a handy value from which to determine control sources elsewhere)
I've tried setting the visibility of the buttons from the AfterUpdate event of the option group but it doesn't work.
I know I can do this with independent buttons but was hoping there was a quick(er) and easy way to do it with an option group instead?
In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?
View 2 Replies View RelatedI have a form with a command button which sends a message containing information from fields on the form. This works fine. Problem is, the user can use the "Email Button", when there are fields not filled in. Is there a way to stop the email message from being sent?
View 2 Replies View RelatedI have 10 fields on a Form. When I load up my Form, I don't want any of them to have the cursor in it.
How do I do that?
I have a customer who is concerned that their access database may be copied and used by a competitor. I have told him to set up passwrods for all users amd hide the system file which stores the password info so database won't open off site if copied. He doesn't want to do this though. Is there any other way, possibly by encrypting it?
Regards :confused: