Recent content by capsula4

Basically I want that when a registry is updated, all the fields are coppied to the rest of the fields that share the same invoice id (FACEXP). Here is the code: Private Sub Form_AfterUpdate() Dim rs As DAO.Recordset Set rs = Form.Recordset ' fields to copy BANCO = Me![BANCO] FACEXP =...

The fact is that I need a view like the previous one to interact with another program which I can't modify. I have to do it that way, there is no other option... I guess I'll have to make a VBA module for that? :confused:

Hi! I have a query like this ItemNumber | Invoice | Code 1 | 404 | 02 2 | 404 | 04 1 | 406 | 01 2 | 406 | 09 3 | 406 | A9 1 | 407 | 01 My question is, how can I achieve the ItemNumber thing? the idea is that counts the quantity of items per invoice... any idea? I know how to make this on...

Thanks!! I could make it by using the following code: Dim rs As DAO.Recordset Set rs = [Details].Form.Recordset rs.MoveFirst Do until rs.eof [Details].Form![FieldToBePasted]=Me![FieldWithInfo] rs.MoveNext Loop Thanks a lot Ken for the help!

Hello helpful friends!! :D Does anyone know now how to make Cmd functions work on subforms? I kinda want to make a massive paste on a field of a subform, so what I'm doing is kinda like this: Code: DoCmd.GotoRecord,, acLast LastRec = CurrentRecord 'get position of last rec DoCmd.GotoRecord...

Thanks! that worked for handling different fields which is part of what I was looking for!!! Does anyone know now how to make Cmd functions work on subforms? I kinda want to make a massive paste on a field of a subform, so what I'm doing is kinda like this: DoCmd.GotoRecord,, acLast LastRec =...

Oh lol!! Thanks a lot!! I have the habit to edit subforms on new window since I find it easier but never realised it could bring up those problems. :D Thanks again!

I have this subform: FRUIT(combobox) VARIETY(combobox) Variety combobox depends on FRUIT. So VARIETY combobox comes from a query which has a criteria id related to what it's being chosen at FRUIT combobox. So far so good... The problem comes when I use this form as subform, it asks me for...

Hi! I have a main form: MAIN_FORM and a subform on MAIN_FORM called SUB_FORM I have a button on MAIN_FORM to browse records but I want to make effect on the SUB_FORM I tried this: DoCmd.GoToRecord acDataForm, SUB_FORM, acFirst I also thought of using a header for the subform, but since...

Yeah, I mean something like what I think you understood. You have let's say a combo with 7 banks... I select one of em for a specific registry... Then, when i create a new registry, I would like the combo just to show up 6 banks in the combo, the ones that haven't been used yet.

Sorry! I missunderstood the proccess of that DB, now I get and think I got a new idea on how to sort it out. Actually I don't wanna do that, the fact is that I sorted my db differently. You have to create the relationship Company-Bank and then, daily, you also have to be chosing all the...

I created another topic about my third idea: http://www.access-programmers.co.uk/forums/showthread.php?p=678076 Anyway, if any of u got any idea for the "default value" thingie or create those records automatically would be nice... maybe with some VBA, what do you think?

I have something like this: tblDays: DAY ID, BANK ID tlkp: BANK ID, BANK NAME And on tblDay I have a form that displays a combobox for Banks. I would like that once you choose a bank, that specific bank is out from the combobox. I tried the followin: Created a query that returns: BANK...

Thanks a lot CraigDolphin! What I'm trying to do is exactly the same as what that DB does, but I have sorted it out differently, organizing it principally by DAY instead of COMPANIES since the balances should be completed daily on the company I'm working. The problem with my DB and the one you...

Well, anyway, thanks a lot Allan for trying to help me! I don't really know any way to make it work... I thought of probably using the default value option and make it incremental somehow as you go on putting records... do you get what I'm sayin here?