Search results

  1. C

    A database for generating and running cmdline batches

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

    Fail to autoupdate list on filter change

    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...
    • C.D
    • Thread
    • Replies: 7
    • Forum: Forms
  3. C

    SQL and textboxes - won't work

    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] =" &...
  4. C

    Getting the ID of a search match in a loop.

    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 =...
  5. C

    Addnew, based on IF in loop - problem

    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 =...
  6. C

    Forcing on a status, depending on calculation

    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...
    • C.D
    • Thread
    • Replies: 1
    • Forum: Queries
  7. C

    Autofill a set of records, based on template

    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...
    • C.D
    • Thread
    • Replies: 23
    • Forum: Forms
  8. C

    Dcount: Combining two criterias - stuck

    [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...
    • C.D
    • Thread
    • Replies: 2
    • Forum: Queries
  9. C

    Concatenation of categories - stuck

    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 =============...
  10. C

    Making static files avaliable in a database based on auto.gen. paths

    Hello, I'm trying to find ways to use my DB as a mainframe for my anime, and other media. Being able to load imagepaths and filepaths automatically, based on table info. Let's say I have four different 'roots' where I store my anime; Root1: "F:\Data\Anime\", Root2: "\\mediaserver\anime\" and...
  11. C

    Autofilling a field, based on other fields

    Hello - first post woho :cool: I'm working on an anime DB, and I don't have much experience on VBA or coding in general. I'm therefore wondering if it's possible to autofill an entity, based on two entities from two separate tables. Let's say I have an entity from the table "Anime" and one from...
Back
Top Bottom