Search results

Hi Again! I am having issues with a comboxbox who's listitems are populated from a query. Basically I have a Holiday calendar that allows you to see a what holidays a person chosen from the combobox has. Now, you can add more holidays in, but I don't want to save changes until all holidays are...

Fair enough! I suppose I could exclude any brackets and ' " characters. Out of shear curiosity then, can a parameter be added to the SQL statement as I have done, or would I need to go down the route of creating a DAO query and adding the parameters to that?

Hi pbaldy, I did consider that but doesn't that leave your database open to SQL injection where someone writes in SQL code into the field and it's executed as part of the query?

Hi, I've done extensive searching over the last hour and I can't seem to find what i'm after, or if it's possibly the way i'm doing it. I want to take the output of a text control and insert this value into a table. I have been reading up on SQL injection prevention so I'm going to use...

Yes, I do. Apologies for the confusion and thanks for the help so far! Should I remove the post?

[Ignore below. I was changing the record source of the main form in VBA and trying to stuff two records into one textbox i think. Sorry!] Yeah, that makes so much sense! Works a treat, thank you! I'm having an issue here with the sites that have no people on them. My subform is a query using...

Hi there, I have been asked to move an VB.net/SQL system over to Access(FE)/SQL(BE) as the company feels it would be cheaper to pick up the work if the people who created it left. I'm by no means a database or programming professional but sadly, probably the person most able to do this. Anyway...