Search results

Ooh... great. thanks 4 your help. :) Can i become genius like u. :( thanks again.

sure. thanks . hopefully we can learn successfully. :D

OK.. i already used your code. But I'm not sure whether I put it correctly. here i attach the db that i create. DB.mdb is example with 1 list only (color) and DB2.mdb is example with 2 list (color and shape). there is no problem with DB.mdb. only DB2.mdb got error. hopefully u can help me...

Hai. U can try my sample db at here: http://www.access-programmers.co.uk/forums/showthread.php?p=819474#post819474

Hai. I love to help. But I'm also a Beginner User and my English also bad. here i put sample db that i make by combine all knowledge that i get from this forum and other website.

Thanks. You are very kind. I'm very appreciate with your help. I will try this code first. any happen i will let u know. Thanks again.:)

ooo.. thanks for suggestion. how about if i want have 2 different list, not 2 list of color. for example color and shape.:o

new question. as we know this code is for one list only. can i make it with 2 list. for example i have 2 color list (lstFavColor and lstFavColor2) Original code: ' Check for Colors in multiselect list For Each varItem In Me.lstFavColor.ItemsSelected varColor = varColor &...

Thanks. jsv2002 wiklendt now i learn something new.

i get this example db from my friend. i try to play with it to learning more about queries. i need help from anyone can teach me. the question is, how to make it open the report on the current filter. Option Compare Database Option Explicit Private Sub btnClear_Click() Dim intIndex As...

So that mean I have to use this code: Me.RecordSource where should I insert this code?

I try to upload my file. But it fail. Then i make a new one using same as my database. so hopefully u can help me to solve the problem.

I see.... Sorry about that.. before insert the extra code.. it's working fine. but only after insert the extra code it's come out with the problem I'm mention above. Where should i get the bookmark code or with what code i should change it. Can i replace it with the form name...

Sorry. how to declare it. Im already put the code like ur.

I used this code in my database: ************************** Private Sub cmdAddImage1_Click() On Error GoTo cmdAddImage1_Err Dim strFilter As String Dim lngflags As Long Dim varFileName As Variant Dim strBookmark As String strFilter = "All Files (*.*)" & vbNullChar & "*.*" _...

Thanks Boblarson. It work 4 that file. Can I use this code for another database, if can ...should I change any part of this code? As a beginner I'm not really expert with the code.

I can't imagine ur problem! please more detail or put some attachment example.

Maybe u don't close the table properly or maybe the table just minimize not close. Please check this. Why don't u just used the command button with hyperlink.

I try to follow the example in 'attachment' file to insert the image. The problem is after insert & update the data the form jump back to first data. Thats mean if I want to insert another data after insert the image so i have to search back to the previous data. Anyone can help me to solve...

So that mean I have to use this code: Me.RecordSource where should I insert this code?