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 Chriss Miller 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: *

  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
  16. Vette00

    Week ID Problem

    The problem with that is week 53 and week 1 fall in the same week and it won't display both. Plus when Week 1 comes it won't look at past weeks.
  17. Vette00

    Week ID Problem

    I made a field called WeekID:Datepart("ww",[Card_Date]) and the critieria for the query is Datepart("ww",[Card_Date])-1. This pulls the entire last week but will have problems in week 53/1 because Access thinks it is two different weeks. I also use the week ID to look at past weeks of data in a...
  18. 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.
  19. 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.
  20. Vette00

    Add Records Based on a #

    My Questions how to I get Access to make the records in the Assignment table based on the days and the # of people. Sorry about that.

Part and Inventory Search

Back
Top