Search results

Hi steve, First I would get rid of those spaces in the names - they will get you in the end. Have you thought about DLookUp()? Without spaces... in the AfterUpdate Event of the PositionID control, Me!JobTitle = DLookUp("JobTitle", "tblOrganisation", "PositionID = " & Me!PositionID) Or...

I had a problem like this but I only got Error when the sub had no records. This is what I do now. On the footer of the SubForm there is a total box called ctlTotal (this is hidden as I want the total on the main form) On the main form I have a hidden text box called DetailsCount. In the OnOpen...

Jack, I had a look at your file and it's way over my head. I go about things in a far simpler fashion so I expect you will think the attached is really lame. Sorry but I can't raise any enthusiasm for learning the clever stuff, I just look for solutions that work for me. The attached is not the...

Problem with a 2000 .mde in Access2007 Thanks for reading this. I am developing in Access2000 but the .mde has to run on a Access 2007 machine and there's some weird stuff happening so I am beginning to hate 2007 before I have had a chance to get to know it. In my subform I have three fields...

65000 sounds like the max lines in an excel sheet so no solution comes to mind. if it helps, send me the excel sheet (or post it here) and i'll see if i can import it to a dummy table then you could use an append query from that. sorry but won't be back online till at least tuesday.

I am thinking that there are four possibilities. a) Started before or on first day of period and returned during period b) Started before or on first day of period and have not returned c) Started in the period and returned in or on last day of period d) Started in the period and have not...

I don't understand foreign keys but why do you need one? what's wrong with... tblCompany - CompanyID(autonumber, primary key), Name, Address etc. tblVans - VanID(autonumber, primary key), CompanyID, Type, Number, etc. Then one company (tblCompany.CompanyID) then has many vans...

I would not have a field called StudentName as this is duplicating the contents of FirstName and LastName and you can always join them on the fly just as you have for the title. You could use an unbound text box with = FirstName & " " & LastName In queries (ie: the one that is the rowsource of...

Hi Matt. Is this any help. First soultion doesn't use two forms, it uses a combo in the header of the student form to locate the selected record. You have a two column combo with ID and Name then you hide the first column by setting its width to 0cm. I have called it cboStudent. In the...

I had a similar problem and boblarson helped me with this. If Me.Dirty Then Me.Dirty = False Bob says "It basically says If the form is dirty (changes have been made to one or more bound controls) then change it back to clean (which forces a save of the record)". You could try putting it just...

I didn't understand where to put the file name in the sample line that Pat suggested so I went looking for decompile info and found Allen Browne. I followed his suggestion to the letter...even though he's talking A97 and I am using A2k!. http://www.allenbrowne.com/ser-48.html Here's the extract...

Sue, Thank you so much, sometimes your so close you can't see. There's a glimmer of hope here so I will certainly be giving it a try and I'll need to find a way to Refresh the subform when frmGlobal closes but that's another day. Thank again, Mike

I have frmMain with frmSub which performs complex calcs and recommendations when values in the sub are changed. This works fine in the AfterUpdate event of all the relevant fields but I have a separate frmGlobal so that the user can make the same change to all of the records in the subform...

Thanks Pat, I'll give it a try.

Sorry for being confused and ignorant. I thought it was a new thread with no replies.

Hi Gemma, Looks like were were posting replys to each others questions at the same time. Spooky... Yes it's on desktop, No there are no images. It does seem to be an Access house keeping problem. I hope my reply to your list box problem helps. Thanks Mike

See chooser.mdb attached. I don't know the author so can't credit him here. Hope it helps. Mike

Hi Gemma Greetings from a village near Cambridge. I see you've had no replies and have to say up front that I do not rate my skills very highly but perhaps I could try to help. I have seen a working example somewhere and will let you know if I find it again. Mike

Hi Doc Man and thanks for taking the time to explain the deeper goings on. I understand totally that it would never be empty and I wouldn't have a clue how to unhide and look at the system tables. I just don't see how after deleting all of the obvious stuff it would still be 4400KB. If I...

Richard. Just in case it helps, In the query screen I think I would use CarIs: [Make] & " " & [Model] & " " & [Type] (make sure that [CarIs] is the control source for the control on the report) or bring all three fields onto the report, hide them (visible=false) and use a seperate unbound...