Search results

Good idea MStef! Easy and effective! Was looking in a totally different direction.....stripping WHERE clause from SQL statement...etc. Thanks again.

I need to have a button in the menu to reset the SEARCH-query. With a button I give access to this query to add criteria for the search. Often these criteria are not deleted, but other parts of the database also use this search. Can one of you help me with this problem?

Hi Bob. Did what you suggested (except setting enabled to no). This does the job, but raises another question. In the form I have fields and pending on the selection in the field it might deactivate other fields. This is now lost. Correct and, if so, is there a solution?

I have a form to view data. For that reason I do not allow edits, deletions, additions and I have also set data entry to no. In the footer I have a combobox of one of the datafields on the form. To type and/or select a value I want the form to be filtered for that value. Due to the settings of...

On the desktop MS Access 2003 SP3. On this computer I made the database. I converted a copy of the database via tools to 2000 format, because MS Access 2002 SP3 is installed on my laptop. I converted to 2000 format, because the menu gives me 97, 2000 or 2002-2003, but this last option is not...

When I copy my database from my desktop to my laptop I can run it, open the backend with the tables, but as soon as I want to open the code MS ACCESS tells me that the project is locked. On my desktop this does not happen. Any idea?

Eventualy I found my stupid error. I still had the recordset open! Sorry for that!

Eventualy I found my stupid error. I still had the recordset open! Sorry for that!

No Bob only the link to the table I wanted to alter was disconnected. The only reason where I can now think of is that once the code starts to add the column the backend as such is still in use. This would also be the case when all links are disconnected, isn't it? If that is the reason the...

Thanks DCrake for your help! The backend table is first disconnected and then connected. Perfect. The code I'm using (as given earlier in this thread) to add the column gives me still error 3211. Any idea on this?

Due to a modification I need to add a column to a table of the backend of my database with code in the frontend. After distributing the frontend and on opening it will modify the table by the users who all work stand-alone. The name of the backend is with all users the same. Due to the backend...

OK Bob, I will do that.

OK Bob, that's why I'm another user. Knowing this an idea could be to break the link with the backend table, add the column and reinstall the link. If this is possible do you know how to break and reinstall the link?

Thanks for your reaction Bob and due to that I now realise my explanation was not complete. Users of the database are not on a network using the same backend, but have the database on individual computers. The error I get is when I test the frontend linked to the backend. Any idea?

Due to an unforseen modification in my database, I need to add a column to a table of the linked backend. I do not prefer users to modify this table, but try to do this with code in the frontend of the release that comes with the modification. For me it seems impossible to add a variable as an...

I have to modify one of the tables of the backend once the frontend opens. Is this possible and how do I have to change the code? strSQL = "ALTER TABLE MyTable IN 'C:\MyDir\MyDB_backend.mdb' " & _ "ALTER COLUMN BackupFolder TEXT(250) " & _ "ADD COLUMN BackupAantal...

Thanks for your help tehNellie. It's now working :). By the way, if the recordset is completed and ordered can I then get the number of records in the set?

What I try to achieve is to sort the data of tblBackup on dtmBackupDateTime in descending order, so that the latest backup is on top of the list. After being able to do that I want to keep the required number of backups-1 and then backup the data.

Thanks for your help tehNellie and it works. Now I would like to order the table on dtmBackupDateTime descending. Again I have a problem with the SQL statement. Maybe you can give me directions again. DoCmd.RunSQL "SELECT [tblBackup].[pkBackupID], [tblBackup].[strBackupName]...

I'm trying to write a SQL statement to fill a table with the backup files as stored in the backup folder. I managed to create the table tblBackup with the fields strBackupName and dtmBackupDateTime. The names of the backup file are: Backup with the date and time of the backup added. I'm able to...