Recent content by bruceblack

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

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

Hi Minty. Thanks you! Will do.

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

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.

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

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

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?

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

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

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

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

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

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

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