Search results

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

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

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

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

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

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

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

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

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

I saw a sample database (Northwind) from MS, where once you enter the DB, it popups two forms, first an introductory form and then a control pane one. I would like to make something like this but with only one form and if possibly by using just a macro since I'm really newbie with VBA; already...

I have tblOPERATIONS, tblCONTAINERS, tblPRODUCTS all of em, one-many relationship, 1 op-many containers, 1 container-many products Sometimes, in a same operation you have dif containers but both containers may have the same products. I have tblProducts with fields: CONTAINER_ID ,PRODUCT_NAME...

Hi! I have two forms, formA and formB. Then i have a query called queryX. I have a report called reportX. I would like the query/report to show only a determined entry by the ID of that record, not all the records. So i have in formA and formB "Show Report" button, but when I click the...

Hi! I'm not sure if this is a VBA question but I'm guessing it is since I don't know any function (this doesn't say much) that would make what I'm looking for. Is there a way to recognize all the empty fields per entry? Maybe this would be like a report or a query, but for example, i have this...

Hi! I know queries can be exported to excel by the option "File > Export". The fact is that I'm using "order by" options and some functions like "Month", and "Export" options appears disabled, is there a way to export this query to Excel? :confused:

Hi! I want to concatenate information from a same field but different records. So I took a sample I found and tried to make it more generic by adding more arguments, but it seems like not working. Can you take a look at it and see if you find any error? When I execute the function in a query...

Hi! I have a main report which has a subreport. The problem is that the subreport works fine, but when I preview the main report it shows in a the top-right corner of the subreport the subreport name. This doesn't happen when I only preview the subreport alone. To make matters worse, I can't...