Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Vette00
  • Content: Threads
  • Order by date
  1. Vette00

    Export Query to CSV without losing leading Zeros

    I am trying to export a query to a CSV. The problem is the two fields are not exporting correctly. I have an Employee ID Field that has 5 numbers but some employees have ID like 00426 and 00527 but are being exported as 426 and 527. Also there is an hours field that should read 0800 for 8...
  2. Vette00

    Blocking Find Target On Shortcut

    I am trying to find a way to prevent my users from going to a shortcuts properties and selecting Find Target and getting access to the folder on the network were the database is.
  3. Vette00

    Adding Blank Records to a Table

    I have a form the pulls up contractor info then I want to build the jobs for next week based on the needs of the contractor. Then later on in the week I assign employees to the jobs. I can't seem to figured out the best way to add the records without manually starting each record...
  4. Vette00

    Is there a way to turn a Form into a web page?

    I have a database that works great but now the powers that be want it to be web based. They want the same functions but used it from internet explorer. It there an easy way for me to turn my forms and reports into web pages in Access?
  5. Vette00

    Appending multi records

    I have a form were the user enters information about a job (ie Date, Time, Select days to work, and # of People needed.) Then at the end of the week the user goes to the assignments table and picks employees and assigns them to the jobs. I am using an append query to add records from the tblJobs...
  6. Vette00

    Week Ending Default

    I am looking for some code that will always return the week ending date. The code will open a form for the current week. I tried the Week ID but ran into problem with the year change over. The code will than be passed into a text to set the max date for the data and the min date will be six days...
  7. Vette00

    Week ID Problem

    I use the Datepart() Function to pull the prior weeks records in a table. The problem is how to I tell Access that week #53 and week #1 are one in the same in the query.
  8. Vette00

    Stop Report Footer From Going 2 New page

    How do I stop the Report Footer Totals from going to a new page? I have a report with 2 Columns and the totals always appear on the last page by themselves.
  9. Vette00

    Add Records Based on a #

    I have a database that has a jobs table and an Assignments table. Everyweek the user select how many days the job will run in the next week and how many people are needed per job. I need to fill the assignments table with all the requests and assign workers to each job. Basically I need the form...

Part and Inventory Search

Back
Top