Search results

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

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

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

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

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

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

Hi everyone, Ive never had this problem before and im completely at a loss of trying everything. Really need some support because its getting shameful :P I have a subform with a few fields. I want to compare 2 of them and get a result. My subform has a query as a control source. My subform...

Hi everyone! Small problem. Im trying to set a reminder (working!) But i get error that saving and going to new record is not available now. Why is it such a problem to run this after my reminder code? I can't seem to find the problem reading about it. Anyone can explain? Cheers!!! Dim...

Hi everyone! Busy with a new project here. Just the technical approach i would need a little hint on where to go from here. I have a table with registered products and their location, and i have a table where i scan the products and their location. I would like to build a form that shows what...

Hey guys! Hope you can correct some syntax here. Im a bit lost. :p I have a continuous form. I have a query with a (count) field which i want to display on the form So i do a Dlookup to get the value. Problem is, it only should do the counting for that specific ID. I was trying this...

Hello everyone. I have a form with a button that has the code below under it. I'm sending an outlook reminder to myself with it. Work perfectly fine. But, how can i send it to multiple users? I searched around and no solution seems to work. Also do i need a special reference for this? Cheers...

Hi folks. I have NO clue if this is a bug or not. I have a query with in a column (short text) that has a few numbers and sometimes it has X. I want to exclude the value X. So in the column criteria is put Not Like "X*" This does work, but if the field is empty, it also filters it out! Why...

Hey guys! Would be great if i can manage this little problem. Which is annoying for the "dummy" guest users :p Im opening Access from another database through a hyperlink. (yes! this needs to be done in my case) It closes the database and opens the "other" database (Expd 2016). I want Expd...

Hi folks! Little stuck here. Some help would be very much appreciated :) I'm trying to open another database from another. There's many threads on this and tried them all with the same result :banghead: When i open the database, it tries to open the other one, but keeps looping and opens...

Hi guys! I was wondering if its possible to have the following query criteria: I have a datefield and a timefield. I would to include - Todays date - Also the date minus 1 day - Where the minus 1 day only between 00:00 and 03:00 Am This has to do that we work till 3 am every day and the query...

Hi everyone! I have a question i hope you call all help me out with. I'm completely stuck here :S. The code below is working, but it skips the first record it goes through it seems. What im trying to do: it needs to loop through "shipments" table, find if the answer is "Yes" and if so, put an...

Hi Everyone!! I know this is somewhat a much about spoken subject. However every solution is find is not exactly how i want it. Some advise would be great :) So i have my attachment field, but is there a way to just send it, instead of storing it on a drive first? All other solutions save the...

Hi everyone! I have a general problem i desperately need help with. Thanks in advance! So, i have this problem in multiple databases i made. So i would like to keep this topic kind of open to get the basics right. I have update queries. They all work fine on their own. Example...

Hi everyone! Stuck here defining weekends en exluding them in my query. I have 4 fields in my query: inbounddate and outbounddate, and inboudtime and outboundtime. I COMBINED these fields in my query: combistart and combiend. The formatting of these 2 fields looks like this: 5-1-2018 9:04:42...