Search results

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

It also gives an error saying it cannot perform the action!!! Is there any other way to have my report closing without any saving???

Yes, I do modify the design of the report at runtime. The thing is that I want after I print the report to close it without being prompted to save it and of course without having Access saving it. This way the report will remain as designed to work with the code that modifies it at runtime and I...

I have a report which I use as a template to produce reports based on fields selected from a form. I want to disable the save question everytime I close the report so that it will not change otherwise I get errors from the code that generates the report. I used the setWarning method in the On...

Sorry about that but my browser was not responding so I didn't realized that the message was sent.

hey guys! I have a report which contains 10 labels named label1, label2.., label10. I need to go in each of them to set the caption property depending on the fields selected on a form. I am using a do..while loop which sets the caption of a label to be the string contained in the variable...