Search results

Well to clarify what I am trying to do is Get a long path name (in a text box which is different on each record of a form) that has to be converted into a short path and placed in another text box on the same record on the same form. This means that I can export data to word then save the...

I can't get it to work. Could you tell me what bits I need to change to = whatever. I am Glad it is Friday it's been a long week. Thanks for your time! David

That might work but I am not sure of how to get the code to work! this is the code Place this code in a .bas module Option Explicit Public Declare Function GetShortPathName Lib "kernel32" _ Alias "GetShortPathNameA" _ (ByVal lpszLongPath As String, _ ByVal lpszShortPath As String, _ ByVal...

Hi Well my problem is I have created a button to export data to word then save the information in a specific file for each separate job. This works fine if I use a short path name but the files that these documents are in have long paths ie: \\sac039\global$\Building Design\Projects\2002...

It is Posible There is code in Access 2000 Developer's Handbook, by Ken Getz, Paul Litwin, and Mike Gilbert. There website has the chapter about resizing forms on it. http://www.developershandbook.com The code for 2000 and 97 is there I think. Hope this helps you. David

Yes well I think so. Set up a Query Place all the field in it. i.e. Company Con1 Qty1 Con2 Qty2 and the check box field set the criteria for the Company field to [Forms]![Treatment Form]![Company] that will only select one company and set the check box field criteria to No Save the Query...

I had tried this but it didn't work. =Sum(Nz[Invoice Amount 3]) I got an error saying the expression you entered contains invalid syntax. You may have entered an operand without an operator. I am stuck on this one. Thanks for your help

I have a Report takes invoice 3 totals from a query then adds the total of all invoice 3's. The problem is that if there have been no invoice 3 the total comes up as an error how do I stop this. I want it to say £0 My Control Source is =Sum([Invoice Amount 3])

Thanks I thought it must have been something simple like that.

I want to change the colour of the text if the check box is ticked I have use similar code for it being = to "Completed" But I can't get it to work for "Yes" in a check box. Here is the code I have used Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![Inquiry] =...

This works Great Thanks.

Thanks worked a treat. But I don’t really want to lock the textbox. I want people to alter the date by typing if required i.e. date is + 10 days it would be quicker to type it in. any suggestions? Thanks [This message has been edited by D.Mair (edited 06-25-2001).]

I have a date that inserts automatically and for speed users thought using + and - to increase and decrease the date by one day would be handy. I tried Private Sub Received_Change() If Me.[Received].Text = "+" Then Me.[Received].Value = Me.[Received].Value + 1 ElseIf...