Search results

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

aaaaaaaaaaagggggggggghhhhhhhhhh ok so this is how the code looks now Private Sub Command30_Click() 'declare variables for holding data Dim RoomName, ItemDes, ItemReplacementCost As String Dim Amount As Integer Dim ItemRef As Integer Dim strSQLApp As String Dim strSQLDel As Integer 'load...

Good Morning I had several pints last night..... and a 2 hour driving lesson this morning! Now its back to work - i tried your suggestion - it now throws up this errror: data mismatch and the debugger highlights this bit of code = DoCmd.RunSQL strSQLDel once it gets past this line all i need...

Hi Its 7.30pm now and i think its time to go - its still not quite working - but i really appreciate your help and time with this today - i ahve certainly got a lot further with it - i shall plug away tomorrow have a good night and thanks again

hi - yes summer is good in brighton even if you are just sitting on the beach drinking beer - i go to the honey every other saturday night!!! well we are getting somewhere the record was appended and was added to the store table - i got an SQL error message though = invalid SQL statement...

i am sorry to cause you grief - i ahve learnt a lot today and have been force to remember my VB code from Uni - i would like to learn to use vba in access as i am sure that a lot of tasks could be simplified i am from Brighton - it's a cool town - there are lots of pubs adnd clubs and lots...