Recent content by matstars

I am the only person with an access (ver: 2003) license in my department. I created an application for my department - it is housed on a shared drive. What is the most cost effective way to distribute it to my department? There isn't a runtime that you can produce without having a...

Dim varDate As Date Dim strSQL As String varDate = Text1 strSQL = "SELECT Employees.Name, Round((((CDate(" & varDate & "))-[IndustryStart])/365),3) AS WorkYears FROM Employees;" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, ?????, "OutputFile.XLS" What do I put for the ????'s ...

I really don't know what you are talking about? I can't just store a query to a string and then have it run the query and output it to excel - seems simple enough? no?

Doesn't seem to work? Dim varDate As Date Dim strSQL As String varDate = Text1 strSQL = "SELECT Employees.Name, Round((((CDate(" & varDate & "))-[IndustryStart])/365),3) AS WorkYears FROM Employees" DoComd.TransferSpreadsheet (strSQL) is my code, Text1 is a textbox with 1/1/2000 in it I get...

Doesn't seem to work? Dim varDate As Date Dim strSQL As String varDate = Text1 strSQL = "SELECT Employees.Name, Round((((CDate(" & varDate & "))-[IndustryStart])/365),3) AS WorkYears FROM Employees" DoComd.TransferSpreadsheet (strSQL) is my code, Text1 is a textbox with 1/1/2000 in it I get...

I have a query with that has a variable (it’s a date – more on this later) The table that I am getting the info from is called Employee, it is flat it just has “Employee Name”, “StartDate.” It has about 50 records in the table. I’m doing this to learn Access’ logic before I tackle...

I have a query with that has a variable (it’s a date – more on this later) The table that I am getting the info from is called Employee, it is flat it just has “Employee Name”, “StartDate.” It has about 50 records in the table. I’m doing this to learn Access’ logic before I tackle...