Search results

Hello; I quite often have difficulty getting into New Posts ..... but I don't take it personnally .... I have enough other stuff to drive me crazy. Maurice

Hi John Glad I could be of help. Best regards Maurice

Hello That would be: Forms!myFirstForm!MySecondForm.Form!myControl Best regards Maurice

Hello Please find attached a sample database that I have posted in the sample database area several years ago showing how to select the default printer. Best regards Maurice

Good morning Here is the location of a sample calendar that I posted about 2 years ago ...which you will also find in Jeff Conrad's collection. Since I posted the calendar almost 3000 copies have been downloaded, so I assume the users like it... the location is as follows...

Hello I haven't noticed this condition, however I did notice that my number of posts counter has been reset to 308 from 408. Maurice

Good morning I've taken the liberty of attaching a simple example of how this works. If you need additional help, please feel free to post back. Best regards Maurice

Hello Glad to be of service.. Best regards Maurice

Hello Have you tried a Repair/Compact on the database .... you could also check the References.. If all else fails you could possibly post the file. Best regards Maurice

Hello I will refer you to the sample database I posted several years ... I know that this one works http://www.access-programmers.co.uk/forums/showthread.php?t=105598 Best regards Maurice

Hello There is a lot of high powered developers in this forum. Maybe post the requirements here along with terms and ask for quotes. Best regards Maurice

Hello This is simple to accomplish using the DLookup function, however you must have the appropriate table structure Best regards Maurice

Good morning Maybe you should look at normalizing you table. You mean to say that you have 255 fields in your table??

Hello It should work exactly the same way, but then I haven't tried this in a report. Maurice

Hello For this particular application, you would be better to link to the image instead of storing it, as this would increase the database bloat. An example of how this is done can be found at: http://www.access-programmers.co.uk/forums/showthread.php?t=108698 Best regards Maurice

Hello You are better to link to the image ... saves on the database bloat. I did post a sample of how to do this, several years ago in the Sample Database area at the following location: http://www.access-programmers.co.uk/forums/showthread.php?t=108698 Best regards Maurice

Hi Arman_canada Please find below a fiscal year year function .... and it does work. I guess you're doing some work for Canadian Federal Gov. Maurice Function WOFiscalYear() Dim mydb As Database, MyTable As Recordset Dim StoredFiscal_Year As String Dim Counter As Long Set mydb =...

Good morning Mr. Boorman I guess we all have to go thru this at some point in time during our life. The very same thing did happen to me some years back .... yes, it is quite a shock, however it is not your fault, in case the guilt feeling starts to set in. I took it as a good chance to...

Here's a tip that came in from Tech Republic http://blogs.techrepublic.com.com/msoffice/?p=352&tag=nl.e056

Hello CA ( Computer Associates ) do have a utility that will scan the PC's to obtain the info you mentioned ...