Beginner's Append Query Problem

I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
but I couldn't choose the table to which I would have appended because
that table wasn't on the list in the Append dialog box. Why is this
and how to fix?
0
p
1/23/2008 4:23:15 PM
access.queries 6343 articles. 1 followers. Follow

1 Replies
589 Views

Similar Articles

[PageSpeed] 23

p.numminen@suomi24.fi wrote:
> I was trying to follow the instructions on http://www.databasedev.co.uk/reset_autonumber.html
> but I couldn't choose the table to which I would have appended because
> that table wasn't on the list in the Append dialog box. Why is this
> and how to fix?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the target table is in design view you won't be able to append to it.
  Be sure the target table's design view is closed.

BTW, that site goes the long way to change the AutoNumber value in an
empty table.  You can run an INSERT query to put a new starting number
in the AutoNumber column.  It will also add a new record, but that
record can be deleted immediately after the INSERT.  E.g.:

To set the new start number at 500:

INSERT INTO target_table (auto_nbr_col, <other cols>)
VALUES (499, <other cols data in comma-delimited string>)

The new record will have an AutoNumber value of 499.  We need to delete
this record so the next inserted record will have a value of 500.  Run
the following query.

DELETE * FROM target_table

Now any new record inserted into target_table will have an AutoNumber of
500.
-- 
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup.  I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR5fygoechKqOuFEgEQLdRgCfXcSQinyVMhLIY+Ej8GAqhmjyb/0AoJgE
lPqy7AHiyfFnAwWtW0fITO0+
=0skY
-----END PGP SIGNATURE-----
0
MGFoster
1/24/2008 2:06:35 AM
Reply:

Similar Artilces:

Delivery Status Notification (Delay)
A user just forwarded me the following, asking my why it would happen: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. dennis@anonymousdomain.inc A few points of information: -- I told her it was likely that the recipient's mail server was temporarily down, but when I opened her inbox and examined the message header, it appears to have been generated by the postmaster account on our Exchange 2003 server. -- If I do an NSLOOKUP on our L...

Problem template file for project missing
Hi, I try to create a new UnitTest project in Visual Studio 2008 Development Edition. I get the message: "The template file for selected project type is missing". Well, I tried to repair Visual Studio but the message is still comes. Any idea how I can solve this problem? Thanks Christian I solved the problem. I had installed a language pack for Visual Studio Tools. Well, Visual Studio searched in the directory "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\1031" and not the subdirectory "1033". I deinstalled ...

