 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Backend 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 > 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 "". > 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). > > > > 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? > 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 "". [quoted text clipped - 5 lines] > > > 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. >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. [quoted text clipped - 11 lines] >--- >J All OK at this stage except I can't set the default to "" for text fields. > Hi Jason, > [quoted text clipped - 20 lines] > >--- > >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. >All OK at this stage except I can't set the default to "" for text fields. >> Hi Jason, [quoted text clipped - 23 lines] >> >--- >> >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. > Jason, > [quoted text clipped - 31 lines] > >> >--- > >> >J >I'm getting >Run-time error '3010' [quoted text clipped - 9 lines] >> > > 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.  SignatureJohn W. Vinson [MVP] Don't know what you need. I'm using the code I downloaded to create/modify the tables. I found that once the code had run it did not append to the table that recorded the latest ID of the table modifications therefore when the code ran it tried to recreate a table that already existed - alwasy starting at 1. I then added my own code to check if record count was 0 - if so add new record then use the ID as the value. Once the value had been entered into the upgrade progress table the original code worked (if dcount >0). However, to improve upgrades in the future how do I determine if a table exists before VBA tries to create it? > >I'm getting > >Run-time error '3010' [quoted text clipped - 16 lines] > 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. >Don't know what you need. I'm using the code I downloaded to create/modify >the tables. "The" code. What code? You haven't indicated where you downloaded it from, or posted any of the code. >I found that once the code had run it did not append to the >table that recorded the latest ID of the table modifications therefore when [quoted text clipped - 4 lines] >>0). However, to improve upgrades in the future how do I determine if a >table exists before VBA tries to create it? Again, Jason: you are not the only person posting to this newsgroup. Maybe you have posted your code, a description of your table structure, and what specific opreations you're trying to carry out... but I'm sorry, as an unpaid volunteer I really don't have time or interest to Google search for all your prior postings. If you post a SPECIFIC question, *with code and a description of your tables*, I or another volunteer will be glad to try to help. But please reread the above with the assuimption that what you posted is *all* the information available to someone trying to help: someone who does not know your business, the structure of your tables, or the content of your code. Not much to go on, eh? SignatureJohn W. Vinson [MVP] I shall repost: Jason, You can update the Front-End file easily by sending the client a new version. However, if you will need to make changes to the Back-End file you need a different method. Assuming that you cannot visit each client to make the necessary changes you need to add some code to the Front-End which will make the relevant changes to the Back-End files automatically. There is code at this site :- http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE%20Update%20U tility.mdb' which will do that for you. Just import the form, table and code module into your database, add one line of code to your 'start up' form and you are done. To add a new table or field to the Back-End you just call up the BE Update form, enter the details of the table, field, relationship, etc and the Back-End file is updated without affecting the client's existing data. You will also need to add relinking code to relink the Front-End file to the tables in the Back-End file. See this site to do that automatically :- http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb' There is full documentation on both sites to explain the procedure fully. HTH Peter Hibbs. On Thu, 1 May 2008 18:58:18 +1200, "Jason" <JAllenNZ@hotmail.com> wrote: >It is split as you say the tables in the user mde is for temporary data and >data i enter for look-ups etc. Since the data files have changed over time I >have found the process of copying and importing easier. Can you post an >example code where the table is checked and modified (i.e. fields added, [quoted text clipped - 78 lines] > the structure of your tables, or the content of your code. Not much to go on, > eh? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.