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.

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.

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.

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.

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

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

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

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

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

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]