Search results

Thank you very much Wayne.

Hi All, Need a help with a UPD qry. I Have 3 fields. The names are: ISSN1, ISSNX and ISSN3. I want an update qry to delete the 2 from the 3 fields and make them null. The rule 1 is to keep the smallest number from the 3 fields. So let’s say we have ISSN1= 1,25, ISSNX =2,26...

Thanks David.

Hi all, I have a table in a database with exactly the same data (double or triple data) but with different ID. Example ID - NAME – SURNAME 100 – JOHN – SMITH 252 – JOHN – SMITH 326 – JOHN - SMITH Please need a help to delete the double data and keeping the data order by the newest...

Check to see if now is working.

The right direction is the following: First you have to DROP INDEXES. Try this Code before you delete: ======================================== Dim str str = "DROP INDEX [YourField] ON [yourTable]" CurrentDb.Execute str, dbFailOnError ======================================== The [YourField]...

The 2007 Microsoft Office Suite Service Pack 2 (SP2) is here: http://www.microsoft.com/downloads/details.aspx?FamilyID=b444bf18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en

Go here: http://support.erol.co.uk/index.php?_m=downloads&_a=viewdownload&downloaditemid=83

Try this: Create a button to your form and put this code: Dim strSQL strSQL = "ALTER TABLE tblYOURTABLE ALTER COLUMN txtYOURCOLUMN NUMBER" CurrentDb.Execute strSQL, dbFailOnError MsgBox "Column change to number", vbInformation, "your db"

Try this code: Private Sub frame17_AfterUpdate() Select Case Me!frame17 Case 1 'your code Me.frame17.DefaultValue = 1 Case 2 'your code Me.frame17.DefaultValue = 2 Case 3 'your code Me.frame17.DefaultValue = 3 End Select...

The code is correct. It is obvious that you are doing something wrong. Maybe your table or you field is “double name”. For example if your table is like this: “Table Clients” Or you field is something like this “Client ID” then You have to put brackets. Dim strSQL...

First you have to create a simple qry TO CHECK YOUR DATA and then APPEND qry based on the simple qry: First edit your table and create a new field named NewTRAVTIME - type: number. Then Try This in the field of your SIMPLE qry: NewTRAVTIME: Left([TRAVTIME];InStr([TRAVTIME];" ")-1) Then in...

Glad to help.

Now i think that you need help from a Microsoft Access MVP from this forum. Also i suggest you to send e-mail to the developer of the RestartDatabase. I Think he knows all the answers about your problem. Good Luck...

I Found this database on the internet. I Think this is exactly what you are looking for. Enjoy...

Wait a couple of minutes. I Think i found a solution to restart the DATABASE.

For to open a database by code try this: Application.FollowHyperlink "file://C:\file\file\file.mdb" To tell you the truth i do not know how to AUTO Re-open a database by code.

Try this my friend: ======================================================= Function FieldExists() As Boolean Dim db As Database Dim tbl As TableDef Dim fld As Field Dim strName As String Dim strSQL Set db = CurrentDb Set tbl = db.TableDefs("YOUR_TABLE") strName = "Comments" For Each fld In...

Try this: Private Sub cmdImport_Click() Dim msg As String, button As Variant, title As String, response As Variant msg = "Is the updated file Task Import placed in 'Z:\PM Metrics\Task Import.xls'?" button = vbYesNo + vbDefaultButton2 title = "File Location Checkpoint" response = MsgBox(msg...

If any of your tables is more than > 2 gbytes then you have to go to Oracle or to SQL Server. The other option is to split your database and to create 2 or 5 or 10 or 20 (or i do not know how many) databases as a back end, each one heaving 1 or 5 or 10 tables with the maximum size of 2 gbytes...