Recent content by johny678

any ideas why i get no results when i use wildcards like '*' to create my recordset???

Very helpful, although I had to alter it a bit! Cheers mate!

Finally, I came up with an answer. You cannot export data based on SQL statements or Recordsets!!!! You need to have stored Tables or Queries. Great!!!

Anyone please help, cause I am too close to the deadline and nothing seems to work!!!

I tried that also and i got the message "An expression you entered is the wrong data type for one of the arguments" The code is: Dim rsRecs As ADOdb.Recordset Set rsRecs = New ADOdb.Recordset rsRecs.Open "SELECT Kartela.* FROM Kartela", CurrentProject.Connection, adOpenStatic...

this is how i call it: DoCmd.TransferSpreadsheet acExport, , strRecs, "V:\Database\Temp.xls", True strRecs is the SQLstatement

I am trying to export data based on an SQL statement but the TransferSpreadsheet returns the error "The Microsoft Jet database engine could not find the object 'select..'". I suppose that is cause it needs to read the name of a table. But I want to export the result of the statement. Does this...

I need to export a recordset to a spreadsheet but "TransferSpreadsheet" doesn't seem to do the work. Any ideas??? Thanks!

Great!!! The fact is that an old db that we were using (developed by a firm) was doing such a thing. Is it possible to generate the report in the db (which is .mdb) that holds the data for the front end and then import it for preview in the .mde file? although I think that you also can't import...

Hi!!! I am using VBA to generate a Report depending on the fields that the user will choose to show up in the report or to group records by. It all works ok, the thing is that I want to deliver the DB as a .mde file for all the known reasons, and this is where the problem is! I cannot open the...

I have a text field for entering dates on a form and I use the BeforeUpdate event to check whether the user has entered a valid date. But it seems that Access wont let me do the check, instead it displays a message saying that the value entered in the field is not valid, so I cannot display my...

I am not sure I understand what you are trying to do but once I wanted to access a subform and i did using the following statement: Forms!MainForm.Subform1!ControlName Hope it helps!

Anyone has any idea about how to filter a form depending on values of a subform??? For example: There is a main form that displays the students of a school one at a time and a subform that displays the courses that each one has selected. A button on the main form opens an InputBox so that the...

Can you be more descriptive???

I created a DB in an old PC of mine for a customer. I set passwords for user accounts to prevent users from accessing the design etc. I bought a new PC lately and I want to open the DB to work in it but I get an error saying that I do not have the rights. I suppose I need to create the same...