Search results

  1. B

    Storing a PDF in an access database

    Right now I am storing a pdf in a database by creating a link to the file. My problem is that my boss went to a presentation and looked stupid when none of these links worked since the files that were link were not there. He requested that I store the pdfs IN the database and not link them. I...
  2. B

    Compacting database not working

    I set my database to compact on close orginally, but it was taking a lot time since it was being run off a network and users start to complain. So I was looking at trying to compact the database by checking the file size when a user clicked exit. I have the checking down, just need to figure...
  3. B

    finding if certains keys are held down on click

    I have tried to search the message board for this problem but I am not finding any information. My problem is relatively simple. When a user click and button, I want it to exit the application. If the user is holding down a certain key (almost any key would work) I want it to open up an...
  4. B

    Timing and controls on subform

    I have two problems right now that I have no idea how to solve. My project works like this... You fill in required information on NewJob form. This form is a continous subform. And then you click in AddWorkOrder button on the subform. This opens up a new form to add a work order. On the...
  5. B

    Changing a record in a table

    Right now I have two forms. One if a job information form that is really a continous subform on the main form, and I also have a seperate work order form. One the job form, there is a button to click to bring up the work order form. Also on the job form, there is a check box that is checked...
  6. B

    Updating Specific field in specific record

    OK, I am looked through the message board so far and could not find anything that helped me. What I am looking to do, is to update a check box on a table. I have a form that gets data for a job. On this form, you can click a button to add a work order. Also on this form is a check box that...
  7. B

    Find the sum of fields on a subform

    In my project, I have a form which contains a repetitive subform. The subform is very simple, it contains a date and a quantity(number). My problem is, I need to try to find some way to sum the quantities of the subforms, and have it on the main form. The form is used in editing the...
  8. B

    Problem making a report from two seperate tables

    I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...
  9. B

    Problem combining two tables, need help with Query

    I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...
  10. B

    Problem with Combining two tables in report

    I am having a problem printing out a report. I need to show the quantity and other information for jobs seperated by day. The only thing is, I have to take the quantity off of two seperate tables. Table 1 - some jobs take more than one day, so it contains the spread of quantity for a job...
  11. B

    Problem with recordsets

    OK, I am trying to do something really simply. Open a table called "DropByDay", check to see if there are any records that have the same [PacketDetailID] that is on the form. If any records have the same ID, then delete them. Then Append on a few records with the [PacketDetailID], [Amount]...
  12. B

    Closing a subform without running a macro to check for required information

    My problem: I needed to write a macro to check to see if all the required fields are filled in. It gives user friendly errors, not like setting the required property on a table. I set this macro to run "on exit." It is working well for that purpose. The problem I am having, is that if I...
  13. B

    Repeating reports equals number of records in subreport??

    I am working on a project. As an analogy, the data being stored is a book, along with information about each page. The information about each page is the same, but some times not every page is going to exist (weird book huh) The report brings up the book, and has a sub report to repeat that...
  14. B

    Varifying a form is open

    I just started working on a complicated database that was handed to me after a few people have worked on it. I need to be able to edit a "Work Order" form. The database allows for it to be created, but not edited. It's created after filling out required information in a "add packets" form...
  15. B

    Varifying that a form is open

    I just started working on a complicated database that was handed to me after a few people have worked on it. I need to be able to edit a "Work Order" form. The database allows for it to be created, but not edited. It's created after filling out required information in a "add packets" form...
Back
Top Bottom