Search results

Is there a way to calculate accrued interest or an amortization schedule in MS Access? I know it's easy in Excel but I have a need to do it in Access. Thank You, Suzanne

This has got to be simple but for the life of me I can't understand it. I modified an existing front end database and then converted it to an mde file. The prior mde file allowed the user to preview a report and then click File Sent To and attach the report to an email. The new mde file...

I have a report that when the user requests the report the can enter a Title that they choose for the report. (So I have a Parameter Control that they fill in on running the report). My problem is that when the report has no data to return they still want to fill in the title and print a blank...

I have one database and I want the ability to click on a button and open up another database. Can I do that?

I have three databases. A. B. C. I have three different users. 1. 2. 3. User 1 needs to be able to add and edit data in database A. User 1 also need to be able to view data in database B and C. User 2 needs to be able to add and edit data in database B. User 2 also need to be able to view...

I have a very simple Access database that contains a form where users enter sheduling information...I wish to limit a group of users to be able to read this information only and not modify or add to it. The tables are in a back end mdb. The rest is in a front end mdb. And the users actually use...

I have a simple database that I enter purchase orders into. Up until about one week ago everything was running fine. Now after I enter approximately 5 new records I get the following message: Runtime Error Program C:\Program Files\.......msaccess.exe Abnormal Program Terminatoin Sometimes...

Thank you. That makes me very scared. I have been using Access for several years and I just wonder how many times my misunderstanding of this has caused me to make errors. WOW. Thanks a lot!

I do understand that. But if I leave the criteria "Not ABC" out the records with a null value are returned so why when I put the criteria back in are the records with a null value excluded. Am I making any sense at all?

I have a very simple select query. I am selecting records from a table where the criteria for field A is NOT ABC . The results do exclude all the records whose field A is ABC....but it also excludes all records where field A is null. Why is that? Null is not ABC. This is very confusing to me.

I have tested my database on three machines: Machine 1: Access 2003 Version 11.5614 References checked: VB for applications, M A 11.0 Object Library, Ole Automation, M DAO 3.6 Object Library, M ActiveX Data Object 2.1 Library. Machine 2: Access 2000 Version 9.0.4402 SR-1 References checked...

I have a macro that contains a line with Send Object. It is emailing the results of a select query to a co worker. It needs to be in Excel format. However it is over 16,500 records and the Macro keeps halting because of the default to Excel version 5 where 16,500 records was over the limit...

No it's not row order it's actually the rows themselves. It's like because I have tabbed through or entered through the fields on the form the joined fields data type changes and after that the joined fields no longer match. I initially populate the tables with an append query. After the...

I am going to try to explain this as clearly as possible. I have two tables. Table 1 has a field in it I will call Field 1. Table 2 has the same field I will call Field 2. I have a form based on table 1. (Of course these tables have lots of other data in them as well). These tables...

I have a number of reports that are designed to be in Portrait orientation. However very often when I open up these reports to preview and then print they are in Landscape orientation. These are the things I have done to try and solve this mystery: 1. While previewing report I have gone to...

I am a novice at multi select list boxes and could use some help. I have a very simple situation that I am trying to learn from. I have the following tables: Rooms (one field - RoomName) Areas (one field - AreaName) Test (two fields Room and Area) I have created a form I will call Form1...

That definetly has put me going in the right direction. I added the following code to the "On Load" Event of the form. But now matter how the form is loaded Label93 is visible and label75 is not visible. What am I doing wrong? Thanks so much for your help. If Forms!Master.NewRecord = True...

I am using Switchboard Manager to open up a form once in add mode and also in edit mode. I want to display one label if the mode is Add and a different label if the mode is Edit. Otherwise the user gets confused as to whether or not they are in Add or Edit mode. Any ideas?