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

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

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

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

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

Hi Everyone, I think this will be an easy question...... I have a database for a membership programme and fields include join date and cancelled date. I want to count how many members have joined by month and members cancelled by month. I've done a simple Group by query, however the date...

Hi everyone, I've got what I thought would be a simple query but I can't get it to work. I've got two fields: Membership ID and Number of months. I'm using a group by to count the number of membership Id's. This works fine until I add a third column to the query which is 'Age group'. Now...

Hi, Hope somebody can help.... I'm using the datediff function to calculate the age of somebody based on a date of birth field:- Datediff("yyyy",[dob],now()) It seems to work apart from older ages-for example I have a date of birth of 17/9/28 and it's returning -27 Can anyone help me/tell me...

Does anybody know what is the best way to group data in a query?? I have a big chuck of data with a date of birth field-I want to add an age group field based on the date of birth e.g 0-17 years, 18-24 years and so on. Can you do it using IIf or is there another way??? Thanks!

Can you program Access to export a query into excel, then have excel create a graph on the newly exported data? I'm a newbie to VBA and was wondering how complicated this would be? I've read something about arrays, and also I'm aware of the transfer spreadsheet action but I'd like to go a step...

Ok here's my problem (challenge!).... I have one table with approx. 1 million records with the following fields: Membership ID, Joining Date, Cancellation Date Each month I will be appending new data to the table which will have the same fields. I don't want to have any duplicate membership...

Does anyone agree that the charting function in Access (97) reports is the pits? I have a chart with number of days on the X axis and number of members on the Y axis. The default scale on the X axis is stupid-I went into the chart to change the scale but it doesn't see it as a number-it...

Hi, I'm currently setting up a database that every month will import a txt file of around 1 million records-I think I'll be using the transfer text method. However, this appends records to existing tables-I want to first empty or clear the existing table to overwrite with the current data. Can...