strange memory leak problem
Hi all, I use _CrtSetBreakAlloc to break the code at the point the leaking memory is allocated and find that it is a CString allocated locally within a function. void Myclass::PrintInfo(CString &strTmp) { ....... CString strUser( "bah"); strTmp.Format(IDS_START_INFO, strUser,); ...... } Additionally I have found some other memory leaks occur in STL stream API calls, like << >>. This string will be freed when the variable leaves scope. What is the evidence that this is leaking memory (if you're relying on CrtMemCheckPoint, know that it doesn't work. ...

Advanced Filter
I am performing an advanced filter in Excel. One of my list fields is Name. When trying to display all of the records that end in with a specific character (lets say 'e'), I use the following criteria: *e When I apply the advanced filter, I am getting all the records that have an 'e' anywhere in the name field. I'm pretty sure I'm using the wildcard correctly. Enough to drive you nuts . .. . Thanks in advance, Randy In the criteria cell, enter: ="=*e" Randolph Pugh wrote: > I am performing an advanced filter in Excel. One of my list fields i...

Max Query
Hi all, I have 2 tables. One holds account numbers. One holds invoices, linked to account numbers. Ive got a query to show the latest invoice for each account number, via the MAX function. However, once this has been done, due to it being an aggregate function. There is no way of me editing this query once done. Is there any way around this, as i would like to only show the latest invoice, and edit information in that. Regards, A correlated sub-query in the WHERE clause might work for you if you don't have a lot of records. SELECT * FROM Accounts INNER JOIN Invoic...

Postcode Problem
I have a problem with a huge mailing list in Excel. The problem is that the postcodes are in the wrong format. They are at present in the format of NH129HS and I would like them to be NH12 9HS. All of my postcodes are 8 characters in length and I just want to insert a space as the 5th character. The postcodes are all in column J of my spreadsheet. Can anyone please help? Thanks Borough. ------------------------------------------------ Message posted from http://www.ExcelTip.com/ -- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum -- Hundreds of ...

Outlook Express 6 "Address Book" problem
Dear All, I have "Outlook Express 6" and I am unable to reply to nay received emails now or "Create" a new mail because it says that an error has occurred. When I try to open the address book it states that it may have been installed incorrectly. I don't know how to rectify this. Can anyone help? Please reply to <lee.north@ragemailorder.net> Thank You in advance This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office family for Intel PCs. For Outlook Express (OE) support try posting in one of these newsgroups: microsoft.public.i...

Smartlist problem............payables trx report
I am using GP 7.50 and created a smartlist report under Payables trx to show open invoice amounts by a vendor name. The criteria set is as follows: Vendor name = ABC Company Doc Status = posted Current Trx amt > 0 the other columns on this report is document type and current balance. For some unknown reason, the current balance does not always balance to my aging report or to any inquiry screen I may do for certain vendors. The only balance that is wrong is what is on this smartlist report. It makes no sense to me --- has anyone had similar issues. Is this column field "c...

Problems Opening Notebooks from Server 2008 Folder Share
I have asked before with no solution, and searched and searched, and am perplexed so I thought I would pose my question and summarize again. Our office uses ON extensively so this is very important to us. A summary of the issue: 1. All notebooks were saved on a SBS 2003 server share for a few years and all worked great! 2. We moved to a new Server 2008 server, and copied all notebooks to a share on the new server. 3. Now, if we try to open the notebook from a drive mapped to the server share, we get an error requesting a password but can't enter a password, and can't...

Scroll problem on Continuous Form
Hi I have a continuous form, which design with Header, Detail and Footer. When the number of records are many, where the Detail area cannot display all of them, I can navigate the records on Detail by both "Vertical Scroll Bar" and "Mouse Wheel". My problem is under the situation, when the number of records are less, where there is an empty area on Detail. In this situation, when I use the mouse wheel to scroll down, the first record will disappear, but when I scroll up, the first record cannot be gotten back. I have to use the arrow on vertical scroll bar to get i...

Money Plus & Windows Live ID Sign-In Problem
Hello, For the past week or two, I am unable to sign in to my Money Plus account with my Windows Live ID. On intial attempt when opening the file, the application states "Money could not verify your sign-in information...". I'm using the latest verion number 17.0.120.1415. My account is setup to retrieve infromation from MSN Money Central because this was the only way to get Etrade updates. I tried to create a brand new Money file to see if my file was somehow corruptedd an I received the same error. I am able to sign in to many other MS services using the same Wind...

vertical look up problem with date and time
hi, I'm trying to compare intraday stock volume data for 2 stocks. The stocks do no trade every minute. I have made a new table that consists every minute of the day. With the vertical look-up function I try to get the volume quotes in my new table for every minute that a trade has occurred. So, since not every minute the stocks trade I expect to see a zero or (N/B) in my new table. But instead of doing this my new table shows a volume from the trade that has happened 1 or 2 minutes ago. How can I overcome this problem?? (I've attached an example xls with some comments) Thanks, ap...

dupliates name in a query
Hello, I have created a query from a table for my employee data base, the query is dupilicating the names. The name only exits once in the table but i can see a name that exits 3 or 4 times in the query. Please help Tia On Sat, 28 Nov 2009 11:45:48 -0800 (PST), Tia <tia.abdelkarim@gmail.com> wrote: >Hello, >I have created a query from a table for my employee data base, the >query is dupilicating the names. >The name only exits once in the table but i can see a name that exits >3 or 4 times in the query. > >Please help > >Tia Please he...

Word 2008 Spellcheck problem
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Out of the blue, spellcheck now underlines correctly spelled words, and ignores incorrectly spelled words. Does this on new documents. It's is as if the spell check instructions have been reversed. Any idea how to fix? Most likely you've pasted content copied form another source or in some other way wound up with text that's formatted for the wrong Language. Although the optimum approach is to control the Language formatting - just as any other - through the use of Styles, you should be able to: ...

