Search results

In my company we just bought a new computer (quad core, 4 GB memory). It runs windws 7 but in french and also the office 2007 is in french. What I've noticed is that any report I run takes about 30 seconds to open and on other computers it takes 2/3 seconds. I've updated office 2007 to sp2 but...

Hello I have a similiar problem. I have a access project that runs on several computers with diferent operating systems. On a computer (that has Windows Vista and Office 2007) I receive a error message (type mismatch) and the line of code that throws this error message is the line where I set...

I just found out how to solve this problem. I can pass a sql string with dates working on any computer regarding of the regional setting. I have to format the date "yyyymmdd". If you know any other solution please let me know.

It works, thank you very much, I'm sorry about not reading the previous post, I actually just glanced over them and thought that it is not what I’m looking for, sorry again. Now I have another question (I hope this one isn’t as silly as the last one  ) With the filter that I have created above...

Hello I have a problem when trying to apply a filter to a form on a oc that is running Windows 7 and Office 2007. (On other pc that run Windows Vista or XP I don't have this problem regardless of the office version (2007,2003)) code: DateStart = InputBox("Enter Start Date " & vbCrLf & vbCrLf &...

I need help with dsum function. I have a form that the user will filter. At the footer of the form I have a textbox and a button, when the user presses the button I want to change the controlsourse of the textbox but unfortunatly it give me a error saying #Name? Here is the code...

I found out that access has the date=0 in 30/12/1899 and sql has date=0 in 01/01/1900. I don't know if this date applies to all version of access :confused:

Hello I have a problem and I don't know how to sort it out. Why when I convert a date value to double in access vba I receive a value and when I convert the same data value to decimal in sql I receive a diferent value. Example: Access vba dim data as date data=date (today is 04/01/2011)...