Recent content by MaggieLeatherman

Thanks for all your help! I did have a syntax problem. It's working ok now! Maggie

I've been getting Runtime error '2001' , You cancelled the previous operation.... on the following code: If Not IsNull(Me.BSRId) Then Me.txtUnits = DLookup("UnitsACM", "GAMaterials", "[bsridfk] = Me.BSRId") End If Does anyone know what this means? Thanks, Maggie

Thanks, MAggie

I know this is simple but... how do you format a text box to only have capital letters... Thanks, Maggie

Thank you so much! Maggie

Hello, my client needs to be able to enter "(C)" in a text box but on exit, it converts to "@". Is there a way to control this? Thanks so much, Maggie

Project #’s consist of “yr-proj#” For example: 07-690 or 06-700 There could be 40 or more projects to pick from so I’d like to first narrow down the list by ProjYr. Depending on the year chosen from the cboProjYr combo, this will only show the projects from that year only. I have 2 combo...

Thanks so much! Maggie

Hi, I have a field called IWname in an old Access DB which contains the fullname ex.(Smith, Irene A.) I need to break up this field into EmpFirst,EmpMI,EmpLast.. Can someone quickly on what to do? Many thanks, Maggie

Hello, I've been resizing a form and moving it to the middle of the screen. After I close it and then re-open it, it's back in the original position and size.. How do I control this so my application looks the way I want it? Also could you direct me to other threads that discuss application...

Hi AceMan, Thanks for your help, I have so much trouble with syntax in criteria! Maggie

Hello! These 2 commands work perfectly by themselves! DoCmd.OpenReport stDocName, acPreview, , "[BuildingIDFK] = " & Me.txtBuildingID DoCmd.OpenReport stDocName, acPreview, , "([Percentasbestos] like '*%*' or [Percentasbestos] = 'ACM')" But I need the criteria together in on OpenReport...

Hi The Missinglinq! Thanks for all your help. I have another question regarding your first post with the code.. Will you explain this? How do you make this work? 'Prompt to enter new Room Number Me.RoomNumber.Value = "Enter New Room Number" How do you make a prompt for the user to enter the...

Thank you so much for this code. I know it will work... Now another important part that I negelected to ask... How do I add the matching Detail records in the subform? In other words, Main form (frmArea) has a subform (subMaterials) When I duplicate the records from frmArea I also want to...

Hi, I have an input form where the user would like to duplicate all the information into a new record and then only change Room Number. This would save data entry time since much of the data is the same except for changing the room number. I'm not sure how to accomplish this task... Thanks...