Search results for query: *

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

...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 command. Below I put both the criteria stmts together from...

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...

What code do I use to find out if a form is open. I need to use this information in an IF statement... Thanks, Maggie

Hello, While looking at your example, I don't know where you got the numbert ex. + 9, How did you know how many pages to add to [Page]? I guess I would need to control this based on a group change, ex: whenever the SRNumber Group changes, i'd need to start the page count over... I'm still...

Thanks for your reply. I'm so bogged down now that I haven't had time to try this.. It seems so complicated and I'm not sure where to start... Thanks, Maggie

I have a report with a Group Header on SRNumber. When I run the report, on the Page Footer it shows Page 1 of 15. I need the page # to reset every time the SRNumber changes and show this on the botton of the page. For example: SRNumber = 501-4 Page 1 of 2 etc. " 501-12 Page...

Hi, I have a report that groups on SRNumber. The SRNumber header section is working fine.. in the SRNumber Footer section I have a subreport that groups on AreaID with a detail section... I need the subreport to print in columns "down and across". It prints correctly on its own but as soon...