Search results

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

This definitely seems like an easier way to do this than I was trying. I have a couple of questions. First, where do I actually insert this code? should I put it in the button's OnClick event or should I put this in a module and run it with a macro? Also, I understand how this will write...

I'm currently working on a db in access and need help with some VBA. I have a form that has more than 10,000 records. There's a button on the form that can search for a specific record by entering the userID. I wanted to know if there's a way of generating a spreadsheet from a specific...

sorry for the late reply. But I actually figured it out on my original db. the DoCmd.OpenReport method seems to work good! Thanks again for all your help

I wasn't able to post the original database, but this one will work. If you just look at the EMPLOYEE table. Let's say that the employee table contained 500 records and some users had multiple products installed on their computers. I want to be able to create a way to just enter the user Id...

That made sense but it didn't seem to do much. Not sure what i'm doing wrong. I'm actually trying to do this: -I want to be able to click on the macro so it gives me a message box asking me to input the user id. -Once I input the ID, a list of computers and programs show up that are...