Adding Records To Filtered Form.
Nov 1, 2005
Ok heres the problem, i seem to have a little bit of a mind block at the moment so help would be greratly appreciated.
Basically there are two tables involved, tblBikes (which contains all information on the bikes) and tblHires (which contains all the information about hired bikes) these are linked with a one to many relationship as each bike can be hired out many times.
I have a button on a form containing bike information which opens the hires form filtered by the bike ID of the record selected in the first form. When I add a record to the hires form i need the bikeID to be automatically input into the field.
View Replies
ADVERTISEMENT
Jan 22, 2006
I have a db with a form showing all customers with communication checkbox checked, I want a button which uncheckes all chackboxes.. all I have now is a button which uncheckes the first record.. anyone an idea?
:confused:
View 3 Replies
View Related
Oct 17, 2006
This sounds like a cascading combo box issue but it isn't quite.
I filter my form using 2 unbound combo boxes which can be used in any order, both of which define text strings using case select. These strings are concatenated into a filter text and applied by a routine called in the after update event of either combo. All works well.
My question: How can I show all the filtered records in a third combo box so that users can easily select the record of interest from the filtered set?
I attempted to define SQL for each combination of the 2 comboboxes but it was getting ludicrously complicated so that got the heave ho.
After that, I attempted to use a recordset clone, but I couldn't get this to work:
'Clone record set for combo box rowsource
Dim R As Recordset
Set R = Me.RecordsetClone
R.Bookmark = Me.Bookmark
'Populate combo box with recordset
With Me![cboProjectList]
.RowSource = R
.Requery
End With
Reading the Access help, it seems that a combo box can only be populted via query, table or SQL. Is there any way of using a cloned recordset or the me.filter to show the filtered form records in a combo or list box?
I will be very grateful for any pointers.
View 8 Replies
View Related
Oct 23, 2014
I want a form which allows data entry into a main table but also displays a list of records filtered from the same table. There is also an additional, calculated field displayed with the list.
The filter criteria are a date and a name, a list of which are in a separate table.They are separate fields for first and last name but i would like to filter with both and display them concatenated in the list.
View 6 Replies
View Related
Sep 13, 2013
I have a form that displays records from a table.
When opened it displays all records (no selection yet).
I put would like to put 2 buttons to filter records (Male/Female).
I'm thinking of 2 possible options:
1-on click run a script that will close current form, then reopen it with selection criteria
2-directly apply a filter on the current form that would automatically refresh itself with the right records
Another (heavy, inelegant?) solution would be to create duplicates of this form. they would be loaded from separate queries that select the right records in either choice.
View 4 Replies
View Related
Sep 15, 2005
i've created a form base on a query, and other users will work on it (mainly filter). then i created a report base on the same query...
what i want is a "print" button on the form which will print the report, not all records, but only the filtered records after user applied their filters...
since users will apply different filters each time, it's quite impossible to make all different filters as query...
any idea?
View 12 Replies
View Related
Aug 31, 2005
I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables.
This is an attendance database with tables for each month. So when a new member of staff joins and there record is added for that particular month I would like it to be added to all subsequent tables as well. Is there a way of doing this. It would also be beneficial if a similar thing could be done for deleting staff (i.e. a staff member is deleted from one table and subsequently is removed from the other tables)
Any help with this would be greatly appreciated
View 4 Replies
View Related
Aug 31, 2005
I have set up an attendance database with tables for each month. Each of these tables has its corresponding form. I want to be able to add a command button onto the forms to add a new record. Obviously this is easily done using the wizard but my problem is I want it to be added over a number of tables.
For instance when a new member of staff arrives and is added to the database I want there record to be added over all the subsequent tables not just the one attached to the current form. It would also be beneficial if I could do the same for deleting staff (ie someone leaves they are deleted off the current table and all other tables)
Is there a way of doing this.
Any help would be greatly appreciated
View 7 Replies
View Related
Mar 28, 2006
Hey everyone... got a little problem, i have the followinf form/subform setup show in the screenshot below, for ages the calendar conrol there has worked fine, its control source is the date field on the left habd side.
Now however, it doesnt work, or rather it works when your editing old records, it changes the dates fine, but when you go to enter a new record in, you cannot use the calendar, it just makes the windows error sound at me. And i cant type the date in either, and i cant type into any of the other fields either, but i can edit the old ones fine....
Of course i can just go into the original table that the form runs off and type new data in there, but thats not the point, i need to be able to use this form. It worked before, but i opened it today and its screwed sideways, lol
any help from anyon would be great, dragon
PIC:
http://img381.imageshack.us/img381/8988/accesserror3oc.jpg
View 6 Replies
View Related
May 4, 2006
uh.. I guess the title pretty much sums it up... Is there a way to enter data in a text box or something once, and have it applied to all the filtered records?
I have it set up so that we can sort by project number, and it displays only the invoices that havent been assigned to a bill (we recover the expenses form our parent company). I dont want to have to enter the same bill number to each of the filtered records individually.
Thanks
View 1 Replies
View Related
Oct 19, 2006
How do I calculate a filtered total from a field in a subform. It needs to be filtered according to [agreementID] and I would like to total the records in another field.
[agreementID] [assessment]
01-pmg18 $20,000
01-pmg18 $15,000
02-pmg18 $13,000
02-pmg18 $21,000
eg: I would like the total assessment for all 01-pmg18's and the total for all 02-pmg18 etc. Can I automate this so it recognizes and totals all assessments according to each unique agreement id group. Customers can have many 'batches" of agreementID's belonging to him. The 18 also refers to his ID number it is typed in. Thanking you in advance!
View 1 Replies
View Related
Sep 3, 2013
I select records from a table based on criteria:
< Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SELECT * FROM [tblLVRWrittenStatements] WHERE [tblLVRWrittenStatements].[seedrsID] = " & seedrsIDVar & "") >
I now want to append these filtered records to another table called ArchivedWrittenStatementsTable;
< CurrentDb.Execute "INSERT INTO [ArchivedWrittenStatementsTable] SELECT * FROM rst" >
Would be lovely except rst not recognised. Is there a way of achieving this without having to <addnew etc > looping through the records.
View 1 Replies
View Related
Apr 11, 2006
I am new to Access and have the following problem. I have one table which displays Skills (memo field) a second table which displays a skill rating ( 5 choices) and a third table which list the jobs in the company. I need to compile a fourth table which lists the skills required for each job and the corresponding ratings. I would like to have a Form in which I select the job and all 560 skills are displayed in datasheet format and I can select the ones required and allocate a skill rating. The results should then be saved to the new Table.
Any ideas as to how to acheive this task.
View 2 Replies
View Related
Sep 2, 2005
Hello, here is my problem:
I have a form to add records to my table. I cant bound it, because the controls are tick boxes, and they need to be "converted" into text to add them to my table.
I have a save button, so I can execute an insert statement with all the data I want to add to the table.
The problem is, once I have saved the record, I want to clear the form to add a new record, and I cannot use a docmd.gotorecord acnext as it is an unbound form.
Is there any way to clean a form without going control by control?
Thanks!
Cristina
View 1 Replies
View Related
Oct 12, 2006
I have a form "release_details" having fields date, version, cksum ,comments,labels, and is link to a table,
it has a button "mai"l ,on clicking this button a new form is open which has a button "send mail" on clicking this a mail is sent and pops a message "mail sent".I need when "send mail" is click it should also save the fields of form
"release_details" to the table.
cmdSend_Click()
Forms!Enter_Release_details.Dirty = False
View 3 Replies
View Related
Apr 10, 2015
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.
View 7 Replies
View Related
Aug 3, 2015
I am currently developing a crude Contact manager database and need a quick way of entering data into a selection of records (around 1000 at a time). At the moment I am manually going through all records and changing the "DateLastEmail" field manually, which can be very tiring.
Any way to assign a button to change the field for all records to today's date or something of the like.
Currently I have a form which filters my subform. The subform resides as a seperate query and when the "Apply Filter" button is pressed it requeries with a change of .filter property, so I guess that all that needs to be done is to change all records that exist within the query, but I am stuck on a way to do this without manually entering it.
View 3 Replies
View Related
Sep 11, 2013
The table has PK and city column can be one of several. I need to create a filtered datasheet view (few columns only).
Since there are quite a few cities, I need to select one to display all the records in that city. My questions
Since it is a datasheet view I cannot use Combo Box. What to do then ?
If I use subform with a combo box, and bind the query in the subform with the selected combo text, it does not work.
here is the subform query
SELECT tblClient.ClientName, tblClient.HqCity FROM tblClient WHERE (((tblClient.HqCity)=[Forms]![frmSearchCity]![cboCity]));
I get nothing.....
View 8 Replies
View Related
Jan 9, 2014
I have a form with a subform. In the form header I have combo boxes for the user to filter data. I want to add a button that they would click to export the filtered records to a table. I have the following code and get the message that records were exported successfully but when I open the table they are not there. I don't get any errors when I compile the code but I also don't get any results in the immediate window either.
Code:
Private Sub cmdAddToTable_Click()
'Dim tmpRS As DAO.Recordset
'Dim tmpSQL As String
[code]...
View 3 Replies
View Related
Nov 24, 2006
Hi guys and girls,
I'm fairly new to Access and I'd appreciate some help. I've built a form with buttons to open new forms for that specific record (based on queries as all the data is held in a single table). This works fine until I try to add new records. At the moment the only way I can make this work is to add the new record, shut the original form before re-opening it and proceeding on to the other sections (via the buttons I mentioned).
If anyone could tell me how to get Access to save the record before it opens the other forms I'd really appreciate it.
Cheers,
Franny.
View 2 Replies
View Related
Sep 20, 2004
OK I'm totally lost again.
What I want to do is;
Use one form to add records into several tables.
I have seperated my data into seperate tables and set up one to many relationships.
tblincident
--------------
Key#
Report#
Time
Date
Location
tblPerson
----------------
Key#
Last Name
First Name
Middle Name
Address
etc.
tblItem
----------------
Key#
Make
Model
Serial#
etc.
What i want to do is use one form to enter all this data into the different tables.
There can only be one record in tblIncident that can match multiple records in the other tables.
i.e. for each record in tblIncident, I want to be able to have the capability to have as many persons related to that incident as I need.
I was thinking about setting up a tabctl for the data that has to be entered for tblIncident and then change the property setting for it to go away and then have the next tabctl appear in it's place for entering data into the next table. The problem I am having is that apparently I can only have one table as the control source for the form.
So next I tried using subforms, but that isn't working either. I can't figure out how to make the subform appear in a specific place on my form, sized in specific dimensions I want where I want.
I am just starting to learn about this relationships stuff and it's kind of difficult. How do you make it where you can do this from one form? Do I need to make a query of some sort?
Any help is appreciated.
View 1 Replies
View Related
Nov 18, 2004
Hi forum, I have this database with a main form and 5 subfoms. For the Address Subform, I need to add multiple addresses for each person I add. How we currently do it is enter the multiple addresses per person, one at a time. Is there an easier way to do this.
For eg: Id Last Name First Name
Then Address 1
Address 2
Address 3
View 1 Replies
View Related
Sep 12, 2013
I have created a piece of code that filters a sub form of diary records using criteria the user has selected or entered. It was working fine when I made it a month or so ago and now is seems to be returning incorrectly filtered records, for example, I enter 2 dates to return all diary entries between the 2 dates. Yet it misses some records out that should be within the date range, and it sometimes include records that are outside the date range. I am also getting an error when I try and filter the diary entries via the supplier, "data type mismatch", here's the code that, bearing in mind, was previously working fine.
Code:
Public Function filter_diary()
Dim dbs As Database
'Dim qdf As QueryDef
Dim Sqlstr As String
Dim sqlstrwhat As String
[code]....
View 1 Replies
View Related
Apr 22, 2013
i have an unbound form with the following code which works as it should
Code:
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("tbl_Courses", dbOpenDynaset)
With rst
.AddNew
rst!DateCreated = DateCreated
rst!Originator = Originator
[code]....
I also need to add other text fields from the unbound form to another table but can't seem to work out how to do it.
View 6 Replies
View Related
Jun 28, 2013
I want whenever I'm updating or adding records to my form, the ID automatically take the value of the previous ID and increment it by 1.
The field type is text (mixed with number) - PM0000000.
I've done some research, what I understand is that I need to:
-do a lookup and
-find the MAX of the number portion.
Name of form - Payment
Name of table - Payment
Name of field - payment_id
I tried these, but to no avail...
Private Sub payment_id_Click()
payment_id = DLookup(("[payment_id]", "Payment", "[payment_id]=Forms![Payment]![payment_id]-1")payment_id + 1)
End Sub
[Code] .....
View 8 Replies
View Related
Sep 12, 2013
I have an existing Main form that has a sub form that the user uses to enter multiple records into a table....it works fine EXCEPT that I need to make it even easier and more intuitive and add a lot of labels. Basically the user selects items from a drop down list that adds items to a Work Order. I need to add some labels to the form to make it more descriptive for the user.
So, what I want to add multiple records using a single main form.
Is is possible to?:
1. simply turn the subform into a single main form? Can this be done by using a Command button or something similar?
2. copy all of the controls etc from the sub form into a new main form and have it all work nicely?
View 2 Replies
View Related
