I tried to search the forums for an answer but I still can't seem to solve the problem.
I receive the "Not a valid bookmark" error message when attempting to open my database. I have tried the compact tool through access and also jetcomp but it just brings up the same error message on access and says "error compacting database" on jetcomp. Can anyone provide a solution to my problem in order that i can either open the database or else retrieve data from it?
Many thanks, any help appreciated
Jon.
I have attached the database in case you have any software which might be of use.
one of the databases at my place has started acting really strange and was wondering if anyone knows what could possibly be wrong?
there's only one big tble holding about 7.5 k records with approx 10 fields
info that was entered yesterday has now been deleted (by access?) and when you scroll down or go down to the end records, all those records that were there yesterday now show either #error or #deleted and then an error popup appears saying "Not Valid Bookmark"
The UID doesn't appear to be working either, i.e it's not incrementing properly?
I am attempting to split an Access 2007 database. My company has two locations. From my location we are remote connecting into the server. While down there they are connecting directly. When I split the database, people in my location can use it fine. When people down there use it, they get a not valid path error.
This is because the network drives are mapped differently. I have been reading that the solution is to use the UNC for the back end file path.
Here's the issue: Access 2010 Database with a Switchboard SharePoint 2007
After I moved the tables to the SharePoint site everything is working correctly except the Switchboard Manager. When I try to the Switchboard manager i get error that is was unable to find a valid Switchboard in the database and asks me to create one. If I click Yes I get error that Table 'Switchboard Items already exists.
My Database has the following: 1. Switchboard Items Table 2. Switchboard form
I can access both of them and attached screenshots of the errors and tables in the database.
I am developing an Access database, and using the Access 2007 Developer Extensions to "compile" it into an installable program which includes the freely distributable Access 2007 RunTime, for users who don't have it already installed.
I am planning on charging a subscription fee to use my Access database. Are there any existing method for handling making sure the user's subscription is still active, and if not, either locking them our or preferably making everything read-only? If there aren't any existing methods anyone can point me to, does anyone have any ideas?
I plan on being the person who installs the application the first time, however I'm sure instances will come up where I instead mail the user a CD for them to install.
Regardless of whether I complete the first install, I'm not interested in going to each users' location periodically regarding the subscription.
I'm more interested in going the route of the user typing in some type of registration code, which is validated for read/write access for a period of time.
I don't want to rely on the user having an internet connection, but if they had one, I could certainly go the Microsoft model (try internet verification, if it goes wrong or there isn't a connection, have user call in.)
I have a small database for producing various financial reports, by date period (from/to). It works perfectly except when there are either no payment records or no receipt records for the chosen period. Naturally enough, MS Access comes up with the message "Database engine does not recognize 'payment' as a valid field name or expression" --- !!!
Is there some way I can tell MS Access that I don't mind if eg the payment column result is zero?
The structure of the table on which the report is based (via a crosstab query) is :
transaction date auto number ID transaction type (either payment or receipt, chosen by form's drop down box) - TEXT amount - CURRENCY receipt type - TEXT payment type - TEXT fundno - TEXT
The crosstab query design is as per the attached jpeg file
Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..
Set AcApl = New Access.Application Call AcApl.OpenCurrentDatabase(strfolder, True) Set AcProj = AcApl.CurrentProject
Set frm1 = AcProj.AllForms
intCount = frm1.Count
But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..
This should be a simple one, but right now I just can't get it. How do I get a Bookmark to pick up on the entry that I chose from in a combo box when there are multiple entries for the same item I want to chose from (ID - primary key is unique, just not the name of the item - 'FullP', and that is what I am using)?
For instance I want to be able to choose the correct record where 'FullP' will have multiple entries, but unique ID's.
Originally I had this bookmark off of a set of cascading combo boxes on a form, but unfortunately when using this set-up the ID (primary key) is not transfered foward, the rest of it works fine and it takes me to the first record for each 'FullP' (just not the correct record when multiples are entered). The record source for the combo is similar to:
“SELECT [LDetails].MDay, [LDetails].Session, [LDetails].DL, [LDetails].FullP “ & _ “FROM [LDetails] WHERE (((([LDetails].MDay)=Forms![DEntries]!EDay) “ & _ “And ([LDetails].Session)=Forms![DEntries]!Session) “ & _ “And ([LDetails].DL)=Forms![DEntries]!DL) “ & _ “ORDER BY [LDetails].FullP, [LDetails].ID;” AND
Dim Rs As Object Set Rs = Me.Recordset.Clone Rs.FindFirst "[FullP] = '" & Me![FullP] & "'" If Not Rs.EOF Then Me.Bookmark = Rs.Bookmark Rs.Close When changing the final combo box and binding it directly to the query, the primary key is transfered foward correctly, but I am still having problems getting it to go to the correct record. I have added:
Dim Rs As Object Set Rs = Me.Recordset.Clone Me.RecordsetClone.FindFirst "[FullP] = '" & Me.FullP.Column(0) & "'" If Not Rs.EOF Then Me.Bookmark = Rs.Bookmark Rs.Close This just takes me to the very first record...
I would really like to keep the cascade combo boxes working. Any ideas?
I have a search form (Form A) that as I type in a text box the contents of the listbox refreshes to show only those items that match the text in the text box. When you double click on any of the items in the listbox it jumps me to a detail form based on the ID field. On the detail form, there is a subform for any notes which uses a listbox (it lists all the notes entered for that detail item).
The notes subform listbox is only displaying the first note entered in the database.... So if I search for information in case 43, I find case 43. I double click on case 43 and the details for case 43 pop up. I go to the notes subform and the listbox showing all the notes entered is only showing the notes for case number 1.
I've found a few posts about this subject, on the forum, so I'm guessing that my database (or at least one table therein) has become corrupt.
I've tried the various suggestions I could find (compact and repair, import into a new Db, etc) and none have worked. I have, however, located a version of the database from the day before this error first occurred. I've checked the problematic table and it contains no 'Error#' lines.
The single table affected contains a lot of data and is pretty irreplaceable. I have daily backups, so no information will actually get lost, but if I can't add any new data to it (for fear of corruption) it won't be much use.
1) What causes this problem? I can't seem to find a definite answer to this one. 2) Is there one definite fix I can use to prevent the problem occurring again?
Hi, I am having some weird problems when using bookmarks. All I want to do is display 1 record at a time in a listbox each time a user clicks a button.
At the moment I save the bookmark value to a global variable, and when the user makes another click is should move to that record. Right now it gives me a "Not a valid Bookmark" error when I click on the button for the second time. First time is alright, but second time it comes up with that error. Any help is appreciated.
Here's an example of my code
Option Compare Database Dim varbookmark As Variant
Private Sub cmdadd_Click() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset
With lstHotel .ColumnCount = 4 .ColumnWidths = "1in;" End With
Do While rst.EOF <> True If varbookmark = "" Then lstHotel.AddItem rst!Name rst.MoveNext varbookmark = rst.Bookmark Exit Sub Else rst.Bookmark = varbookmark lstHotel.AddItem rst!Name rst.MoveNext varbookmark = rst.Bookmark Exit Sub End If Loop
I have a knowledge base database which lets the user search for articles containing answers to common problems and issues. Some of the users want to be able to bookmark certain useful articles. The DB is a front end/back end design so I am thinking if I have one table stored in the front end which can be used to store that particular user's favourites then that would be great. However, I a little stuck on how to implement this. Ideally, I'd like a simple checkbox option next to each article, which when ticked, would store that article ID in that user's local front end.
Private Sub Form_Current() If Not Me.NewRecord Then With Me.Q_Subform.Form .RecordsetClone.FindFirst "N=" & Me.N .Bookmark = .RecordsetClone.Bookmark End With End If End Sub
The problem is that when the Q_Subform has no records I have the error 3021.
How can manage it. It's the last step before ending My db
I have been working on a database back and forth and home and at work. Today I saved my database from home and onto my computer at work. The database is not opening here at work. It works fine at home. When I attempt to open it, it tells me Access has encountered a problem and needs to close and it closes.
I tried the Compact and Repair.. Access still shuts down on me. I made a new empted database and tried to import the tables and forms into it.. Access still shuts down on me.
It's getting frustrating because I've been trying to get this working for 3 hours now with no success.
Here's a little problem I have and wondered if anyone knows a way around it.
I currently have many databases that I have created for work and they are quite happy running away doing what they are meant to do on a 2000/NT setup, we will soon be switching to our parent company's network 2003/XP/Citrix which is presenting me with the following problem and we do not have any control over how this is run.
We can no longer create desktop shortcuts to the databases as current, they will place 1 database in the start menu and would like this to be used as the database menu so that all databases are launched from this.
So I am trying to launch access databases from within an access database (Access XP), here's what I have tried so far
Shell - works when I use full MS Access but does not work in Run Time versio n which is what the users will access, shows no error, it just beeps and does nothing.
SendKeys - %fo<FileName>.mdb~ - again works in full access but not in Run Time as RT does not have 'open' in the file menu.
FollowHyperlink - this actually works but I can not get this to open the new database as a full screen window, this requires the user to either run everything maximized (not ideal as some forms are designed to run side by side) or for them to resize the main forms.
Are there any other ways to open a database from within access RT version that will open the access application full screen?
A ex-coworker created a .mde database, but didn't save the .mdb version. The .mde version has been working fine, but today it closed when the end-users tried to open it. It looks like it tried to open the start up form, but it closed. I was able to get into the database and launch the second form, but the start-up is the issue. What could cause the start-up form to keep the database from opening?
Ok....Just when you think it's all running smoothly.... :( I have a combo box, MDLastName, with a column count of 9, with column 2 displaying and all others hidden. The selection made with this combo populates 7 corresponding fields (first name, address, etc). It's working perfectly.
The first problem I encountered was with identical last names, but different corresponding data. When I selected Jones, for example, it would populate the first Dr. Jones and his info, listed in the table. However, if I selected the second Dr. Jones in the combo list, it was still populating only the first Dr. Jones' info. I resolved this by binding the fist column (ID, aka primary key), but still hiding all colums but column 2. First problem fixed..
Next, I have a Word Template document bookmarked to receive data from the form, frmDenial. I have all the coding working fine and dandy to insert the data from the fields on the form, save, and print. However, instead of inserting the text from the MDLastName, it is inserting the primary key (because it is the bound column in the combo box). Now, because of the first problem discussed above, I cannot change the bound column to column 2 (containing the data I need in the Word Template). How can I get the right info to appear in my template with the bookmarks?
Public Sub cmdRequery_Click() Dim vFlag As String vFlag = Me![EncounterNbr] Me.Requery
With Me.Recordset .FindFirst "[EncounterNbr] = '" & vFlag & "'" Me.Bookmark = .Bookmark End With
The user starts on a continous form and opens a record, makes some changes, and then when that form closes it triggers this public sub.
The code does what I want it to do in that it returns to the last encounter number that was selected (now on the continous form again) and it requeries and shows anything that was changed about the record on the form that was closed before requery.......
But it always resorts and moves it and I want it to stay in the same spot unless the user sorts. Is there any way to make that happen?
The problem: I have my database set to open a form on start-up. On opening that form I put in a command for a message box. When I click OK on the message box it tries to open the form again which leads to the same message box. I need to somehow get to the design view on start-up. Any help would be appreciated. Thanks Bob
I have a question. I have a button on a form. When I press that button, another database should be opened.
I tried this:
Dim dbMyDB As Database Dim rsMyRS As Recordset Set dbMyDB = OpenDatabase("C:DocumentenJohnnyStyle_be.mdb") Set rsMyRS = dbMyDB.OpenRecordset("nslArtikel", dbOpenDynaset)
When I'm trying to open a back end database which was previously created is MS Access 97 it gives me the following error;
Cannot update. Database or object is read-only.
I have tried running the "Compact/Repair Function of MS Access 97 and MS Access 2003 to no avail.
I have tried converting the back-end to Access 2003 as well but I still get the same error message. I can link to the database tables from an Access 2003 database fine with no error message!!
Has anyone got any suggestions before I have to take it offline and rebuild the back-end and then copy the data across from the old one?!!!
I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.
I tried that database on 3 different PC's with the same effect.
Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.
I am creating an order processing system and am using 2 tables
OrderHeader OrderLines
The OrderHeader table includes the number of orderlines on the order.
I want to ensure that when a user completes the order lines they don't up in a line number greater than the number of lines and want to programatically get the number of lines from the order header table.
The form links to the ID of the order header table by using a combo box, which works fine and I can even display the number of order lines in the combo box.
I don't know how to use an ADODB recordset to query the current database.
I can't use something like : objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:filesdatabase.mdb"
which i see all over the place, because I don't know where on the PC this will be running on it will be stored.
There must be a simple way to find out a value from a field within a recordset of the current application database?
