Off2013-Cannot open a database created with a previous version of your application

Hello,



My department is rolling out Office2013 to the workstations in the next few weeks, and I was tasked with testing the various MS Access apps with the new version.



I expected some normal stuff, such as files/references to be weird - normal stuff.



But this is a problem I don't know how to handle. When I fire up this older MS Access app using Office 2013 I get the following message:



"Cannot open a database created with a previous version of your application"



And then the app closes... The app is called by a shortcut that has a /wrkgrp parameter since the app is using an mdw for security. ALso the app is split into a backend that lies on the network, and all the users have local front ends on their machine.



My first thought that this was a problem because the data storage container was perhaps an old version... so I opened the application's parts (the front end, and the backend) individually and did the Save and Publish to "2002 - 2003" format but still get that error.



Am I barking up the wrong tree? How can I find out what version of the db this is? It opens and runs fine in Office 2010. I'm beginning to freak out a little bit...



Is "save and publish" the same as Convert?



Thanks,

-Matt G.

Off2013-Cannot open a database created with a previous version of your application

Day Name from Date

I have a report on which I have two unbound text boxes that I want to populate with the dayname for a related date. One is called txtStartDateName, and the other...... yep, you guessed it, its txtEndDateName



txtStartDate name Control Source is:

Code:

---

=WeekdayName(Weekday([txtStartDate]))

---

With very similar for txtEndDate



Now, the odd thing is that when I run the report, the day names that appear in these boxes are the day before the actual date - - - so if I used today's date (26/03/2015), I would get Wednesday instead of Thursday as it actually is?



At first I thought it was my PC at work screwing around, but I have now tried a copy of the database on my new PC at home and it is exactly the same?



Any idea what I am doing wrong?

Day Name from Date

A CMD button to clear a table column

I'm currently making an Experience Statement for my company. In one of the forms I've created I an Industry sort that is weighted and connected to a table so that it'll show a report based on the numbers provided IE. 1-5 One being shown first and a blank statement not showing on the report at all.



I have the report function working correctly the only thing I would like is a cmd button that clears sort table of numbers so that it doesn't show anything and can start fresh. What VBA code shall I use?



I was thinking something along the lines of this, but it's not working.



Dim s as String

s = "UPDATE All_Projects_Sort_Table SET Industry Sort = Null;"

CurrentDb.Execute s

Requery







Attached are some images to give you an idea of what I am talking about. I hope I'm making sense.

Attached Images

	Design Custom Report Selector.PNG (19.0 KB)
	Custom Report Selector.PNG (28.0 KB)
	All Projects Sort Table.PNG (21.7 KB)

A CMD button to clear a table column

Want to have an event happen when ctrl+r is pressed

Hey all!



When I press ctrl+r I want to copy a couple values from the previous record (on a continuous form) into the current record. I figure you would use the KeyPress event for this, but I want the event to occur when ctrl+r is pressed while Me.TechName has the focus. I'm just a little confused about how to work the variables, etc in this KeyPress event.



For a bit more detail, the event is this: I want Me.TimeIn and Me.TimeOut to be populated with the same values as TimeIn and TimeOut in the record BEFORE in this continuous form. I'm also looking into how I would code that procedure, so any guidance on that is appreciated as well!



Thanks much,

Kevin

Want to have an event happen when ctrl+r is pressed

Conditional Formatting Two Fields in Report

In my Access 2010 report, I am attempting to perform conditional formatting of one field based on the difference between two fields.



In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.



Any recommendations how I can conditionally format to do this? I appreciate your help ahead of time.

Conditional Formatting Two Fields in Report

Secure User Login System..

Hey ..

I'm looking for a secure user login system for my DB that has a Home form with 3 buttons: Invoices, Banks, Analysis.. each button has a macro that opens the form of the name on button..

So, i need to enable different users to login on the DB with different permissions.. like for the 'Juniors' to only open the Invoices button, add/edit on it but not delete and when trying to open other button a msg should pop up saying that it's not permitted, for the 'Seriors' to open all buttons but read only with no editing or adding, and ofc the 'Adminstrator' has all the access on all buttons..

Also, no one of the users can show the navigation pane or the hidden ribbon or show the design view or even enable any edit in the DB but ofc the adminstrator should be able to do everything since the adminstrator is the DB creator...!!

Secure User Login System..

Newbie

Hi,



Am not new to Access but am new to Access Web Apps. Look forward to learning all I can about this utterly amazing development platform. One can't help but feel with Web Apps that we are at the beginning of what will become an invaluable database resource.



Later,



Cybersteve

Newbie