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

    From 32 to 64 bits ><

    Hey, I don't want to take a whole lot of your time, I am simply looking for a good article on how to design or tweak a code for it to work on 64bits and 32 bits machines. To put you guys into context I have designed about a year and a half ago a sort of database for timesheet / projects, in...
  2. ItIsHardToProgram

    Looking for criticism.

    Hey, I have recently designed a macro in order to split a cell arithmetic into mutltiple cells. This is a quite simple concept, but I found the time it took to design this, what I would think, "simply" macro, was quite arsh, I put around 5 hours on this, and I realize that my lack of experience...
  3. ItIsHardToProgram

    Hungry for knowledge!

    Hey, I am currently working as a bug fixer, and the lack of questions sometimes bore me out. So I figured I would try to add to my VBA knowledge. The only place that I know off to learn about programming, and learn it well I might add, is to read on these forums. Could any one suggest some good...
  4. ItIsHardToProgram

    GROUP BY - aggregated function

    Hey every one, I have been reading in the past hour to try and find a way to GROUP BY a LEFT(field,#). i.e.: SELECT Left(T.IdProjet,7) AS ProjetSommaire...
  5. ItIsHardToProgram

    Vba Query - unexpected error

    Hello all! I have a query that is running fine in the Access query, but that is throwing me an error in the VBA environment. This is the query: SELECT Left(T.IdProjet,7) AS ProjetSommaire...
  6. ItIsHardToProgram

    VBA Query - Filtering

    Hey every one! I have a question about possibilities with VBA queries. I was wondering if it was possible to strip a specific field from its few last characters in a query. The environment is access. For example, the specific field looks like 20080512-1-5-2. Every '-' is a seperator for...
  7. ItIsHardToProgram

    Input masks for Excel 2007

    Hello all, I am wondering if there is a possibility to do an input mask in excel that will return the whole mask as a value. i.e. the cell would show like this: _______-_-_-_ The user would have to enter full 7 digit, and the 3 other digit in order for the cell to update. The cells would...
  8. ItIsHardToProgram

    Using WHERE / BETWEEN with dates

    As I have been suggested, I am posting my problem in a more appropriate forum. I am trying to use the between clause with dates in a VBA generated SQL. I have the following code wich errors on the DoCmD. Option Compare Database Dim dDateBEG As Date Dim dDateEND As Date Private Sub...
  9. ItIsHardToProgram

    WHERE / BETWEEN for dates

    Hello! As my thread indicates, I am trying to use the BETWEEN function with 2 dates in SQL. I had a feeling I had to convert the DATE to numbers and then reconvert to DATE. I am wondering how to proceed when using the CAST in order for this to work. This is my code that isn't currently...
  10. ItIsHardToProgram

    Array error - VBA

    Hey again, I don't want to double post, but I made the other thread messy and this is a different issue (I believe they are both related). I am getting random errors when running the code. When I say random I mean the following: When I open access, First time I run it, it runs smooth...
  11. ItIsHardToProgram

    VBA access - Evaluate error

    Hello all!, I am getting the following error: execution error 50290, Evaluate object method failed. when running the following code: Do For Each ws In Sheets(Array("JfSommaire", "MaSommaire", "MartinSommaire", "BrunoSommaire", "JimSommaire", "NancySommaire", "GuillaumeSommaire"))...
  12. ItIsHardToProgram

    Error - subscript out of range

    Hello, I have applied a script given to me by SkipVought, who is alot of help always, and I am getting a subscript out of range error on the following line: For Each ws In Sheets(Array("BrunoSommaire", "NancySommaire", "JfSommaire")) The overall code is the following: Function...
  13. ItIsHardToProgram

    Dirty dirty loop

    Hey everyone! I programmed a VBA "manual" loop to store some specific query related data in an excel spreadsheet, where a specific criteria matches. It is very dirty, and before I run it and try it out, I want to make sure this is the best way to do what I want to do. I seriously doubt it, and...
  14. ItIsHardToProgram

    Database cleaning through excess

    Hey every one, this is a followup of my conversation in microsoft access JET SQL forum: Converting text to number in access What I am trying to do is to have a macro that modifies or removes the data accordingly to the excel sheet through DAO in a access database. I am trying to find out wich...
  15. ItIsHardToProgram

    Converting text to number in access

    Hey, I am not sure what section is best to start this thread, but I believe the solution to my problem will reside in queries... Let me start off by explaining what I have. I currently have a database that stores the number of hours an employee spends on a specific project (in access). The...
  16. ItIsHardToProgram

    SQL Function problem

    Hello, I currently have a SQL for my database that sorts out some data, innerjoins it and groups it in the same time. strSQL = "SELECT T.IdProjet, P.TempsPrevue as Budget, Sum(E.SalaireHoraire*((T.Lundi)+T.Mardi+T.Mercredi+T.Jeudi+T.Vendredi+" & _...
  17. ItIsHardToProgram

    Query does not run ?

    When processing the following query access freezes and then closes. SELECT tblTimeSheet.IdProjet, sum(tblTimeSheet.Lundi+tblTimeSheet.Mardi+tblTimeSheet. Mercredi+tblTimeSheet.Jeudi+tblTimeSheet.Vendredi+ tblTimeSheet.Samedi+tblTimeSheet.Dimanche+tblTimeSheet...
  18. ItIsHardToProgram

    Query through VBA

    Hello, it is me again! I am trying to apply something to the working and optimized query (thanks to PHV). I have a code that selects a employee number, in a form, and then tries to run the query through VBA, with an ADDED WHERE statement, the code goes as following: SelectEmp = No_Emplo...
  19. ItIsHardToProgram

    Access Query substraction

    Hello Everyone, I am looking for some one to help me with my access query that is currently not working... The database infrastructure goes like this: TblTimeSheet tblprojet tblemployer Idprojet IdProjet IdEmployer Idemployer TempsPrevue SalaireHoraire Lundi Mardi...
  20. ItIsHardToProgram

    Linking excel to access

    Hello every one! It is a nice summer day today, wich makes me happy! Ok, down to business... I am currently working with a consultant on a project, the project is simple, he has to link excel sheets to an access database, thus with the sheets that have been provided to him: Time sheets...

Part and Inventory Search

Back
Top