Recent content by Lightningfast

Thanks I was sure there would be a simple answer :-)

I need to create a report list for an art show. List needs to have exhibit numbers in order grouped by artists so that they can be easily found from catalog. Trick is I only want to print the artists name when it changes. eg Joe Bloggs then list Joes exhibits in numerical order access wants...

I want to add a new record to an append query. I have a field Qty in my stock table. I want an individual record for each on my append query so if there are 5 in qty my new table will have 5 records. Any ideas?

Thanks guys, I have CHR(34) in other parts of my programme, had a mental blank on it, getting old I guess, Cheers Trevor

I create web pages using access. How do I get data from a field and place it on my page eg: url is the field ='"[url]"' returns "[url]" I need the contentes of [url] within double quotes, not the control name Any ideas?

Silly me of course Tektips converted it. The access result I get is < & then g then t then ; instead of > I can't show it as it appears as Tektips converts it correctly. Thanks Trevor

I have been exporting a query to html to display the title and point to the image when the title is clicked. It all works fine execept for this expresssion Expr2: &quot;<A href=&quot; & [p-no] & &quot;.jpg>&quot; & [Title] & &quot;</a>&quot; returns <A href=p-no.jpg>title</a> I have to then do...

I am wondering if anyone has ideas how to go about this. I have a form and when it opens I display the cover of a brochure as an image (path controlled by the item part number)I have the images for the other pages stored pno_1 pno_2 pno_3 etc. I would like the user to push a forward or back...

Thanks Guys Steve's got it. Its just keep it simple I went thru all the formats but because I come from coding environ wanted to use both fuctions eg: STR(sell$,format(###.##)) or something similar .Its much simpler though I nutted it out eventually and this works fine...

I have a field with number in currency format sell$. I want to add this to a text string in format so it looks like $5.00 when there are no cents instead of $5 as it does now heres the code I am using Str([sell$] Anybody know how? Thanks Trevor

Thanks Daniel, Thats exactly what I needed the right syntax. Had to massage it a bit but it works just fine now. Thanks from Down Under, Trevor

I have a form linked to an image file but I need a way to return a default error file if the requested file does not exist eg: this code leaves the last image in place On Error Resume Next If Not IsNull(Me![imageafter]) Then Me![pictureimage].picture = Me![imageafter] End If...

What a winner thanks Bob. I knew there would be a really simple way but none of the reference books seem to mention it. Thanks again from down under TP

I have a database with unique part number field. I use this field to name an image matching the database record. I need to find a way to link the path, the image and the form page. I don't want to open another program to display the image just show it on the form. Any ideas? TP

I am running a calculation based on field called weight and want to return a,b,c or d to a field called weightcode automatically. This is the code I put in the weightcode field. =IIf([weight]<=170,&quot;a&quot;,IIf([weight]>170 And [weight]<=420,&quot;b&quot;,IIf([weight]>=420 And...