Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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+" & _...

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

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

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

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