Search results

Hello my friends! In my database (in a server with the appropriate user control, (single database file, not splitted), i got a sub which exports a report as a pdf and then creates an email with the report and another excel file (total 2 attachements). My problem is that in my computer (win 10...

It's really a long way! I'll give it a try and if it won't work, i'll write by hand "various customers". Thanks!!!

Hello my friends! I've got a database which records incoming samples information. Fields: ID Sample description IncomeDate Customer Responsible. After inserting the information, a report is generating and a message is ready to be sent to the responsible. All the fields are included in the...

sneuberg, i copied the functions and code from the database you uploaded and it's working fine! I used arnelgp's method. Thank you very much!!!!!!!!!!!!

Sorry, copy paste error. I've changed it, still the same problem..... Form design: http://prntscr.com/bu0598 Foram data: http://prntscr.com/bu05eu

Guys, i've tried it again, with sneuberg's suggestions but no result again. You can see above screenshots from the project. Module photo: http://prntscr.com/btzws4 Form design: http://prntscr.com/btzwzb Form with data: http://prntscr.com/btzx60 In greek, i have to use ; instead of , The...

sneuberg if i use space between accident date, it will not work, table fields are [Employ date] and [Accidentdate]

arnelgp i created the code you mentioned but the result i get is #name. Furthermore, how can i also make it work in report? missinglinq I'll try it as a second test. Thanks in advance!

Dear friends, hello to everyone! I have a from and a report, which calculates the difference between 2 dates. The fields called [Accidentdate] (the day accident happened) and [Employ Date] (the employment date). On the same form/report, after i enter the accident date, then 3 different fields...

Thank you all guys! It worked with arnelgp directions! Thanks again!!!!

The product code is text. Data from table: ID (autonumber), Productcode (text with maximun 9 numerical characters), ClientName (text), OurName (Text) 1, 1234567, Paper1, Paper1 2. 1245689, Paper2, Paper2 3. 0215487, Bav, bdu 4. 0596847, Beu, Bea 5. 0569874, Dei, Deita

Hello everybody! I've got the following problem: In my database, i use three fields: 1. Product code (conbo box-text) 2. ClientName (text) 3. OurName (text) The same fields are also in a table (ClientOur), so i can pull out the dlookup. My syntax in product code after update event is the...

yes, i'll also clarify it!

Thanks guys! It's working great with Minty's directions!!! Thanks again!!!!!

Dear friends, i've got the following problem with the dlookup function. I use the function in a form and report, just to show information about the document. The problem is that, it always shows me the first record and not the correct value. I think syntax is ok. compid is the clients id...

Thanks! I've solved it by making a reference at the subreports totals on main report footer. it's working!

Hello friends! I've got the following problem and your help is valuable!!! I've got an invoice form (with subform) which generates a report (printable invoice). Report fields and design: Reports header: Comany and invoice info Detail header: subreport with purchased products, totals. Report...

[SOLVED] Re: Form format design problem (detail) It worked! It was in front of my eyes! Than you Simon!!!

You have to use another field to display date in your language. Dim okt_courtday_lang as string Select okt_courtday case "Monday" okt_courtday_lang = "isnin" case "Friday" okt_courtday_lang = "your language date" End Select

[SOLVED] Form format design problem (detail) Hello everybody! I've got a form which has been designed in ms access 2000 and upgrated to 2007 and then to 2013. My problem is that, the background format (stone background template if you remember) that it had in 2000, couldn't be removed from...