Recent content by Rattlesnake

Hi, I have an Access 2003 report , that contains a subreport on the right corner of the main report. (see attached image ). The main report has 2 image controls and 2 textboxes (on the left side of the report). The subreport is a tabular report having 2 columns. The problem I face is that as the...

I think you forgot the CODE. :)

Hi, I have report that displays records in a tabular format. (the fields have a border to them so the reports looks like a table) The number of records may vary according to certain conditions. What I want is that the report should always print a minimum number of records say 25 , irrespective...

Hi , I have a Report in Access 2003 , . In the report there are 2 fields RecordID and Category_ID. In this report I also have subreport, which is linked by the RecordID field. I want to Filter the subreport by the Category_ID field also. I have written this code but it gives me an error Private...

Hi, I have an Access application that contains a form , where the user will selects a Picture and add comments about that picture. I have decided to place only the Path to the Picture in the database and not the actual picture , as I have read that the Database size increases alarmingly when...

Hi , I am developing an access application that will be used by our Marketing Dept to create BRIEFS for our AD agencies. The Brief has the following structure 1. Option1 1.1 A1 1.2 A2 1.3 A3 1.3.1 AA1 1.3.2 AA2 1.4 A4 2. Option2 2.1 B1 2.2 B2 2.2.1 BB1 2.2.2 BB2 2.3 B3...

hi, I have a table that stores the monthly depreciation of Assets. The structure of the table is as follows: [Asset#]-[Depreciation Date(DD/MM/YYYY)]-[Depreciation Amount]-[Asset Account No]-[Company No] I want to create a query that will give me the Total depreciation per [Asset Account No]...

hi, I have a table that records the Time attendance of employees and has the following fields TIMEIN- TIMEOUT- OVertime -OvertimeType The records have the values like the follwing: 09/03/2003 8:00 - 09/03.2003 22:00 - 4.00-150 The overtimeType determines whether the Overtime has to be paid...

hi, I have a chart , that is based on a query (lets say queryC). QueryC is based on 2 other queries (A and B). While calling a the chart(displaying it) , I want to pass a "WHERE" condition to the queries A and B. Basically A and B supply the records for the chart and Query C groups and SUMS...

I mean FIELDS. One text file is one RECORD. There many fields in it. So i just want to import the fields I want. Thanks

hi, We have an application that produces tab seperated text files.It creates like 10 -15 files at one time. I want to create an application that will export SELECTED FIELDS from each text file (for. e.g. the 1st,5th,10th,20th values) to one excel sheet.(all 15 text files to one excel sheet) The...

Yeh the rights on the mde was the problem.its OK now. Thanks

hi, I havent enabled the security for the Database. There is no password for the database. I tried opening the database directly , by double clicking on it and also by using a shortcut. But i get the same error.

I get the following error when i open an MDE database.(see attached image) We have Win2000 , Access 2000 .It is on an NTFS partition. I have tried giving for all users Full Access on the Database. It works fine if I login as Administrator, but not when Logged in as a USER. Any Ideas?????

The startup form has 4 buttons and looks weird if the form is maximised(if i make it normal). I dont know of any other way of making the form smaller without making it popup.