I'm completely new when it comes to Access and SQL databases, so I hope you can help me out a bit:
I have started a project at my workplace, where I'm making a database over equipment that is provided for our users.
Now I no problems with setting up the reports for my tables, but I also want to be able to print out a single record in a table.
I've looked into it and so far found three solutions:
- Create a command button and insert the following code: DoCmd.OpenReport "YourReportName", acViewNormal, , "[YourFieldName] = '" & Me.FieldName & "'"
- Set up a macro manually (as seen in the post from Trevor G in www(dot)access-programmers(dot)co(dot)uk/forums/showthread.php?t=195641)
- Create a button and insert the code in the VBA editor (www(dot)allenbrowne(dot)com/casu-15.html)
In the first solution, I get an "invalid value for the WHERE condition" error, in both the number and text code (I'm using the unique ID or an owner field linked to an unique ID).
In the second it's probably because of language barriers, but I'm very unsure on what I'm supposed to do. (If Trevor happens to see this thread, I would appreciate it if he had the time to provide pictures of the process
With the third, I get the report with all the fields I want shown, but the data that should be in that record isn't shown.
I hope you guys can help me find out exactly what and where I'm doing something wrong
P.S. Sorry about the links, but I can't post them yet