Search results

I have had a look at the database and it is not normalised. In order to solve this problem, you are going to have to take a few steps back in order to address this problem, before you go on to design queries, forms and reports. I have taken a look at the database design and taken my best shot...

Just of the top of my head, I'd try Private Sub FrmOption_AfterUpdate() Select Case Me.FrmOption Case 1 Me.TxtLineDim1.InputMask = "[00.000\x00.000;0;_]" Case 2 Me.TxtLineDim1.InputMask = "[00.000;0;_]" End Select End Sub

You don't need to use SQL to do this. Check in Help for the DCount() function.

I had alook at this, but couldn't open the attachment, but I'm using Access 2000 - was it created in a later version? I suspect that the modification would be to use a loop on each salesperson and then filter the report based on that. Each report can then be individually mailed through whatever...

Its not your report that the problem - its your underlying query. Group By on memo fields truncates text for some reason. As http://www.access-programmers.co.uk/forums/showthread.php?t=92624&highlight=group+memo mentions, you can remove the memo field from the underlying query and then do a...

If it's just a one-off exercise and not too much data, I would export the original table into Excel, and manipulate it there (maybe use Excel's Paste Transpose function) and re-import it back into Access.

There's a ton of information on Microsoft's support website click here

You're welcome! :D

You should be able to do this in a query. Look at the SQL GROUP BY keyword and use that to group on address.id (I assume you have a seperate Address table, if the database is normalized?). You can then sum on MemberDues to give the total for the family. This assumes that all members of the...

Ahh, those pesky quote marks...

" WHERE BizTalk_Import.F1 Like " & "TT"

Are you changing it within acess or from windows control panel? If you do the latter it should be more permanant. If you can't change it from the control panel because, say another app needs those default margins, you can always create a new printer, with the margins you need, pointing to you...

The approach I would use is to desgin a sub-report containing your chart. Base teh charts information on a query which gnerates the averages you need. You can base yoru averaging query on the query you used for the main report.

try ssql = ssql & "[Sales_Pipeline_Current].R_List & ' ' " & "& '" & fname & "'" for the second line of code

Something like : SSQL = "UPDATE Sales_Pipeline_Current SET [Sales_Pipeline_Current].R_List = " & "'" & Fname & "'" & " where [Sales_Pipeline_Current].oppt_Id = " & ID & ";" assuming Fname is a string and ID a number

Autonumber is not suitable for this. Use an ordinary Integer field and use the DMax function with the current year in the criteria string to assign a number.

Just a thought (this happened to me) are you sure your printer settings aren't affecting this? For me, once I changed from Fast Draft to Normal, pictures printed fine. You may want to check your settings. It took me ages to find this out!

How about breaking up the report into multiple reports eg Report1 -> Page1-10, Report2 11-20 etc. You could write a bit of VBA to print out each report sequentially, n times if you needed to.

It may help if you ask a more specific question. What do you actually wish to do with this winsock application? Build a server to listen to requests? Build a client to send requests? Or just access email/ftp or whatever? Also you only posted you initial request yesterday and that was a holiday...

use owkb.save '(if you need to save the file, I assume you do) owkb.Close oXL.Quit richary