LISA GEORGE
asked on
how to create view in ms access
I tried to create view in query but it's throwing up error ,.this is view i created in query create view Search as (select ----)
error - syntax error in create table statement
can someone tell me how can we create view in ms access? i have seen that we can do that using vb code
but no idea how to do that and how can we execute that
i want view as record source for my form so kindly let me know how this can be done
error - syntax error in create table statement
can someone tell me how can we create view in ms access? i have seen that we can do that using vb code
but no idea how to do that and how can we execute that
i want view as record source for my form so kindly let me know how this can be done
ASKER
@noah
i found my answer, i have created view using vb code
thank you for your reply
i found my answer, i have created view using vb code
thank you for your reply
@LISA GEORGE Alright, in that case, please mark this question as solved for everyone's convenience :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
On a basic level, this can be a simple problem of ensuring the coherent data type before creating a view. You will need to use the visual designer or in other words, change the data type to the correct properties in the design of your table; choose from valid data types, and the view created will automatically generate the correct syntax.
To assist you further on the VBA you mentioned, we will need at least basic information on the basic inputs and desired outputs.
Examples of Basic Inputs: How your tables are segregated/linked; the relationships, The Data types, Primary Key etc.
Examples of Desired Output: The row and column headings, Rounding up/down of numbers etc.
However, if you have managed to fix the problem with the troubleshooting mentioned above, a VBA script would not be required.