If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Backend update
I think I've figured out how to use the B/E upgrade mdb file. How do I add
an autonumber field - this is not listed in the drop down list). Thanks, J. |
#2
|
|||
|
|||
Backend update
Also the command RunCommand acCmdSaveRecord always generates an error
"Jason" wrote in message ... I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). Thanks, J. |
#3
|
|||
|
|||
Backend update
Found how to set autonumber - it was at the top of the list
But can't set property type Caption. Nor set default value to "". "Jason" wrote in message ... Also the command RunCommand acCmdSaveRecord always generates an error "Jason" wrote in message ... I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). Thanks, J. |
#4
|
|||
|
|||
Backend update
I'm getting
Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? "Jason" wrote in message ... Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". "Jason" wrote in message ... Also the command RunCommand acCmdSaveRecord always generates an error "Jason" wrote in message ... I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). Thanks, J. |
#5
|
|||
|
|||
Backend update progress
It's taken me all day to sort most of this out - one of the errors being
that there was an update command for an empty table. I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". Also the command RunCommand acCmdSaveRecord always generates an error I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). --- J |
#6
|
|||
|
|||
Backend update progress
Hi Jason,
I assume you are referring to my Back-End Update code in your various posts. If so, how are you getting on. You seem to be finding problems and then finding the answers yourself. Have you now fixed all the bugs in your code, if not then let me know and I will try and help. Peter Hibbs. On Sat, 3 May 2008 20:31:56 +1200, "Jason" wrote: It's taken me all day to sort most of this out - one of the errors being that there was an update command for an empty table. I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". Also the command RunCommand acCmdSaveRecord always generates an error I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). --- J |
#7
|
|||
|
|||
Backend update progress
All OK at this stage except I can't set the default to "" for text fields.
"Peter Hibbs" wrote in message news Hi Jason, I assume you are referring to my Back-End Update code in your various posts. If so, how are you getting on. You seem to be finding problems and then finding the answers yourself. Have you now fixed all the bugs in your code, if not then let me know and I will try and help. Peter Hibbs. On Sat, 3 May 2008 20:31:56 +1200, "Jason" wrote: It's taken me all day to sort most of this out - one of the errors being that there was an update command for an empty table. I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". Also the command RunCommand acCmdSaveRecord always generates an error I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). --- J |
#8
|
|||
|
|||
Backend update progress
Jason,
I would just leave the Default Value property blank so that it defaults to Null, I don't really see the point of setting it to "" (unless I am missing something). Peter Hibbs. On Sun, 4 May 2008 09:33:41 +1200, "Jason" wrote: All OK at this stage except I can't set the default to "" for text fields. "Peter Hibbs" wrote in message news Hi Jason, I assume you are referring to my Back-End Update code in your various posts. If so, how are you getting on. You seem to be finding problems and then finding the answers yourself. Have you now fixed all the bugs in your code, if not then let me know and I will try and help. Peter Hibbs. On Sat, 3 May 2008 20:31:56 +1200, "Jason" wrote: It's taken me all day to sort most of this out - one of the errors being that there was an update command for an empty table. I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". Also the command RunCommand acCmdSaveRecord always generates an error I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). --- J |
#9
|
|||
|
|||
Backend update progress
I've got into the habbit of using TxtFld & "" in if statements and other
areas because previous fields (in the years work) could be null - I've been getting invalid use of null etc. So no problem with sticking with empty field. "Peter Hibbs" wrote in message ... Jason, I would just leave the Default Value property blank so that it defaults to Null, I don't really see the point of setting it to "" (unless I am missing something). Peter Hibbs. On Sun, 4 May 2008 09:33:41 +1200, "Jason" wrote: All OK at this stage except I can't set the default to "" for text fields. "Peter Hibbs" wrote in message news Hi Jason, I assume you are referring to my Back-End Update code in your various posts. If so, how are you getting on. You seem to be finding problems and then finding the answers yourself. Have you now fixed all the bugs in your code, if not then let me know and I will try and help. Peter Hibbs. On Sat, 3 May 2008 20:31:56 +1200, "Jason" wrote: It's taken me all day to sort most of this out - one of the errors being that there was an update command for an empty table. I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". Also the command RunCommand acCmdSaveRecord always generates an error I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). --- J |
#10
|
|||
|
|||
Backend update
On Sat, 3 May 2008 16:47:51 +1200, "Jason" wrote:
I'm getting Run-time error '3010' Table 'TblName' already exists. Is there a way to check if a table exists before trying to create it? "Jason" wrote in message ... Found how to set autonumber - it was at the top of the list But can't set property type Caption. Nor set default value to "". "Jason" wrote in message ... Also the command RunCommand acCmdSaveRecord always generates an error "Jason" wrote in message ... I think I've figured out how to use the B/E upgrade mdb file. How do I add an autonumber field - this is not listed in the drop down list). Thanks, J. Jason, you may be assuming that the volunteers here can see your computer monitor and read your mind concerning what you are trying to accomplish. Maybe some of the gurus around here can, but I certainly cannot. Please explain the context, what you're trying to accomplish, what steps you have taken to accomplish it, and the specific error messages you're getting. -- John W. Vinson [MVP] |
|
Thread Tools | |
Display Modes | |
|
|