Have you tried breaking it down into its components - run the first query, if works, union add the second query, check it works then add the third query
You may need to use UNION ALL rather than just UNION which will remove duplicates - depends on your your requirements
I know you said each query works OK but the error may be referring to the from clause in your separate queries
CJ_London
Last Activity: Oct 7 '25, 04:01 PM
Joined: Nov 11 '13
Location:
-
A>GV is 204 columns so should not be a problem to link and run a number of append queries to populate your two or three tables. This can be automated.
So to answer your question, yes there is a way to bring this into your database. In fact a number of ways, but which way is best suited to your requirement depends on the detail which you have not provided.Leave a comment:
-
CJ_London replied to Taking value from a control in a form and place that value in a field in another table.in AccessYou don't need to save it as it is automatically copied to the clipboard - see image, I don't know how to embed it - Neopa, please can you do the honours or point me in the right direction as to how to do it :)
[IMGNOTHUMB]https://bytes.com/attachments/attachment/10569d166121476 3/image_2022-08-23_013240557.pn g[/IMGNOTHUMB]...Leave a comment:
-
CJ_London replied to Taking value from a control in a form and place that value in a field in another table.in AccessClick on the advanced tab (bottom right of the response box)
then click on upload files. See attached :
[IMGNOTHUMB]https://bytes.com/attachments/attachment/10567d166121048 7/image_2022-08-23_002125577.jp g[/IMGNOTHUMB]
If you are using something like the snipping tool, you should just be able to select it from the clipboard....Last edited by NeoPa; Aug 22 '22, 11:31 PM. Reason: Updated to show the helpful illustration posted :-)Leave a comment:
-
CJ_London replied to Taking value from a control in a form and place that value in a field in another table.in AccessI have to say I'm struggling to understand your relationships - any change you can post a screenshot?Leave a comment:
-
CJ_London replied to Taking value from a control in a form and place that value in a field in another table.in AccessIf the only options are as set out by the OP then personally think just as easy to maintain. But in the future if a value of 5 can be sent which requires a 0 or there are values above 10 then it would not be appropriate and you would then use a case statement along the lines you proposed.
I do think users should learn and understand boolean handling. Every comparison provides a boolean result, even the case statement - either an action...Leave a comment:
-
CJ_London replied to Taking value from a control in a form and place that value in a field in another table.in Accessalternative to the case statement would be
Code:unitAvailable = Abs(ActionID>=4)
Leave a comment:
-
For how I am using it I don't disagree - but the solution I provided in the thread (post #1 on this one) was a very simple example for a dynamic form which avoids the need for a user to create a form and controls.
I wonder if there is any chance to Insert Existing Fields to a Form via a VBA code.. Because I created the table using import from excel and the field name may vary each time depending on the excel file heading rows.
...Leave a comment:
-
yup, we go back a few years!
Hi Colin
An example you have seen is Access Studio - it is used to display the lists of tables and fields, the drop downs for templates and queries and of course displaying multiple query results. There was another one not available in the released version to select and add projects. These are all subforms and not populated in the way I described above as not relevant to the OP's question....Leave a comment:
-
I use a similar technique to Adezii but I create the form with around 50 textboxes plus associated labels plus 50 labels in the header and 50 textboxes in the footer - so around 200 controls altogether.
Labels are named in a similar way T0, T1, T2 etc for textboxes, L0, L1 for associated labels, H0, H1.. for header labels and as you may guess F0, F1 etc for the footer textboxes.
50 may seem to be overkill, but I have...Leave a comment:
-
Two Experts Meet
I use a similar technique to ADezii but I create the form with around 50 textboxes plus associated labels plus 50 labels in the header and 50 textboxes in the footer - so around 200 controls altogether.
Labels are named in a similar way T0, T1, T2 etc for textboxes, L0, L1 for associated labels, H0, H1.. for header labels and as you may guess F0, F1 etc for the footer textboxes.
50 may seem to be overkill, but I have...Last edited by NeoPa; Aug 18 '22, 03:11 PM. -
Appreciate this post is a week old and may now be resolved, but this could be done in an Access query fairly easily. I'm thinking link the two excel tables in Access then export the result back to Excel.
Happy to provide the code if this is of interestLeave a comment:
-
What version access have you upgraded to?
the object "Lblvw.Document " will have been specified LabelView 8.5, you probably need to upgrade the references to Labelview 10Leave a comment:
-
You haven't described your form so I'm assuming you have a continous form with at least the header and detail showing.
On your form header put an unbound text box, we'll call it txtFind.
In the after update event of txtFind put the following code:
Code:
This assumes that BatchNo is numericCode:me.filter="[BatchNo] = " & txtFind me.filteron=true
Leave a comment:
-
Would love to advise, but I haven't used it for years. Search on line for Access 2003 user level security
Here are some links that may help
http://office.microsoft.com/en-gb/ac...005188226.aspx
http://www.pcreview.co.uk/forums/set...-t3880204.html...Leave a comment:
-
if you open the form properties, click on the events tab and you will see current event. Click in the 3 dot button to the right and select code builder. If you are happy with macros then this should e familiar to youLeave a comment:
-
In your form on current event put the following code
return_date.vis ible=has_return edLeave a comment:
-
Try
change table and field names to suitCode:SELECT Count(*) FROM myTable WHERE Col1="Personal" OR Col2="Personal" OR...Col8="Personal"
Leave a comment:
-
What version of access are you using? if 2003 or earlier you can use the access security facility, if later you need to write your ownLeave a comment:
-
as a newcomer, I'm pleased to helpLeave a comment:
No activity results to display
Leave a comment: