Search results

Try a Google search for Access Password. This should provide sites offering software to get around or display the password

Public Sub CreateNewTable() On Error Resume Next Dim myDb As DAO.Database Dim tableName As TableDef Dim indexNew As Index Set myDb = OpenDatabase("C:\MyFolder\myDataBase.mdb") Set tableName = indDb.CreateTableDef("MyNewTableName") With tableName .Fields.Append...

To finish answering the question. Yes you can link tables using code. A search of the forum will provide code examples/links.

It can be acheived by having a split FE/BE database. If you need to add/amend forms, queries, reports etc. then you can send a replacement frontend. If you need to create or change tables, indexes, relationships etc then you can use a third database to apply changes to the BE by use of...

Hi Rachael I know we have corresponded before on the joys of PDW. I can’t offer any advice on alternate products but I did a while ago experience problems with installing on 2000. It came about after I had upgraded the operating system to XP Pro and the PDW was picking up later versions of some...

If I understand correctly you want a Program Group on your Start Menu with two sub Menu Items. If so when in the PDW for the Start Menu Item create two new items. In the properties of the first enter in the target something like /runtime "$(AppPath)\myFirstDb.mde" in Start in $(AppPath) for...

Are you looking to create a pop-up menu? If so then create a customised Access toolbar and when happy it works change it to a pop-up via the customise toolbars properties. Set the forms Shortcut Menus to Yes and Shortcut Menu Bar to the name of the pop-up menu. When you right mouse click the...

I use a similar approach but with two BE mdbs and a FE mde. The prime BE is shared across the network and the second (with temp/work tables) on each of the local PCs, compacting on close. It's worked fine for a number years. Keith

I have Access 1.0 Evaluation Kit which is dated August 1993. I think it first appeared in the UK late 93. Recommeded memory 4mb, minimum 2mb and 8mb hard disk.

X = CurrentDb.Name will provide the full db path. You can then manipulate the string, e.g. search for last "\" (instrrev if you have access 2000 or xp) to give the current folder. Hope this helps

Have a look at pdf995 (google search on pdf995). It may help.

Try PDF995 (Google search). You output PDF as a psuedo Printer which perhaps presents another problem unless you are using Access 2002 because earlier versions do not have a Printer Object. Hope this helps.

Many thanks Mile-O-Phile. I found just what I was looking for and I'm sure the sites will prove extremely useful for the future.

I would like to be able to identify the top and left coordinates of a given control on any open form relative to the Windows screen.. I’m sure this must be possible but its beyond my skills.

I think you may have to enclose in brackets, e.g. me.orderBy = "[StartDate]" me.orderByOn = True

I have found that on occasion Access throws a wobbly and gives the sort of problem you've experienced. I suspect that it is not directly the change to DAO 3.0 that's given the cure but rather that the change is causing the references to resfresh. Try putting 3.6 back in, it will probably work.

Check that your references are okay. I suspect one or more is missing.

Hi Marion After you have defined the field and before you have appended it use the attributes property, e.g. td.Fields![SMID].Attributes = dbAutoIncrField You will also need to make the field dbLong rather than integer. hyperlink is similar but the field needs to be described as dbmemo.

Hi Arage I think what you are looking for is FaceId. It's a long time since I did the following code which is a direct extract from from my app. I can remember it gave me a headache at the time. Hope it helps. Set X = CommandBars.Add(menuname, msoBarPopup)...

I suspect you are right in guessing it's a reference problem. I recall reading that the DAO refence needs to be at the top of the loading list. You could also try adding another reference (any reference), compile, remove the added reference and compile again. You could also Dim your database and...