f



Playing & recording WAVE-type sound in MS Access - could Me!Message.Action = 7 value assignment differ if I'm using Access 2.0?

I've followed the instructions found on Microsoft's site...
http://support.microsoft.com/default.aspx?scid=kb;en-us;149119&Product=acc97

Here are those instructions...

To play and record sounds, follow these steps: 
Create the following new table in Design view:      Table: Messages
      -----------------------
      Field Name: Message
        Data Type: OLE Object
					
Save the table as Messages, and then close the table. 
Create a new form in Design view based on the Messages table. 
Add the following controls to the form:      Bound Object Frame:
        Name: Message
        ControlSource: Message

      Command Button:
        Name: RecordMessage
        Caption: Record

      Command Button:
        Name: PlayMessage
        Caption: Play
					
Add the following event procedure to the OnClick property of the
RecordMessage button:      Me!Message.Class = "soundrec"
      Me!Message.Action = acOLECreateEmbed
      Me!Message.Verb = acOLEVerbPrimary
      Me!Message.Action = acOLEActivate
					
Add the following event procedure to the OnClick property of the
PlayMessage button:Me!Message.Action=7
					
Switch the form to Form view. 
To record a message, click the Record button to open the Windows Sound
Recorder. 
Record your message, and then click "Exit and Return to Messages" on
the File menu. To play your recorded message, click the Play button.


Works fine in Access 95/97, but when I run it in Access 2.0, it pukes
on the Me!Message.Action = 7 line.

Anybody know why that may be? I know Access 
2.0 is old and unsupported... etc, but so am I.
0
CRCI (2317)
11/5/2003 12:15:11 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

6 Replies
1141 Views

Similar Articles

[PageSpeed] 33

get the PlaySound cod from www.mvps.org.  That should work in Access
2.  Check the modules section.
0
pietlinden (2926)
11/5/2003 7:10:44 AM
Hey thanks! I'll give it a shot.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


On 4 Nov 2003 23:10:44 -0800, pietlinden@hotmail.com (Pieter Linden)
wrote:

>get the PlaySound cod from www.mvps.org.  That should work in Access
>2.  Check the modules section.

0
CRCI (2317)
11/5/2003 10:11:06 AM
Oh, well, as luck would have it. My search there for 'playsound'
turned up 5 hits, but none of them reeked of 16-bit stuff.
Unfortunately for me, I'm afraid. I couldn't specifically identify
the 'modules section'.

Thanks anyway, Pieter. I appreciate the suggestion.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
0
CRCI (2317)
11/5/2003 10:22:15 AM
sorry, got lazy.  here's the full address for the PlaySound API function:

http://www.mvps.org/access/api/api0011.htm

not sure about recording...
0
pietlinden (2926)
11/5/2003 2:56:06 PM
Well, I tried it.
However, when this line ran...

lngRet = apiPlaySound(strFilename, intPlayMode)

Access 2.0 returned a msg saying "Error in Loading DLL"

I'll test this in Access 97 2C if the error occurs there.
0
CRCI (2317)
11/6/2003 7:36:24 PM
Try this:
Dump this in a module (I called it basWav...)  (watch for line-wrap)
Declare Function csvSndPlaySound Lib "MMSYSTEM.DLL" Alias "SndPlaySound" (ByVal FileName As String,
ByVal How As Integer) As Integer
Function csvPlayWave (ByVal FileName As String, ByVal How As Integer) As Integer
csvPlayWave = csvSndPlaySound(Trim(FileName), How)
'Example:
'Dim lngRetkode as long
'lngRetkode =csvPlayWave("c:\windows\media\tada.wav", 1)
End Function

Works in Access 2.0 on my PC ...

-- 
Hope this helps
Arno R


"MLH" <CRCI@NorthState.net> schreef in bericht news:e4ggqv8o63o6oocg4o5orsovlea2v6t7id@4ax.com...
>
> I've followed the instructions found on Microsoft's site...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;149119&Product=acc97
>
> Here are those instructions...
>
> To play and record sounds, follow these steps:
> Create the following new table in Design view:      Table: Messages
>       -----------------------
>       Field Name: Message
>         Data Type: OLE Object
>
> Save the table as Messages, and then close the table.
> Create a new form in Design view based on the Messages table.
> Add the following controls to the form:      Bound Object Frame:
>         Name: Message
>         ControlSource: Message
>
>       Command Button:
>         Name: RecordMessage
>         Caption: Record
>
>       Command Button:
>         Name: PlayMessage
>         Caption: Play
>
> Add the following event procedure to the OnClick property of the
> RecordMessage button:      Me!Message.Class = "soundrec"
>       Me!Message.Action = acOLECreateEmbed
>       Me!Message.Verb = acOLEVerbPrimary
>       Me!Message.Action = acOLEActivate
>
> Add the following event procedure to the OnClick property of the
> PlayMessage button:Me!Message.Action=7
>
> Switch the form to Form view.
> To record a message, click the Record button to open the Windows Sound
> Recorder.
> Record your message, and then click "Exit and Return to Messages" on
> the File menu. To play your recorded message, click the Play button.
>
>
> Works fine in Access 95/97, but when I run it in Access 2.0, it pukes
> on the Me!Message.Action = 7 line.
>
> Anybody know why that may be? I know Access
> 2.0 is old and unsupported... etc, but so am I.



