Search results

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.

All of the records are successfully being inserted in step 1. The Insert query is written using VBA based upon user selection from checkboxes on a form (AKA: lengthy) step 2, all of the DCounts work except for Department DCount("[Department]", "tblEmployee", "[Department]='Central Supply'")...

Upgraded from Access 2003 to Access 2010. My DCount query was working fine in Access 2003 for many years but now I am having issues. Everything is written in VBA. Routine: 1.) Insert records into table tblEmployee 2.) Query table tblEmployee to count how many employees are in each department...

Well, he said +4 months so a criteria like: >DateAdd("m",+4,Date()) should do that. The only issue I foresee in this is "WHEN" they run this. IN that such case, using a Between criteria with DateAdd should solve it. I agree that that field should have been an established date and not just a...

Maybe this would work? MyMonth: CDate([Month Contract Expires] & "/01/" & Year(Date())) For the query field.

You can put this function in a module and call it from the query column. You'll have to come up with the criteria. Function MonthConvert(strMonth As String) Dim intNum As Integer MonthConvert = 0 On Error GoTo Err_MonthConvert If strMonth Like "Oct*" Or strMonth Like "Nov*" Or...