Recent content by lisagippe

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

True, but with a different person of the team running them every quarter or even multiple people and different amounts of data everytime wouldn't that cause some data compromise at some point?

I add and delete it because once the csv is imported it takes the original file from 3 megs to 18 and not everyone's pc here is the same. I have more ram and can run larger files but it just locks up for the rest of them. So to keep the original file running smoothly and not breaking in the...

Excellent, but to throw a wrench in it, the macro as a whole adds Accnt Details2 as a sheet, then creates the import and imports everything, then after copy/pasting to the appropriate sheets deletes the Accnt Details2 sheet. So there is no refreshing of the connection only building of it...

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

Thank you guys so much! I will try and get it sent out to each person to have on their PC. MoLaker, I am not able to import the tables it won't even let me choose the db as the same error pops up. Luckily my boss who looked at it last week was able to figure out that I had left all the...

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

Well I now have a more pressing issue to deal with. My queries dont seem to be working, at all. I have not made any changes to tables or their relationships but even when I create a very simple query I am getting no results returned. At first I though I must have accidentally altered my...

Skip your a genious! It worked until I tried to add more calculated fields, then it doubles the returns again...what am I doing wrong? SELECT DISTINCT [tbl_CSV_name-payroll].Name, [tbl_CSV_name-payroll].Supervisor, tbl_CSV_payroll.Date, tbl_daily_schedule.[Start Time], tbl_CSV_payroll.LogIn...

Skip, tried it still getting duplicate results.

here ya go SELECT [tbl_CSV_name-payroll].Name, [tbl_CSV_name-payroll].Supervisor, tbl_CSV_payroll.Date, tbl_daily_schedule.[Start Time], tbl_CSV_payroll.LogIn, [tbl_daily_schedule]![Start Time]-[tbl_CSV_payroll]![LogIn] AS [Start Variance] FROM tbl_daily_schedule INNER JOIN (tbl_CSV_payroll...

Actually they are both in the Date/Time format - Medium Date in fact.