Search results

Hello everyone, I just developed an application and now I want to distibute it. I want to work with licenties and I also want to make shure the software can only be installed according to the number of licences. How do I solve this problem?

Thank you guys, Aikeas last solutions works like a charm. I put 2 rectangles on the form. You dont even see a difference in background color. My detailbackgroundcolor is #FFFFFF And I made the color of the rectangle #FFFFFE You dont even see the difference. Thanks guys.

Hello, I have this code. But I guess that I can make it a lot shorter. Can anybody help me? Public Sub ExtraVeldenMedewerkerDetails() strExtraTekstVeld01 = DLookup("LabelWaarde", "tblBEHEER_VRIJVELD_MEDEWERKER", "[VrijVeld_ID]= 1") strExtraTekstVeld02 = DLookup("LabelWaarde"...

Aikea, thanks for your reply bro but I am afraid we ere not on the same page ;-) In the detailssection of a continious form you can set the backgroundcolor for the alternating row. However I want the backgroundcolor of the detailssection only to be a certain width and not span over the total...

Thanks for yur help but I do not understand you. Could you please explaine?

I did it bob!!!! I changed the code and now it works. This is my code now: Private Sub txtMedewerker_ID_LostFocus() If Me.txtMedewerker_ID = "" Or IsNull(Me.txtMedewerker_ID) Then Exit Sub Else If IsNumeric(Me.txtMedewerker_ID) And InStr(1, Me.txtMedewerker_ID, ",") = 0 Then 'MsgBox...

Dear Bob, Thanks again for your quick reply. I adjusted your code so now it looks like this: Private Sub txtMedewerker_ID_LostFocus() If Me.txtMedewerker_ID = "" Or IsNull(Me.txtMedewerker_ID) Then Exit Sub Else If IsNumeric(Me.txtMedewerker_ID) And InStr(1, ",", Me.txtMedewerker_ID...

Hello, Access 2007 has the neat feature where you can set the alternate backgroundcolor in the details section of your form. This is very handy but how do I prevent the backgroundcolor from spreading all over the width of the page?

Does anybody have an idea please?

Thanks guys. Bob, I tried your code and it works just fine. I just dont get the instr statement and why you use it. I also would like to check that only whole numbers are allowed like 1 or 10 etc. NOT 1.2 or 12,4. Anyway I just want the user to input full numbers.

Hello everyone, The thing I want to do is check if the value entered in a textbox is an integer. If it is...then great. If it isn't then display an errormessage. I tried this: If CInt(Me.txtMedewerker_ID) = Me.txtMedewerker_ID Then MsgBox ("It's an integer.") intID =...

Hello everyone, I was looking for a great way to link and relink BackEnd to FrontEnd and I sort of found it. Bob larson build a great extensive tool to autoupdate backend en master frontend. You can find his great post here...

How do I create a submenu?

Hello, I have a label called "lblTest" in mij form header. When I hover above this label I want a rectangle containing textboxes to appear. But when the mousepointer doesnt hover about the label the rectangle must disappear. I tried: me.rectangle.visible = true on the mouseover event. It...

Thank you very much for your help. I am going to use the setfocus solution. Because I dont have that much groups. This encounters another problem which I will place in a seperate topic.

Hello, I have a question but I don't know how to name it. My question is probably anwsered somewhere on this forum but I just don't know how te call it. Ok...here we go: I have a form. On that form there is a long list of controls. The controls are nicely grouped. I want to make a list of the...

List of customers in the northwind database in access 2007

I understand that. But how did they format the formheader. It is red colored that fades. There is no picture in the background. How???

Hello my helpfull friends, I was just looking at the northwind database that comes with ACCESS 2007. How do I get that formheader that is used in northwind. I just can't discover how it's done. Anybody has an idea? Thanks in advance...

I did.. lol