Search results for query: *

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

I know this is simple but... how do you format a text box to only have capital letters... Thanks, 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...

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

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

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

Hi, I want to learn more about ACCESS and the use of VBA... I consider myself at an intermediate level for ACCESS right now. I need a resource for good training that is directed to application development.. Any suggestions would be appreciated.. Maggie

Hi, I have a report where the detail should not print if certain criteria is met... for ex. If Surv = '3' don't print that record If Surv = '1' and Cond = "D" or "SD" - print that record etc.... How do you supress printing on a report based on code. Thanks, Margaret

HI, I just went to the following site and downloaded the Access example, to my computer - http://www.access.hookom.net/Samples.htm When I go to open the PhoneList2k.mdb, I get the following error.... "Microsoft Access cannot open this file. This file is located outside of your intranet or on...

Hi, I have a report that at first had 1 Group Header for "AreaName". I needed the detail section to print in 4 columns for the "RoomName".. Got that to working ok.. Then I needed to add another Group Header section for "SRNumber". When I preview the report now, the data in the GroupHeader...

Hi, I have a form with Area records that has a subform that contains Material records. Each Material record has a column to store comments. I put a command button on the subform to open up another form to view/edit/add the Material comments. This "VIEW" command button is seen on every record...

Hi, what is the most efficent way to look thru a table and locate the record with the most recent "ArchivedDate" field. I need to grab the "ProjNumb" from that record. Currently I'm looping thru the table comparing dates and my logic isn't working and it takes a long time. Thanks, Maggie

Hi I've created a routine that archives 3 tables (Area, Materials, Surveillance) after a Project is complete. I copy the tables and rename them with the project appended onto the end (AreaGA1777)... I then have a screen where a user can pick from archived Projects and view the data. That's...

HI, I need help with the following code. I need to create my table name on the fly (varAreaTable) and then use it within a query (qdfTest).. But have huge problems with placement of the quotes!! Any help is appreciated.. And if you could point me to any articles talking about using quotes in...

Hi, I need to run the code that is in the OnOpen method of my form whenever I click a Reset Command Button. How do I call the OnOpen method code from a comman OnClick method? Thanks, Maggie