Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MoulayKool
  • Order by date
  1. MoulayKool

    Letter vs Characters

    Hi All, Yes, all the above codes work. The reason I was having trouble is: I am looking for the text box to only allow 8 or 11 character. in other words once the user reach 8 then the text box should not allow him to enter anymore. And the same goes for 11 characters. Your code allows the...
  2. MoulayKool

    Letter vs Characters

    thanks so much for your idea but it's sitll not working. This is what I put: Private Sub Text53_BeforeUpdate(Cancel As Integer) Dim Txt As Property Set Txt = Me![Text53].Properties("Text") If (Chr(KeyAscii) Like "[A-Za-z0-9]") Then If Len(Txt) = IIf(Txt Like "#*", 8, 11) Then...
  3. MoulayKool

    Letter vs Characters

    I realized that I put the code in Form_BeforeUpdate, I changed to: Private Sub MemberID_BeforeUpdate(Cancel As Integer) If Len(Me![MemberID]) <> IIf(Me![MemberID] Like "#*", 8, 11) Then Cancel = True Exit Sub End If End Sub But still not working, not even giving me an error message.
  4. MoulayKool

    Letter vs Characters

    This is what I put: Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Me![Member ID#]) <> IIf(Me![Member ID#] Like "#*", 8, 11) Then Cancel = True Exit Sub End If End Sub
  5. MoulayKool

    Letter vs Characters

    Thanks It did not work for me. When I try to enter an id the text box allows me to enter as many as I want..
  6. MoulayKool

    Letter vs Characters

    Hi, Can anyone help me Please I need to make a text box allow the user to enter member id like this: if the member id starts with a number then id lenght must equal 8. Example 16466851 If the id starts with a letter then id lenght must equal 11. Example JYW37125T01 Thanks in advance Moulay
  7. MoulayKool

    Open Report using a form

    Beautiful. Excatly what I am looking for. I learned something new today thanks to you fneily. ragnarok75, The site you recommended is great, it looks like I'll be learning a lot using it. Again thank you both. Ismail
  8. MoulayKool

    Open Report using a form

    fneily, thank you much for your help.. I am stuck..Please bear with me I am not an expert in vba. 1- I created the union query 2- created the form put the drop down box 3- placed the query on the ROWSOURCE of the combobox all 3 steps are working perfect. My question is: Do I put your code...
  9. MoulayKool

    Open Report using a form

    Thanks so much.
  10. MoulayKool

    Open Report using a form

    Hi, I need help creating the following: How to open a Report using a form (the Form contains 1 drop down boxes to choose from). Form1 contains a button that opens another form (form2) with 1 drop down box. Form2 contains drop down box and a button to open the report. The drop down box...
  11. MoulayKool

    error message

    thank you.
  12. MoulayKool

    error message

    Hi, would be helpful to just create the objects that we have created in another copied database instead of recreate the entire database? thanks
  13. MoulayKool

    Month End date

    Hi, This will also do it: =DateSerial(Year(Date()),1+Month(Date()),0)
  14. MoulayKool

    error message

    My operating system is Win98. do you think that changing my operationg system to xp will get rid of the problem?
  15. MoulayKool

    error message

    It doesn't highlight any line of code. The Form is using macros to run and you know with macros you can't debug like vba.
  16. MoulayKool

    error message

    Yes. Also I have access to the database through Network Destop connection. thanks
  17. MoulayKool

    error message

    Hi, Can any tell me why I am getting the following error message: The expression on open you enterted as the event property setting produced the following error: error accessing file. Network connection may have been lost. *the expression may not result in the name of a macro, the name of a...
  18. MoulayKool

    compile error

    Maybe this: You’ll need: - the Acrobat PDFWriter software on your machine. - Your own version of the Get/Save registry setting calls below Note: this is a chopped down version of my real code just to show the salient points. You’ll need to adapt this to your own context. I don't know what...
  19. MoulayKool

    compile error

    Hi, I am not an expert in vba.Can anyone tell how to solve the following error. I am trying to export an access report to pdf but i am getting this error: Compile Error sub or Function Not defined This line is highlithed: GetRegistryString Here the whole code: Private Sub...

Part and Inventory Search

Back
Top