Search results

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

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

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

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

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

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

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

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

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

I want to use a public variable called myFilter which takes values from a form called searchForm and then use it in another form to produce a report with the same filter. The problem is that I cannot make my variable work as public although I declare it in the General level. Any tips or even...

I am trying to copy and .mde file along with the .mdb in my laptop from the office server. When I try to open the database I get the message "Required type library or wizard is not a VBA project". Wherever I click on the start up form I get this message. I don't think that it is a matter of...