Search results

Erm. Lost, totally! I'll explain again in a little more detail (hopefully not upsetting the kind souls that have already posted) I have a form say for example "main". On this form is a button that will open the MS Windows dialog box to open a file. Once "open file" is clicked it will then...

Hi there The basics of it are this. I have a main form entitled BAR_frm. On this form are 7 fields for an address named as follows: mainsite_organisation mainsite_address1 mainsite_address2 mainsite_address3 mainsite_address4 mainsite_address5 mainsite_postcode I have a seperate form...

Thanks! Worked a treat:D

Ah, I can't do that:( If it was a database that I had built myself then easy, but it is a corporate database that is not allowed to have the structure changed. Any ideas?

Hi there I'm working on a query where I need to calculate the number of days left before a deadline. There is a slight twist though. I have created a query which has an expression field in it as follows: OfficerDeadline: DateAdd("ww",5,[Date_Valid]) I need to do the calculation off of this...

Hi there I am trying to work on a query which I am not sure if is possible to do. Basically I work for a local council and we are trying to return a list of jobs that have not been inspected in three months or more. The problem lies in that the table that holds the data has a number of...

Hi there I am trying to link in photos to a database but I do not want to create them as OLE objects within the database. I have seen on a database somewhere where you press a button and it opens up a box the same as if you were browsing for a file in windows. You then choose the file you wish...

Hi Mailman Thanks for the answer. I'll see how I go when I get back to work in the morning. I know that the easiest way is add in an extra column BUT it is not as simple as that. The database is based in SQL Server and we can not change the structure of the tables as it would mess up our...

Hi there I'm new to the forum and was hoping a kind person out there could help me out with a problem. Basically I work for a local authority and each week we produce a list of planning applications for our Parish Council's. Part of the query includes the category used by the ODPM (Office Of...