Search results

Thks Nigel, I will wokr on this or do it the way mentioned earlier, to replace before sending. Michael

Hi Richard! Sorry, I did not understand what you will do. I will try to understand. ClientAccountNumber is a field in an access table? There are some files produced in Publisher as PDF and you want to merge those PDF's (more than one per ClientAccountNumber) to only one per...

Hi Tj, this seems to be your solution http://www.office-loesung.de/ftopic503307_0_0_asc.php In German. HTH Michael

Hi Paul! A few minutes ago I found this grzzzzz...problem, which took me a long time! Thank, the problem where somewhere there, BUT I have to do in access anyhow: Me.Total= format(replace(rs("TtlPrice"),".",","), "Currency") but no I got it. Thanks yr help Michael

Hi! I get a result set from a pt qry from a sql server 2008 in vba. Me.Total is an unbound field in the report foot( correct translation of german "Berichtsfuß"??) Private Sub Berichtsfuß_Print(Cancel As Integer, PrintCount As Integer) SELECT SUM((DATEPART(hour, Calctime) * 60 +...

[ ' Replace CRLF with LF only. Me.Mailtext.Text = Replace(Me.Mailtext.Text, Chr(10) & Chr(13), Chr(10)) ' If necessary replace LF with a space Me.Mailtext.Text = Replace(Me.Mailtext.Text, Chr(10) , Chr(32)) Hi Nigel! Replace(Me.Mailtext.Text, Chr(10) & Chr(13), Chr(32)) deletes the whole...

Hi Paul! How could it then be, that the cursor stays in line 2 with your code after replacing the linefeed? What forces the linefeed in your code? Or is it just like as I would move the cursor with the mouse? I tried your code, but there is still a line 2 and I can place the curos there. But...

Hi! My users send SMS via a form. If they insert an crlf it counts 2 ditigts in an SMS and i would like to avoid that they insert Chr(10). Private Sub Mailtext_KeyPress(keyascii As Integer) If keyascii = Asc(Chr(10)) Then MsgBox "No returns in a SMS Me.Mailtext.Text =...

Hi Paul! It is an unbound object field ( I do not know, if it is translated correct from German; there are two icons, on is a bound object field - the one with XYZ on top - and an unbound one, I took the unbound one. By the way I could not find an unbound object FRAME control - or it is the...

Sorry, I did not read correct... Me.GroupImage.Image = Me.Article.column(3) brings an Error that this property or method is not supported.

No .Image is not available either!

Hi! A topic which often discussed, still I do not find a solution. I stored JPEG in an SQL-Server 2008 table. Pictures are small therefore I did not use the FILESTREAM format but varbinary(MAX), which works well in the form frmArticleGroups with a BOUND objectfield. I only have less than 50...

Thanks a lot! Its definitively the better way, either I decide to update tblArticles or keep it dynamic with only the view. Michael

Hi! Please help me in this issue as I do not know how to handle it: A PT query from Access 2010 to SQL server 2012 for an inventory project. tbls: tblArticles, column ArtID, column Price tblMovementsdetails, column ArtID, column Number, column Unitprice Whenever new items (ArtID) from an...

Thanks, I found a solution in Round(((datepart(hour,[TimeWorked])*60)+datepart(minute,[TimeWorked]))*[PaymentPerHour]/60,2) AS TtlPayment

Hi! I run a Pass through query against a SQL-Server from Access 2010. I have a field TimeWorked which has values like 1899-12-30 03:30:00.000, for 3:30 hours and a field PaymentPerHour with values like 10.50 (for EUR 10,50). The result schould be 36,75 (36.75). I tried to calculate like...

What about understanding that "Location" is the CURRENT location? In case you need to know what the original location is, you need another field in the table.

Hi! I searched without success for a solution to show small pictures (icons) in a table field to show up in a continous form. Purpose is: a communication log table has comm codes such as - mail out - mail in - tel call in - tel call out the comm log table has the fields CustomerID...

Spike, you might be right! Meanwhile I was also thinking about MS VIsion, which might be even more suitable, but as we have already the PPT whith the shapes on it, I will try it that way. Thanks! Michael

Hi! Here is my project: For a duty plan the employees are assigned to positions in a certain area. For example: Name. Position. Description. Map Brown. 1. backdoor. 1 Miller. 3. frontdoor. 1 Norman. 4. left...