NTbackup restore problem
Hi, I have been trying to restore an exchange 2000 server (exch service pack 2, windows2000 service pack 4) in two different scenarios. The first to the orignal machine, and the second to a test/recovery machine. NTbackup continuously reports this error: Unable to create the log path. Check to make sure that it is a valid path. and aborts. I found KB article 272591 (http://support.microsoft.com/default.aspx?scid=kb;[LN];272591) which lists this as a problem pre-SP2, but I am beyond that service pack, and have reapplied it. Is this a bug, or is it possible that I am simply doing something...

Exchange 2003 Email Addressing problems
Example: If I’m in Domain A and address an email note to someone in Domain B that has the same user name only, domain suffix is completely different. The Exchange server in A apparently looks at the email name and decides that since it has an email name that matches in it’s directory it changes the domain suffix to it’s own and the user in domain A receives the note. If the user dose not exist in A and does exit in B then the mail will send to the correct party (obviously). Added note: I’m typing the full email address Example: joe@foo.bar.com, I’m not using the check names component fo...

Cash Flow Forcast Problem
I am recently getting the following error in Money 2004. When I click Cash Flow it says, Please create at least one checking, savings, or cash account before you go to the cash flow forecast. But when I am in an account register it still shows the 60 day forcast. ...

Looping through Query to create multiple sheets in excel- Just need the loop
I figured out where I should start the loop in order to keep the excel work open and still be able to add more sheets, but I can't figure out how to add code to For Next loop to go through a query "qryManufacturer" and take each one and put them into the string (strManuf) I always get to this point and I can't figure out how to loop through a recordset. I have put the string in the query at the bottom. Public Sub CopyRs2SheetHacked(strSql As String, strWorkBook As String, _ Optional strWorkSheet As String, Optional strRange As String) 'Uses the Excel...

? CustomDraw Message Reflection Problem (Bug?) #2
Hi, I am having trouble with message reflection. I am trying to set up my list control to handle CustomDraw on its own, but also let the parent override it. (That is, the control gets CustomDraw notifications to handle, then reflects them to the parent to handle after�if it wants.) I have ON_NOTIFY_REFLECT_EX(NM_CUSTOMDRAW,OnNMCustomDraw) in the control�s message map. The handler has a simple switch on the DrawStage to ask for subitem notifications, makes a change to the colors per subitem, then returns a BOOL. The parent dialog has ON_NOTIFY(NM_CUSTOMDRAW,IDC_LIST,OnNMCustomDrawList) in it...

Problem with filtering from times
Hi, we have project server 2007 with PPS running for about 1 month and with initialization we have some problems where we need some help. The view for own work and the team work are really fine in the pwa ... but we didn't find a way to filter it by time? We have about 100-200 project planed for about 1 year in future. The teammembers now have so many steps assigned, that they have 10-30 pages on work. The sortation is first the projekt, then the day ... with this view nobody can work :) Can anyone tell us how to filter this views for "today", "this week", &...

MS Outlook newsreader problems
HELP I run outlook for e-mail and outlook newsreader for newsgroups. I have a problem in that whenever I open outlook newsreader, I can only see the last 5 or 6 headers. Bottom left of my screen says things like "4 unread 24 not downloaded". I used to see weeks if not months of headers before I moved over to a new pc. Anyone know where my problem is. (For example within a couple of days I'll not be able to view this post anymore). I haven't been able to determine wether it's a date thing or not but this could be a possibility. Here's hoping Thanks Dave. On We...

Update query
I have a table ("Table1") with a memo field ("p"). I need a query in SQL that replace any character "#" inside the memos with the chr(13). ...

Mail Merge
Hello, A campaign activity I created has the status "System Aborted" even through it sent the emails out OK - this means that my No. Targeted = 0 so my measuring of the campaign is all wrong. Is there any way to manually change this status? Can I change the No. Targeted for a campaign / campaign activity somehow? What I did: Created a campaign activitiy - chose "Email via mail merge" I have the Outlook client so when I distributed this activity Word fired up Once Word loaded the Campaign activity freed up I did the mailmerge in Word - it seemed to run OK, sending out ...

query problem after changing to SQL server
I use queries in Excel to create custom reports out of our accounting database. We recently changed to an SQL server and now I can't run any of these reports since the address of the database changed. Any suggestions?? I can't figure out a way to access the query to edit the address since I don't have each query saved outside of the spreadsheet. You need to change the Querytable objects' connection string and/or SQL text. See: http://www.dicks-clicks.com/excel/ExternalData5.htm#ChangeConn Jamie. -- ...

MS Access Query
Hi I need help with this: COnsider this Data: Description // SW Version // Asset Tag // Machine Name // Name Acrobat Standard// 4 // 12345 // abcde // Steve Acrobat Standard// 6 // 12346// abcde // Steve Acrobat Standard// 6 // 12346// abcde // Steve Acrobat Standard// 9 // 23456 // zxcvb// Dick Acrobat Pro // 7 // 65432 // qwert // Dave Acrobat Pro// 9 // 54321 // qwert // Dave Acrobat Std // 8 //67324 // asdfg // Ryan I want the output as only the Unique & Highet Vales Unique Based on Machine Name And Highest SW Version Output: Description // SW Version // Asset ...