0
11/6/2003 10:52:37 PM
Reply:

Similar Artilces:

Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW? #2
Hi Alex77, can you please post your vi? so that it will be easier to understand your problem. Any of the field has autogenerated values??? ...

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

MS-Access, ODBC access with Visual C++ 6.0, and external actions on database
[was redirected here] I have a problem that I can distill down to the following. 1/ A Visual C++ 6.0 program connects to a MS Access database using an ODBC connection and sleeps for a long time. The connection takes all defaults and uses CDatabase::useCursorLib in the OpenEx command. 2/ The database is well over 400MB large with over 200 tables and is compacted. 3/ Another process starts a winzip on that database that takes about 45 to 60 seconds to complete (wzzip -a -ex aaa.zip aaa.mdb). 4/ The Windows Task Manager shows 100s of MBs of available memory being consumed....

How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I am trying to write to a MS Access database. Everything works fine as long as I add data to all records at the same time. The database I am using have two tables (just for testing) with a 'one-to-many' relationship between the two. They both have a PrimaryKey with the data type 'AutoNumber'. From what I understand those numbers should be automatically generated when new data is written to the DB. I can't get that to work with LabVIEW. I am using the function 'DB Tools Insert Data.vi'. According to the manual I should be OK with specifying the column I want to write...

Re: How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I applied the same approach as you guys have described, however my problem starts before I get to autonumber. I have an issue feeding column (data) from "DB tool list column VI" to "DB Tools insert data VI" .So when&nbsp; I connect&nbsp; column output of "DB tool list vi" to column input of "Insert data Vi " I get an error message "exception occurred in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.." However, when I don?t connect column between those two v...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

how to access MS data access 2.7 sdk ???
I keep getting the following when trying to create a connection to a database : Error: User defined type not declared . The declaration it is complaining about is : c1 As ADODB.Connecton I'm re-entering this mess from a couple of years ago, and just want to connect to a DB2 v8.1 database from a VB app. Any suggestions, code examples, etc., would be appreciated. Mairhtin O'Feannag mairhtin at techsolutionsgroupllc dot com ... On 24 May 2004 13:31:01 -0700, in comp.lang.basic.visual.database you wrote: >I keep getting the following when trying to create a co...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but I don't know what software is >needed. Do you know? If so, please answer this post. Thanks. I think it comes down to semantics. "Licensed" vs "Loaded". No you can't create an app that will run on a PC with nothing loaded. Yes you can create an app that will run on a PC where nobody's paid the fee to run MS Access. You still have to install something on that PC, however. What it is is a freebie version of MS Access that only runs applications - doesn't allow anybody to develop an app. You develop the app on your PC, which has MS Access installed. Then somebody installs the freebie ("Runtime Access") on somebody's PC and they can run the app you developed without having to pay any money to anybody. -- PeteCresswell Sue, If Access isn't present, some version of it must be installed to run an Access database. VB.NET, ...

Use ASP to read MS Access query that calls MS Access function
Hi: I have an MS Access query for a table called MyTable. One of my fields in the query is a custom field that looks like "MyField: = MyFunction(ID)" where ID is a field in MyTable. I have ASP code and I can use it to read the query OK when "MyField" is not part of the query. If I add in MyField and then run my ASP code to try to read all the query fields, I get an error message on my web browser which says something to the effect of "cannot find MyFunction." On the Access side, I have MyFunction set up in a module and use the keyword "Public" in front of the function name. What else do I need to do to get my ASP code to run this query. I'm trying to avoid reproducing MyFunction within the ASP code if possible. Thanks. Kevin On Thu, 14 Jun 2007 21:38:19 -0000, k-man <kmccrack@gmail.com> wrote: Sorry, no can do. From ASP you don't have access to the Access VBA interpreter. -Tom. >Hi: > >I have an MS Access query for a table called MyTable. One of my >fields in the query is a custom field that looks like "MyField: = >MyFunction(ID)" where ID is a field in MyTable. > >I have ASP code and I can use it to read the query OK when "MyField" >is not part of the query. If I add in MyField and then run my ASP >code to try to read all the query fields, I get an error message on my >web browser which says something to the effect of "cannot find >MyFunction."...

