Search results for query: *

Is there a software or an easy way to convert queries built in server 2008 to Access? I have a few dozen queries for various projects that on their own work fine, but I'm beinging a new project that will combine the data from these queries with spreadsheets sent over from other departments...

Hi, I've got code written to import a csv file to a worksheet, the csv file will always be housed in the same folder on our server, the problem is everyone running the code has that paticular server named something different ie X:\Shared or G:\Shared or I:\Shared. I have a code that allows you...

I need help with checkboxes and based on everything I have searched I have not found out if this is actually possible. I have a simple form with 15 checkboxes, 2 text boxes for dates and a button to run the query. Each checkbox represents a different skill listed in a data table, ie DPU...

Hi! I have a table Name, Date, Hours, Comments. Each day an employee will have an entry Name, Date Hours, Comments (which might be blank). I need a weekending report that shows Name, Total Hours (summed, and all the comments. This is where the problem lies. I have the hrs totaled but I...

Hello, I have a db that houses our payroll for nearlly 260 employees. There are only about 18 people who use it on a daily/weekly basis. The db is split, the front end is the one that is having issues. This Friday afternoon I get a phone call that it won't open, the below error is what pops...

Hi I have a team of 15 people, each having there own time cards for each day of the week. The report looks something like this: Name Date LogIn LogOut Smith,John 2-Feb-07 900 1730 Smith,John 3-Feb-07 900 1731 " " " " Total Hours: 40:25 Tony,Bobby...

I have a query that pulls from 3 tables, tblNames (Name & Supervisor Name) tblPayroll (start & end times) and tblSchedule (scheduled Start & End times). In the query there is a date range criteria in the date field. The various calculations in the query work fine except it returns 2 records...

I have a database setup on a network drive with a front and back end with multiple users allowed. The database has worked beautifully until today. I was in redoing a form which of course locked the database, after awhile I went to save a recent change and it told me it was locked user<name> on...

I have a query that pulls the login and logout times for my agents from a table and calculates the difference. This works great, however, when I try to add all these times together for a weekending total it won't give me the format I am looking for, which would be 40:39 (hrs:mins). The agents...

I have a form based on a table that holds employees hours. The form displays their Name, Date, Hours and a 'Comments' section. I need the user to be able to pick a date in a popup calendar and then only show records with the matching date. The only thing I can't seem to figure out is how to...

I have a combo box based on a simple list of names. When I open the form I can view the names in the drop down but it will not allow me to choose any of them. After I go into design view and then back to form view I can choose from the drop down list. I only have a couple of forms out of...

I have over 60 agents with schedules like below: SMith, Charlie Date Schedule Start Time First Break Start Lunch End Lunch Second Break End Time 20-Mar-06 010 06:15 AM 08:15 AM 11:00 AM 11:30 AM 01:00 PM 03:45 PM 21-Mar-06 031 11:45 AM 01:15 PM 03:45 PM 22-Mar-06 008 06:15 AM...

I can't get a text box to calculate correctly. I have 4 text boxes Sick, Vac, Flt and Other. I need another text box, Reg Hrs, to have this equation in it =80-sum([Sick]+[Vac]+[Sick]+[Other]) Then another text box that will show the Total Hrs =[Reg Hrs]+ (Sum([Sick]+[Vac]+[Flt]+[Other]) Any...