Search results

cheers. have got both rename and copyobject working , but what I'm trying to do is create a copy of the table in the BE, but as a part of an import function in the FE. In other words, can you copy tables in a different db from the one you're in?

The simple answer is always the one that evades me. N To do this for all of the fields, try dim Ctl as control For Each ctl In Me.Controls If Forms!form1.NameOfUpdateFieldFromInitialForm = "Edit" Then Me.AllowEdits = False End If Next

Use your if statement to create the security. The line would be along the lines of me.NameofControl.enabled=false This will prevent a user from typing in the listed control. If you haven't got too many fields, follow the example and list them all. If there are too many, I'll try and amend...

for a simple solution have an unbound text box (not visible) that you populate with either "edit" or "view" as a part of opening the data form process. In your data form, set an on open statement that looks at the text in the TB you've just created. Something like; If Forms!form1.Fcn =...

After appending your table defs (or however you've created your tables) call something along the lines of Dim db As DAO.Database Dim tbl As DAO.TableDef Dim idx As DAO.Index ' Open the database Set db = CurrentDb Set tbl = db.TableDefs(strTblName) ' Create Index object...

I have a table that is overwritten every month, but want to keep a copy of the old table (in the BE) for audit. How can I control the BE from the FE and is it possible to create a link to the new table in code? Hope someone can help!