Search results

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

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

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

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