Search results

Hi Everyone, I've develpoed a database using Access 97 with a split file front end/back end format and this is now being used in a number of different sites. I was wondering what happens if someone in one of the sites upgrades to a newer microsoft office-2000, XP or whatever, will they be...

Hi all, I've got an access database that links to JPEG pictures stored on a particular network drive. Basically image codes are stored in the database and the user can select the image codes to view from a combo box. Once a user has selected an image code they would like to view they press a...

Hi everyone, I've got an access database that is being used by a number of people in a number of different sites. As our company do not want to spend money on a proper intranet/document management system they have asked me if we could use the database. Basically the idea is that the database...

Hi, I've been trying to create a form based on both a table and queries and it's returning the same message! I've compacting the database but still no luck. Thanks! StephenD

Hi everyone, I'm trying to create a new form in my database and keep getting an error message saying 'No current record', anyone know why it's doing this?? Thanks

Hi there Jeeps, I've used both SPSS and Access and you can do data entry in access and import it into SPSS or do the data entry striaght into SPSS. I reckon it's probably easiest to do the data entry striaght into SPSS because if you are importing from Access you have to make sure the...

Hi everyone, I need to setup security on my database to allow different people to do different things. The database is operated by a user using a combo box drop down to select a particular coutry-it then gives the user information on that country and provides futher buttons for the user to...

Thanks for the reply! It kind of helps-do you know how I would do this automatically-Is there a function that I kind use that selects the top 5, so then I could use an If statement or somethind to select those not in the top 5? Thanks, StephenD

Hi, Can you customise the 'top 5' etc. function on queries?? I'd like top have the top 5 shown and then everything else grouped as a total under 'Other'. Does this make sense??? Thanks, StephenD

Thanks Hayley-I thought there would be a simple answer!

Hi, I've got a macro set up to print out a form, it prints potrait and therefore cuts off some of the information. Does anyone know if you can set it to automatically print as landscape? I've tried changing the printer setup properties through the control panel but that has no effect...

Hi everyone, I'd like to create a search form that searches and returns any records that contain the text that a user enters in a text box on a form-the form would be searching a memo field in a table-does anyone know if this is possible in Access?? Many Thanks, SteveD

Hi everyone, I've split my database into front end and back end-I need to unsplit it, can this be easily done? Is it just a case of creating a new database and importing all the objects from both the back end and front end files?? Many thanks, Stephen

Thanks for the reply- I thought about using a report, but the images that the form loads up are based on the records a user selects via a drop down combo box. I don't know how I could get the same functionality via a report-could I place a report on the form and then link the report to the...

Hi People, I have a form that contains linked JPEG images on it. The size of the images vary so I've made my image frame as large as possible to accomodate this and set the picture size mode to 'Clip'. It appears just fine on the screen. I want to be able to print the image as it appears on...

Hi, I'm performing a nested iif calculation-it seems to hit a limit at 12 then it says 'expression you entered is too complex' Anybody got any ideas? Thanks, StephenD

Thanks!, Didn't think I was programming-simply tring to do a simple calculation of the difference between two dates using a built in function-but there you go!

Thanks Rich, What exactly is this doing? How do you find stuff like this out? The access help files on datediff seem to sell it as a pretty obvious function that will calculate the number of months, days, or whatever between two dates. After using this in some pretty important analysis on our...

Sorry-yes is it correct for the two dates 01/12/01 and 27/12/01. I'm concerned about it putting 1 when the difference is only say a few days but the days go across two different months. As in my first example of 27/12/01 and 02/01/02. Does this make sense?

Hi everyone, I'm using the datediff function to calulate the number of months between two dates. I think I've over-estimated the power of Microsoft Access!.......... I got two date fields in the format dd/mm/yy. I'm using the formuala: Datediff("m",[Date1],[Date2}) I thought this was working...