Recent content by dbmanalser84

  1. D

    Calculating years, months and days between two dates

    I have a form where I enter employees and the dates they've started working. I used the following code and managed to display the days passed from the start date up until now: Dim pocetakRada As Date Dim trajanjeOdnosa As Integer pocetakRada = [dtePocetakRadnogOdnosa].Value trajanjeOdnosa =...
  2. D

    How to detect when query returns no values?

    Thanx for the code Bob. It works but not 100% as I wanted, so in order to be able to understand it better can You please explain to me (in simple English - translate) the following lines of code: Dim qryDef As queryDef // I tried searching help for this Variable type but with no luck, can You...
  3. D

    How to detect when query returns no values?

    But my query is not saved as a file in database, instead it is generated on the fly with VBA on each After_Update event when another Combobox is selected. Here's the piece of code that generates the query, and fills the combo box with it: Private Sub intPrevoznikID_AfterUpdate() //...
  4. D

    How to detect when query returns no values?

    I have a combo box that is fueled by a query, and I want to detect when that query (that is a Row Source for the Combo box) returns no values (the Combo box that is fueled by that query is empty)? I tried using the following codes: If cmbField1.Value = "" Or cmbField1.Value = Null Then...
  5. D

    Filling Combobox with message if the query returns no values

    3 days passed and not a single answer. Is the question clear enough? Let me rephrase the question just in case: How do I display appropriate message if the Query (combo box source) returns no values? I hope there will be some answers this time. Thnx. Can anyone please explain this to me?
  6. D

    Filling Combobox with message if the query returns no values

    m creating a database that has records of all my travels and the money I've spent for each. I have for with 3 combo boxes: 1. Relation - it has all travel destinations. For now it has only two (Nis - Aleksinac) and (Aleksinac - Nis) 2. Travel agency - it has all the companies I've traveled...
  7. D

    VBA and SQL Error Message

    I've started learning VBA recently and came to the part of working with SQL in VBA. Up until now, all the things I did as the tutorial said worked prerfectly, except this one. I've wrote this piece of VBA code: Private Sub intPrevoznikID_AfterUpdate() Dim SQL As String SQL = "SELECT...
  8. D

    Question JOIN types?

    Ok. And can you explain a CASCADE DELETE? If you delete a PARENT in parent table will all CHILDS be deleted and vice versa? And how (and does) the JOIN (any) effects this?
  9. D

    Scenario: Substracting Items from Storgae when purchased

    I have a table in my database that holds items and their quantity and that table represents the storage. I have a table that represents a cross table and holds the infromation about items sold and the date they are sold, and I have a form for entering data in that table (matching items with the...
  10. D

    Question JOIN types?

    Where can you best see the application of LEFT and RIGHT JOIN while Refferential Integrity is on in the relationship between the two tables? I can clearly see this while Referential Integrity is not applied, because in that case it is allowed for data from one table not to have their...
  11. D

    [ASP-DW-ACCESS] Multiple checkboxes inside reapeat region with one submit button

    I built a Card database and now I wan't to put it online using ASP and IIS. I build a page in dreamweaver, and created a relevant rsEdition (each card comes from specific edition). On page I've put rsEdition.txtEdition object and added a checkbox in front of it, and wrapped both in the repeat...
  12. D

    Filtering The Search quiery with Checkboxes

    Well. I didn't missunderstood you, I think you misunderstood me. As I said I haven't created this, I "Print Screen" it from an existing program Magic Workstation (sorry if mentionnig this program is illegal, it's free tought). So, I cannot help you, maybe the creators of the program can...
  13. D

    Filtering The Search quiery with Checkboxes

    If I.... If I understood you right you think that I created this on the picture. I'm sorry to dissapiont you but this is the screenshot from the functionig program I posted is just as a refference for everybody to see what I wan't to create.
  14. D

    Filtering The Search quiery with Checkboxes

    Image of what I want to do To cut the long story short, and to help you better helping me here's what I wan't to recreate. How do I do it?
  15. D

    Filtering The Search quiery with Checkboxes

    I'm building card database, and the next step in my work is to build a form where i could search from particular card in database but besides searching where you would enter the card name only I wan't to add a couple of checkboxes that would act as filters. I have the following tables in my...
Back
Top Bottom