| Thread | Last Post | Replies |
|
| Method or Data Memeber Not Found for Replacement Method | 22 Nov 2007 19:20 GMT | 1 |
I have created some code that obtains data from the internet and puts it into a word document. I want to replace all of the double quote marks with nothing. When I try to run the code that I have now, I get a message that says, "Method or data member not found." Below is the
|
| Record count and file creation date | 22 Nov 2007 17:26 GMT | 2 |
Is there a method in which I can get the following information from an exported delimited text file:- 1. How many records were created? 2. When was the file created (date stamped)?
|
| Dynamic INSERT INTO command | 22 Nov 2007 10:16 GMT | 4 |
I'm trying to create a SQL Insert Into string where one of the fields is the value of a certain variable. How can i do this? What i've done is the following:
|
| Calender | 22 Nov 2007 08:51 GMT | 1 |
I want to insert Calender in my access form, how its possible? Thanks Hassan
|
| create folder with package wizard | 22 Nov 2007 08:08 GMT | 2 |
I have a database that I am packaging using the developer extensions package wizard. I am wondering if there is a way to create a folder such as "MyFolder" in the user's My Documents folder regardless of which Windows OS they have installed.
|
| Reading VB Random Files with Access | 22 Nov 2007 06:39 GMT | 4 |
Is it possible to get Access to link to VB random access files? I mean the old style fixed length files TIA
|
| Automation from Access to Powerpoint | 22 Nov 2007 06:16 GMT | 1 |
I am using the below procedure to open up an Excel Worksheet Embedded in a powerpoint presentation. I have got that to work, What I cannot get it to do is open an embedded Excel Worksheet on any other slide but the first slide. Any suggestions on how to open the file and open ...
|
| Calculated controls | 22 Nov 2007 06:04 GMT | 1 |
I have a report which summarizes sales by Product Code. That is, each line in the report shows total sales for a particular product for the select period. This information is displayed in the ProductCode Header section of the report while the Details section is not visible. I ...
|
| determining if this is the first new record in a subform | 22 Nov 2007 04:49 GMT | 5 |
I've got a form that uses subforms to display/enter data associated with a parent record. The "parent" is each day on a project and the "child" is each tool used for the project on that day. So... if project number 37, building a chair, requires green hammer and a blue saw on ...
|
| Find exact Match | 22 Nov 2007 00:54 GMT | 2 |
I have a code which uses findfirst too check if a number currently exists however it is advising that the number I am checking does exists but when I check in the table it is not there. ie looking for 356 but is finding 356125
|
| Commndbars collection does not contain menus? | 21 Nov 2007 16:56 GMT | 2 |
running the folloing code (from helpfiles) For Each cb In CommandBars("Menu bar") If cb.name = "Forms" Then ' cb.Protection = msoBarNoChangeDock
|
| Search Form | 21 Nov 2007 16:25 GMT | 2 |
Hello, I'm trying to write a search form that will search a main form for fields. The main form consists of several of several subforms. The following piece of code successfully searches for the Buyer Field on the main field. Private Sub cmdSearchBuyer_Click()
|
| MS Access 2002 problem with subform | 21 Nov 2007 14:02 GMT | 2 |
I have an Access 2002 database. On a form there is a subform containing a query that selects data from one single table according to a few criterias on the parent form. I have started this database a while ago and at that time I could select
|
| How do I return a Percentile Rank in Microsoft Access? | 21 Nov 2007 13:33 GMT | 3 |
I'm trying to add a field to a "Make Table" query in Access which will add a column representing the percentile rank of the [Value] field, based on the other values in that column (i.e., 1%-100%)....similar to the PERCENTILE RANK feature in Excel. Does anyone know how to do ...
|
| exif data from jpg's | 21 Nov 2007 13:21 GMT | 6 |
Can someone please enlighten me on how to retrieve exif data from jpg's using vba? My app reads job photos and their path from a specified folder and adds the file and path data to a photos table where the user can add captions etc. The app also creates a copy of each photo much ...
|