| Thread | Last Post | Replies |
|
| Error and endless loop | 24 Jul 2008 16:11 GMT | 4 |
Access 2007 - Preview report - I get message box that says "Microsoft Office Access can't find the field..." I click OK and get the box again and again and again. Is there any way out of this loop but to force the entire application down?
|
| Access 2000-Index Capacity-Reporting | 24 Jul 2008 16:08 GMT | 6 |
Never thought I would be asking this question. I may be exceeding an Access capacity because some Indexes have disappeared or lost their basis. Compacting/Repair is done frequently. Access 2000. Front end is growing and is connected/linked to a variety of
|
| Removal of Zero lenth String | 24 Jul 2008 16:08 GMT | 2 |
I understand a zero length string. We have a table of data downloaded from "who know where" and a lot of the values seem blank and some are, but others are zero length. Can we programattically or thru any other means, clear the fields of the "".
|
| command to send an e-mail | 24 Jul 2008 16:06 GMT | 1 |
I'm using the below command to send an e-mail,I need the message to open before sending,so that i may put the To and CC fields. The code is Dim mess_body As String
|
| cannot add the number in excel shhet | 24 Jul 2008 15:57 GMT | 1 |
I have copy some figures from HTMl formats to Excel sheet but some figures can be add but i cannot but i can see in excell sheet all the numbers but still cannot add or add sum
|
| Group radio button is grey color | 24 Jul 2008 15:50 GMT | 1 |
I don't understand why when i use the group option for radio or checkbox, i notice the inside box or inside radio become grey color if nothing is select. I tried if i use regular checkbox and radio it will not that way. Can anyone explain and how do I make the checkbox or radio ...
|
| printer object | 24 Jul 2008 15:42 GMT | 3 |
I don't know if this is possible, but I need to get the name of the printer that a user sends a report to. I have tried using Application.printer.devicename in the Page event of a report to do this, but it will only return the name of the default printer, not the printer that ...
|
| Diff2Dates Calculation without Weekends or Holidays | 24 Jul 2008 14:48 GMT | 1 |
Is there a way for the Diff2Dates function to exclude weekends and holidays in its calculation of the Difference between to General Dates? For Example: A field in my reporthas the following control source:
|
| Report Question | 24 Jul 2008 14:46 GMT | 4 |
I am working on a Procedure database that has a sub form. That database, form, report and queries all work fine (so far). On one report I have a graph that show the for departments each with a colored bar to show how many procedures they have completed. This works great and as I ...
|
| MaxLocksPerFile exceeded | 24 Jul 2008 14:02 GMT | 2 |
I tried to use the table analyzer in MS Access to see what it does. When I got to the end it couldn't create a query and gave me the above error. I went to the registry editor and found that the setting was 9500. I am working on a Novell network and read that I can't increase the ...
|
| Sending E-mails via Access | 24 Jul 2008 13:58 GMT | 2 |
I have an access database that generates a report, then sends the report out as an attachment via e-mail (through Outlook) to a list of users. The problem I'm having is that when I start sending the e-mails it ends up locking up my computer, and then crashing Outlook; so I'll get ...
|
| Continuous Form question | 24 Jul 2008 09:00 GMT | 5 |
I have a continous form that displays the results of a query. The criteria for this query is a part number. I would like to have on that form a text field where you can enter in the part number and use that field to run the query against
|
| working days calculation | 24 Jul 2008 08:45 GMT | 4 |
I have tried to use Arvin Meyer's GetBusinessDay function to calculate a due date from a recieved date. It works fine except for one problem: The function reads dates from the holiday table as US dates but all my region settings are in UK Date format. So if I have a holiday date ...
|
| Access and Windows login (AD) | 24 Jul 2008 08:10 GMT | 6 |
I was assign to develop an Admin Forms database for my office. It consists of 20 or more form. Our HR personel adviced us not to allow browsing staff information. Is there a way to capture login name of the current user from AD? I want to bing this login name to the name of staff ...
|
| Finding null | 24 Jul 2008 06:12 GMT | 4 |
I have a query with criteria in 2 fields: FieldA has criteria: [forms]![MyForm].[Field1] FieldB had criteria: [forms]![MyForm].[Field2] So I need an exact match on those 2 fields.
|