Search results

Actually yeah but since I'm pretty newbie I'm not really sure how it works, or is there a sample somewhere which I may see? :D

Thanks a lot ahuvas!!

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

;)Thank you! I could make it work really great in that way.

Okay thank you Adam I got that one, I actually didn't realise how I could make it, really newbie at VBA. And is there a way to delete a whole record? not erase the data but instead delete the entry using VBA. :confused:

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

SELECT [tlkp.Language].[LangID], [tblRawData].[LangName], [tblApplication].[AppID] FROM (tlkpLanguage INNER JOIN tblRawData ON [tlkpLanguage].[LangName]=[tblRawData].[LangName]) INNER JOIN tblApplication ON [tblRawData].[AppID]=[tblApplication].[AppId] I'm also a bit newbie, but I was thinking...

What you are looking for may look like this probably: IIf(Q1 = 99, 0, Q1) + IIf(Q2 = 99, 0, Q2) + IIf(Q3 = 99, 0, Q3) + IIf(Q4 = 99, 0, Q4) + ... and so on if you have more fields :D

Is there a way to export a filtered query?:confused:

If I understood good, you are giving me two options... 1. using the NZ function with where condition 2. using If and return Y/N and then creating a module Or you mean both together? The NZ function would return only those entries in which there are missing fields and the Y/N would say which of...

I know you can add parameters and make them work as a criteria. Once you open the report/query, a popup appears and ask you for a criteria value (tho not a combobox). I'm not really sure if you can make a field of an entry become a criteria value, maybe what you are looking for should be done...

Actually the value True for MonthDate enables abreviated months, so he will see only the first 3 letters by typing true, so this should work: =MonthName(Month([YourDateField]),True) :)

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

Nevermind, I just modified it and now I can export it, althought I still don't understand why it was disabled... If you have any idea in case this happens again it would be appreciated. :D

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:

Here is the function already finished, anybody can use it :D fConcatenate("whereID",[criteriaID],"strField","strTble") whereID: field being repeated in which you wanna group the different items. This mean this value should be between inverted commas "whereID" criteriaID: the values of the...

I had a problem but since it was module stuff I decided to open a new topic and someone already answered me. So I don't have any problem! :D I modified a bit the module so as to make it generic, enter here in case you wanna see it (it's finished)...

This is how I call it and it worked with pbaldy suggestions! :D CONT: fConcatenate([N_OP],"CONTENEDOR","CONTENEDORES") Althought the original sample had a criteria on it and I removed it, so now I see all containers in each operation instead of the specific containers of each operation (its a...

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