Search results

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.

hi, This must be a simple question but I cant seem to make it happen. I have startup form that is a popup form((covers half the creen) with 4 buttons on it All these buttons open forms that are maximised when opened(i.e. not popup). My problem is that when these forms open , the startup form...

hi, I am using Access 2000. I want to know the SQL query to import data from another Access database. i.e. Copy the records from a table in another database into the Access database that I am currently working in. Basically the main database(from where I will import) will be updating everyday...

hi, Mine is not a technical question ,but a logic question. I am creating a time and attendance software. I have an access database that stores the IN and OUts of employee recorded by a finger scan device. We have three shifts in our company.(7 to 15, 15 to 23 and 23 to 7) I donot want to...

hi, I have a simple question. Can I connect to MSDE 2000 from Access 2000 using adp's. If yes what are the requirements for it (offcourse other than Access 2000 and MSDE 2000 being installed:) ). Can I connect to a remote MSDE installation using Access 2000? Thanks

Thanks DJN. But the solution suggested in the article is to select the "Use Hijri Dates" option in the Tools-->StartUp menu. When i do this my Gregorian dates are messed up. For most parts of my application i require the gregorian date . I require the hijri date for only a few modules and that...