Recent content by Tracy2

i think that it will - i have done something similar to display a selected report from a list box so it looks hopeful........ have a good weekend Tracy2 :)

many thanks for that - i will have a look at the example - i think i get how this works now thank you very much for your time Tracy2

yes I did - but when i open the report to view - i still get a dialogue box asking me to enter a parameter value???

Hi I have created a bound object frame and linked this to the ole field using the control source in the properties of the bound object frame - please excuse my ignorance - I have nver done this before - the thing is that when I open the report - i now get a pop up box expecting input?? many...

Hi I have looked at that but to be honest I do not understand how to go about coding this... Thanks for your reply

Hi I would like to be able to display an image on a report that is linked to the record. For example, I have a table called room that has many records of different rooms. What I would like to do is to display a picture that is associated wit each room? i have searched the forum for a solution...

Hi cool job - i'm just starting out as you have probably guessed - i finished a computing degree last year and i am now working on an IT helpdesk - not as grand a job as yours but its a good start for me as i have no IT experience in industry and theres room for moving at my place to different...

i deleted the relationship and it all works an absolute treat - thank you very much for your persistence and for teaching me a thing or two about using VB and SQL in Access........

Hi yes there is a one-to-one relationship - not ideal i know is that causing the problem

Hello again SQL_Hell - yes i ahve tried this and i now get the message you are about to delete 1 record but it will not delete due to key violations??

Hello - thanks very much for that - that has moved the record to the correct table and i gt a message telling me it is only deleting 1 record but will not delete the record due to key violations? not sure what is going on there?? many thanks for your help

i have tried changing "DELETE FROM Item Where ItemReference = '" & ItemRef & "'" and get the data type mismatch error and the debugger highlights the DoCmd.RunSQL strSQLDel is this because strSQLDel is string and the data item it is dealing with is an integer?

ok so - is this the correct place to put the code: DoCmd.RunSQL strSQLApp MsgBox "" & ItemRef DoCmd.RunSQL strSQLDel now this is what happens i get the message you are about to append 1 row - i then get a message box with just the ref numebr in it an option to click ok - when i click ok i get...

ok something very strange happened - i get a dialogue box asking for a parameter - i enter the item ref # of the record that is to be moved and then deleted - i then get a message advising that all records will be deleted? is this something to do with itemRef and itemReference?

yes i have double checked.......both are auto-number