Search results

I'm receiving Run-time error ‘2024’ - The report snapshot was not recreated because you don’t have enough free disk space for temporary work files. I've looked at all the threads from people who've had the same problem and tried the recommendations, but I still get the error on both these...

Yes, it certainly would Ken. However, near as I can reckon, in Control Panel you can't change the default colour of message boxes - they are always grey. I recall seeing a posting on the web (or perhaps here?) about changing Windows default stuff, but it was much farther than my limited...

You're the best, RG - That's what I was looking for! Thanks! Christine

Could someone look at my code and tell me why my “Me.TargetDate.Undo” won’t work? First, let me say that the TargetDate field has an On-Click event that calls a module written by Allen Browne), which is shown below and works great. =CalendarFor([TargetDate],"Select a date from the calendar ")...

Hi RG. It's just the regular tab control that you can put onto a form. It is grey by default and you can't change it. I'd like to know what colour it is by Windows default so that I can duplicate its colour for other controls. Christine

I don't want to get fancy with changing the colour of tab controls (a la S. Lebans), I'd just like to be able to duplicate the default gray color. Does anyone know the numeric expression to enter in the tab control's Background Color box? Many thanks.

RG, Just wanted to say thankyou for your assistance. The reference to the text box for filling in dates threw me, but you were right - it works great as-is. Thanks again. Christine

QueryA takes information from the main table (tblCARs), which is used to store corrective action requests (CARs). The purpose of QueryA is simply to present a list of all CARs in the system. The results of the query are in a subform; the main part of the form allows the user to search for CARs...

Rich, thanks for joining in. I tryed what you said, and also took Rover's suggestion to change the join properites to option 2. This produced the message: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed...

Hi again. The problem with selecting option 2 is that I want to see ALL records in my table - not just those who have an Assignee. Is this possible? Last night I did find a work-around by using DLookup: Assignee: IIf([tblCARs.AssignToID]>0,DLookUp("[FullName]","qryEmployees","[EmployeeID]=" &...

Thanks, Rovers. I've got it set up as you say: Left table: Right table: TableA qryAssignee Column: Right column: AssignToID AssignToID Of the three join property options, #1 is selected. I know that's not right, but the other two options aren't...

Um, If I understand you correctly I've already done that: qryAssignee gets its info from tblEmployees. I do understand that, in records that don't have an AssigneeID, the nature of the relationship with qryAssignee can never be true.... I just don't know what to do about it! Help!!

Hi. I'm having a strange problem I hope someone can help with. In QueryA, I'm getting values from TableA, which includes a field called AssigneeID. I want to see the name associated with AssigneeID, so in QueryA, I've added qryAssignee, which has a relationship to TableA. Trouble is, if the...

Thanks, RG. I have to leave now to go to another site (hate to leave in the middle of a this!!! :( , but I'll give your code a go in the morning and let you know how I get on. Many, many thanks! Christine

Oh - I didn't know about that! As to your question, um... I want the user to pick a date from the calendar and store it in the table. This type of thing would happen for a variety of fields.

I got the code to run the ActiveX control (all the lines of code I sent a few posts ago) perhaps ... um... a year and a half ago. I don't know if it was Alan's or not. The new code IS Alan's and I just got it last Friday from his website. I'm sorry if I confused things by posting the ActiveX...

Oh dear, RG - Don't look at the code I sent to you -- that's all related to the ActiveX control I'm trying to get rid of because the References are all messed up and everyone says that's why you shouldn't use ActiveX. Alan's code (which I haven't posted yet - it's on his website) is the stuff...

RG, here's what I've got: ActivateCalendarForm "CompletionDate" Here's the code in frmCalendar: Option Compare Database Dim arArgs() As String Private Sub UpdateCaller(ByVal DateIn As Date) On Error GoTo Err_UpdateCaller Dim fFrm As Form Dim cCtrl As Control Dim arFormInfo() As String...

Dazed, Yup, I've looked at Utter Access but the samples didn't work for me. RG, if you could indeed have a look-see I'll be very grateful. My programming skills just aren't up to the task - I'm much better at learning by example!

Yes, I have looked at that link, RG. There's lots of great stuff, but Alan's looked the simplest for me to deal with - save the trouble with the text vs. date definitions. I'm really hoping someone can help me soon, as I've had to take my application off-line whilst I try to figure something...