Use of Access 2002-2003 structure in MS Access 2007 #2
Dear reader, Is it possible to run in Access 2007 an application designed in Access 2002-2003 format? Tanks for any assistance. Kind regards and all the best for 2009 Simon Simon van Beek wrote: > Dear reader, > > > > Is it possible to run in Access 2007 an application designed in > Access 2002-2003 format? > > > > Tanks for any assistance. > > > > Kind regards and all the best for 2009 > > Simon Yes. There might be some issues, though, depending on how you've programmed the db. Best suggestion, in my eyes, would be testing and playing around a little with *a* *copy* of the database and see what turns up. Most likely, you'd need to set the directory in which the database resides, as a trusted location. A very good sumup of "the good, bad and ugly" ;-) of Access 2007 is this list by Allen Browne http://allenbrowne.com/Access2007.html -- Roy-Vidar Simon, Best wishes to you too. One question: why do you use so many carriage returns in your messages? They cause readers having to unnecessary scroll. Thanks, John "Simon van Beek" <SvanBeekNL@Versatel.nl> schreef in bericht news:495f3ebf$0$28733$bf4948fe@news.tele2.nl... > Dear reader, > > > > Is it possible to run in Access 2007 an application designed in Access > 2002-2003 format? > > > > Tanks for any assistance. > > > > Kind regards and all the best for 2009 > > Simon >...

Accessing a passworded MS Access 2000 database in Crystal Reports #2
Can anybody give me some code that I can put in to my VB6 app to open a passworded Access database in the Crystal Reports 8.5 RDC? I see so many examples - none of which seem to work for me. I am using a native connection in Crystal ( pdbdao.dll). My current code is : Dim Report As New crPrintPreview Dim crTable As CRAXDRT.DatabaseTable Private Sub Form_Load() Set crTable = Report.Database.Tables.Item(1) varpath = CurDir crTable.Location = varpath & "\OrderManager.mdb" CRViewer1.ReportSource = Report CRViewer1.ViewReport End Sub All I receive is the message "Error opening file xxxxxxx etc" and then "Open Database session failed" Appreciate any help! Peter Tyler ...

Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Hello all Would it be possible to migrate the MS Access 2000 to MS SQL Server 2000? My application is using MS Access 2000 as database and as user interface such as forms. Now, I want to migrate the backend database from MS Access 2000 to MS SQL Server 2000. However, I want to keep the MS Access 2000 interface. Would it be possible? If I migrate the MS Access to SQL Server, would the queries, back-end VBA, macro, tables and forms be affected? Do I need to change the MS Access data type to SQL server supported data type? Which tool I can use to do the migration? Upsizing wizard or exporting...

Using Access to 'access' an sql database on a webserver
Is this possible? I know about a bit about ODBC and found how to import an ODBC database stored on the computer, however I am after accessing an SQL database stored on a webserver. I'd like to keep it up to date, but that could probably be done with a macro. At the moment I'm just considoring possible options, so just need to know if it can be done, how easy and a rough idea of how. Any help would be much appreciated! Flic On 6 Oct 2006 03:59:25 -0700, "Flic" <FelicityP@gmail.com> wrote: I typically create an ADP, then connect to such db specifying the IP address and the u/pw I got from the ISP. -Tom. >Is this possible? > >I know about a bit about ODBC and found how to import an ODBC database >stored on the computer, however I am after accessing an SQL database >stored on a webserver. I'd like to keep it up to date, but that could >probably be done with a macro. > >At the moment I'm just considoring possible options, so just need to >know if it can be done, how easy and a rough idea of how. > >Any help would be much appreciated! > >Flic Yes, you can connect to the sql server. However, how that server is exposed to the wild wild internet is another matter!! Most (if not all) administrators of their web sites NEVER EVER allow their database server to be exposed to a wide open port on the internet. So, can you do this...sure. However, you need go to web server, and setup the permissions to a...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

