My client wants to be able to have a form open with a record, then open the same form with a different record. In all my experience I have not had this request or seen it done. I assume I could have a different form to open the second record. How to confirm my assumption?
The situation is they have a sales lead open and they get a call and need to open another sales lead without closing the other one.
One shows my form with the Transporters Subform with 3 entries, and 1 entry.The three line items that say "Transporter" are in one subform. I used this code
Code:
Private Sub Form_Current()
If Me.RecordsetClone.RecordCount >= 3 Then
Me.AllowAdditions = False
End If
End Sub
to limit the number of records I can add to 3 or less.My issue is that I lost the blank text box that allows you to add another record. So, if I only have one Transporter listed, there's no box to let me add a second or third.I have the following properties for the Transporters Subform set to "Yes":
Data Entry
Allow Additions
Allow Deletions
Allow Edits
Allow Filters
I have a form which needs update ever month. When the form is opened, the end user can see the old records and data, and also a new record is added for any new data. I want to protect the old saved data and the user can only add, edit, or delete the new data in the newly added record. The problem is once a user adds the new data and moves to another record or another form, then he/she cannot edit or change the new data in case if there is any mistake or need to change something after couple of minutes.
I changed the Form Data Properties "Allow Additions", "Allow Edits", and "Allow Deletions" many different times and situations to solve this problem but with no success. I tried the following with NO success too: One of the Fields of the Record is (Month). In the Data Properties, I set a Default Value for this field as(December 2014) for instance. I set the Data Properties "Allow Additions", "Allow Edits", and "Allow Deletions" to (Yes). Then I put the following code in the Form's Current Event:
Private Sub Form_Current()
If Me.month.Value = "December 2014" Then
Me.AllowAdditions = True
Me.AllowEdits = True
Me.AllowDeletions = True
[Code] ....
I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.
I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??
Form Detail
-Form does not allow additions or deletions. Edits allowed
-All fields are disabled and locked
-I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results
Here is my code
Code:
Dim rstMyForm As DAO.Recordset
Set rstMyForm = Forms!MyForm.Form.Recordset
rstMyForm.MoveFirst
Do While Not rstMyForm.EOF
If Not RequiredField.Value = "" Then
[code]...
The user will be creating a new project that contains a bunch of releases. The releases have standard names which are stored in a table tbl_ReleaseNames It should be noted that the list of names is not static.
The user selects which of the releases pertains to their project and then based on their selections, new records would be created in tbl_RFP_Release and then a subsequent form would open where it would display each of these newly created releases where they could enter additional information. I thought of creating an unbound checkbox associated with each of the standard names, and then checking to see if the checkbox was checked and then creating the new records followed by opening up the new form.
We have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she needs to edit one.
We have received a request from users for a functionality which allows users to browse all records, using the main form layout, that they have keyed in. I guess what I am asking is: Is there a way to limit the records visible in a form using field on that same form as a limitation (ie. the users name - which is a required key-in)?
I am building a Form based on 3 Tables. Each with primary keys, although two tables do not relate to one another, and I am using one table to be the link within both of them, which has both of the primary key fields within it.
The issue is that I am building this form and in the control source I am building this query to pull the information for the form, which I was hoping will allow me to add new records (Not Working ). I am also attempting to accomplish that when I integrate a field from one of these tables into the form (the table that does not relate to it at all, other than through the linked table) that it will show the fields relating primary key in a transparent text box. This field I am integrating will be disabled for editing (like transparent), but will show up when the corresponding field (primary key) populates with the appropriate number.
The Fields in the pictures on the form that are dimmed are the fields that will not be enabled, but once I do this it does not allow me to enter New Records .Here is the SQL:
SELECT TblSupplierTests.*, TblCreamReceiptsScaleWeights.LoadID, TblLOLCreamTests.BFTestForSettle, TblLOLCreamTests.SNFTestForSettle, TblCreamReceiptsScaleWeights.RecievedDate, TblCreamReceiptsScaleWeights.SupplierLBS AS SupplierLBS_TblCreamReceiptsScaleWeights
FROM TblLOLCreamTests RIGHT JOIN (TblSupplierTests LEFT JOIN TblCreamReceiptsScaleWeights ON TblSupplierTests.BOLID = TblCreamReceiptsScaleWeights.BillOfLadingID) ON TblLOLCreamTests.SO = TblCreamReceiptsScaleWeights.LoadID;
I want to create a form in MS access for General Journal input for an accounting software. Problem is that my client required a form in which he can input as many Debits and/or credits as he likes, for one transaction on one form. For example it may be 2 debits and 4 Credits in one transaction. Its a simple one table entry with fields; TrNo (Transaction Number), Date, Type (Debit or Credit), Amount, and Narration (for details of transaction). Out of these field TrNo, Date & Narration will be same for all debits & credits in one transaction.
View 9 Replies View RelatedOnce I enter records in my form and move to a new record, they won't show up in the form. For some reason there are a few records showing in the form but not all. Unsure what has happened or what I need to do to get the records showing.
If I open a the form called frmhome, I can enter information search on hours completed and even enter new towns. The table that the information gets entered into is called Crisis_support_workers. If you open this table, you will see a lot of information that has been entered. However, if you open the form that is meant to put info into that table, there is only 7 records and most of them are blank records. The form where info is entered is called Crisis_support_workers v3.
I have a form where users can look through different records as well as add a new record through a control button. When a new record is added, all the relevant data should end up in the corresponding back end tables.
The problem I am having is that some of the new records I am adding work perfectly (sync with the tables, etc). Other records, however, are showing up in the tables but not in the actual form. For example, when I attempt to search in the form for the record name, nothing comes up.
The Datasheet View is set to No, so it's definitely not that. I'm not really sure where else to look - the new records appear in tables and the report I have linked to the form, they just don't all show up in the actual form!
Basically I have a table where freelancers have multiple records for each module they teach. What I am trying to do is show all records for each person onto the same form, but anything I have followed still only brings up the first record.
This information is all on the same table, so would this be easier to be on separate tables to then create relationships?
I am putting together a database in access 2013.
I need to put in a form which basically lists all the clients names, with a button next door to each name, allowing them to edit their details. Is this possible.
Basically when loading the form, all client names are displayed in alphabetical order. Clicking on the edit button next door to the client, displays the client details in another form for easy editing. How can I do this .
Just a general query about the best approach to take for an editing form.
I want to have two separate forms, one for adding a new record (have completed this) and one for choosing and then editing a selected record.
I have seen that people use combo boxes to display a list of records with fields. This seems quite difficult to use. Maybe that's the best way though?
How do you apply an edit button to a selected record in this type of situation? I suppose really I need a box that has a list of records with a little edit button next to each one, or can I do something that launches the edit form as soon as you click on a specific record?
I've created simple data base with 2 connected table with relationship one to many, then I have built the querry based on those 2 table and then I have done the form based on this querry, so there are fields from those 2 tables in the form.
When I try to fill in the fields with information I get error message:
"You can not add record (records); missing foreign key in the table"
When I checked relationship property window everything seems to be ok.
I have a main form with a sub form.
I cannot enter new records into the sub form! Only existing records are displayed.
If I open the record source of the sub form, I can enter new records
The subform's Allow additions, deletions & Edits are all "Yes"
I start with a table of UserIDs, names and roles (tblUserIDList). I have a simple query off that which lists them in alpha order by UserID. Next I have a simple form with a combo box which uses that query to select the User and binds the UserID field to use.
There is a button which triggers a macro which opens the 2nd form using a query which filters using that UserID. There is another point in that form in which that UserID is again used as a filter for other data. The 2nd form is a data input form. All works fine up to that point.
However, when the 2 forms are closed, for some reason the UserID is re-added to the tblUserIDList. I've never had this happen before.
I have several forms in a navigation form. On all the forms, the little search bar at the bottom shows # of 103 records. On my navigation form it shows 1 of 1 and won't allow me to search.It would seem that the search bar is only looking at the current form and not at the records.
View 1 Replies View RelatedI have a database that it has 2 forms. Form 1 shows list of received letters Form 2 shows list of send letters Now database has been splitted and back end is on the shared drive and front end there is on each computer and myself and other users have read/write access to the shared drive and me and other users can see all the records. .Now I would like to add something like a check box field to the forms. When I tick the check box for each record other users cannot see that record on the form.
View 1 Replies View RelatedI have a form where you enter a Case number (Primary key) and EmployeeID (foreign Key), the employeeID must match a employeeID held in the employee table. Within this Case form, I have a subform called Account which has an autonumber Primary key called accountID. Each of these accounts will have a questionnaire. So I created the questions in the same table (account). So Q1, Q2, Q3 etc. which are Questions relating to each AccountID, one accountID can have one questionnaire.
What is working fine is I can enter an account NUMBER which is a field in my account table (which creates a new AccountID(autonumber)) and can happily check the checkbox, fill out the text fields move to the next record and the checkbox is unticked and text boxes are blank (default state) which is great as I want them to ready for new input (new accountnumber/id).
My problem is assume I create my very first account number which would be say AccountID(0), I want all textboxes for the three questions disabled until the checkbox is ticked. So thats ok, I can put the default value of chkbox to FALSE, and in VBA I can do the on_checkbox_click, if chkbox.value = true then textbox1.enabled = true else textbox1.enabled = false. I can do that for the other two textboxes in the Chkbox click event.
When I Tick the checkbox it enables the textboxes, which is good, but when I create/move to the next record, instead of these textboxes being disabled as default, they are enabled because i ticked the chkbox for the first record. I dont want the manipulation of one AccountsIDs questionnaire to affects the other records. If I add an unbound textbox which I want to display a message if the chkbox is ticked, then if I tick it on one record, it has the displayed message on all records. How can this be if each questionnaire is independently i.e each questionnaire is for ONE accountID.
It seems the textboxes etc are not unique to each accountID but they should be because they are in the Account table and when I enter values and use the checkboxes without doing the disabling or showing a textbox comment, they are separate and work great, but when I use my code to manipulate the flow of a questionnaire for each account i.e enabling textbox/showing textbox comment, it changes the formatting on the other records questionnaire which I don't want as each questionnaire will be different, so a chkbox may enable a question on one ID but not on another as it wont be relevant, so at the moment I only have ONE truly working questionnaire which works for ONE account , but I want it to work uniquely for each account.
How to sort entered records in a subform by combo box. Notice combo box has integer value not text. I want to bo sroted by text visibled ASC. The code must be in Command control SORT (See pict enclosed)
View 2 Replies View RelatedI created a split form. My main form is just a form, based off of tblBlotter. The subform is based off a query, which is the based off the same tblBlotter. (Not sure if this is proper - maybe I just need the table?)
I have a link master and link child field set to ID. When I open the form "subBlotterHistory", it opens and shows as a new record only. I want it to show ALL records on the query subform and be able to scroll up, down and edit.
Attached is a sample w bogus data.
I have created several tables, and also created forms associated with each of them. In every case, the primary key is the first column of the table, and it is autonumbered starting from 1. Every table is sorted by that first column.
In most cases, when I bring up the form that is associated with the table in Form View, as I sequence through the records using the buttons at the bottom of the screen, the records sequence in the order of the autonumbered primary key in the order you would expect (1,2,3,etc)
However, on one form, when I do the same thing, the records sequence through in a different order. When it shows "1 of 21" at the bottom, it is displaying record number 8. "2 of 21" displays record number 13, and so on.
I have doublechecked to see that the associated table is actually sorted properly and it is. I've gone to the Property Sheet in Design view, but I don't see anything that would control the sequence order.
I'm working on a database for residents at a care home. I've just started and I want to automate a process where I can click a button and see the contact details of a GP. It's all working but I want it to be that if the resident has no GP it will open a form so you can choose a GP. I have a message box to tell the that the resident has no GP and it takes them to the relevant form but I need it to be based on the correct residents ID and it is not. I have the code running on form load. I have attached a zipped version of the database (it is safe I promise)
View 5 Replies View RelatedI am trying to display a table records on the form with this code:
Private Sub Form_Load()
Dim rs As DAO.Recordset
Dim str As String
On Error GoTo Err_cmd_vimport_Click
'defining the form recordset
[Code] ...
Err_cmd_vimport_Click:
MsgBox "Error No: " & Err.Number & "; Description: " & Err.Description
Resume Exit_cmd_vimport_Click
End Sub
however i could not be able get any results in the form as if the debugging is not showing an error.
Im trying to prevent duplicate records based on a PO # (RA_PO_Nbr), entered from a form. I'm trying to throw a 3022 error when the user attempts to enter a record that already exists, but I dont necessarily have to do it this way.
Code:
Private Sub cmdSubmit_Click()
On Error GoTo cmdSubmit_Click_Error
Dim db As Database
Dim rst As DAO.Recordset
Dim strSQL As String
strSQL = "CompanyPOTable"
[code]....
I'm working pro bono on an Access db system for a wildlife hospital. We need to be able to record from the system how many patients (animals) we have every night. We have a form that shows the number of animals in-house as we admit and discharge animals, but I need to be able to record the result of the form's Count() function in a Table whenever we open the "In-house" Form. I want to have a Table showing the time the Form was opened (easy!) and the number of patients then in-house. But recording the Count function always produces 0 of course. I need a function that will record (when the form is opened) the number that the Count() function shows!
View 11 Replies View Related