Forms :: Spreadsheet Control In A Form
Aug 24, 2013I want to have a spreadsheet type control in a form to be use for data entry and also to perform calculation. Is there a way to do that and save the data afterwards?
View Replies
ADVERTISEMENT
Tables :: How To Use Spreadsheet In Tab Control In Form
Oct 5, 2012i have created a form and added a tab control with a spreadsheet on each tab,(ex. column headings in spreadsheet, date of service,minutes tab headings ot visits, pt visits, dr visits, , however, i will need each spreadsheet to be visable when printed because forms will be used a cover sheet with summary of data
View 1 Replies View RelatedPopulating Spreadsheet Control In Access
Oct 22, 2005Hi, I am new to access XP. Pls. can someone tell me how can a spreadsheet control on an access form be linked to a table for retrieving data onto it. I tried export/import with a .csv/txt file but can there be a better way? Thanks in advance.
View 4 Replies View RelatedForms :: Excel Spreadsheet On A Tab In A Form
Feb 17, 2015I would like to add a spreadsheet to my form on a tab just like on the asset tracking data base template in access 2010. I can add an unbound object frame but then I can not edit it on the form??
Pic of what I want to do : excel sheet.jpg
Forms :: Add Record Lines To Spreadsheet Form
Apr 25, 2013I want to create an access spreadsheet form in which the user can add data, which will be - after being processed - added to a database table. The spreadsheet form is for this reason not directly linked to a database table.
In the spreadsheet that I actually have, I manage to copy paste data from an Excel spreadsheet. However, only the first row is pasted. Access doesn't add new record lines for the other rows of my spreadsheet.
How can I make Access add record lines in function of the data on that is pasted? Or if this is not possible, how can I add sufficient additional lines myself?
Forms :: Default Property / Using A Control Of Main Form Without Using Names Of Forms?
Nov 8, 2013In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.
I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.
Forms :: Access Form With Tab Control Pages Each With Embedded Forms
Apr 13, 2013I have an access form with tab control pages each with embedded forms.In one page I have a list of records as a datasheet form with the record identifier field configured as a hyperlink. When I click on this it passes its value to a form field in the form in the following tab page (works without the hyperlink but its a useful way of highlighting which field to click) which is a display/edit form of the details of the individual record. The Subroutine which does this sets the focus on this field it is passing the value to on the other form and the 'On Got Focus' event in that triggers the query that fills the editor form.
When I click back on the following tab to select another record to view/edit, the identifier value of the other record is passed to the other form but the data displayed in the rest form doesn't change. I understand this is because the field with the 'On Got Focus' never lost focus and so the query function was not called. To correct this I tried adding the same function call to the 'On Change' event however this does not work (the field is a text box set to 'locked' if that is relevant).I can get the form to do a new query properly if I click on a different field in the form before going back to the list tab or (as this is removing the focus allowing the On Got Focus to work again) if I click on a button to select a different record (which just takes me back to the list form).
Is there any way I can get this to work without having to manually remove the focus from the problem field? I have tried setting its On Got Focus event to move the focus to another field after the query function call however this prevents the Setfocus line in the code in the previous form from working. Here is a snippet of my code below.This code is for the list form and passes a value to the editing form:
Private Sub SalesID_Click()
Forms!Mainform.Requery
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.Value = SalesID.Value
Forms!Mainform!Sales_Admin_Form.SetFocus
Forms!Mainform!Sales_Admin_Form!Sales_Admin_SalesI D.SetFocus
[code]....
Forms :: One Table / Three Forms - Each Form With Control Tabs
Jul 4, 2013I'm trying to make a very simple click through data entry screen in Access 2007. For each record I want to have a standard form with three buttons at the bottom. Each button opens a new form (each form has a set of tabbed pages on it as there is lots to enter).How do I make sure that each of the additional forms populate the same record as the main form.
View 1 Replies View RelatedForms :: Navigation Form - Using DB Forms Under Its Subform Control
Jun 19, 2013I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database (through RunTime). I was hoping this would be a clean task by simply loading the forms into the tabs of the Navigation Form, however that is clearly not the case.
For starters, When attempting to use a form that has some VBA behind it (Docmd.ApplyFilter based on a selection from a combo box), I am given the error stating: "The action or method is invalid because the form or report isn't bound to a table or query."
After searching on this error, I believe it's because my Navigation Form does not have a record source. If this is the case, then I am confused as to what record source it should have, as with the 3 forms I need to access through the Navigation Form all pull data between various tables and queries within the database (some not related).
Now I've also come to the conclusion that my VBA references now must change in order to correctly use my forms. A correct reference would look something like:[Forms]![Navigation Form]![NavigationSubform].[Form].[My Form's Control]..Is this necessary in order to write any events, such as an AfterUpdate on a combo box?
Forms :: Setting Focus To Control On Single Form Side Of Split Form
Jun 24, 2013When I right click a row on the data sheet side of a split form an select "New Record" I want the curser to go to the first field on the single record side. I've placed this in the OnCurrent but it did no good.
Code:
If Me.NewRecord Then
Me!Descrfiption.SetFocus.
End If
Any way to set the focus to the single form Side of a split form?
Forms :: Tab Control Within A Form
May 21, 2015I am trying to create a form where there will be information entered. The information being entered needs to be on two different pages, as they belong to two different tables. I would like to use the tab control. The problem I am having is that I want to be able to lock the second tab until all of the information on the first tab is correct and the employee entering the information verifies it. Is this possible and if so how?
View 5 Replies View RelatedForms :: Get Value Of A Control On A Form
Jul 25, 2013I have a form that has many calculated fields(hidden and shown) based on the data in the source table. The calculated values roll up to a textbox(txtAward) that shows an award(Gold,Silver,Bronze) based on the total calculated points.
There is no inputting in the form. Its just used to display what was input and what the final award is.
txtAward isn't part of the source table but can be added.
How can I get the txtAward value into the table so I can do some reporting?
Forms :: Filter List Box On Form By Using A Control On Form
Jan 14, 2015On a form I have a:
control called "FilterListBox"
list box called "lstCustomer"
option Box called "optCustomerType"
When the user selects an option in the option box, "FilterListBox" is updated to either "1", "2" or "1 or 2"..One of the fields in the query for "lstCustomer" is "CustomerType" and its criteria is set as follows:
[Forms]![frmPrintHowCustomersPaidInvoice]![FilterListBox]
if "FilterListBox" = 1 the query for "lstCustomer" returns the correct records
if "FilterListBox" = 2 the query for "lstCustomer" returns the correct records
But if "FilterListBox" = 1 or 2, no records are returned.
Forms :: Form Control Recalculate
Sep 17, 2013I have two combo boxes on the same form and for some reason one recalculates and updates and the other one doesn't. The control source for each is as follows:
=DLookUp("[03_END_PREP].[END_PREP_DESC]","03_END_PREP","[PDS_PREP] = '" & [PREP_A_subform] & "'")
=DLookUp("[OPT_DESC]","10_OPTION","[PDS_OPT_NUM] = [PDS_OPT_subform]")
Is there any reason why one would recalculate automatically and the other wouldnt? By the way, I've coded the second one EXACTLY like the first one except the proper tables etc were added, and it just doesn't work for some reason....
Forms :: Tab Control Form With About 5 Tabs
Nov 21, 2013I have a tab control form with about 5 tabs. However when I move to the tab that has a datasheet form, the page moves down. You have to scroll up to see the above tabs. Is there something I'm missing on this simple tasks? Is it better to have it as a basic form for easier interface.
View 2 Replies View RelatedForms :: How To Control Display Of Fields In Form
Nov 20, 2013How can I control the display of fields in a form? I see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.
I can't find how it was done, i see no difference in the fields' properties. Another question is how can i make a comboBox to display just the text without the ID number...
Forms :: Populate Form Control With OpenArgs
Sep 19, 2014I have this code in a button on my Patient Form:
Code:
DoCmd.OpenForm "frm_Admissions", acNormal, , , acFormAdd, , "NHS Number|" & Me.[NHS Number]
And this in my Admissions form LoadEvent:
Code:
Private Sub Form_Load()
'Use this version if the ID is a number
Dim x As Variant
[Code]....
The expression you entered refers to an object that is closed or doesn't exist
Borrowed code from: [URL]
Forms :: Defining Colors On Form Control
Mar 30, 2014I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors.
I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the values for it that will give me the exact colors that I need!
I also saw a possibility of using a the hex equivalent for the color but I couldn't make that work?
Forms :: Display Value Of Control Within Popup Form
Jul 25, 2013I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.
View 4 Replies View RelatedForms :: SQL To Run After Data Is Entered Into Form Control
Aug 3, 2015I have a form that the user enters employees daily duties. I have code to run sql after the BoxNum field has data in it. I want it to look at the BoxNum field and the dropdown box for the task to see if the entered box number has already been completed for the task selected on the form. Here is what my code looks like now. The code runs but gives me the msgbox no matter if it is a made up box number and I also get a syntax error 3075.
Code:
Private Sub Text13_BeforeUpdate(Cancel As Integer)
Dim rs As DAO.Recordset
Dim strSQL As String
[code]....
Forms :: Dragging Existing Form Onto Tab Control
May 2, 2013I have read where you can drag fields onto the tab pages to create a form or you can place a subform onto a tab page, but can you drag an existing form onto a tab page?
I have done it and it is working, but I just wanted to know if this is ok to do or would it lead to problems.
Forms With 2 Dimensions (looking Like A Spreadsheet)
Dec 10, 2005Hello,
I'm trying to build a personnal budget application.
I need to build a form that looks like a grid.
On the first column, you will see the different budgets elements
On the top line (headers), you should see the different months of the comming year.
I already managed to build the necessary tables (with 2 keys in the table source for the form).
My questions are the following:
1) how can I build a forms that looks like a spreadsheet, proposing me every cells from the start (not only the cells that i have filled before)?
2) how can I make for this form to be dynamic ? This means that, if I add a budget element in the budget elements table, how can I make the form to be adapted automatically, adding a line under the others, for every months?
I have asked severall other forums, no one could answer me.
thanks for your help.
Stephane
Forms :: Examine Image Control On A Form Programmatically
Jan 3, 2015I have an Image control on a form which I want to examine programatically. It seems there used to be a way of doing it using Point and PSet from info I have seen online. Is this contained in any of the libraries available under References in Access and if so which one...
View 7 Replies View RelatedForms :: Data Entry Form - Set Focus On Tab Control
Sep 10, 2014On my data entry form I have a tab control with three pages
At the bottom of the first page I have a sub form with 3 fields
Currently, when tabbing, the focus runs through the fields as per the tab order
BUT
Once it gets to the subform (datasheet view) it jumps into the first field of the first record rather than the first 'empty cell' thereby starting a new record in the datasheet.
Once the three fields in the datasheet are completed the focus tabs back to the top of the first page of the form rather than onto the next page of the form
How to correctly reference controls using VBA so I could SetFocus where I want?
The Main form is called frm_Admissions
It has three pages called Patient, Treatment & Service Providers
Patient has a subform called sub_Cluster (which may or may not hold Cluster Information)
I would like the tab order to jump from the last textbox on the form into the first field of a new record in the datasheet (rather than the first field of any existing records)
Once it has finished in the datasheet I need to tab to the first field/textbox in the Treatment's page of the form rather than back to the first field/textbox in the Patient's page.
Forms :: Displaying Control From Database To Form Automatically
Jun 24, 2013I have created and saved a form in access automatically from database table. But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.
View 1 Replies View RelatedForms :: Requery A Control On A Form Pulled From Subform
Feb 6, 2014how do you requery a control on a form pulled from subform? i've tried but it doesnt work
Private Sub Form_AfterUpdate()
[Forms]![Project_Details]![subform].[Form]![Text119].Requery
End Sub