Search results

  1. R

    FE to go into Users Profie?

    I would like for the front end of the database to be copied to the users profile directory. The reason is because they do not have privledges to create folders on the local C: on their machine. I am using the Auto FE Updater to distribute the FE's to the workstation. The website there cites...
  2. R

    writing values to a table

    I have a similar problem. I have text fields that perform calculations and would like to store the value in the table. I have a form based on a table and I have fields that are bound. In one of my text fieldcalcuation it has =[YWC]/[WordCount] for the control source. So how can I bind this...
  3. R

    Report Preview

    Thank you! That was it. I inherited this database and there was a me.requery on the form's on activate event.
  4. R

    Report Preview

    I have a main form frmCustomers and a subform frmInvoices. One to many relationship - One customer can have many invoices. I have a command button cmdPreivew which allows to preview the invoice and then print if they chose to do so. When I click on the command button it opens up the report...
  5. R

    Crosstab Query - Dates?

    Thank you Scott. I have created a table with that information in it. And then how would I incorporate this into determining how many days it took to complete one of the tasks?
  6. R

    Crosstab Query - Dates?

    Thank you Scott. I have taken a look at that site. And that would have been great if I had 2 dates that I needed to calculate the difference of. In this situation, I have only 1 Date Field, which is logged when the user inputs his or her work for the day. I have realized something I should...
  7. R

    Crosstab Query - Dates?

    Hello, I have a crosstab query with the following column which calculates the number of days an employee took to perform a task. Problem is that it is also counting weekends and holidays. Field: LogDate Table: tblWorkLog Total: Count Corsstab: Value Is there anyway to exclude weekends and...
Back
Top Bottom