Search results

Hi! I have a form like this: MAIN FORM: [OPERATION ID] [CLIENT] {subform} subform: [ID PRODUCT] [QUANTITY] [UNIT PRICE] TOTAL: [UNIT PRICE]*[QUANTITY] So far so good, but now I would like the main form show the sum of "TOTAL" I tried =Sum([query_name]![TOTAL]) but doesn't work, I see "#Error"

Hi! I have an autogenerated form for my operations. I see something like this: Operation N°: Client: [subform products] The fact is that when I change "Operation N°" i want it to work as a filter instead of being allowed to change the "Operation N°". I tried the option "Search By Filter" and...

Hello! I have a 1-many relationshiop: TRANSACTION -> PRODUCTS is there a way to have a field in a query called "ALL PRODUCTS" separated by commas? I need this as text in a report, not as a list (not one below the previous one). EXAMPLE [TRANSACTION ID] [CLIENT] [ALL PRODUCTS] (autogenerated)...

Thank you!! I'm not sure if I did it in the best way but I can tell you I could make it work! I had to make dif queries and make the combo lookup from queries instead of the table, and then when I want to make a report I had to select P1 and P2 table ID and query ID and then add a criteria...

I thought of making something similar to that but still doesn't make what I was looking for (showing country and name of P1 and P2) :confused: I'm guessing I will go with queries for P1 and P2 and make the lookup combo from queries, seems like the only way to make it work. Thanks for trying it! :D

What do you do instead?? Any suggestion for a newbie (me)?

Thanks for trying to make me think but I can't really tell what I may do something using parameters or filtering somehow... not sure how :confused: Consider also that I'm pretty newbie and I have just started learning access for 1 week :o

I couldn't really make it work with autoform, although I could make a new form using the wizard that MS Access features and now works okay. :D

Thanks Rural Guy but then which is the solution to this problem?? I thought of creating different queries for PERSON 1 and PERSON 2 and make the combobox lookup info from the queries instead of the tables, this seems to work good but I haven't finally tried it. If any have a better idea, just...

Although I understood pretty well this, I'm encountering a problem with reports. I have the following tables: Table - TRANSACTIONS [T_ID] [ID_PERSON1] (combobox from PERSONS) [ID_PERSON2] (combobox from PERSONS) Table - PERSONS [ID_PERSON] [PERSON_NAME] [ID_COUNTRY] (combobox from COUNTRY)...

Thank you a lot bob! :D But I gotta say... :( I have the backend file where I have the tables with its relationships (i tried autoform and worked okay). I have the frontend file where I have everything except tables, where I see this old autoform and can't expand information. I tried using...

Thank you bob!! I've been reading a bit of everything but I have a lil doubt. Once the db is divided, when I modify/add data in a form in the FE, is it automatically stored in the BE? ------------------- Another big problem I found is that I have 3 tables with 1-many relationship...

Thank you rak!! I actually did some research on merge with word, but find a better solution for my situation which requires installing alternative software. The tool is free and is called "Cute PDF Writer" and it exports any report as PDF file, and looks exactly the same way as you see it in...

Hi! I work at a company where a same DB is being opened by more than one user, is there any way to allow many users be working on a same DB? Actually I cannot even open it if its already opened. It appears another file with a "lock", which seems to be protecting the DB. :confused:

Hi! I would like to know if there is a way to enhance the Access=>Word export, since most of the text tends to overlapp or get displaced. I tried also making a JPG for a header I did using text (which is all messed up in word), but JPG's aren't being shown on the Word file. Is there any way...

Thank you Mike and John for your explanation/help!

Thank you neileg!! Although is a way to still store that field using a form? I just should make a "date of transaction" field in the table and set the default value in the form instead of in the table? :confused:

I'm actually using [DATE OF TRANSACTION] i just wrote here [DATE] to make it faster lol! And yeah, I'm putting this as the default value of a field in the table. I need this to be a default value and not a calculated field in a query since it's a default value which may require a different...

I'm putting the following as Default Value, but isn't working: IIF(weekday([DATE]-3)=1;[DATE]-4;[DATE]-3) it appears an error saying that the syntax is invalid, that I may be missing inverted commas (" ") for text... do you know how should I make this? Another lil thing, I'm using Spanish...

I'm not sure which was the problem but I redid the query adding some more "relating" fields and it worked okay. Thanks!