Is This Possible - Continuous Report / Form
Jul 26, 2005
Ok, first post here and a bit of a novice so don't shout at me
I have a table called TblStored which contains hundreds of records. Within it is a field called VrcID. This field is made up of a combination of numbers and letters ie 81/28193GK. Each one is unique.
What I would like to do is produce this field in one continuous format, one after another with a coma inbetween. So if I have 600 records it will produce something like
81/281937K,84/1937K,92/28197H,81/28193HJ,87/281937G and so on.............until it reached the 600th
My ultimate aim is to get it onto a report (boring reading I know but their is a reason) but a form will do.
Is this possible, Can anyone help with this
Cheers in anticipation
View Replies
ADVERTISEMENT
Mar 7, 2006
I've been trying to get my head round this one , but i'm just to thick to get it.
I have a continuous form that lists all items at a certain location.
The user selects a record by clicking on the record selector and then clicks on a command button with this code:
stDocName = "DivingInspectionCert"
stLinkCriteria = ("EquipmentID = " & Me!EquipmentID)
DoCmd.OpenForm stDocName, , , stLinkCriteria
The user then enters inspection details in to the "DivingInspectionCert" form which i want to store in a table (DivingCert) which will relate to the item. On completion of this form the user then clicks on a command button with this code:
DoCmd.RunCommand acCmdSaveRecord
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "There are no items to Print", vbInformation, "EquiTrac"
End
Else
DoCmd.OpenReport "DivingInspectionRpt", , , ("EquipmentID = " & Me!EquipmentID)
DoCmd.Close
When i click on this button, the report doesn't print and i get a message "No current record".
The inspection details are not stored in the table.
I did have the forms RecordSource based on the table "DivingCert" but that didn't work and i have just tried a query but it is still not working.
Would be much appreciated if you can help me.
Thank you
View 3 Replies
View Related
Mar 12, 2014
I have some images stored in a SQL Table which is linked into Access. These images have to be stored in the database as I also reference them on other platforms (Android, Web etc).
In my Access programme I need to display a continuous form / report showing each image. Now, good old Access cannot display multiple images stored in the database on a continuous form. It can only do this if it is referencing the path to the image.
When the user views the form they will only see about 12 images at a time. I thought of a workaround which is to write the database images back to file to a local temp directory when the user loads the form. The user would be happy to wait for say 10 to 15 seconds whilst the form loads.
However, I cannot find an efficient algorithm to write the images back to a file. The one I am using is a BinarytoString algorithm by motobit which is fine for very small images, but anything over 100kb (which is still pretty small) it goes sooooo slow.
How to quickly write an image stored as a long binary in an Access DB back to a file? Or do I need to crack open my Visual Studio and write some C# DLL to use instead...?
View 1 Replies
View Related
Jul 1, 2014
The database I have created is to produce product description sheets. From the switchboard, the user clicks a button that opens a form on which they can enter about 5 bits of information , then select the product they wish to produce the product sheet for and when they click a button, the product sheet is produced. The product sheet is a report with a subreport. The information entered on the form is included with more information from the database on the main report and the subreport is based on a union query which combines information from 2 tables to list the items included in this product. (the information the user inputs into the form is information that changes depending on the situation and is not stored in the database.
Now comes the next step in this process. Just as the information input into the form is temporary information, there is also one bit of information that needs to be input on a temporary bases for the items that are listed on the subreport. Each of the items on this subreport needs an assignment of AAA or BBB that needs to appear in the subreport on the line with that particular item. There can be one item in an product, or there can be many and the listing of AAA or BBB can be different from one item to the next or they could all be the same. The assignment needs to be made on an item basis.
My thoughts on this were to have a subform appear once the user selects the product on the form which would list all of the items and allow them to select either AAA or BBB in a column on this form. Then when the click to open the report, those assignments would carry through to the report.I have been able to create a continuous form displaying all of the items based on the union query but that's as far as I can get. Not even sure if that is the way to go.
Is there a way to reference the AAA and BBB input on the subform I described so that it displays in the report.
View 7 Replies
View Related
Aug 9, 2005
What I am trying to do is put a subform within a subform. The trouble is I want both forms to be continuous forms.
when I put the subform within a subform, access comes up with the following message:
************************************************** ********************
A form with a subform object cannot have its DefaultView set to Continuous forms.
You tried to add a subform to a form in design view.
MSAcess will reset the property to Single Form.
************************************************** *********************
which it does my higher level form becomes a form only showing single records at a time whilst the subform is a continuous form.
does anyone know of a way around this?
what about Access2003 does it allow this?
help much appreciated.
Steve Ferry
View 8 Replies
View Related
Feb 26, 2015
For the report in question all data is taken from one table named "Completions ". The fields I will be using are as follows:
Code:
[Surname]
[Firstname]
[Branch]
[Quarter1_A]
[Quarter1_T]
When the records are added, the Branch is added using a combo box. There can be several rows of data with the same Firstname and Surname but with different Branches.The report layout must look something like this.I have tried using DLookup to select the data based on the data in the Name text box, but this just gets the first result and duplicates it.
View 2 Replies
View Related
Nov 2, 2013
I have a command button as a field in a continuous subform which is based on a table. I click it and it opens a report. I need the report to be filtered by the ID of said record and not to show all the records.
View 3 Replies
View Related
Sep 5, 2013
I have a form called GetdataFrm. Within it i have a combo box that filter a query. When the combo filters, it populates a continuous subform called GetDataQrysubform. GetDataQrysubform look like a table that contains this Jobcode information:
EmployeeID Jobcode CardAccess Folders Software
When I filter the GetDataFrm form, I want to be able to click on a Employee's EmployeeID number from a single record in GetDataQrysubform and then a form called SingleRefrm would pop up taking me to that record.So far I have a event procedure coded to open up SingleRefrm, when the EmployeeID field is clicked but its not working. The code looks like this:
Code:
DoCmd.OpenForm "SingleRefrm", acNormal, , "EmployeeID = '" & Me.EmployeeID & "'"
View 9 Replies
View Related
Jul 23, 2013
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function
Public Function Sort_1(SortName As String, FieldName1 As String)
DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'"
End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
View 4 Replies
View Related
Jul 30, 2014
I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.
At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.
continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"
pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"
This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):
1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid
2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid
3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria
4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub
View 9 Replies
View Related
Oct 4, 2013
I have a continuous form that displays all my customers .I want to be able to dble click a customers ID and go to there customer details form.
View 14 Replies
View Related
Aug 22, 2014
How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?
In other words, how to auto populate the primary key to multiple records displayed the subform?
View 5 Replies
View Related
Aug 17, 2007
I have a continuous form bound to a recordset that has the following fields:
- Ignore: Boolean
- OverTime: Boolean
- AnnualLeave:Boolean
-ExtraValue: Double
The Ignore, OverTime, AnnualLeave fields are bound to a I, O, A checkboxes respectively in this continuous form. The ExtraValue bound to a EV textbox in this form.
What I want is that when the user check O or A checkboxes, the EV textbox is enabled only for this form record NOT all the form records, when the user check I checkbox, the EV textbox is disabled only for this from record, NOT all the form records.
The problem is that whenver the user check, all the form records EV text box is affected by this action.
Is there any way to achieve this?
View 2 Replies
View Related
Mar 31, 2005
I have a continuous form which I have placed a unbound text box. For some reason when I place a value in the box it duplicates the value in all the correponding records! Any ideas why!!
View 1 Replies
View Related
Aug 27, 2006
Hi, thanks.
View 1 Replies
View Related
Jun 19, 2005
The problem is that I have a recordset Rosters.
Fields are ShftDay, A, B, C
The ShftDay is distinct field.
I have continuous form mapped to this recordser.
This continuous form have 4 text boxes, each is mapped to one of the recordset fields.
The user can edit these fields.
What I want to do is when the user enter the value "Na" in one of A,B or C textbox, I want the backcolor property of this textbox to become pink.
What I face is that for example if I enter the "Na" value in the A textbox, all the cells of the A textbox are converted to pink. What I want is only the cell in the edited record, not all.
Please Help Me.
View 3 Replies
View Related
Aug 18, 2005
I have a subform in continuous mode which has a list of people. I have created an unbound field which has a dlookup into a telephone number table.
What I want to happen is for each person in the list to have their telephone number displayed (not recorded - just displayed) on the form alongside their name. On a single form this works fine, but on a continuous form it displays the same phone number on all the rows (presumably the first person in the lists number).
Can anybody advise how I can get the dlookup working for each record in the continous form.
Thanks in advance,
Adam.
View 14 Replies
View Related
Apr 19, 2007
Thanks for reading another one...
I am building an application for my marketing dept. that will track their mailouts. So far I can handle it; however, they want a thumbnail displayed of each piece of creative. I can do this if they only wanted to see one record at a time, but they want all records w/in a certain date range and the pic that goes with it. I am currently storing the path to the image so not to gorge my db to explosion.
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
pic campaign_name start end mail_out #_pieces
where pic is the thumbnail. I have built it with a continuous form so I can display all the records but I am up to change if needed.
I have read other posts and they all deal with single forms and the onCurrent event is not really working for me.
Any and all help is greatly appreciated!
View 10 Replies
View Related
Feb 10, 2005
Hi All - It must be the early hour or something, my brain is dead.
I have a continuous form of Pharmacy items that belong to a specific customer. At the end of each row I have a TickBox.
I have a button that prints a report on the form and when it prints the report I want the TickBoxes to then be ticked automatically. When I put the code
Me.Tickbox = -1
it just ticks the first item and not all the tickboxes.
How can I get it to do the rest? (I have searched but found nothing yet of help)
Col
View 1 Replies
View Related
Feb 16, 2005
I have a continuous form setup that has a check box field (Yes / No) I also have a command buttom to preview data. How can I code the command button for each record so that is the check box = No then the command button is not visible. I had code in the on open but it seem to either make the command button visible for all records on invisible for all.
Jim
View 5 Replies
View Related
Mar 22, 2005
I have a continuous form, which is used as a sub form in a main form. How can i put some code on a control which will work only, if the focus is on the last record (the event i would like to use is onKeyDown). I have tried using:
if Me.CurrentRecord = acLast Then ....
but to no avail.
Any suggestions please ?
Thank You
View 6 Replies
View Related
Apr 4, 2005
I am going to retype this as perhaps my original explanation was too wordy.
I need to display data from 2 tables in a continuous form. Sure I can do this with a query and a join, but the user needs to be able to add records to the form as well. When adding a new record, only one field need be entered (actually selected from a combo box) and the other 2 fields would auto-fill based on the selection.
Is this even possible?
View 5 Replies
View Related
Jun 2, 2005
Is there a way I can requery a continuous form. Basically my form runs from a query. If when certain criteria become true I want that record to move to a different form, (working on another query) Basically I am saying is that if checkbox1 = true then I want to hide that record. Does that make sense?
View 2 Replies
View Related
Jun 28, 2005
Hi,
On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?
Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?
Mant thanks, in advance.
Lampy
View 3 Replies
View Related
Aug 11, 2005
I have a list on a continuous form which goes like this:
1 adsf
1 qwer
-----------------
2 sdfg
2 rzrzur
2 gjkghjk
2 nmfhj
-----------------
3 sdfgrtwe
3 wrtwret
I would like to have a line appearing under each category. Is it possible to do?
Thanks for the help.
SWK
View 4 Replies
View Related
Oct 4, 2005
Hi everyone.
I've searched the forum, couldn't find an answer. Is it possible to give each record in a continuous form a different backgroundcolor?
For example:
--------------------------------------------
Record 1 has a light yellow bgcolor
--------------------------------------------
Record 2 has a light blue bgcolor
--------------------------------------------
Record 3 has a light yellow bgcolor
--------------------------------------------
Record 4 has a light blue bgcolor
--------------------------------------------
And so on...
Thanks in advance!
Seth
View 3 Replies
View Related