Access needs to be installed for me to use MS Access
Hi, Is it required for MS Access to be installed on machines on which I need to deploy windows app which uses MS Access as its backend. If no then how do I access and wrie to access database? Thanks, Vikas. <vikassah@gmail.com> wrote in message news:1166161668.556801.183030@n67g2000cwd.googlegroups.com... > Hi, > > Is it required for MS Access to be installed on machines on which I > need to deploy windows app which uses MS Access as its backend. If no > then how do I access and wrie to access database? If Access, or the Access runtime (from the developer extensions) is not on the user's machine, then the front-end can be written in a language that supports either DAO or ADO, both of which are available in libraries that are compatible with classic VB (through V6), C++, C#, or VB.NET. There are ther programming languages that can use Windows DLLs, too. Just for the record, though even Microsoft makes the same slip, what you have is _not_ an Access backend, but a Jet database engine backend. DAO support for Jet is available in the "MDAC 5.0" and earlier, and ADO support is available in that, and later versions of MDAC (Microsoft Data Access Components). Larry Linson Microsoft Access MVP ...

Accessing MS-Access from OpenRoad using ActiveX
Hi I'm wanting to conect to an MS-Access MDB file from an OpenRoad program using ActiveX. Can someone tell me the files I need to use/register for Windows XP? Any other help or suggestions would be most appreciated. Darren dharvey911@hotmail.com ...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

accessing ms access via ODBC without Microsoft Access
Hi, If I have a computer without Microsoft Access installed but with an ODBC connection to a .mdb file - can I still access the 'database' via ODBC? thanks Tim <timasmith@hotmail.com> wrote in message news:1145206985.433826.106120@i40g2000cwc.googlegroups.com... > Hi, > > If I have a computer without Microsoft Access installed but with an > ODBC connection to a .mdb file - can I still access the 'database' via > ODBC? Yes, provided you are running a program prepared in a language that supports ODBC and have installed an ODBC driver on that user's machine. What you cannot do is to access a Jet (often called Access) database via ODBC from Access. You can link to tables in that Jet database, or open it directly, but you can't ODBC to Jet tables from Access itself. Larry Linson Microsoft Access MVP ...

Date picker from MS-Access 2000 to MS-Access 2003
Hello. How do I get a date picker (References: Microsoft Calendar Control 8.0 Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in MS-Access 2003. TIA J�rn Why not scrap it and use the all-API approach Stephen Lebans has at http://www.lebans.com/monthcalendar.htm -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message news:42190d18$0$48635$edfadb0f@dread15.news.tele.dk... > Hello. > > > > How do I get a date picker (References: Microsoft Calendar Control 8.0 > Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work > in > MS-Access 2003. > > > > TIA > > J�rn > > Allen Browne has an excellent calendar control at http://allenbrowne.com/tips.html -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com "JHB" <joern_bea@removeThis_tdcadsl.dk> wrote in message news:42190d18$0$48635$edfadb0f@dread15.news.tele.dk... > Hello. > > > > How do I get a date picker (References: Microsoft Calendar Control 8.0 > Location C:\Windows\System 32\mscal.ocx) inset in MS-Access 2000, to work in > MS-Access 2003. > > > > TIA > > J�rn > > Thanks for the link...

Can I join an Access 2.0 system.mda file from Access 97, to make it easier to import forms and other objects from my old Access 2.0 apps?
The arduous job of importing Access 2.0 objects is complicated by the fact that I have some of the apps secured. I know I can UNSECURE chosen apps and circumvent this issue using the old CopyObject security loophole. But sometimes I need to just pull in a couple of forms and some modules w/o the hassel. Can I join an Access 2.0 system database from Access 97? Tip: A better Title for this thread:=20 A97: Join Access 2.0 system.mda ? I simply can't read and don't like these 'far too long' titles. You are doing this more and more ?? Why ?? Now to your question: You can use (and thus join) Access 2.0 system databases AFTER converting = them. Arno R "MLH" <CRCI@NorthState.net> schreef in bericht = news:3fvp91ho82a5tqpet8q0h529qnsgqji939@4ax.com... > The arduous job of importing Access 2.0 objects is > complicated by the fact that I have some of the apps > secured. I know I can UNSECURE chosen apps and > circumvent this issue using the old CopyObject security > loophole. But sometimes I need to just pull in a couple > of forms and some modules w/o the hassel. Can I join > an Access 2.0 system database from Access 97? I should-a-thought of that. You are right, short subject = better. ...

Access 2.0 Help mentioned 'record numbers' frequently but nowhere did it ever say how to determine a given record's record number
Anyone remember how to determine a particular record's record number (Access 2.0 table question)? You could get the number from the AbsolutePosition property of the Recordset. Details: http://allenbrowne.com/casu-10.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "MLH" <CRCI@NorthState.net> wrote in message news:qkoo90t2nta3v281a2kn7bkp2ru8jjdii5@4ax.com... > Anyone remember how to determine a particular > record's record number (Access 2.0 table question)? I checked. Unfortunately, I don't think it was available in Access 2.0 - any other recollections? Even guesses (SWAG's) will be appreciated. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx On Sat, 8 May 2004 23:20:33 +0800, "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote: >You could get the number from the AbsolutePosition property of the >Recordset. > >Details: > http://allenbrowne.com/casu-10.html Don't have A2 installed on this machine, but if you open the form in design view, open the Properties box, and look on the Data tab of the dialog, you should see the property. (Make sure you're looking at the properties of the Form, not of a text box.) -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne ...

