Search results

Thanks a lot, I will try that out. My one worry though is that many of my files are very large (~30Mb) and import time is an issue. I imagine going through the file twice would make importing twice as long and maybe there will be some memory issues if I try to save the entire file in one...

Here are two very small files.... thanks.

The difference is the line endings. Windows has CR+LF at the end of every line. Unix only has LF. CR = 0x0d LF = 0x0a

I cannot import a linux text file into my access database using the following code... Open spspath For Input As #1 While Not EOF(1) Line Input #1, strline Can I modify my code to handle linux or windows text files? And a bit of background: I have a database where I will be...

Thanks, that did help.

To any readers out there: I guess the answer is no, you can not use a crosstab query as a subquery. It seems strange to me though. I don't know why you can't. It seems like you should be able to.

Thanks a lot Galaxiom... I never would have found that on my own! I hear what you say that users should not look at naked tables or queries... mainly I was just curious. I want to understand things well. It always pays off eventually.

I do not have a Form! I have a query. This is what I am confused about.

How do I access the "Form". All I have is a query and I am viewing it in datasheet view.

I'm trying to improve my understanding of datasheets... I have a query that I saved in my Access application. I can see its SQL as a variable in Visual Basic by typing the following into the immediate window: ? CurrentDb.QueryDefs("TestQry").SQL SELECT Employees.EmpName, Employees.EmpNumber...

It sounds to me like that quote is talking about someone wanting to use a subquery within their crosstab query. I'm actually trying to do the opposite. I would like to use my crosstab query as a subquery. SELECT * FROM (TRANSFORM......PIVOT.....) No luck yet.

Still hoping for an answer, even if it is a negative one. Is it possible to use a crosstab query as a subquery? B. U. M. P. Thanks

Hello, Is it possible to use a crosstab query as a subquery? I'm trying to do the following: SELECT * FROM (TRANSFORM Max(Expirations.DateRequired) AS MaxOfDateRequired SELECT Expirations.EmpID FROM Expirations GROUP BY Expirations.EmpID PIVOT Expirations.EventID) as XtabBut I get an error...

Perhaps you can help me with creating a query object within VBA code? The following code gave me an error: Dim dbsA As Database Set dbsA = CurrentDb() Dim qdfTemp As QueryDef Set qdfTemp = dsbA.CreateQueryDef("tempqueryy", "SELECT * FROM Employees") The error was "Run-time error '424'...

Hello, I'm trying to export a crosstab query from a form in Access to an Excel spreadsheet. Unfortunately the following code did not work: sqlquery = "SELECT * FROM AllPossibilitiesAttendance WHERE isSS" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sqlquery...

I take it back.... It worked, I just had to call the procedure through the form object. Duh! Forms!CreateSpreadsheet.testprocedure Thanks.

Thanks for the reply. Say my procedure is in a form module, and this form is currently open. As far as I understand, any form I create is a class, and if it is open it is instantiated. I still can't run this procedure in the immediate window. Is that normal?

Thanks Pbaldy, Your website was really helpful. And manipulating a Dataset object rather than working with SQL statements was good advice. Here is a snippet of my code in case any forum readers might find it helpful: Private Sub SubmitButtonA_Click() Dim db As DAO.Database...

I am trying to insert multiple lines into a table using a Multi Select List Box. The best solution I could come up with was to loop through each selected item and then run an insert query for each loop iteration. For Each rownum In EmpList.ItemsSelected empIDval = EmpList.Column(0, rownum)...

1) Are there convenient ways to test code from a class module? Every time I try to run a procedure from my class module in my immediate window I get an error "Sub or Function not defined" 2) Is it possible to run a procedure from a class module outside of the class module? I'm imagining...