Active X form control
Microsoft InkPicture Control
Need help with a Active X control.
I working on a project to write my work orders on a computer and let the customer sign on my tablet PC screen, this is the idea.
I found a active x control, that maybe worked "Microsoft InkPicture Control"
But I found no way to print the signatur on a report. I dont want to safe the signature as a picture, only if I have to.
Working with Access 2007 and Windows
disable controls on a subform,
I have a form, it has two combo boxes and a subform with four controls one txt and three combos, When the form opens the first combo is active and the second combo is enabled to false, so is the subform and the controls on it "see first image", as I add data into the control the other update event activates and the next control becomes active.
the subform becomes active and so on for each control on it.
when the last control is used its focus is directed to one of three buttons. close, exit and save and add record.
the form controls which are set to enabled to false work just how I would like, but when I press the add record button, I get "you can't disable a control while it has focus". .
or if I do not put the focus on the close button it works but not all the controls on the subform get set to enabled to false "see second image".
Requery Macro Action
You can use the Requery action to update the data in a specified control on the active object by requerying the source of the control. If no control is specified, this action requeries the source of the object itself. Use this action to ensure that the active object or one of its controls displays the most current data.
Outlook Calendar Control Needed
I am currently recording patient's appointment dates and times in table via a form by having 2 separate controls; a date text box and a time text box.
I still have to use Outlook to display the appointments in a Calendar form (double entry of data is annoying) as I cant find a Calendar control where I can see a week in view. Id like to enter.
via the Calendar control.
Does anyone know how I can do this ? Ive tried inserting an Active X Control but its saying the object isnt installed or something like that
Show All Records
I have a table with a filed named Status which the default is set to Active, it is a combo with a value list using Active and Archived. On my form I have an option group with the default being set to 1 or active.
Sometimes I wish to set the status to archive so the record does no appear on the form bu not delete it. I also set the criteria for the query that the form uses for the field status to 1 meaning active.
I am using a Do.Cmd.ShowAllRecords (on click event for a checkboxl on the form to view all record but of course it does not work.I need a solutionfor this problem.
P.S. I want to be able to view ALL records on command but then go back to the default when either the form is loaded again or another event is triggered.
How to change a page control parameter
I've got a little problem in changing a tab control enabled parameteri have a tab control named tabctl0within that tab I have 3 pages: page1,page2,page3I want to depend the enabled parameter of each page on a field in the main form.the field in the main form = dovisitif me!dovisit = 1 then me.page1.enabled = false me.page2.setfocusend ifI wrote that code but everytime I get the message that you cant change a page control if it is active.can somone help pleasethanx alot in advanceNoam
Filter Subform from another form
I am trying to filter a subform when I open the parent form from a different form with an option group. So, the first form pops up with the options: 1) Show "Active" Contracts 2) Show All Contracts. If the user selects 1, I want it to open the specific customer form (frmContractsForm) and filter the subform (frmContractSub) where the subform's "Status" field is "Active." Here is my code:
'Display Active or All Contracts
DoCmd.OpenForm "frmContractForm", , , "CustomerID=" & Me.txtCustomerID
'Filter to Active or All
Select Case frameOptions
.Filter = "Status= 'Active'"
.FilterOn = True
reference a text box from a function
I have a couple of forms which have a text box named txtTempHold. The value of txtTempHold changes on the 'gotfocus' event of the active control. Rather than put the code I am using behind the form on every gotfocus event I want to put it into a function.
I'm having trouble with the folowing line (which compares the active control value to the temp value). I can't use 'me. in the function and am not sure what I should use.
If Screen.ActiveControl.Value Me.txtTempHold Then
I can write it with a reference to the actual form name etc. but as it's on different forms I only want to have the one function and reference the text box from both forms.
how to make the form active for editing?
I have a form and when I click a button it opens up another form. The problem is the newly opened form goes below the form and is not active. I have to close the previous form first to get to the newly opened form
Tab Control - Pages
I have a common text box control which appears on all 4 pages of my tab control. (Common text box control achieved through pasting a text box control onto the tab)
I only want the user to be able to change the data in this text box control if they are on Page 1. If they are on any other Page, then I would like to Lock the text box control.
If there was a Got Focus event for a Page then I could do what I need; but there isn't!
Is there a way to determine which Page of my Tab Control is active
Autodesk DWF Viewer Control In Report
I'm using Autodesk DWF Viewer Control in a form to look up dwf files on our server and it works just fine, how ever I'm having a heck of a time getting it to work in a report. The Autodesk DWF Viewer Control gets its date from a textbox I call "FileLocation" which is stored in the table "OldpartsTBL" and I can't seem to pass the file location to the active x control on the report.
Communicating OLE Server Active X
I have received this error message at a charity that I volenteer at.
A problem occured with communications with the OLE server or Active X Control.
The user has received a new computer with an XP operating system, and was able to use her Microsoft Access 2003 databases on her XP computer previous, but not on her new computer
Need something faster than DLookup
I have two tables that may contain information a user is looking for. One is the "active" table; the other is an "archived" table. Information gets archived periodically, but sometimes may need to be brought back to the active table.
Users generally access the active table (by entering a Customer ID in a form), but if they enter a customer ID which does not exist in the active table, I use a DLookup function to check the archived table...
Record source in form not updating
I have a form that I use to enter employee late arrivals. The employee name on the form is a combo box that is bound to a table that the information goes to, and the employee name in the table is bound to a query which finds active employees, and the in the table the employee name field is limited to the employee name field in the active employee query. The active employeequery gets information from and employee master table.
Long story short (too late) the combo box is limited to what is in the employee name field in the active employee query. I just added a new employee and need to put information into thistable, but while I can see the employee is on the active employee query, I cannot choose them from the combo box on the form, nor can I choose or enter them onto the late arrival tableitself.
What have I screwed up and how do I fix it?
open form corresponding to control from report
I have a students table with its report and its form.
In the report, I created a macro called on double-clicking the student's name control. The aim is to open the form corresponding to the clicked student.
I have a simple OpenForm command which works fine, and this is the code in the WHERE field:
="[Name]=" & """" & [Screen].[ActiveControl] & """"
It should act as a simple WHERE filter like: [Name]="Peter Roger" except that the name is variable and equals the clicked active control.
Now the form is opened correctly, but not at the record corresponding to the clicked student, only at the beginning.
I tried to use Char(32) and several other combinations, but I just can't get it to work
Filter with iif?
I'm trying to set a field to add only active employees.
This is what I came up with it does look at the status for Active but does not add in the last name.
Goal to be able to click on said report and pull only active employees information out
Query with 'active' form field
I currently have a basic query that uses a form field. This query is used as the row source for a listbox that has a lot of events associated with it.
WHERE ITEMS.ITEM_ID = Forms![Form 1]!ItemID
How can I change this query to work in more than one form, not just Form 1? Is there a way I can reference the active form or the form from where the query is called e.g. WHEREITEMS.ITEM_ID = Forms![Active Form]!ItemID (assuming all forms have an 'ItemID' field)...
Setting a forms focus using a variable
I have two (or more) forms open. I want to set a form (that doesn't have focus) as the active form. I think I do this like so:
But I am using a variable to denote the form I want to be Active.
lets say the varibale name is frm12bActive.
So if I wrote this variable in the code:
Wouldn't Access be looking for a form Named frm12bActive?
How do I reference the form I want to be active using the varible.
I am not even sure the initial code is correct, but I did get it off of another thread on this forum. so I think it's probably correct
Code a data validation list in a spreadsheet control of a form
I can't figure out how to code a data validation list on the active cell of a spreadsheet control within an Access form. I use the 11.0 spreadsheet, however I don't think the versions are so differents.
Record source in form not updating
I have a form that I use to enter employee late arrivals. The employee name on the form is a combo box that is bound to a table that the information goes to, and the employee name in the table is bound to a query which finds active employees, and the in the table the employee name field is limited to the employee name field in the active employee query. The active employee query gets information from and employee master table.
Long story short (too late) the combo box is limited to what is in the employee name field in the active employee query. I just added a new employee and need to put information into this table, but while I can see the employee is on the active employee query, I cannot choose them from the combo box on the form, nor can I choose or enter them onto the late arrival table itself.
What have I screwed up and how do I fix it?