Recent content by deagio

Hi, I've made a form with conditional combo boxes, based on the selection in the second combo box an address appears in 4 list boxes, but the problem is, they arnt saved to the record type on exiting the form. Any ideas how to make the contents of the list box save to a field on exit? Here is...

Hi, I've found several scripts to make images appear in reports from external sources where the address of the image is stored in a field on the report. (Pg. 1, Sample Databases) However, as the address fir the image is on the web, i keep getting an error message 'Access cannot open the file...

Solution! Hi, Just to let you know i managed to fix this problem with the following code: Private Sub CommandPNT_Click() Dim stDocName As String On Error GoTo Err_CommandPNT_Click DoCmd.RunCommand acCmdSaveRecord stDocName = "repInvFrm" 'DoCmd.OpenReport stDocName, acViewPreview, ...

Hi Hi, I've been through the table design and there is no sign of any OLE object types and i also had a look on the server and it appears there is no way to convert this field to an OLE object type. If anyone could help with this enigma it would be great! Thanks, James

Hi, I'm trying to make a button to link my form to a report, but I keep getting the error 'Invalid Column Name: FieldContents'. I cant see why this error would be occuring, the field exists in both the report and the form. Here is the code I used to link the two, I am using the datase with...

Hi Hi, Thanks for the tip, I've just had a try at making it an OLE object and i cant find how to do it, is there a special way to do it? I'm using access 2003. Thanks! James

Text box Hi, It shows up just in a normal text box. Thanks, James

Hi, I am trying to make an image appear on my reports from the internet, I have the URL in a field on the form but i would rather display the actual image. I have managed to display the image using the 'Web Browser' component on the forms but this doesnt work on the reports! If anyone had any...

hi Hi, Thanks for that, works perfectly! James

Hi, I have a form called [Summary] with three subforms on it, [Skips_Avaliable] [Delivered Orders] [Completed Orders]. And I was wondering if it would be possible to refresh all the subforms on the form every 30 seconds or so, any ideas if this is possible? Thanks, James

Record Number Hi, Thanks for that! I'm not quite sure where to paste the =Count(*) & " Records" in the text box properties, I've tried the 'Default Value' and 'Control Source'. Or should i paste it somwhere else? Thanks again, James

Hi, I was just wondering if it is possible to display the number of records on a form in a text box. Thanks! James

Hi, I have a form which displays an Image depending on the URL in a specific field. This works fine, but I now want to display theimages in 'Continuous Forms' mode. At the moment, the script below only works when you click on the record, but I wanted all the images to appear Automatically...

Hi Hi, I tried pasting in your line of code with the correct punctuation and there is now no error, but the second form opens blank, not displaying any records. I've looked through the whole forms code and I cant see anything else major that could be causing this problem. I dont know if any...

Hi Hi, Thanks for that, yes the field does have some letters in it, so I added the quote marks, but now I get a different error message, 'Microsoft Access can't find the fiels "Delivery_SigRef" refered to in your expression." Ive checked and the field is definately there in both forms, i can...