Search results for query: *

I have a table of tasks and about 9 records are "Daily" which are identified in a Frequency field of the TblMain. I also have a complete checkbox, a start_date (prepopulated) and an end_date. Once the complete checkbox is marked, the end_date is updated with today's date. If I check off all 9...

Obviously you have more than one record for each one...it seems to me that you may have 2 different values in both records. I.e., brochure.type could equal "this" in one record and "that" in another.

That's exactly what I want...for the user to HAVE to choose an item in the list. I tried putting .style = fmStyleDropDownList but I got an "object doesn't support this property or method" error. Here's my code: With Selection.Validation .Delete .Add Type:=xlValidateList...

I have a validation dropdown list of names in which I need to match the users input to. If the user enters anything besides what is on the list, I need to display an error message. My validationlist is called =val_list which is on another worksheet (Names) within the workbook. I can get the...

thanks ineuw. I had that idea over breakfast after posting this. I'll try when I get the time and advise. If it doesn't work, I'll post the query.

I'm sort of having the same dilemma as buckag only I don't have subreports. I have a report based off of a main query that is based off other queries. There are apprx 6 queries that are based off one table with common fields (date). I need this date to have a between start & end date for...

Rhinob001 I also had this problem and did the host and spyware thing to no avail. I finally called my ISP who had me run the following commands: (I run XP so the commands may differ from the O/S that you're using) Start--run--type in cmd, enter. type in "prompt c:\" without the "" At the...

I have a form with an unbound field that I want to use as an "End Date." This "End Date" will always be on a Sunday. I'ved tried just about every date function there is but because the system date changes, my "End Date" does also. I need it to stay on the following Sunday's date for an...

I tried something similar to this and it only gave me the YES values but this works!!! I must have had my RGB values wrong. (I did it as txt_proform.forecolor = RGB(255,0,0) and txt_proform.forecolor = RGB(0,0,0)) Thanks again and a star for you!

I have a report based off of a query that has a field called [Pro_form](yes/no field). Based on the value of the field, I want to be able to change the color of the font within the report, i.e., if pro_form = -1, then the font is red, otherwise, it's black. Any ideas? Thanks

I had just finished doing that when I checked the post and that was it! Thank you :)

I'm trying to get the number of weeks between 7/2/1997 and 6/8/2004. The code i'm using is what I found here in the forums: Using DateDiff("ww", 07/02/1997, 06/08/2004) gives me 0. Any help is appreciated.

I have been trying to do this for days. I have a .wma file to insert into PP, did exactly as instructed here and it still won't play. I can get a .midi file to play, just not a .wma, .wav or .mp3. I'm using PP 2002 and WMP9. Any help is appreciated.

DoCmd.SendObject acReport, "Reportname", "RichTextFormat(*.rtf)", "", "", "", """[Claimno]= '"" & Text80 &", "", False, "" RichTextFormat(*.rtf) is where your output option goes Subject Line: [Claimno]='"" & Text80 &" will show up as just that. The easiest way to do this is create a Macro...

There's no way around it. Access expects a join on the child (subform) and master (main form) fields. If you have related fields in each table, you can set the child and master properties on the subform and set to continuous forms. This will show all those records in the subform that are...

I'm running Access 2002 on Windows XP Pro. I created a form that pulls from a populated table and created a command button to export the contents to an excel spreadsheet which uses a macro. The form itself is based off of this query: SELECT Office_Entry.* FROM Office_Entry WHERE...

Perfect! Thank you very much!!

I did an import to no avail. I'll try the scanpst and let you know how it goes :) Thanks!

I created a new Outlook Data File, named it Personal Folder(1).pst and moved all my items to it. My problem is that the messages do not show. If I look at the details, it shows that it is 38xxx kb so I know there is SOMETHING in there. How do I get Outlook to show the messages? Thanks!!!

That's what I've had to do on quite a few. I tried splitting this one up between the two CHOOSE functions and pasting into two separate unbound fields. The first CHOOSE worked and the second didn't. Same error. Also tried pasting into a new...it was a no go also. Access is a good tool for...