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

Much appreciated thats it. Must look up all the table join types. Changed from INNER JOIN, the default on the query that was suggested: http://office.microsoft.com/en-gb/access/HA010550991033.aspx to LEFT JOIN and it seems to work fine. Had to change to SQL view. Must remember that one for...

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

Smashing thanks

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

Regarding the interface, I always the background in Paint Shop Pro, drop it in to the form and then "Send To Back". Looks MUCH more professional than the Access interface. tbh, I'm not good on using subforms, I dont use them. There are two ways that I would handle this a) The way I have done...

Did you import the sheet or did you just try to copy and paste? If you have the fields matched exactly, then there must be an difference in the types. Access must be expecting a date type and you are entering a text or something like that. If you take a look at the table that you are...

yeah, the way that I do this is as follows. I'm not sure if there is an easier way, there could well be. 1. Get your data in an excel spreadsheet. Add a new empty row at the top of the sheet. This will be used to add the headers. 2. Export a sample of the table (that you wish to import to)...

Sounds like you're making it difficult for yourself. At this point, and not being familiar with Access (as you say), I would think that you are probably scrapping it and starting with the Contact Management template again. Why dont you make your data fit the table that exists already instead...

I'm a bit confused as to what you are trying to do. 1. Where does the combo box pull it's list from? Why should it match the other information in the form. 2. What you were saying about adding the information to other records. Are you saying that the form is cycling through the records? I...

You seem to have this sorted anyway but, There may be an underlying problem with the field that is the control source for the combo. You should check the table that the field is associated with and see what parameters have been set on it. The issue is usually something to do with this in my...

Never even thought of using the 'v'. Because the arrow icons are so small it may work. I tried in the symbols and there was (surprisingly) nothing even close to a down arrow.

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

What I usually do is to design it as follows. On the left you will see "search by" then you have a field to whether to search by name, location etc etc. The list box underneath's rowsource is a query which has the Search string field as a parameter. When you press the search button, it...

:)Yep that's it thanks.

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

And you know I had the left() statement in already and was gonna try the & but I thought it would be thought of as part of the SQL statement. Works like a dream. thanks, J

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

Got it sorted. Not sure if it's the best way, been working for hours on this and just tried this. ... Problem was that the call logged was not being saved when I opened the subform to enter the site visit details. To counter this I saved the record on the add visit button before opening the...

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