Forms :: Open New Form With A Specific ID (or Name) Filled In
Feb 4, 2014
(MACROS ONLY)I am looking for a way to open a form in order to add a new record. The idea is that I open up the form with a MemberID and possibly the name already filled in on the relevant form. It is merely for ease of use regarding the user.
I have got as far as opening the the new entry form. I just need to pass the MemberID into the relevant field. If I use the wizard it is just finding a record of a pre-filled entry.
View Replies
ADVERTISEMENT
Mar 24, 2014
I have 2 fields in my form.. on if for date (date picker)..
The other one is for day..
I am using this atm:
Code:
Private Sub okt_courtdate_AfterUpdate()
okt_courtday = Format(okt_courdate, "dddd")
End Sub
So.. after i pick my date.. when i click tab.. the day field in form will be filled with correct day of that date.. The problem is..
I want to change days to my countries language.. example if it's monday, i want it to be "isnin".. I need to do this for all 7 days of the week.
View 2 Replies
View Related
Jul 17, 2014
I have a ticket database where tickets are added to access with no priority scores on them. Over time, meetings and discussions, those tickets are given scores through a form on my database. What I would like to do is somehow add a timestamp that shows exactly when a ticket went from being unscored, to having a priority score assigned to it. Note, before the ticket is scored; the Priority Score field is still blank. Null?
An idea I had was to somehow put a timestamp on the "Priority Score" field in my form that will only timestamp when that field goes from being blank to when it gets a number for the first time. It will not change the timestamp when that number is changed down the road. (We edit the priority scores, but I only want to know when the ticket was actually scored for the first time. This is for reporting purposes, how many new tickets we score each month, etc)
Could I do something along the lines of assigning code to the BeforeUpdate value of my Priority field on the form? Although I'm assuming this would put up a timestamp any time the field is altered afterwords also.
View 2 Replies
View Related
Sep 29, 2006
Hi again,
One last one that's been niggling me - I just can't fathom the code... I bet it's very simple...
I have a Form ("frmJobSummary") that shows all the jobs for a customer - the customer is selected and the Customers ID is stored in a Control called "CustomerID" (It's just a number)
I have a button that opens up a new form... "frmEditJob" This allows you to add a job to a customer. I know how to get it to open up as a new record... but...
How do I get it to open up as a new record (or job) for the customer selected on the form "frmJobSummary"?
Here's the code so far... all it does is open the form with the Current record. :(
Your help is, as always, most appreciated!
Private Sub OpenNewJob_Click()
On Error GoTo Err_OpenNewJob_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmEditJob"
stLinkCriteria = "[CustomerFK]=" & Me![CustomerID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_OpenNewJob_Click:
Exit Sub
Err_OpenNewJob_Click:
MsgBox Err.Description
Resume Exit_OpenNewJob_Click
End Sub
View 3 Replies
View Related
May 16, 2014
Basically I have a database that records commitments for clients. The user can go a client form, and within that form there is a subform which shows each expenditure commitment for that person (wihtin the subform there is also another subform that shows all income attached to each commitment). The user can use the Next and Previous buttons to navigate through the expenditure commitments (and the same if they want to navigate through the income commtiments within each expenditure commitment).
If you double click on any specific commitment whithin any part of the subform, then the expenditure commitment form (or the income commitment form if it is an income one) opens to allow the user to change stuff.
My database is set up so that each time a form opens the previous form closes. So when the user has the commitment form open and clicks close, the client form will re-open. My issue is that is always goes back to showing the very first commitment and the user then has to navigate back through till they find the one they have just updated.
What I would like to be able to do is when the user closes the commitment for that the client then the form opens up with the specific subform on the screen that they have just changed.The code I currently have written on the Close command of the Commitment is as follows:
Code:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmTotalCommitmentsbyClient
stLinkCriteria = "[FrameworkID]='" & Me![FrameworkID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Close acForm, "frmCommitments"
I essentialy just need the bit that would also say show the subform (which is called subfrmComms2) where the commitmentID = the commitment ID on the Commitment form.Now just to really complicate matters, I would also like this to happen if someone has the Income Commtiment form open and they close it, only the Income Commitment subform is actualy a subform of subfrmComms2 (above), but equally the income commitment form has within it the Expenditure ID, the Income ID and the FrameworkID.
View 3 Replies
View Related
Jan 26, 2014
1. I have created a button in a switchboard with embedded macro:-
Close Window
OpenForm (Form name: frmCustomerFind)
2. I have created a form "frmCustomerFind), in which I can select a customer name in a combo box named "CustomerName".
a. The row source: SELECT [tblCustomer].[CustomerID],[tblCustomer].
[CustomerName] FROM tblCustomer ORDER BY [CustomerName];
b. After Update Macro:
Open Form (Form name: frmCustomer)
SearchForRecord (Object Type: Form Object Name: frmCustomer
Record: First Where Condition = "[CustomerID]=" & Me.CustomerID
At the end, the form "frmCustomer" does open but not go to the record I want. It goes to the first record instead. (The frmCustomer has the "CustomerID" and "CustomerName" fields).
View 1 Replies
View Related
Mar 31, 2015
Need to open a form to a specific record.Ive done the command button wizard that opens the form to a specific record but but that brings up the form with the filtered button showing.I've tried to put the formula into the filtered section but that doesn't work.I just want to be able to open the form to the specif record and then be able to navigate to other records if required (without aving to press the filtered button)
View 1 Replies
View Related
Feb 9, 2015
Currently, I have a form with tabbed pages in it. The second tab, I have a subform inserted into it. I have a completely separate form that looks through records. I want to be able to click on a record from the separate form and open the Main tabbed form, to the second tabbed page, to a specific record. Currently I have:
Private Sub Form_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frm_Main_Data_Entry"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Forms![frm_Main_Data_Entry]![pgAgreement].SetFocus
End Sub
Which opens up to the tabbed page just fine. but I can not figure out how to get to a specific record.
Also, the subform in the tabbed page, doesn't have the same controls as the Main tabbed Form itself, so when I add something like:
strCriteria = "Agreement_Number = " & Me.Agreement_Number
it won't work because it is not reading from the subform in the tab, rather its reading from the main form controls.
View 1 Replies
View Related
Dec 31, 2014
I have a form that lists a number of orders (list box).
I have another form that has customer details as the main form and the order as a sub form and then another sub form for items....
How can I open the sub form to a specific record? ie I want to view order 14?
View 4 Replies
View Related
Nov 5, 2013
No I know this one has been done, and I have a form with a button that this works on. Here is my problem. I have a list of parts in a continuous form, I added a button to open that specific record in a detail view and it works just fine. I used an open form macro and put in the criteria
="[Description]=" & "'" & [Description] & "'"
I have tried to use this similar procedure for another form, it however has two subforms in it and I get a data type mismatch in criteria exception error. I suspect that it has something to do with the subforms but am not sure.
View 13 Replies
View Related
Jul 10, 2013
I am trying to open a word document with corresponding data filled from the text field of a form. I managed to get the word document but I don't know how to give a variable in word document.
View 2 Replies
View Related
Aug 20, 2013
I have been trying for weeks to get my login form to open up to a specific record on the mainform. I have built a form out of my Employee tbl (mainform). The table stores (ID,Name, password, EmpNumber ect.) I built a subform in that allows the user to type in the number of overtime worked on a paticular day. I have disabled the navigation on the main form so users can't advance to the next user but have enable the natigation on the subform so a particular user can advance to the next week of available overtime to input data.The goal is to get user login form to display a particular record on the main form and open a different form in the user is a supervisor.
Option Compare Database
Private intLogonAttempts As Integer
Private Sub cmdExit_Click()
DoCmd.Quit
End Sub
Private Sub cmdLogin_Click()
[code]...
'If User Enters incorrect password 3 times database will shutdown
intLogonAttempts = intLogonAttempts + 1
If intLogonAttempts > 3 Then
MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical, "Restricted Access!"
Application.Quit
End If
End Sub
View 1 Replies
View Related
Aug 6, 2014
I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done?
Using:
Win 7
Access 2010
View 14 Replies
View Related
Jan 20, 2015
I'm wanting to open a record in another database, below is the code that opens the form to the correct record in the DB I want to open.
Code:
Private Sub btnDetail_Click()
DoCmd.OpenForm "fJob", , , , , , Me.Name
Forms![fjob]![txtJobNumber] = Forms![fJobAlphabetic]![fJobAlphabeticSub].Form![JobNumber]
End Sub
View 2 Replies
View Related
Apr 1, 2013
I have a form and this form shows some values from one table. One of the fields named as Key. I want to open another form and show the record that has the same value as Key.
I am able to make this with filter but the form opens and when the user navigates the record, it creates a duplicate value in related table.
I want to open form and find specific data to display and then stop at this record.
View 1 Replies
View Related
Apr 10, 2013
I have created a Datasheet Form which when opens shows lots of records. I was looking to see if there was a way that if i clicked on a specific field name within a record it would open a new form with all the information of that record only.
View 5 Replies
View Related
May 2, 2013
I am currently creating a database in a hierarchical system that is to be used by multiple users to enter information specific to them. The tables are arranged like this:
Owners
Modules
Tasks
Highlights
Theses are connected using primary ID's and Particular Entries in the next table so they form a hierarchy - when you expand owners it brings up a list of Modules attached to that owner, then expand each module and it brings up a list of tasks associated with that module, expand the task and it brings up a list of highlights associated with that task. This is all very straightforward of course but what I would like to do is create forms that basically match so that the users can navigate from their name, through their modules and tasks and then add highlights to each task.
For this I have been using continuous forms to list all the different entries and inserting a button in each entry that I would like to link to the next form and find the specific data, however when I try to do this the button always without fail will just return all the entries from the form rather than the specific ones requested. I set up the button using the wizard and select 'open form and find specific data' and then select two entries that are identical on each form. I have trawled the internet quite a bit to try and find why this is happening and have inserted various bits of code etc into the embedded macro in an attempt to make it work but to no avail.
I wonder if there is something I need to activate on the form that the button connects to aswel or if I need to connect these forms using the relationship that I used to connect the tables (I am still using a unique identifier).If I connect to a single form it will display the first entry on the list (and I can cycle through them all) on a continuous form it will display all entries starting with the first.I would like it to display all entries for the selected record on the form.
View 1 Replies
View Related
Mar 4, 2014
I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see attached .jpg)
This problem started to happen only recently, namely you will see that the left column under [Job Quote Form 10-2205] is blank, where normally there had been a number of fields to choose from. The fields are all still available, they are just not opening when I try to match two fields.
View 2 Replies
View Related
May 24, 2013
I am fairly new to Access and trying to populate a text box based on whether other textboxes throughout the form contain a date or are null, so as I update the progress of work the textbox that I have located in the header will indicate the status of work flow, this is what I thought might work but I seem to be doing something wrong.
Code:
Private Sub Form_AfterUpdate()
Status = IIf([Date_Raised] Is Null, "New", "")
Status = IIf([Date_Raised] Is Not Null, "Open", "")
Status = IIf([Approved_Date] Is Not Null, "Approved", "")
Status = IIf([Actioned_Date] Is Not Null, "Actioned", "")
Status = IIf([Tested_Date] Is Not Null, "Tested", "")
Status = IIf([Closed_Date] Is Not Null, "Closed", "")
End Sub
View 2 Replies
View Related
Jul 20, 2015
I'm using Access 2007. I have a few problems:
1. I have a switchboard. I want to click a button, that opens a form with a dropdown list, when I make my selection, it opens a subform in add mode, but the linked field in the subform isn't empty, but filled with the mainform's field value that I selected?
OR
2. Is there a way for me to open a form in add mode, add data to it, click the add button (I will add an add button) that allows me to add again, but this time a particular field is not empty, but filled with selected info from previous selection?
Say for instance, I have 2 fields (both combo box fields), I click add, made selections for both fields, I click add again, but this time one of the fields stays constant like it's already been selected. It's filled with what was selected from before.
Either of those 2 - which ever is simpler.
View 4 Replies
View Related
Sep 9, 2013
I have a table in my database whose forms are refusing to open to specific records. They only open to a blank record--either by using other forms to open to specific records or simply by opening the form straight from sidebar. Even the Navigation bar doesn't allow me to move from one record to another; it only shows "1 of 1".
The "initial" form, which creates new records in the table, works perfectly--in creating a new record. I can create a new record, use the Navigation bar to move to a new record, create it, and move back to the first. But then when I close and re-open the form the above issue once again comes up.All my other tables--and the forms that are associated with them--work perfectly and I can open them to specific records without a hitch.
View 3 Replies
View Related
Nov 2, 2006
I have a table that depending on a certain field in that table it will be able to open a specific form.
In other words I have multiple forms but only want a specific form opened when accessing a record if that record has a field with certain criteria
if that makes any sense
thanks
View 1 Replies
View Related
Jan 3, 2007
I have 2 forms one named "View" and the other "edit" on the form "view" the final user cannot edit any field as set from the form properties the form "edit" has no restrictions, what I need is to put a push button on the form "View" that will open the form "edit" showing the same record as on the form "View"
Hope I explained my problem :)
View 5 Replies
View Related
Jun 19, 2012
I have an input form that opens another second input form. The code below opens the form to the correct record.
However, the form that I open has a bunch of tabs on it, and I want to open the specific record right to the tab "Technology_Page". Any way that I might be able to do that right from this statement?
Code:
DoCmd.OpenForm "ProjectDetailsActive", acNormal, , "PPID = " & Me!PPID
View 1 Replies
View Related
Nov 26, 2014
I have 3 attachment boxes in my table that appears in a form.each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes. The issue is there's a lot of document and I see my database growing (fast)...My question finally is....
Can I use a Hyperlink to open a folder within a specific directory where multiple file are located so i can open the specific file need there RATHER than attaching them in the attachment box individually?.?.....If not how this can be done (no SQL) unless that route is very simple and basic coding.
My thinking would be to place the file path to the documents in the table and hyper link that column in the table, but not knowing exactly how Hyperlinks work I don't think it would actually work..
View 6 Replies
View Related
Feb 2, 2005
Hi,
I want to open a new form which is similar to the form it will be opened from. Only difference is the new form I want to open is designed for printing purposes.
I'd like to access the this new form by hitting a button that opens the print form for a user given order number. Any ideas if this is possible? Thanks
View 1 Replies
View Related
