473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Need help with append query

Hi All,

I have a split f/e - b/e setup on my database with RWOP queries on the
front end. The code below gets a PO number(s), and vendor name from a
multi choice list box on another form. It then assigns these values,
plus a new receiving number, to the current form. The SQL string is an
append query that copies select fields from the PO line items table
into the receiving line items table and appends the current receiving
number to each receiving line item. The code runs fine if I am the user
but will not run for anyone else because "record(s) cannot be added, no
insert permission on tblRecDetail". After searching these boards I have
tried giving insert permissions on the table link in the f/e (same
error), I've double checked that all queries are marked RWOP, I've made
sure the users have permissions on the queries involved. I've also read
here that the query must be an actual saved query, not a SQL string run
from VBA so I am now trying to convert it. My questions are:
1.) Am I correct in assuming this is the way I need to go?
2.) I understand how to write the new append query as far as getting
the data from the PO line items table but how do I have it append the
receiver number from the form at the same time?

Here's the partial code. I'm so sorry for the lengthy post.

Call GetFromList(Forms!frmRecPO!txtPOList, strWhere, strPONo,
strVendor)

strRecNum = NewRecNum
Me!RecNum = strRecNum
Me!DateRec = Now()
Me!CreatedBy = CurrentUser
If strPONo <> "" Then
Me!PONum = strPONo
End If
If strVendor <> "" Then
Me!Vendor = strVendor
End If
If strPONo <> "" Then
strSQL = "INSERT INTO tblRecDetail (PODetailSubID, PONum, RMCNum, UOM,
Style, Color, [Size], Description, RecNum ) IN
'C:\access\MYTABLES.MDB'" & _
" SELECT qryPODetailAll.ID, qryPODetailAll.PONum,
qryPODetailAll.RMCNum, qryPODetailAll.UOM, qryPODetailAll.Style,
qryPODetailAll.Color,
IIf(IsNull([qryPODetailAll]![size]),[qrypodetailall]![garmentsize],[qryPOdetailall]![Size])
AS POSize, qryPODetailAll.Description, " & strRecNum & " AS RecNum" & _
" FROM qryPODetailAll" & _
" WHERE " & strWhere & _
" WITH OWNERACCESS OPTION;"

'populate receiving items table
CurrentDb.Execute strSQL, dbFailOnError
End If
Thank you for any help you can give me as I am stumped.
Karen

Nov 13 '05 #1
0 1730

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Juho Saarikko | last post by:
I made a Python script which takes Usenet message bodies from a database, decodes uuencoded contents and inserts them as Large Object into a PostGreSQL database. However, it appears that the to...
10
by: Mark | last post by:
I have a table about people containing 25 fields. The table contains the usual fields - first, last, address, city, state and zip. There is no primary key. These fields all have data with the...
2
by: Danny | last post by:
I want to extract a subset of fields from one table into another the master table has many fields the subset has about half, but still many. Is there a way I can just append the master into the...
1
by: tHeRoBeRtMiTcHeLL | last post by:
Below is an earlier post to an Excel Group.. ....but I thought that there might be a way to do this in Access by importing data and then creating append and/or update query. I would most certainly...
5
by: Michael C via AccessMonster.com | last post by:
Hello, I have a table that I am appending 3 seperate tables into. My main problem is that each time I append the data, it simply adds to the data already there. That might sound ok, except that...
5
by: robertmeyer1 | last post by:
Hey, I have 2 append queries. The first is based off of code given and works great. For the second, I followed the format of the 1st and adjusted it to meet my needs. Query 1 works great. It...
16
by: ARC | last post by:
Hello all, So I'm knee deep in this import utility program, and am coming up with all sorts of "gotcha's!". 1st off. On a "Find Duplicates Query", does anyone have a good solution for...
10
by: pythonnoob | last post by:
Hello everyone. New to python as well as this forum, but i must say ive learned a but already reading through some posts. Seems to be a pretty helpful community here. Before i post a question...
2
by: Dhananjay | last post by:
Hi all , I have got problem when i am tring to exportGridview Data into Excel format. It is going into text format ,but what i want is if the field is number/currency then it should go into...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.