Search results

Having trouble getting the code right to hide and unhide forms. I have a main menu from which users can open other forms. When another form is opened, I want the Main Menu to be hidden, so it doesn't appear in the task bar. For example, from the Main Menu Me.Visible = False...

Without any responses from my post of 3-Mar, I'm hoping that this re-post will bring some help my way! How do you tell Access to send email in HTML, with the user's signature (set in Outlook) - rather than Plain Text? I am sending an attachment, but the formatting for that is okay; it's the...

I use the built-in toolbar to send reports via email using the "Mail to Mail Receipient as Attachment" button, and output as an SNP file. However, when Outlook opens, it changes the default format to plain text, doesn't include my signature, and the Outlook interface is different - almost like...

I'm certain this question has probably been asked before, but I can't seem to find it! I have a form field called fldTitle, and want to ensure users write something that is meaningful by evaluating words within the title to a table of keywords (tblKeywords). I know how to write the IF/ENDIF and...

Hope this isn't too silly, but I've just discovered "decompile". Instructions don't mention back ends and front ends. Do you have to run decompile on the FE and again on the BE, or is it sufficient to do it only on the FE (which has links to tables in the BE). Cheers, Christine

Not sure why nobody is responding to this question, but I've been trying to find an answer since my post of 11 October and a previous one 1 year ago. I'm REALLY desparate for a solution -- there MUST be a cure!! :confused: The problem is that, when you do a "DoCmd.OutputTo acOutputReport"...

I posted this query about suppressing an Access message box 1 year ago but never received a response. I've worked around it, but it has become an issue again. Back then, I was trying to send an SNP file, but I'm having problems with the "not enough disk space message" and haven't had resolution...

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

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

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.

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

I'm *finally* getting around to getting rid of the ActiveX calendar control in my application. After doing battle with references on other users' systems, the ocx references have finally lost the plot and don't work. I've downloaded Allen's popup calendar but have a problem since the app uses...

Form1 calls Form2. Form2 has a command button, but it doesn't work. I've never had to do this before, but I need to see Form2's command button code whilst the form is running. I've tried setting the breakpoint in the VB window, but it doesn't "catch" after I've closed the form. I've searched...

I have a form that allows the user to specify, among other things, date ranges for data to be displayed in a subform (in a form, not datasheet). In the subform, the user can click any column heading to sort the records by record number, employee name, department, etc. The Click event calls a...

Is it possible to set a custom background color for conditional formatting? Don't particuarly want to do it via code, but I suspect it might be the only way. If coding is required, can someone advise how and where to put it? You see, I have a form with a custom background colour. In the...

Is it possible to total columns in a query? Right now, I have a query that produces the following column counts, but I'd like to total Pending, Overdue, etc. This data is being displayed in a subform. Process Pending Overdue Total ------------------------------------- Engineering...

In forms, I frequenty use the following expression to get the results needed from a field's column: =EmployeeID.column(1). However, when I try to use the column function in a query it doesn't like it: EmployeeName:[EmployeeID].Column(1) What am I doing something wrong? Along the...

I'm having difficulty getting results of a query, and hope someone can assist. Query A pulls together data from a table. Query B summarises the info from Query A. Here's a sample column: Field: Pending Review: PendingReview Table: qryA Total: Sum Form A...

I was working on a module and query in my Front End on our internal network when suddenly the system crashed. I now get a message saying the file is corrupt. The system is currently stuck with Record Locking on the file. I can't run "Tools, Compact and Repair". I've tried making a copy of the...

I use the Active X calendar control 10.0 in a number of forms*. The mscal.ocx file is in c:\Program Files\Microsoft Office\Office 10. (*In the calendar's Properties it says it is "MSCAL.Calendar.7", which I think is just MS's way of confusing people.) After splitting the deploying my app, it...