Search results

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

Thanks for this, Workmad. By asking me to post the code, do I assume that there is no way for me to see the code working? Anyway, here is the code. Quite simply, the code checks to ensure all form fields have been filled in (via a module). If all is well, e-mail addresses are obtained and...

Thanks for that. I've checked the button and it is associated with the code. When I click the button, there are no error messages and the programme doesn't become "hung", as I can click the Exit CmdBtn and exit back to the other screen.

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

Scott and Pat, Thanks for your ideas and info. I haven't formatted the date in the query, but the format IS specified as a medium date (DD/Mmm/YR) in the table, where an option to select 'no formatting' isn't available. So, am I assuming correctly that the only way to sort dates is as I've done...

Oh, I see! I took off the formatting and sorting works. However, I'm an American in England and my simple mind still gets confused looking at the D/M/YR format used here, so I really want that formatted date. As a work-around, I've since discovered CDate. In my query, I've added DateReviewed...

Boy, that was fast... Thanks, SJ! But, er... I understand that it's not good to store date info as text. I don't understand what the point of date fields is if you can't do something with them like this. Sorting dates is quite important ot my application. Do I need to create other fields to...

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

Thank you Tim. Christine

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

I tried SJ's suggestion -- [EmployeeID].[Column](1) -- but that doesn't work. So, if I understand The Doc Man correctly, it is not possible to show anything but a combo/lookup field's first column in a query; the only time this is possible is in a form or report. That is a shame. Would you let...

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

Thanks, Mike. If this ever happens again, I'll try your suggestion. In this particular case, it didn't work - the whole thing went south. It suspect that the cause was when I was trying to create a new module for a query. I really didn't know what I was doing, trying different things, when it...

Sounded like an excellent idea, Uncle, and I gave it a go. Unfortunately, as soon as I specified the mde as the source of my import, its tells me it's corrupted. Thanks for trying to help me with this. Thank goodness for backups! Christine

Thanks for that, Uncle Gizmo. You suggested to "isolate the damaged files". Well, the entire database (*.ldb) is damaged as far as I know, and there is no way to isolate the tables, queries, forms, etc. that make it up. I tried moving the *.ldb files (there were 2: one for the back-end and...

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

Yikes, that's a heck of alot of code in the pop-up calendar! I'd have to modify it to suit my needs (if I can figure it out!), especially since some forms have up to 3 fields that you the calendar function, along with modifying all my forms! Still, the ability to show 3 months is a really nice...

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