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!

Recent content by Vette00

  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

    Thanks for the info.
  4. 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...
  5. Vette00

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

    They wany $99. dollars I figure it cheap enough when I use it I will post the results. Thanks so much for all the info.
  6. Vette00

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

    Has anyone ever heard of a product called Acces2Web it claims that it can turn your Access forms to web pages. We have 2 citrix server but they would perfer the web.
  7. Vette00

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

    Right now it is a split database with only a couple of users.
  8. Vette00

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

    I don't have visual studio but they will buy it if that is the way to go. The reason for push is they want users from across the state to be able to use the same database instead of each section using their own. Plus they have no idea how much work that is.
  9. Vette00

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

    Can I use the pages in Access to do this or will I have to use some other product?
  10. 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?
  11. Vette00

    Appending multi records

    I want to add the date, times, and job to the assignments table. I will assign them from a different form. The problem as I see it is there is only one job and it can have many days and many people. I need to add many days which i did but I don't know how to add many people.
  12. 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...
  13. Vette00

    Week Ending Default

    Thank you so much my brain is cooked and I just couldn't think anymore.
  14. 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...
  15. Vette00

    Week ID Problem

    SELECT tblWork.Date, DatePart("ww",[Date]) AS WeekID, tblWork.Hours, tblWork.Status, tblWork.Comment, tblWork.ID, tblWork.Approved, FROM tblWork WHERE (((DatePart("ww",[Date]))=[Forms]![frmWorkMenu]![cboWorkWeek])) ORDER BY tblWork.Date; I want to call up A week at a glance
See more

Part and Inventory Search

Back
Top