Search results

Hi As requested, here's a function that will do the job for you. Function fCardinalDate(bytDay As Byte) As String Select Case bytDay Case 1, 21, 31 fCardinalDate = bytDay & "st" Case 2, 22 fCardinalDate = bytDay & "nd" Case 3, 23...

Hi A mock database would be good. Please make sure to include all reports, queries ( if applicable ), reports Maurice

Proceed as follows: Step 1 - do a repair / compact on your database Step 2 - using PKZIP - zip the database Step 3 - send it Best regards Maurice

Hi Jessica892 Can you post your database? Maurice

Hi Please find attached a calendar that may be of help to you. To enter data at any date simply click on that date. Best regards Maurice

You can take a look at a sample bilingual database that I had posted quite a while ago. http://www.access-programmers.co.uk/forums/showthread.php?t=103594 Best regards Maurice

Hi Can't download the file 2000Ver.zip as indicated. Please feel free to email the file at: stcyrm@aol.com along with the requirements. Best regards Maurice

Hi I tried the database using Access and do end up with the same error you did. You may have to create the replace function yourself. Maurice

For a sample of a bilingual database, you can check the following link for how this can be done. Best regards and good luck. Maurice http://www.access-programmers.co.uk/forums/showthread.php?t=103594

Why don't you just link to the file???

Instead of a listbox, would you consider a popup calendar, such as the sample that I have posted a while back. The sample is located at: http://www.access-programmers.co.uk/forums/showthread.php?t=103387

Hi Crispie38 If all you want is a date picker, you could use the sample that I have posted a while back. http://www.access-programmers.co.uk/forums/showthread.php?t=103387 Best regards Maurice

Hi Dennis I'm not sure what you've tried so far, but the general expression below should help you get going on this... Example:....... Function fGetFldNamesADO() Dim strStoreSQL As String Dim i As Integer strStoreSQL = "SELECT * FROM tblCustomers" Dim adoCon As New ADODB.Connection Dim...

Hi Dennis Can you send me what you have and I'll take a look at it Best regards Maurice

Good morning Please find attached the MoveRecord.zip file which contains an MDB file of the same name. The app allows you to rank the listed items, allowing you to place the new item at the required location using the Up/Down buttons on the right of the form. Best regards Maurice

It certainly is possible to put a border around the report using the following code... Private Sub Report_Page() ' Draw a page border around this report. Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), , B End Sub Best regards Maurice

Good afternoon Tanha I have recently completed a project similar to yours. Please find attached the Excel file used in the project. This file is used as the import source into an Access database for data analysis. Take a look as to how the items are layed out. Best regards Maurice St-Cyr

Hi Douglas This value is set in the Regional Settings Properties. IN your case, click the number tab and select U.S.

Right on ..... that's exactly why I stopped posting a few months ago.

Good morning all Anyone out there have any experience with Dynamic HTML. I have tried just about everything with this and cannot get my web data to update when the data in the table is changed. I'm exporting to ASP, have added a DSN with the proper database. I seem to have done everything...