Search results

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

Simon MT, I agree with you. If the DB gets the username from Windows, there's no need to ask who is going to use the DB. On the other hand, password is important anyway. Without password confirmation, anyone else can use the computer and mess with the DB. With password confirmation, only the...

I'm sorry, namliam, I'm a beginner. I really couldn't figure out how to do it using only the DoCmd.OpenForm. :( If you don't mind, please, show me how to do it with an example. :) Thanks for your attention. Hugs, Bruce

halem2, Take a look at this file I've created for you. :) I hope it can help you. Don't forget to create security levels for the users (if you need it, of course). Hugs, Bruce

Friends, Please, tell me if it's possible and how to do it. - I have 1 table (tblProducts). - I have 3 queries based on that table (qryProd1, qryProd2, qryProd3). - Those 3 queries have the same structure, they are identical, but each one has different criteria for filtering records from...

halem2, I'm not sure if I really understood what you want, but here's what it seems to me it's happening with you. (Maybe I'm wrong. If so, discard my reply, OK?) :) Last year, I created a little DB file with the same login form you've created. I also had to pass the username value from the...