Discussions in microsoft.public.access - www.microsoft.com/communities/newsgroups... | Site profile

I often use Windows Common Controls (mscomctl.ocx) in Microsoft Access. If I use a Treeview Object an want some context help by clicking F1 when selecting a property of the treeview methods, then only a blank help window comes up. Who can help?

I have deployed a 2002-3 mde which was created in A2003. 2 of our people now have A2007. There is a custom toolbar allowing users to print or export reports. If they print a report with a chart in it the chart doesn't print. If they click export they get an error message saying "You tried to perform an operation involving a function ...

Hi, I ran into a similar conflict when I built an outbound dialer/lead manager application for a small call center. I built a NEXT button on the form. The next button pulled a single row DAO query based recordset (qsLead). The selection query was something along the lines of SELECT TOP 1 * FROM Prospects WHERE Status = 0 ...

Hello everyone I have made a form with both horizontal and vertical slider bars. But when I view the form I can not see the horizontal bar along the base of the form and the vertical bar has the bottom missing so I can not see the small arrow that is needed to move to the next record. I have made a mistake somewhere....

Could there be a way, as in Excel, to insert only 9/9/69, which shall be automatically be converted to 09-Sep-1969, instead of typing the complete date? -- Best Regards, FARAZ A. QURESHI

Hi, I have several MS Access DB's that are in a folder that is Read/Execute for Authenticated users. No one can open the DBs. If I change the permissions to Read/Write/Execute than it works because the DB lock file needs to be written to the folder that the DB is located. Is there anyway around this? I do not want the users ...

Good day to all, I was wondering if its' possible to retrieve all e-mail adresses from the BCC field on a received e-mail in OUTLOOK or OUTLOOK express, through MS access in combination with outlook redemption maybe? a silly question maybe but I am very curious! Thanks in advance!...

I incorrectly said Acrobat & should have said Adobe. When I try to open the file I get the error: Microsoft has encountered a problem & must close. It also has the check box about "repair & reopen" but this doesn't help. Then it automatically makes a copy. If I click on the error this is the info that appears. App Name: msaccess....

How can I get a report to display a zero for blank records in a query? Or get the query to display a zero for a blank record? I don't want to have to create a zero record on the table, as this information is entered manually. I have a subquery for each warehouse, then another query that sums all of the warehouses into ...

I am looking for a redistributable package that allows me to Create/Read/Write simple Access 2.0 - 2007 tables. [Only create 2003/2007, but need to read older versions.] I have used JET 4.0 for many years (To support Access 2.0 to 2003) but now need to be able to create Access 2007 tables also. I know I can use the 'Access ...

I incorrectly said Acrobat & should have said Adobe. When I try to open the file I get the error: Microsoft has encountered a problem & must close. It also has the check box about "repair & reopen" but this doesn't help. Then it automatically makes a copy. If I click on the error this is the info that appears. App Name: msaccess....

i have a form that when filled out opens multiple reports from on query. it works all well except for one thing. i have one field, "slicemach", that i choose criteria using this expression: IIf([forms]![Slicing Sheets - print]![hrmachCheck]=True,"HR",Null) Or IIf([forms]![Slicing Sheets - print]![vertmachCheck]=True,"Vert",Null) I...

Hello, I have a database with a subform with the following fields: Tasks and Volume. Everything works fine and I can pull a report and it looks good. However, I need to be able to total each task so as the users are entering their volume for the month, I don't have to look for each separate task on the report to add it....

Hi I have the folowing code in a query, but for some reason it returns the value of 911 ?? any ideas where I have gone wrong. Thanks All SELECT [Main Audit Data].[Audit Date], DCount("*","[main Audit Data]","[fault code]" Like '*[Jacket Panel Damage]*') AS [SELECT] FROM [Main Audit Data] WHERE ((([Main Audit Data].[Audit Date])...