How to access MS Access from Perl?
Hi, Good day! I am writing some Perl script on the server side for HTML forms that can create/update an MS Access database. Does anyone know of examples how this can be done? Your help is greatly appreciated. -lc Email to luican@yahoo.com bounces. Anyway, try DBI and DBD::ODBC. Or maybe DBD::ADO, but I've never tried it. ---------------------------------------- http://cpan.org http://search.cpan.org/~jurl/DBD-ODBC-1.09/ODBC.pm ... Connect without DSN The ability to connect without a full DSN is introduced in version 0.21. Example (using MS Access): my $DSN = 'driver=Mi...

access MS-Access database in C# Windows Application
Hi, I am trying to access the MS Access database on my local machine in C# Windows Application in Visual Studio.NET. But it seems that it does not work. I use the Microsoft Application Blocks to access the database. I have tried 2 possible connection strings. ----------------------------------------- str_1 = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + DBFilePath; str_2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBFilePath; //SqlHelper is the class in the Microsoft Application Blocks SqlHelper.ExecuteNonQuery( str_1, CommandType.Text, SQL_str); ----------------------------------- The error message I got is: "Unknown connection option in connection string: driver." for str_1 and " Unknown connection option in connection string: provider." for str_2 So I am wondering, where is the problem? Is it because my connection string for MS Access is specified wrongly? Or is it because I cannot use SqlHelper to access the MS Access database? ( I have used SqlHelper class to access the MS SQL server, and it works) Your help will be greatly appreciated. James James wrote: > Hi, I am trying to access the MS Access database on my local machine > in C# Windows Application in Visual Studio.NET. > > But it seems that it does not work. I use the Microsoft Application > Blocks to access the database. > > I have tried 2 possible connection strings. > > ----------------------------------------- > ...

Web resources about - Playing & recording WAVE-type sound in MS Access - could Me!Message.Action = 7 value assignment differ if I'm using Access 2.0? - comp.databases.ms-access

Message - Wikipedia, the free encyclopedia
A message is a discrete unit of communication intended by the source for consumption by some recipient or group of recipients. A message may ...

How a Perth SAS soldier’s spiritual message from beyond the grave changed lives
SOMETHING was telling Charlotte she had to go. She didn’t want to. She never left her cousin’s farm in the northwest of NSW before enjoying a ...

How a Perth SAS soldier’s spiritual message from beyond the grave changed lives - PerthNow Search Search ...
SOMETHING was telling Charlotte she had to go. She didn’t want to. She never left her cousin’s farm in the northwest of NSW before enjoying a ...

Apple releases OS X 10.11.4 beta 7 with Messages & Notes improvements, more
In addition to releasing the seventh beta of iOS 9.3 yesterday, Apple today has released OS X 10.11.4 beta 7 to developers and public beta testers. ...

WhatsApp testing text formatting to include bold and italics in messages
The latest beta release of WhatsApp features some basic text formatting options including bold and italics. While features in beta versions of ...

The Fed's Hidden Message
Officials are strangely OK with low inflation. The U.S. Federal Reserve's latest economic projections contain an encoded message crucial to understanding ...

The world's oldest message in a bottle spent 108 years at sea for a critical science experiment
The world's oldest message in a bottle was actually one of more than 1,000 identical bottles that helped shape our understanding of ocean currents. ...

WATCH: Tom Izzo’s Emotional Message To Denzel Valentine After Michigan State’s Shocking Loss
"We just got beat," Izzo managed to croak out after a 90-81 loss to No. 15 seed Middle Tennessee State on Friday ended their pursuit far sooner ...

Foxx parlays personal story, message of change to big win
Chicago Tribune Foxx parlays personal story, message of change to big win Chicago Tribune Cook County State's Attorney Anita Alvarez and challengers ...

What’s Taking So Long With that Email? Google Adds Smart Reply To Messages
Not sure how to reply to that email about your upcoming class reunion from Karen? Don’t worry your pretty little head, Google has apparently ...

Resources last updated: 3/21/2016 9:11:33 PM