Search results for query: *

I have a data base that is a runtime version of Access 97 that is installed on many different types of machines, all have O/S from Windows 98SE to XP Pro. I have a form that easily allows the users to select email addresses and then send reports out all with the click of a button. In my code I...

I have a data base that is a runtime version of Access 97 that is installed on many different types of machines, all have O/S from Windows 98Se to XP Pro. I have a form that easily allows the users to select email addresses and then send reports out all with the click of a button. In my code I...

I have a report where the fields in the detailed section are placed vertical on top of each other (The fields are very long). In the detailed section I have 5 different fields, occasioinaly some fields are blank. In order to minimize blank areas in the report, I would like to be able to compress...

I have a form that contains tabbed page forms. I have a simple question, is there a simple test using VB that I can do that will tell me which tabbed page is selected for view by the user. On one tab page I display photo's but I would only like to update each record with the appropiate photo...

I have a VB function in a module that I call from a form that returns the file path and file name from a Windows open file dialogue box. I would like to put this information in a field in a table from within the form. I currently display the file path and name in unbound boxes, every thing works...

Thanks!!! gkprogrammer, Your answer was exactly what I needed to know. It worked perfect, thank you very much! I have another question in regards to the same email form I am working on. Once the Email form is open for sending a report, I have list boxes for the user to select multiple email...

I have a form which has a list box where the users can select multiple email adresses for sending a report as an attachment. When viewing a report I would like to have a button on the toolbar for emailing this opened report. When the email button is pushed it opens up my email form where the...

In my database there are two tables one of which is the main table and a second child table. The relationship betweeen the main to child is one-to-many. I have a main form where data is entered going into the Main table, on the same form there is also a sub-form for entering data into the child...

I would almost prefer to use a simple message box that informs the users that he can't do this, as only about 5% of the users attempt to enter data into the subform only. Do you have suggestions on the best approach to check for this situation and then create a message window preventing this...

I have a main form that also contains a subform and entering data into both fills data into two separate tables. The two tables are connected as a one-to-many relationship, where the data that goes into the main form and its related table is the ONE and the data input into the subform has the...

I have have an Access 97 database that is split into a two files (back-end and front-end). The data base is used by several different groups each with their own data and all stand alone systems. I have made an enhancment to the database where I have added more fields in one of the tables. I...

I have a MS Access 97 database running on many different machines each with there own set of unique data. The data base has a frontend and backend file. I have made many enhancements to the software including adding new fields in the backend file. I would like to be able to upgrade the users...

I need to know if there is a way to update an Access 97 database where I have added new code and ADDED additional fields in the tables. The database is in two files the code and back-end data file. I really need to know if there is a simple way to update the back-end file without losing any of...

I am trying to create a macro to print the current page of a report. I need a macro because I would like to create a custom toolbar which has an icon that when clicked will print only the current page in the report showing. I am using Access 97 for the database. Does anyone know how the VB code...

I need help with some VB coding as I am a novice in VB. I need to create a button on a form such that it will print a single page from a report in which the report page corresponds to the record showing on the form. Thanks in advance for the help. Tfrank

I have a multiple page report where I would only like to print a certain range of pages in the report. In the print dialogue box under Print Range pages the To: box is grayed out, so I am unable to print the desired pages, I can only print the complete report. Any ideas would be greatly...

I would like to add a custom print button to a report view, which brings up the print dialogue window, so that I can select which pages to print in my report. While I can do this under file/Print, I need to add the button because I have versions of the database that are only using the Access97...

I have a unique problem where Access97 crashes with the following error "MSACCESS caused an invalid page fault in module MSO97RT.dll at ..." after 2 characters are entered into any field in any form. This is on a users computer that has only the Access runtime engine installed. The...

I using Access97 and distributing a database with the Access runtime engine. I have sent out several copies all working on many different types of machines, but I have a problem on one machine with the following error, "MSACCESS caused an invalid page fault in module MSO97RT.dll at...

I need to add a button to a form that will print only that record displayed, based upon the layout and fields in a report to a single label printer. I know there must be a simple way to do this, but I can't figure it out. I have found a easy way to print out all the records, but I only want to...