Recent content by dbmanalser84

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

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

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() //...

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

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?

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

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

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?

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

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

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

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

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.

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?

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