Search results

I assume that your year starts on 1st April otherwise I would have suggested DatePart and done away with all the code. You can still use DatePart though. This is not actual code but a suggestion. All assume week starts on Sunday and 1 Jan DP1 = DatePart ("ww", year/04/01) = Weeks from 1st Jan...

Make the app a .accdc or .accde See Access Package and Deploy - Make your db a Standalone app for more info on file formats (near the bottom of the OP).

Re: Access Package and Deploy - Make your db a "Standalone" app Open your DB Show System objects (in the navigation options) See if USysRibbons is there. If not the you need to create it. It is a table with 3 fields: ID (Autonumber) RibbonName (Text) RibbonXml (Memo) MyHide - goes in the...

Read this article on Bang vs Dot

Did you try the code where you only have one combo? Private Sub Combo1_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[Field2] = '" & Me![ComboField1] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub Field2 = Field in the form that...

The code I gave goes into the USysRibbon table. See How to: Hide the Ribbon When Access Starts or just Google it. There are lots of simple to follow tutorias on the subject. Runtime see Access Package and Deploy - Make your db a 'Standalone' app

You can either disable the standard ribbon and have custom ribbons where you need them (lots of links available on this topic) by editing the USysRibbon table. Example MyHide <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true">...

Sorry didn't digest your the whole post. What you are saying here is that the users wants to backup the FE file or the file where the app is not split. The code I posted was a backup of the BE where the app is split. Sorry should have made that clear in my OP in FAQ. I will go back and ammend...

I posted the code. The code is copying only the BE files (.accdb). If you look at the rem line above it tells you to change the file extension as needed. The need was to bypass .laccdb files. If you only have one BE file then substitute this. I have 3 BE files in my app. File structure used by...

No more creating 2 db's with 2 sets of code and 2 sets of custom menus. Even to the extreme of 2 sets of help files with 2 sets of screen shots. Or having to test the app on 2 computers (or on a virtual computer) to see if the 2003 version works. Your client requests a change or submits a bug...

Last thing to do is to create a "relink to backend" button for your app. That way is, for any reason the path to the BE changes, the user can easily relink.

Extracts from the Access help file: Access 2007 Developer Extensions and Runtime

I feel like I'm posting the same comment in every other thread. Forget which version of Access a user has. Or even if they have Access installed on their computer. It doesn't matter. If you are designing your app in 2007 or 2010 then just package your app to run under Runtime. For more...

Package you app as a 2007 or 2010 Runtime. That way it doesn't matter which version of Access they have, or even if they don't have Access.

Why not just password protect your BE?

All correct. Rather create a new FE with the forms that "perform some tasks" and link that to the BE. Or even have a secured Admin section in your FE.

Many install compliers have the ability to read the registry and act on what they find. For the full install, write HKLM\MyApp\Version\0.2 to the registry. For the updated DB first check the registry for the installed version. If <0.2 then install and change registry. If >=0.2 then do nothing...

Be professional, use Runtime and Developer.

Years IIf([DOB] Is Null,"",DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")>Format(Date(),"mmdd"),1,0)) Months IIf([DOB] Is Null,"",IIf(Day([DOB])<=Day(Date()),DateDiff("m",[DOB],Date())-[Years]*12,DateDiff("m",[DOB],Date())-[Years]*12-1)) Days IIf([DOB] Is...

You need Access 2007 Runtimes and Access Developer. Both are free from Microsoft. Open Access 2007 Goto Access Help Type "Introduction to the Access 2007 Developer Extensions and Runtime" into the search box and press enter.