Recent content by DaveB

Cool, thanks for the prompt reply, I'll check it out.

I Hope this is the right place to ask this question. I have an Access Database which fetches information from a SQL database View. In order to do this I have had to set the user up with an ODBC DSN setting which establishes the link. I then call an Access Update Query which goes into the SQL...

That's perfect. Thanks a lot pbaldy, I appreciate it.

Hi, I am trying to show a list of fields in a report, but instead of them being listed DOWN the page in the conventional report manner, like so: RESULT1 RESULT2 RESULT3 I would like them to be listed across the page: RESULT1, RESULT2, RESULT3 I'm assuming I can create a text box with a...

Thanks for the replies guys. @MissingLing; Sorry, my mistake, it is a custom function. I can't remember my source for getting it now but I thought it was working when I first set it up but after a few months of use I have identified these issues. here is the code for the function...

Hi there, I'm really hoping someone can help me with an issue I am having using the ‘DateDiffExclude’ command to work out the number of working days between two dates. I have created a complaints database which is used to log all complaints coming into the company. Upon entering a Resolved...

Hi David, That worked a treat. Thanks a lot for your help. Much appreciated. Dave.

Hi David, Thanks for the prompt reply. To be honest I don't know why it's setup like that. That's the way I initially created the database and I've just had a 4 month break from working on it so I'm not entirely sure why I set it up this way. I've been trying to remember where I was at and...

Hi All, I am currently working on an Access 2007 database with a relationship which I would like to drop, then reattach as part of a procedure. In a nutshell, I have a ‘create table’ query which fetches data from an SQL database creating a new table in the Access database with all of the...

That is essentially correct yes. The continuous forms doesn't work as I want the image to remain static on the screen. I've got it working exactly as I want with the individual locations, you select one and it shows it on the map to the left, but I would like it to show all of them at the same...

Thanks KenHigg, appreciate the compliment. It's a little project I've been working on for a couple of weeks in my spare time and so far this is the only thing I've not been able to do which I would like to.

Here's a small animated gif of the screen I am working on. As you can see on the list to the right it has the different users. This only test data right now so will grow longer. There are x,y coordinates attached to each user which is displayed in the top right (but will be hidden in final...

OK, The image is of a small building, appearing on an overhead map. It's an embedded image and is used is to represent a location on the map. there is only one image on the form, the different records show the image in different locations. The [xcoords] and [ycoords] values are actually...

yeah I was afraid that might be the answer. I have tried it with a continuous form but that's not what I'm after. I tried a split form as well and that was close as it did display each record as I selected it in the table view, but again that wasn't suitable as it was a manual process, I was...

Hi there, Hoping someone can help with the following issue: I have a form which displays an image on the screen by using an x, y coordinate stored in the record. Each record has an [Xcoord] and [Ycoord] value so on the form it will display an image (image23) by using the 'left' and 'top'...