Search results

So a good programmer isn't worth £50 per hour?!! And if you know how long it should take you must have some idea of what to do?

You could consider using the "print #" command to create the file and populate it by running through a recordset. You could also create a function to get the length of your data and add the relevant number of spaces, or shorten the string if necessary, and use this as you run through the recordset.

It does work, instructions here http://social.technet.microsoft.com/Forums/en-US/w7itproappcompat/thread/6b98381b-44ff-43d4-a9b1-1fb00023d3d5

Search the forum for CDO email. This should do what you need.

I don't think so. The use of making a report would facilitate the creation and emailing of the pdf file, so is it a compromise that is worth while?

Or use a macro in the spreadsheet to convert the fields to text which will allow both text and number entries. Sub MacroConvertToText() Dim cell As Object For Each cell In Selection cell.Value = " " & cell.Value cell.Value = Right(cell.Value, Len(cell.Value) - 1) Next End...

I use a mda file, put standard functions in there, set the mda in references and then use the functions from there. If you want to stop the user changing any of these functions create it as a mda file then compile it as a mde file and then change the extension back to mda. KEEP A COPY OF YOUR...

You could use Stephen Lebans PDF code to create the file and then use CDO to email your pdf. Search the forum for CDO there are examples. hth

You missed one W1A 5TT. I don't try and use an input mask, I just force it in to uppercase.

It might be worth looking at the OutputTo command Create the report in your db, then expression.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding) Output format could be acFormatSNP ands the outputFile specified by you, then you could attach that...

You could install a runtime version of access on you're users PCs. This would stop users getting to tables and queries. You would need to address other issues using custom menus and toolbars and get on top of error reporting.

Look at the datepart function, you could use this to select each part and re-arrange.

Not working ghudson. If I run it locally it returns false on both wired and wireless, and if I run from a network shared folder it returns True on both :eek: Not what you wanted to hear I'm afraid.

The point of using Print # is you can put whatever text you want in the file, so you build the whole schema and populate data values looping through a recordset, ending up with exactly what you want.

You could use Print # commands to create, edit and save your xml file and use a recordset to populate the values you require.

Remote Desktop would allow your users to log in to an office PC take over the desktop and run your application live. The screen size would obviously be small, but depending on the form sizes / screen resolution of the PC it might be workable. Would aviod alot of modification to the db. Or would...

You could look at developing your own or perhaps http://www.msmltd.co.uk/ might be of interest to you.

I have access 97 running on my Windows 7 PC. http://www.access-programmers.co.uk/forums/showthread.php?t=194004

It does install, however when you try and install sp2 it errors out as sp2 tries to install the tahoma font which windows 7 protects. I can't remember how i did it but if you delete (or cut & paste to a backup location) the font sp2 installs and re-installs the font.

From your code it looks to me as ifthe right hand section of all post codes have a length of 3 characters. if this is correct then you could create a function: Public Function HasSpace(xstr As String) Dim i As Integer Dim l As Integer Dim x l = Len(xstr) For i = 1 To Len(xstr) If Mid(xstr...