Search results

I want the user to click a button on a sub-form (continuous form format) and pass the value of a field (ColorCode) in that record to a new form which opens from the button click and autopopulate the field (ColorCode) on the new form. First Form is: On button click stDocName =...

I want to automate the distribution of individuals Vacation Balance and Usage via email. The data is being pulled from 2 tables related by an Employee ID#. tbl-Employees provides the Header Info for each employee and tbl-VacLog provides the detailed Usage data. I want the output to appear as...

I'm modifying a calendar I downloaded from one of the forums. What I want to do is allow the user to double click the specific day, which is a subform in the main calendar form, to open a deatiled view of that days events. The problem is when the detailed view opens, I'm not sure how to pass...

This is really strange. I made a database into a design master and then created two replicas. While testing, the design master suddenly lost all it's replicable settings and my replicas cannopt sync with it. The database is still listed in the list of sync-able DB's in the replicas. I also...

I have a set of queries that will Approve and Revoke Credit Approval based on given criteria. The field giving me a problem is the [ReviewDate]. I want the [ReviewDate] to be not more than 6 months old. This date is held in a table I'm linking to via ODBC and the field is formatted as text (I...

I have put simple error trapping into a module that performs some updates to access tables from Excel spreadsheets. I have trapped if the table doesn't exist but now I need to trap if the table is locked or open. Can some one share the syntax for this Test. Someting like this is what I'm...

I'm building an application that tracks quotes and have implemented some outlook modules to send emails and schedule tasks for the employee. Sending information into outlook has been fairly easy. The hurdle I'm trying to get over now is how to retrieve a list of tasks from each user. (My boss...

I have a DB for requesting Details of Products. My sales coordinator enters the Job information on a form linked to a Request table and enters the parts needed in a subform linked to a Detail Table. I'm using code to create an email populated with data from the Job Info form and want to also...

I have created a replica of a database that has linked tables in it. Some of these tables are in other databases and some are linked via ODBC to other databases. I created the replica with little issue and when I sync with the Design Master the replication process appears to complete...

I'm trying to populate a field on single form with input that could come from three different forms in my database depending on which department is using it. I keep getting a #Name? in the field instead of the job number. In the forms OnOpen event I have: If...

I have a windows 2000 box with access 97. The user wants to put a shortcut to a form in a networked database on the desktop. When we try to open the form Access tries to open but freezes up and never makes it to the database. When we close access it says it "can't find c:\machine\documents...

I'm trying to create replicates of an access 97 database. When I click replicate I get an error message that says "Mocrosoft acess can't convert the database to a design master" due to one fof the system tables created by the replicate action. I've tried the sample code from microsoft to make...

I have a subform in an form that on open checks some criteria and if true changes the AllowEdit property to False. If the user wants to modify the data on the form or subform they click a button and I want to change the AllowEdit property back to True for both the form and subform. The button...

I'm trying to buuild a proofsheet view on a form that will allow me scroll thru all photos to do a quick visiual scan. I know with reports you can do multiple columns but it does not appear to work with forms. I could use the report to display this but I'd like to have click functionality to...

I have a Autoexec macro that runs thru an update process several times a day automatically and when complete sends an email to me that tells me all is well. I'm tired of deleteing these confimations now and would like to change the macro to only send the email on error or when the macro does...

I have a macro that runs thru an update process and when complete sends an email to me that tells me all is well. I'm tired of deleteing these confimations now and would like to change the macro to only send the email on error or when the macro does not complete running. I'm hoping it is a...

I have a series of queries that take in part numbers for stocklength materials, qty and cut size needed. It process a Bill of Materials that tells our shop what to fabricate. I am trying to determine how much stock material to pull from inventory to give to the shop to be cut. I am able to...

I want to have a user enter a MM/DD/YY value and then have access populate a table with the Monday and Friday Dates for each week. I think if I can tap into the system calendar it may be possible. Has anyone done something like this? Your help is greatly appreciated. I don't want the end...

I'm importing an excel spreadsheet into a table in access97. The field in question has text formating though most of the contents are numeric. When the import script runs, I've told it to delete the existing Access table and import the new Excel version to replace it. This happens as expected...

I had the sendobject in a macro to send an email to me when it finished running. Out of the blue, it stopped sending emails. It will run correctly from all machines except mine. I've seen this message before but whatever the problem was always went away. Now it appears permanent. Does...