Search results for query: *

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?

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?

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...

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

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...

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...

HI, I do a lot of scanning with out needing to alter settings. I have recently installed a new hard drive and since I have reinstalled software and every time I try to import a scan the scanner has to load and rescan again. 2 scans instead of one as it was before. Scanner is HP 4300C. Any...