Recent content by brunces

petehilljnr, I can't remember if I ran a query without the table, but I admit this could've happened indeed. And certainly that's the reason why my queries were stuffed up, as you said. I've tried your last code and it works fine. I really had no problem with it. Just one more little doubt...

petehilljnr, Hi, buddy. I'm sorry, but I really didn't understand your corde. :confused: You've put a Private Sub inside another Private Sub with the same name... Else, what about that Function at the bottom? Sorry, I'm kinda confused. If you don't mind, could you please rearrange it or post...

Friends, Please, help me with this... I have two files: main.xls and main.mdb. main.xls has one single sheet (SheetData) main.mdb has one table called (tblData) I have to LINK main.xls (SheetData) to main.mdb (tblData). To do this, I have a form with a button (bttLinkFile). Private Sub...

Thomas, Have you tried creating a query and putting the words "Is Not Null" (without quotes) under the field "Notes"? It should work. Unless you need something different (via VBA or something). Hope it helps. Hugs, :) Bruce

SpeedThink, Could you upload your file for us to take a look at it? Maybe we could help you better. :)

raskew, 'Hugs' mean 'hugs' in Brazil and, not necessarily, mean physical relationship. Using the word 'hugs' at the end of a message is a gesture of politeness or gentleness (not 'gayness' as you might have thought). Now, tell me, raskew, being polite or gentle means something different in...

namliam, This method of yours is very cool and works very well. Now I understood how it works. Thank you very much for your attention. I appreciate it. Hugs, Bruce

You're welcome, halem2. I'm glad I could help you. :)

Try this, then... Declare a new variable like this one: Public intMissData As Integer Add this to that function of yours: intMissData = 0 (For each missing data, make your function do: intMissData = intMissData + 1) Add this to the BeforeUpdate event for your ListBox: If...

SpeedThink, When you say the user can go to the next record, do you mean it by clicking a button (Next)? If so, maybe this can help you. Declare a new variable like this one: Public intMissData As Integer Add this to that function of yours: intMissData = 0 (For each missing data...

Adzi, Take a look at this. http://www.access-programmers.co.uk/forums/showthread.php?t=124364 Look for my replies (specially on page 3). I don't know, maybe it can help you. :) Hugs, Bruce

halem2, I forgot to say... In your unbound control (TextBox), you should use it this way... =DLookup("[UserLevel]";"tblUsers";"[UserUser] = '" & [LoginUser] & "'") No need of VBA here. Just put this formula above inside a TextBox. Obs.: My MSOffice is in Portuguese and some functions use ";"...

halem2, I've been thinking about your login... The user Admin can access any of those two forms, right? Admin is always "the man". (lol) So, that would be nice if you had a special level name for Admin and give him the option to choose what form to open. Maybe you should have a special menu for...

halem2, Hi, buddy. Sorry, I hadn't seen the message you sent me. :) Take a look at this file. Hope it helps you. :) Hugs, Bruce

namliam, I respect your words, but believe me, when I put a question in a forum, it's because I've already tried everything I know, but really couldn't make it on my own, unfortunately. And, believe me again, I wish I knew how to do everything I want by myself, without asking for anybody's...