Search results

Certainly. It's PW protected - not to be lame, but It's just a personal preference :) I'm sending the PW to everyone who has helped me yet and to anyone who helps in the future.. Thanks! BTW - frmAnime is the main form..

I get this error: -2147352567 80020009 Me!sub.Form.EpID = "Episode " & -Format(EN + (StartEpisode - 1), "0") I'm note sure why this error is occuring. It says something about the input not being valid for the field.

BTW here's a screen of the form.

Okay, the referance method was wrong. It should be Me!Subform1.Form.RecordSource Which makes Me!frmAnime_Delskjema_EpReg_Delskjema.frmAnime_Delskjema_EpReg.EpID ? Still get an error when trying to add episodes: Me!frmAnime_Delskjema_EpReg_Delskjema.frmAnime_Delskjema_EpReg.EpID =...

Thanks for the reply! It doesn't work, though. I've tried to adapt it to my setup, but still get an error. I use a form with a subform for registering new episodes - which pops up and searches for an ID to match the active AnimeID. I've placed this code in the Popup_sub: Option Compare...

Thanks for pointing that out for me.. I've scrambled up some code and surprisingly, it doesn't work. Private Sub Kommando12_Click() Dim db As Database Dim txtFrom As Integer Dim txtTo As Integer Dim x As Variant Dim rsEpisodes As Recordset Set db = CurrentDb Set rsEpisodes =...

I've searched this forum, other forums and googled, but can't find any specific info regarding this coding. I'm really nothing but a novice VBA coder. I would greatly appriciate links to examples of code, or any help to write the code. Thanks.

Thanks for the response. I've found a few posts, by using the keywords you supplied me with, and I think this is one of the closest. I don't have much experience on the coding, unfortunately, but I'll try to cook something up based on the info I've got so far. So, basically, I need to make some...

Hi, I know this is a fairly easy one. I really try to avoid asking answered questions, but I've honsestly searched through the forum with no results.. I have three statuses: 1 = Ongoing 2 = Complete 3 = Dropped I want to force status 2, if IIf([EPsDL]/[TotalEps]=0;2;""), so that it would force...

Hello, I've been searching the forum for a macro or module, that lets me add a set of records, based on a filled template. Let's say I want to add a number of episodes to a TV show. What I usually do, is launch excel, and type in "Epsiode 1" and just use autofill and drag down the anchor so I...

That worked perfectly, thanks alot Gizmo! It has much more code than I would've thought was needed, which proves I have much to learn.. Though I only understand about half of the code, I can see what it does much easier, since it's based on my own DB. Thanks again, I have atleast a dozen places...

Certainly! When you look at "tblAnimeCategory", you may see that I need some sort of a WHERE expression to filter out those categories that don't match the anime. Thanks alot for looking into this. I had to split the database up with winrar.. Just change the extension of part01 to .EXE, and...

Yes, but I'm not sure where you are going with that.

Hi, thanks for replying. I've been doing some tests lately, and I'm pretty close. By setting strSQL = "SELECT qryAnimeCategory.SjangerType FROM qryAnimeCategory", it lists up ALL records, so it looks like this: So, what I need is the WHERE - as you wrote in the previous post. However, I can't...

Heisann, Det fungerte veldig bra - tusen takk for hjelpen! Lærte en nyttig regel der. Det er utrolig morsomt å se at ting begynner å ligne det bildet man har forestilt seg :) Thanks alot, that worked out fine! An important lesson learned there :)

[solved]Dcount: Combining two criterias - stuck Hey, I'm trying to calculate the number of episodes downloaded from one animation series. I've managed to find two working criterias, but I fail to combine them: This counts the total amount of episodes for each induvidual anime...

Thanks, that seems to be exactly what I'm after! - but I fail to rewrite the code, since I basically have no idea how :P I understand some of logic in it, but that's all.. I would really appriciate you could explain how to rewrite it.

Hey, I'm trying to find a way to combine categories in a many-to-many enviroment and make a single sentence, listing them up. I've looked around the MS web and googled, but got no solid results yet.. Here's the DB Anime ===== AnimeID AnimeTitle AnimeCategoryList =============...

Thanks alot! I've managed to get the =[column1] & [column2] thing to work, by using queries - great! I haven't managed to find any solid info regarding IFO - I'll return to the thread later.

Thanks alot. I've found a way to use the [tablename] & [tablename] in queries - and it works great!