Search results

I like to make the database look a bit more professional by creating an interface in Paint Shop Pro and then firing it in to the background of the forms. But they seem to be huge.. If I add a 20KB image to the form, the database increases by 1MB in size. Why are they bloating my database...

I am having trouble with this one... I have a table with records of each product sold. saleid | producttype | clientname | value and a table that contains the calls logged against each product sold. (ONE-MANY) saleid | calldate | problem. I am trying to create a report that will show...

I have a database that keeps track of all of my calls. I am a field service engineer. On the form, I have the name, address of client, cost, invoice number, callid and a few other fields. When I click the print invoice button, it opens a query based report which is an invoice related to the...

I need a down arrow image for decrement the hour in a time field. I already have the up arrow by using the SHIFT-6 character which produces ^. But there is no down arrow. I cant use any of the images as they are all too big, and they disappear when I try to resize them really small. Any one...

I have a list based on a date query. Works fine but when I sort it, it sorts by the numeric value of the day. For example, 12 July 2007 14 July 2007 13 September 2007 is sorted as follows: 12 July 2007 13 September 2007 14 July 2007 The query column is Expr1: Format(datefield, "Long Date")...

Hi, I've googled this but cant find an answer. I have a memo field for storing the problem that is logged (in my call logging system) which I want to display in a list box. Is there any way that I can truncate this neatly and have something like "..." at the end to indicate that there is more...

Hi, This is my first post, thanks in advance for your help. My problem is as follows: I have a table for storing calls logged with the help desk. There is a one to many relationship with a subtable that defines the times spent on getting the call sorted. Each site visit associated with the...