Search results

Here is my query: SELECT Format$(Target_Date,"mmm-yy") AS [Month Period], Count(Action_Item_Number) AS Count_Items_Committed, Sum(IIF(Status = "Completed"),1,0) AS Count_Completed FROM [Action Items] GROUP BY Format$(Target_Date,"mmm-yy") HAVING Target_Date <> " "; I keep getting a message...

Sweet that worked great. Thanks. But if I can I have another question. How can I sort this by the month. Right now it is sorted in alphabetic order by the month. I tried the following statement: ORDER BY Year([Defects].[Discovered_On]) & DatePart("m", [Defects].[Discovered_On] ) I...

Hello all :) I am trying to create a query from my account of the number of defects we have had in a month. I know the date to use (Discovered On). But I need to show the sum of defects by month and it in a format of "mon-yy". This data will be used in a chart for a later process. I...

That did the trick. Thanks

I have a label that says "IV&V". But on the report it shows up as "IV _V". I figure it is having trouble figuring out if the '&' is just an ampersand or a continuation. Is there a way to get my label to say "IV&V'? Thanks :D

Hello again how are you. I created a query that produced the sum of a particular field under a certain date range. It is only a one field query. Sometimes the query will be produce no records (depending on the date range entered). But instead of a 0 in the field I can't a blank query (which...

Hello again. Is it possible to move data from an OLE Object field to another OLE Object field. I am trying to run this function that takes the description field from one table and moves it to another field that is also an OLE Object data type. But when I do the following: rs.Edit...

I opened the backup database as exclusive. Then I went to import the IR table from the main database and I still get errors. I can't see where I can mark the main database with the IR table as exclusive. I don't see that option. I have a feeling it is something with the OLE object in the...

For some reason I am having headaches today with my project database. Sometimes I get this 'On Open you entred as the event property produced the following error' message when I try to open up my database. The database has a startup form of "Main Menu". I don't get it all the time but I...

Every week I take my projects Access 97 database and back up on a separate DB. I have had no problems with doing the IMPORT but lately I have been having a real hard time with one of my tables. Everytime I try to import my IR table to the backup database I get the following message: The...

Hello all, how are you doing. I had to make some updates to a system I was working on for my job. Made the change and went through the Setup Wizard part with no problem. But when I execute the SETUP.EXE file I get 'Setup Error 824' on Object 625, 630, 635, and others. Then I get a 'Setup...

I knew I wasn't going to explain this properly. Let me try to reprhase it. If the user doesn't enter a value in the form Start Date and End Date fields I want the select query to read: SELECT Contractors.Developer_ID, Contractors.Case_Prefix, Contractors.Case_Num, Contractors.Expense_ID...

Is it possible to include some kind of "If" processing when decided to use criteria. For example I have this query: SELECT Contractors.Developer_ID, Contractors.Case_Prefix, Contractors.Case_Num, Contractors.Expense_ID, Contractors.Expense_Amount, Contractors.Expense_Date FROM Contractors...

Is there a field or variable that is set when the user hits the "Delete" key? My form uses a datasheet view mode to add, update, delete data. In some cases the form is going to the "BeforeUpdate" and "AfterUpdate" events and I don't want that to occur. I want the form to delete the record...

To save them the trouble of going in and out of a form. The subform table only has 4 fields in it. I think I figured out that problem anyway but still need some testing.

Hello all how are you doing. I am trying to create a screen that allows the user to add multiple records in a table at one time. I figure that using a subform in datasheet view will solve this problem (stop me if there are better ideas). I created the subform and linked it with the main form...

Hello all. My manager wants me to create a summary report from information in 5 different tables. The main key for all tables are Status_number. 1. Requirement table - count of records 2. Defects table - count of records (if any exists) 3. Metrics - sum of two hour fields 4. Peer Review -...

Hello all. I am trying to work on my application to set all the reports to Print Preview. The problem is that for users that only have a run-time version of Access 97, they don't get to do anything with the preview (print, save to file, display multiple pages). Is there a way I can get around...

Is there a way to shrink or grow horizontaly based on the data of a text box? I know you can grow and/or shrink veritically but I would rather be able to shrink the other way because of the different size of data in this text box Thanks

Your probably getting tired of these messages but can I get a copy of the code you were talking about. I just got bit by the screen resolution bug myself. I tried to look for your email address and had no luck. Please send it to: michael.hammond@eds.com Thanks a lot.