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

    server 2008 to access 2010 query conversion?

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

    vba select location of .csv file then run import to excel

    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?
  3. lisagippe

    vba select location of .csv file then run import to excel

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

    vba select location of .csv file then run import to excel

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

    vba select location of .csv file then run import to excel

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

    Checkbox as query criteria

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

    concatenate text field suggestions

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

    "The database is in an unexpected state" any ideas?

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

    "The database is in an unexpected state" any ideas?

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

    report groups on different pages

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

    query date range problems

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

    query date range problems

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

    query date range problems

    Skip, tried it still getting duplicate results.
  14. lisagippe

    query date range problems

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

    query date range problems

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

    query date range problems

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

    Locked database won't unlock

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

    adding multiple time cards in time format that will be over 24:00

    Sorry for the delay, but thank you it works beautifully!! You guys have been such a huge help I can now finalize everything and show Management, thank you thank you thank you!!!
  19. lisagippe

    adding multiple time cards in time format that will be over 24:00

    No problem, let's see if this helps. Save: ([TotalTime]-[Lunch Time])+[Sick1]+[Vac1]+[Flt1]+[Other1] [Save] gives me an agents total hours for a given day including sick, vac etc. It is returned as a decimal value, for an employee who works an 8:02 day it returns 0.33472222222. This formula...
  20. lisagippe

    adding multiple time cards in time format that will be over 24:00

    Save is just a general# calculated field, it contains some minor adding and subtracting of other fields. None of which are date/time formatted. 24*Int([Save])+Hour([Save]) & Format(Sum([Save]),':nn') This formula converts it to a time format. The formula I am having trouble with should be...

Part and Inventory Search

Back
Top