Search results

Hello! I have a 1-many relationship: tblCOMPANY (one) - tblBANKS (many) I have a main form called COMPANY with a link to a subform (opens in new window) of BANKS. I added the wizard button to duplicate record COMPANY but it doesn't duplicate the related BANKS that COMPANY has. I've noticed...

Thanks a lot Brian!! I could make it! Here is the code I used, there are some lil differences with ur code, since I'm using a SQL query instead of opening the whole file/table. Some lil spanish for ur help :P Desde = Since Hasta = Until Private Sub CalcularDesde_Click() Dim strSQL As String...

It was as easy as using a default value on second form, refering to the main form. :D:D Easy but took me a couple of days to realise of that :rolleyes:

Thanks a Lot Brian! I liked how you made it, actually If I understood okay what you make is store the value in a database field through a form instead of assigning a value to the function? I guess I'm gonna go that way

Thanks Brian and Adam! I also think that's the problem but I don't know how to solve it. What rings a bell to me is that once I "made" another function (personalized one I found there) and it was one function but returned dif values for each record. It didn't use any array or weird thing, except...

Sorry a lot for the confusion Brianwarnock, HASTA is the field I'm using which is the spanish word for UNTIL!! Okay, so I should add Move.First Before starting the loop, tho... would this solve my problem? I find weird the fact that fSince() returns the value of the last entry only to all the...

Hey Ted / Helpful Friend :D ! Not sure if you are still on these forums but I gotta say that your module is getting really popular! :D I'm a bit newbie into VBA and I imported the modules you created (those 3) and also the sample form. But I got some doubts. - Shall I create a field where...

Thanks a lot for the reply tho I'm guessing that what you are telling me isn't the mistake. What I'm trying to do is to compare if REL_ID field of the current record is the same as REL_ID of the previous record. So I use the "flag" variable to store the first loop, if it is the first record...

I'm trying to create a module that returns a SinceDate when having more than one UntilDate per ID, for example: REL_ID, UNTIL, fSince 1, 10/10/08, 0 2, 09/10/08, 0 2, 30/10/08, 10/10/08 3, 10/10/08, 0 So far it works okay, the problem is that fSince returns the value that corresponds to the...

Here is my DB: What is in red is what I'm creating in the form. Additional Info about the DB for better understanding: One day has dif companies, each company has dif banks, and each bank has a quantity of available money for that day. 1 DAY - many COMPANIES 1 COMPANY - many BANKS Each...

There can be more than one person per project? There can be more than project per person? In the example you posted, seems like "one person-many projects", but not the opposite. This is kinda fundamental for your database structure. If it is "one person-many projects", I would go with two...

First you have to create two tables in which they share a field (they have the same name) If you have "one costumer-one sale" relationship, then the shared field should be the primary key field of both tables. If you have "one costumer-many sales" relationship, then the shared field should be...

Okay, I could make it by using the wizard. It asks me where I wanna save the information of the combo and I can only choose COMPANY_NAME, not COMPANY_ID, is this okay? Also I have noticed that sometimes it appears a new value in the combobox once I have already used the combobox, I'm guessing...

Okay so I make the query "M: Month(Date), Packaging, PricePackaging" without grouping by... But how do I make the subform?? I mean, "Month" would be the main form and "Packaging, PricePackaging" the subform, but how do I organize it this way? Should I make more than one qry? Maybe "M...

I have read that many of you don't recommend lookup values in tables, instead making it by using relationships between tables. I have: tblTransactions: DAY, ID_COMPANY, TRANSACTION tlkpCompanies: ID_COMPANY, COMPANY_NAME I just don't get how to make the combobox in the form so as to Have...

Hello! I have 1-many relationship: tblMain: Invoice, Date tblProducts: ProdID, Invoice, Product, PriceProduct, Packaging, PricePackaging Okay, the deal is that all of the fields are being filled with info except PricePackaging which is being filled at the end of the month. PricePackaging is...

Thanks for not answering! I just investigated a bit on it and also tried dif options with the SQL summary functions, I didn't really understand how they worked but now since I played a bit with em I got it. Thanks! :D

Thanks pbaldy!! Actually I changed DESC to DESCRIPTION. My doubt is once I group by those 2 fields, what happen with the amounts? I want them to become summed, how shall I indicate it? Or is it enough as you have already told me?

Hi! I would like to know how GroupBy works. I have a 1-many relationship (invoice-products) I have this query: [OPERATION_ID], DESCRIPTION: [PRODUCT NAME] & [PRODUCT TYPE], [QUANTITY] What I would like is to have a group by DESCRIPTION since some products may be repeated in a same OPERATION...

Hi! It has happen to me many times that when I create specific queries I'm then not able to modify the values of em... Do you know the possible causes of this? Is it because I'm filtering? Ordering by? Grouping? Using fields of differents tables related 1-many? Calculated fields? Expressions...