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.
I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.
Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.
I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.
In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.
In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.
I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.
So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?
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.
To display images on a form (Access 2003) I used the same code of the Northwind database sample (Form Emplyees).
when changing the Picture's location it returns a bug in the code (Couldn' open ...the file), or the ErrorMessage Label should have the value: "File not Found".
Here is the code:
Private Sub Form_Current() Dim res As Boolean Dim fName As String Path = CurrentProject.Path On Error Resume Next ErrorMsg.Visible = False If Not IsNull(Me![ProductPicture]) Then res = IsRelative(Me![ProductPicture]) fName = Me![ImagePath] If (res = True) Then fName = Path & "" & fName End If Debug.Print "fName: " & fName Me![ImageFrame].Picture = fName showImageFrame Me.PaintPalette = Me![ImageFrame].ObjectPalette If (Me![ImageFrame].Picture <> fName) Then hideImageFrame ErrorMsg.Caption = "File not Found" ErrorMsg.Visible = True End If Else hideImageFrame ErrorMsg.Caption = "Click on Add/Edit to add the Product Picture" ErrorMsg.Visible = True End If
End Sub
Function IsRelative(fName As String) As Boolean IsRelative = (InStr(1, fName, ":") = 0) And (InStr(1, fName, "") = 0) End Function #
To start off I have only been working in Access(2003) for the past 2 months. And Yes I am a neebie of all neebies but please read on.
What I am trying to do is for every record I need to associate multiple pictures of damages to items in for repair. For example I have an High end Amplifier that came in for repair and the outside has markings of a fire(thats one pix) then opening it up we see that the fuses, wires and PC board has fire marks also(pix two) and so on. The record is keyed to the serial number. On the form my fields are Serial number, RMA #, all the senders info (name,address, contact number, store purchased, etc.). Then I created a subform for the picture with the following the picture itself, buttons(previous, next, add pic, delete pic) a hiden textbox(serial number) that I have joined(relationship) to the major form(serial number). How do I link the pic to that specific serial number and then other pictures that also link to that serial number.
I know its wordy but I wanted to make it as clear as I could.
I made a db with tons of forms and they all have pictures on. I want to know if there is a quick way to embed them all so I don't have to go in the settings of every picture and do it manually!
I'm trying to place a picture on my forms using a browse button code i found on the net. After picking a picture, the image won't display automatically during run time, i still need to select design view and finally form view just to display the image. Im using the events form current, and the text box afterupdate.
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.
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"):
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
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.
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!!
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.
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.
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)
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.
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:
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 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?
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?
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...
I have scanned through the forum but have not found an answer for the above..
How do I do a requery only for the combo box of a particular record in a continuous form? To be brief...the user has to select the pimary sector for a project . After, this, I want the next field to show up all sub-sectors based on the value selected in the previous primary sector combo box.
When I do a requery using the following code,
Me.cboDACCode.Requery
all the records in the form get requeried.
All the field are bound field.
There was a similar post in the form but was not complete.