Search results for query: *

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

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.

Thanks for the info.

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

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.

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.

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

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.

Can I use the pages in Access to do this or will I have to use some other product?

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?

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.

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

Thank you so much my brain is cooked and I just couldn't think anymore.

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

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

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.

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

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.

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.

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.