Search results

The real challenge with this project, is how to make access and the cmdline-window communicate. For instance, when encoding video, the command-line window is continously updated. It shows the encode rate(fps), how long it's been working and how much it is left of the process. Is access capable...

Hello! I'm designing a database for running batch-jobs on my server, for use with everything from encoding video to zipping. I've made a couple of databases already, but my knowledge is limited. I therefore need some guidelines on how to design this DB. Functions The idea is to have a basic...

A slightly late reply from me here - but if you still need help, post a reply or send me a PM :)

Thanks alot ShaneMan, that worked perfectly! I failed in some logical aspects there, as I thought about having the list requery as the textbox content changes - as with the search-textbox I'm using. Turns out that only works when you input something in the textbox. I knew it had to be an easy...

Hey, ShaneMan, thanks for replying. I'll try to post some more info. The list is a standard list, and it's the basis of my form. In the rowsource of the list, I've got these: Like "*" & [Forms]![frmAnimeFansubber_Updater]![Search2] & "*" to search for names. Like "*" &...

Hi, thanks for replying. I'm indeed trying to update the searchlist. As I change my selection in the option group, so does txtOptionResult, but I fail to make the filter of the searchlist update as the value in the textbox changes. And I must update the form manually for the filter to take effect

Hello, tried to search the forum for a matching problem, but It's difficult to get exact results.. I'm working on a filter for my form, which is based on a list. I've made an option group to filter the list based on status.. The only problem is that I have to manually update the form for the...

Hi, I've got this problem that drives me mad. I've been trying to search the forum, but it's impossible to get good results.. I'm working on a DB, where I'm trying to limit the results based on textboxes. strSQL = "SELECT * FROM [qryAnimeFansubberEpisode] WHERE [AnimeFanID] =" &...

Thanks a bunch, Chris - the code now works with name strings! For x = 1 To Me.AnimeEpisodesTotal If DCount("AnimeEpisodeID", "tblAnimeEpisode", "AnimID=" & [AnimeID] & " AND EpID=" & (DLookup("[EpisodeID]", "tblEpisodeList", "[EpisodeName]='Episode " & x & "'"))) = 0 Then...

It gave me an error, and wouldn't show me the querry data - I'm just testing out in a querry builder. DLookUp("[EpisodeID]";"tblEpisodeList";[EpisodeName]="Episode") works, and so does DLookUp("[EpisodeID]";"tblEpisodeList";[EpisodeName]=("Episode" & " " & "10")), but in both cases, a popup...

Could DLookup work? I tried, but I'm not sure how to concatenate it properly. What is wrong with this sentence? DLookUp("EpisodeID";"tblEpisodeList";[EpisodeName]="Episode" & " " & "10")

Thanks for replting, but I'm not sure if I described the situation correctly. I have two tables, tblAnime and tbEpisodeList, and I'm using tblAnimeEpisode as a many-to-many conjunction. I need a quick way to add episodes to the anime series. Here's the tblEpisodeList EpisodeID EpisodeName 1...

Yay! That worked perfectly! I thought I had done the IF and End If wrong. This is really cool, and I never have to manually add episodes ever again :D Thanks alot, Paul!

Hello, I'm wondering how I can get the ID of a matching record and use this ID in an AddNew loop. Private Sub cmdAdd_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim x As Long Set db = CurrentDb() Set rs =...

Good day, I'm trying to make a combined newrecord/update button for adding episodes to series, but it won't work. Private Sub EpUpdater_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim x As Long Set db = CurrentDb() Set rs =...

That worked great, with a couple of adjustments. Thanks alot for the help, brilliant! I also learned quite a few things too. Private Sub cmdAdd_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim x As Long Set db = CurrentDb() Set rs =...

I've made a flexible and easy copy+paste model, like excel, but I don't have to type anything. This works great, but I'd prefereably use something coded in VBA. This will do for now :) Btw, did the database work, Paul?

Did it work?

I also forgot to say that you need to click the "Add episodes" above the episode list in frmAnime.

First you need to remove the .ZIP - since it's a .rar archive