Search results

Anybody know how to get the Author property of an MS Office file (VB or APIs) ? BTW I am also interested in getting the title. Alex [This message has been edited by Alexandre (edited 02-26-2002).]

I am looking after a way: -To determine in which view a query is opened (design, datasheet...) -To programatically set the RecordSourceType property of a query to snapshot. This property is available from the queries properties form (right click) but not among QueryDef objects properties...

I delving into providing to my users a facility to create their own reports. Since I hate to re-invent the wheel , I was looking after adapting existing wizards to my needs. According to Pat, an utility would be available on MS site to get access to wizards code. I couldn t get it from the MS...

Good day, Pat I somehow could not answer directly to your post without getting a script error. Hence this one to make sure. The following site should provide you with pretty complete info on the RunCommand Constants. http://home.clara.net/tkwickenden/ Cheers, Alex [This message has been...

Could anybody explain me what is the use of using at the same time HAVING and WHERE for the same field in anSQL statment. Example: SELECT Table1.A, Table2.B, FROM Table1, Table2 INNER JOIN Table1 on Table1.A = Table2.A WHERE Table1.A 'Criteria1' GROUP BY Table1.A, Table2.B HAVING Table1.A...

On a non-secured, not shared database, I am struggling against the following problem: a user creates a query, saves it, exports it (say under xls 5-7 format). Then Access won t allow to export again the data, unless it is under the same file name and in the same folder (ie: useless). Error...

Could someone remember me of the syntax to declare un enumerated type under Access VBA? Couldn t find the reference in the help. Alex

I want to disable the minimize/maximize/restore buttons for reports opened in preview mode. Here is the code I wrote: Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As...

I ve just written a function to set reports margins at run time, to put an end to that bad habit that Access has to 'forget' the page settings from time to time. What I could not find was a method/property to set set the page orientation (portrait / landscape). Does anybody know how to ? Thanks...

There you look at the properties of a query in design mode, there is one cqlled filter, thqt I guess must be similar to the reports .filter property. In the case of reports, I know how to programatically change the filter using the DAO .filter or using DoCmd.OpenReport. Is there also a mean to...

I have just splitted my DB BE/FE, and a few things are not working anymore (some code I had written to automate of facilitate part of the data entry), but with no error message. I hate this way ACCESS have on some occasions not to do the work nor to give any eror message . I guess I ll have to...

I ve just tried to split my DB BE/FE using the Access 2000 wizard, and get the errors: - Records cannot be deleted. No delete permission on MsysObject [Why the hell should they be deleted anyway? And I did not set any specific permission on this system table!] - Incorrect [parameter] or...

In order to replace Acess default message when a required field is left blank or filled whith a non allowed zero-length string, I usually de-activate the required and zero-lenghth properties in the backend table and replace them with equivalent validation rules and a custom message. Not that I...

Lastly I decided to further prepare my database for future utilisation in a multiuser context (10 simultaneous users to the maximum). Namely, I reviewed all the code using connection / database or recordsets objects in order to: 1) reduce risks of conflicts, using readonly recordsets/snapshots...

I am looking after a way to automate operation on various recorsets. Is there a way to create a set of recordset (like an array...)? I would like to be able to use a generic name and countable declinations (rcd1, rcd2 or rcd(1), rcd(2), etc...).

Sorry, my Enter key got blocked while I was sending to you the following lines. It seems to have killed your thread. Here is my post: Peter, I had misunderstood your situation. As usually, Pat gave relevant advice so did you follow his second indication (deleting and re setting the source)? It...

I am making reference to Mike Gurman s statement about a rich text control: http://www.access-programmers.co.uk/ubb/Forum5/HTML/001115.html Does this really exist? If so, would anybody know more about it and how to use it? I couldn t eve find it in the More Controls list. Any clue will be...

I wrote a function to automatically fill a table TblAuxGeogr with values in another table TblListGeogr zhen the user selsects a given value in a field. The function freezes at the very begining (Set RsList...) and I can only get out using Crtl+Alt+Supr. What is wrong in the way I am opening...

I am a beginner with database designing (this is my first one), and I recently used ADO for the first time, adapting from examples to fit my needs (could have been DAO but I wanted to learn a bit about how ADO works). My function works fine till now (I didn t test it in a multi-user...

Well, I posted this one in the Forms forum but had no success, so... I created an "Onglet" control on a form (sorry, but I don t know the translation in English: it is the ActiveX control allowing to switch between different pages in a same form). My problem is that each time that the user...