Search results

  1. B

    Two forms with same record source prevent writing conflict

    Who else than isladogs :) Thank you. I did that actually. The problem was that Form-A is a continuous form. So when i am scrolling, and i close it, i have to scroll back to where i left off each time. Which gets annoying fast. I understand that its just not possible other than that? I think i...
  2. B

    Two forms with same record source prevent writing conflict

    Dear friends, I'll keep it short and sweet. I have two forms, with the same record source. Say form A and form B. Form-A is the main form. But Form-B goes into more detail. Both forms are showing completely different fields on it. But once i entered the details in Form-B, close it, and want...
  3. B

    How to change field backcolor in continuous form

    Hi Minty. Thanks you! Will do.
  4. B

    How to change field backcolor in continuous form

    Hi all, I am stuck quiet a bit with a simple little thing i try to do. I have a continuous form with a table record source. All i like to do is that when i select a field (click on a control) the backcolor changes to green (for example). My expected result is that only that one specific field...
  5. B

    Run code while other command (play wav) is still running

    Good one...but! im using SAPI voice. So it uses text to speech from windows from within Access. This because i have different conditions in my forms, and thus different outcomes.
  6. B

    Run code while other command (play wav) is still running

    Hi Isla :) Thanks. Thats clear and confirmed. Good idea, ill just run another instance of Access to play it. The app guides the user through a process with voice. Maybe i could use a webbrowser window....
  7. B

    Run code while other command (play wav) is still running

    Hi everyone! General question: Can you run code and at the same time run another line while the first one is finishing? An example im strugling with is that i play wav files some time. But i would like the user to be able to continue, instead of waiting until the wave file is finished. Is...
  8. B

    Open a form with same ID, but as text string

    Crapdoodle :D , yep early and no coffee Now the form printouts dont work. DoCmd.OpenReport "label1", acNormal, , "[item_ID] = '" & Me.item_ID & "'" i applied the same method :S..... But for reports is ANOTHER different way??? What is going on?
  9. B

    Open a form with same ID, but as text string

    Holy damn. Youre a life saver. My brain must be sleeping somewhere else. Thanks a ton!
  10. B

    Open a form with same ID, but as text string

    Hi everyone. I'm stuck in a basement somewhere and need to fix this but cant find a solution all that quick. I have the following code: DoCmd.OpenForm "itemseditform", acNormal, , "[item_ID] = " & Me.item_ID But the item_ID has been converted intentionally to a text string. What is the right...
  11. B

    How to lookup last record id and take value from another field of that record

    Ah thanks gasman :) I looked up combining them. Got it to work. Final code: stringname = DLookup("NumberNeeded", "table1", "[ID] = DMax('[ID]','table1')") Thanks!!!!!
  12. B

    How to lookup last record id and take value from another field of that record

    Hi everyone! Some basics that i cant seem to find if its out there. Ive been searching but cant find it. Maybe someone can explain? I have a table with an "ID" field and a "COUNTRY" field. How can i get the highest ID, and get the value thats in COUNTRY of that record? I would like this in...
  13. B

    Constuct unique id number counting up

    Hey guys, Sorry for the late reply and thanks for all answers! The thing is. I want it to keep a 7 digit number. So the last 2 numbers, can only go till 99, if you catch me. I understand how to put the numbers together. I will never have more than 99 parts in 1 week. So it would be great to...
  14. B

    SAPI text to speech change language setting in VBA

    Hi Isla! Thanks for your help. The problem is that i can not set any other language on the windows systems. They NEED to be in English. That's one of the reasons i wanted to try if i could do it with VBA. Because i am able install language packs strangely enough. Yes, for Dutch users, i will...
  15. B

    SAPI text to speech change language setting in VBA

    Ah cool! Thanks for that. Its useful. Yet, i cant find anything about changing the language in VBA.
  16. B

    SAPI text to speech change language setting in VBA

    Hi everyone! I'm using the following code to have some text to speech in my database: Dim objSpeech As Object Dim strPhrase As String Dim intPitch As Integer Dim intRate As Integer Set objSpeech = CreateObject("SAPI.SpVoice") intRate = 1 strPhrase = "Hello World" intPitch = 1 objSpeech.Speak...
  17. B

    Constuct unique id number counting up

    Hi man. Thanks Well we add product to a list which needs to be quickly identified with a number like this. The year, the week it was added is important for us, and there are multiple products a week...so i need an additional number. Usually there are around 15 to 20 products a week. So...
  18. B

    Constuct unique id number counting up

    Hello everyone. I would like to know how to partially make a unique number, but also count up. Which is the part where i have trouble :) Maybe someone can help me along the way with this? what i have now is: Dim newnumber As String newnumber = "I" + Format(Date, "yy") + Format(Date...
  19. B

    If value greater then on form controls does not work

    Cool thanks! Indeed, my scanner itself sends an enter after scanning. So thats covered. But you have an idea on how i should do this without the dlookup?
  20. B

    If value greater then on form controls does not work

    Right, its exactly the same situation indeed as before. So i need to do a Dlookup on the query field (difference) ? Im lost... Dim varX As Variant varX = DLookup("[difference]", "compare_all_q") If varX > 0 Then MsgBox "too many" End If...
Top Bottom