Search results

Heya all! I have a small problem regarding to excel. I have a formula: =AANTAL.ALS(gegevens!F2:F294;G9)-(EN(gegevens!BA2:BA294>0)) Only this formula looks then at the fields that have the value "0" but my meaning of this formula is that i want to filter those "0" value out and that it counts...

Awsome! Thats it! Thanks alot m8! i couldnt find that around anywhere... LOL!

Well that's a thing what i already know m8 but thanks for your reply! :) What i mean with it is that the access program is running in background NOT visible! So if i click on my database icon that it only shows actually my database and that its not starting Microsoft Access. (Im using...

Hello All! As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(. So first question: How can i do this with a code? Second...

Hello All! I think this will be a difficult question but im going to ask it anyway. Ive tried several ways to open 2 forms. Ok, ive achieved this one by letting a code to open up the Main menu (like where you can press buttons) and the second one is to open a field with the open incidents of...

Hmmmm, ive seen there a code like DoCmd.MoveSize 2000,2000,2000,2000 Only this is actually changing the form and not the position of the form so i didnt help :( thanks for the reply! :D

Ofcourse ive tried to fix it on my own but i still cant get it how i want. ive tried with some codes like Position = 100h or something like that :P but thats only used for images what ive found in the forum. Ive also searched to forum but i cant find anything about the problem that i have...

Hello All! You probably think what the hell does the title mean? Well, i cant explain it more better. What i want to achieve is that i can do a fixed position of a form in Access itself. Example: I start my DB ==> startup screen follows After the startupscreen ==> login screen After logging...

Thanks Larry for your reply (sorry that im kinda late :P) but ive tried your way and the hide my logon form is solved :) only the next problem is how can i achieve that my name is filled in. What do i need to use? Im asking this because ive tried your way but i couldnt make it work so... EDIT...

Ok, sounds logical but how can i achieve that goal? C.

Hello all! Ok, lets get down straight to the point. What i want to achieve is that when i login that automaticly the name has been filled in on every form. I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage...

Ive read your post :) and it still doesnt work :( its very wierd... Well, then ill try to post my db here on the forum. If it is possible... can i also send it directly to you? C. EDIT Dont forget that i have Office XP ;)

Well thanks for the reply :D and ive tested it out ofcourse. When ive put this "code" into a module of microsoft access and then i go to my form to perform the action it notice that it still doenst work somehow. I have read that you have edded the line: Dim dbs As Database Thats already the...

Option Compare Database Public Function SendEmail() PROC_DECLARATIONS: Dim olApp As Outlook.Application Dim olnamespace As Outlook.NameSpace Dim olMail As Outlook.MailItem Dim rstEmailDets As Recordset Dim strSender As String Dim strRecipient As String Dim strEmail...

Hello All! Well ive read this topic and tried it out but unfortunaly it doesnt work for me. I have a problem with the loop. How can i fix that problem?