microsoft.public.access | Forum profile

  On Wed, 7 Jan 2009 19:56:01 -0800, Richard <Richard@discussions.microsoft.com> wrote: >Hi Albert > >I have a related question. If the relationships have been setup in the >diagram window prior to exporting the tables to SQL server do the >relationships need to re established? Depends on how the export is done. If you use the Upsizing Wizard the relationships will be read from the...

  Bruce is wrong Jet is crap. Move to SQL Server, because it has a future and Jet does not On Jan 7, 9:35am, "BruceM" <bam...@yawhodotcalm.not> wrote: > I wish I had found that tutorial or something of the sort sooner. From what > you have described Access is well-suited to your project, but yours is not > the simplest kind of database in that it includes the junction table. The...

  Try If Nz(Me.[AutoRenew], False) Then Me.[Review].Visible = True Else Me.[Review].Visible = False End If -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "sofiac" <sofiac@discussions.microsoft.com> wrote in message news:1FC1CB10-3BFF-4777-B922-0544DBAAF6F2@microsoft.com... >I am unable to add a new record and get the error message "Invalid Use...

  Alex: A primary key doesn't need to be a single column.; it can be a composite one of more than one column, which is exactly the situation in your case, where the five columns area a 'candidate key' and can consequently be designated as the primary key. Your table in fact illustrates a common situation as it is modelling a relationship type between users, groups, actions and times (regular, or overtime). You are...

  Bob, Are you saying you can't answer the questions below? Did you create the database to which you refer? >> 1. Is this a split database? >> 2. Does it give them the option to open 'Read-Only' if the others try to >> open it? >> 3. You could use an append query but I find it curious you can't do this, >> so what exactly are some of the error...

  Hi Steve, I'm feeling your pain now when using the Edit | Find dialog method of searching. I just opened a clean copy of Northwind in Access 2003, and then opened the Employees form. I selected the Personal Info tab, and clicked into the Notes field, at the beginning of the sentence. This is for employee "Nancy Davolio", and the mouse cursor is positioned just before the word "Education". I...

  Thanks for the help Clif, I must of pushed the mouse backwards or something. "Clif McIrvin" <clare.moe@nevergmail.com.invalid> wrote in message news:%23Tyg3uPcJHA.1676@TK2MSFTNGP03.phx.gbl... > "CW" <CW@discussions.microsoft.com> wrote in message > news:E7908283-65FD-44C9-B1B1-F89A75135E16@microsoft.com... >> Thanks for the suggestion Pete...

  Clint Marshall <ClintMarshall@discussions.microsoft.com> wrote: >I'm sorry, Tony, I didn't describe this well. No, you described it quite well. >I just opened VBA from Access and couldn't find anything useful when I >searched for "write #". from A2003 help. Write # Statement Writes data to a sequential file. Syntax Write #filenumber, [outputlist] The Write #...

  Hi The query will not affect the linked tables in the Table View. It is a good idea not to use this access facility as it will "always" lead (sooner or later) to users inputting data directly into the tables. What you need is a linking table (so you have a many to many relationship). Table1 = JobID + other stuff Table2 = CoulorID + other stuff Table 3 = JobID & CoulorID + stuff directly related to this...

  Simplicity, like beauty is in the eye of the beholder. For me it's a couple hours to write and debug code, for you it could be longer depending upon your skills. Yes, it is simple. It can be very simple if you set everyone's default open to Exclusive: Tools >>> Options >>> Advanced >>> Default open mode >>> Exclusive That opens all...