Recent content by midmented

FINALLY! I had to think this one through but it works. I used the NumberFormat function to get the cell format. Dates with English (Caribbean) came back "mm/dd/yyyy;@" Dates with Armenian cam back "dd/mm/yyyy;@" So I simply used an if statement to swap the month and day for Armenian dates. If...

I still can't find a solution to this. Even in Excel when I click into the cell that contains the Armenian date, the formula bar displays an English date but the cell itself displays as Armenian. There is a bug in Adobe XI standard. When you "Save as Other" a pdf to Excel, the date columns...

gemma-the-husky: Yes, this is what I am struggling with. Because of the locale, both dates are valid. The ambiguity throws another wrench into the issue. arnelgp: I will try this approach and see what happens. Maybe the NumberFormat option will solve this issue. I DO know that format "mm/dd/yy"...

good link! I've been using a version like one of them listed in your link: http://www.databasejournal.com/features/msaccess/article.php/3548586/Auto-Logout-Users-for-DB-Maintenance.htm I modified mine over the years but it has worked perfectly and never once failed for over 5 years.

I am importing into a date field. My issue with parsing is the data importing is not in a consistent format other than date (locale format could be anything). During import, it could be English (Caribbean) or Armenian. English (Caribbean) imports correctly; Armenian does not. I am looking for a...

I made a table called tblMaintenance with one field (yes/no) and put a timer event on the main form to check tblMaintenenace for a yes checked every 2 minutes. If yes is checked, another form pops up that has a timer event (and gives a 2 minute warning) that closes the application after 2...

I receive an Excel 2010 spreadsheet that I import into an Access 2010 table using a VBA Function that I wrote. I discovered that some of the dates were not being imported correctly (mm/dd/yy is the correct format). In the Excel cell the date displayed mm/dd/yy but this date imported as dd/mm/yy...

Gave you the approved rep...... thanks so much for thinking it through with me.

oh my! Guess what, there IS a space at the beginning of every single department. Dang, so sorry. It is an Excel Import so it looks as if I will need to write code to get rid of the blank space. I was looking for blank space at the end this whole time. Hours wasted and it was right in front of...

Yes, I deleted all of the records in tblEmployee, manually added 3 records (unique ID's only), then ran an actual update query (not SQl statement). The 3 records updated to the correct department. I ran the DCount in the immediate window, and it still came back as 0 yet there are 3 records in...

I just checked relationships. There is a relationship from SSNbr to SSNbr between tblStaff and tblEmployee.

Sorry, I ran everything manually using query wizard, leaving out all of the code for the criteria selection just in case something was messed up in the criteria code. How: Deleted all the records in tblEmployee, and simply added 3 unique ID's under SSNbr field leaving all other fields blank...

If I run: ?dcount("*","tblEmployee","[Department]='Central Supply'") in the immediate window, it returns as 0, yet there are 3 records in the Department Field with "Central Supply". If I physically open tblEmployee, and change Department on 1 of those "Central Supply" records, close...

It's an update query strSQl = "UPDATE tblStaff INNER JOIN tblEmployee ON tblStaff.SSnbr = tblEmployee.SSNbr SET tblEmployee.Department = [tblStaff].[Department];" DoCmd.SetWarnings False DoCmd.RunSQL (strSQl) DoCmd.SetWarnings True

DCount works but only if I manually update the department.