Recent content by aatrv

wow that was stupid of me to ask that lol I should've known that... but yes it works perfect now, Thanks guys! :)

I tried that..it doesn't seem to work :/ there's an error that comes up saying: "Query must have atleast one destination field"

oops...forgot to attach the database lol here it is

I'm attaching a simple database to this post. I'm still a rookie at Access and I'm trying to figure out something simple. Basically, I have 2 tables: tbl_allusers and tbl_impusers. tbl_allusers has all the users registered in the system and tbl_impusers only shows the users that are important...

Sorry for the late reply. I just wanted to say that I used the code that delikedi provided me and it works perfectly! Thank you all for your help :)

Yes it still highlights : "Set rstBooks = Me.RecordsetClone"

Ok so i added that from tools > reference. When I did that, it says "Name conflicts with existing module, project, or object library."

I placed my whole code under Option Compare Database. I clicked on the button in design view, then clicked property sheet, onclick, event procedure, and then I pasted the code there. Here's exactly how it looks Option Compare Database Private Sub Command28_Click() Dim rstBooks As...

hmmm that's strange. I've changed both things you said and i still get that same compile error. I did not see any logic errors. And yes, i am using this code as the Onclick event of a button.

Do you know how I would do that in Access 2010? This link shows only for Access 2000 or 2002

When I tried that, it gives me a compile error: "method or data member not found." And the following is highlighted: Dim rstBooks As Recordset Dim lngBookCount As Long Dim i As Long Set rstBooks = Me.RecordsetClone If Not rstBooks.EOF Then rstBooks.MoveLast rstBooks.MoveFirst...

Hello. I'm a beginner at Access and i'm currently using access 2010. I have a report in access that contains records of authors and the books they have written. I want to be able to filter the report by author name and then export the filtered results to an excel template I have created. I...

I'm not too familiar with access actually :/ I just recently started using this for my internship. By the way, yes the records are listed in a subform that looks like a "page". I'm using Access 2010. When I search a user, his record comes up and at the bottom left of the form you can see...

Actually, you can ignore my last comment. I figured it out! it shows up just how I wanted in excel. :) Now I have one question. When I search a record on my form, it sometimes comes up with more than one page since theres more info for some records. For example, Person A is incharge of 20...

hmm...seems pretty easy, but for some reason I keep getting an error. When I press debug, it highlights what I have in red below. not sure why because I did create a template, named it "MyTemplate.xltx" in the C drive. Also, since I will be using objXLSheet.Cells.Range("B2") = txtCustomerAge ...