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

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

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

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

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

hi, I'm using Access 2000 I wanted to know as to how can i access a non-gregorian date in Access. I have the Hijri Calender (Arabic) selected on my system. But when i use the DATE or DATE$ functions it returns the gregorian date. Is there a way to make it return a Hijri (or the the date...

hi, I was confused as to where to submit this question so I put in the general section. I converted an application in Access 97 to Access 2000. DAO 3.51 was used in the Access 97 app. While converting DAO 3.6 was automatically refrenced. The application was running fine. Now I split the tables...

hi, I have created an Access 97 application that is being implemented in an organisation. Now they have asked me to do some modifications in the application . While I do the modifications, the unmodified application will continue to be used in the organisation. When I finish the modification...

hi, I have a subform in Access, which has a field which is a calculated field , but it is stored in the table. Now Let me explain what i want to do........... In a purchase order module, -->The user selects a currency(like dollar,Euro etc) which is a part of the main form. It is a combobox which...

hi, In Access 97,how can I access each row one by one in a subform where the "Default View" property of the subform is set to "Continous form". Basically I want to update other tables , once the user has finished entering all records in the subform. These updates will depend on the individual...

hi, I have created a report in access 97 which is in the format of an Invoice. It has a report footer that contains the Total and remarks etc. How do ensure that the r eport footer will be printed at the bottom of the page even if there are only a few lines(table rows) in the report. Currently ...