Recent content by trish

Hello I have a main form with a search command button in the header. This search facility looks for information in a subform. At the moment I can't seem to get it to work. Main form called Building Subform called LineTypeSub Field its trying to search is called Line Here's the code I have...

I have 7 records that won't do what its told due to key violations 'Database didn't update 0 field(s) die to a type conversion failure, 7 record(s) due to key violations, 0 record(s) due to lock violations and 0 record(s) die to validation rule violations.' Just wondering, regardless of...

:) This is what I currently have.. UPDATE Portfolio RIGHT JOIN LandlinkPortfolio ON Portfolio.BuildingID = LandlinkPortfolio.BuildingID SET Portfolio.BuildingID = [LandlinkPortfolio].[BuildingID], Portfolio.BSMName = [LandlinkPortfolio].[BSMName], Portfolio.SBSMName =...

Hi Pat, George Thanks for your help and explanations. The query doesn't work 100% (yet) but it has at least put me on the right path!! Kind regards Trish

Thanks for the info Pat. I don't actually know if an update query is the right thing to do. Basically the spreadsheet that is generated monthly contains information that is already in the database and new information as well. All I want to do is add the records that are new and also if any of...

Hi Can someone please explain to me what I'm doing wrong. I'm trying to update my table called Portfolio with information sent to me via spreadsheet. I've been able to import the data from Excel into a table called PortfolioUpdate and the data types are all the same, but when i try to run the...

hello i have a search facility on my form and currently it works, with some code i found from the net. the search works where you enter the BuildingID in an unbound textbox 'SearchBuildID' and click on the search command button cmdSearch, it will bring up the corresponding record. i've also...

any suggestions would be great! can't say that i'll understand, but if you put it in laymen's terms i'm sure i can figure it out.

Yes this application is to be used by someone else, however there will only 2-3 max people using this. I actually wanted to remove the shortcut options and have command buttons (although don't know whether this is possible with a subform in a main form), but at the moment my skills are still...

i'm selecting the line by right clicking then using the options available. i.e. new record, delete record, cut, paste etc. the default view is continuous forms.

hiya i have a subform which won't allow me to delete a record unless i'm in the datasheet view. is there anyway to change this. the properties have been set to allow deletions. thanks trish

thanks for that fizzio, i'll check my db and get back to you cheers, trish

hi i've got my form up and running, kind of. something's happened to my form since i worked on it two months ago. when trying to add records into a subform on the main form, i keep getting the error message "Cannot add record(s); join key of table "TblUnitEnrolment" not in recordset." can...

i've added the StudentID field into the subforms with it set at visible = no, and it's worked. which is great Idjit, thanks. but i've also attached the db for more help, as per Rich's comments. i hope i converted it ok.

dcx693 - i've added 'StudentID' into the property sheet in both the link child and master fields for the Enrolment subform, but now i get a message (when i tried to enter data into the form view) "The object doesn't contain the Automation object 'StudentID'. You tried to run a Visual Basic...