|
WriteIniValues does not work in maintenance mode
Hello,
I created a sample installation that wirtes to an .ini file the value taken
from the textbox via property.
It works ok during the initial installation. But if I re-run the
installation and "change features", I then enter another value in the
textbox, but the installation does not write new value into .ini file.
According to the log, the action writeinivalues is called, but it ...
|
1 |
4/3/2007 8:15:22 PM |
|
|
Default Max Records
If I goto Tools/Options/Advanced I can enter the default max records. I have
set this to 10,000.
Which is fine for my forms. However, this is one particular view,
qryCheckClients that I use this when a user adds a new client - it has over
50,000 records.
If I check this view through code, it seems only the first 10,000 is
returned.
Set cnnADO = CurrentProject.Connection
Set rsO...
|
3 |
4/3/2007 9:12:14 AM |
|
|
SQL Backend, Access Frontend - Filtering problem - plz help
Hi All
I've been asking this on lots of forums but noone answers :(
I wonder if someone can assist me. I've got an inherited access database
which for the most part uses bound forms (about 40 of them) to an access
back-end. Database is in continuous use by around 10 clients. I am not very
experienced with databases, but with a big pile of books I am learning.
We have a need to make ...
|
8 |
4/3/2007 7:15:09 AM |
|
|
Importing Access tables into SQL Server
I tried importing Access tables from 3 different Access database .mdb files
using the upsizing wizard in Access 2003. When importing tables in the first
database, it imported some of the tables, and it got hung up when importing
one of the tables, so I had to end task, and that table's design got
imported, but none of the data got imported, and the remaining tables weren't
imported. Th...
|
2 |
4/2/2007 11:33:42 PM |
|
|
Access 2007 and ADP SQL 2000
Good morning;
i've recently upgrade access from 2003 to 2007.
now when i run storeprocedure from macro i've the error 2950, but the adp
file is always trusted.
you've any idea?
thanks a lot...
...
|
1 |
3/31/2007 9:09:10 AM |
|
|
Newline Characters
To anyone who can help,
I'm trying to create a character string that will display output on two
different lines when an email notification goes out. The email part works,
however, the output isn't what I'm looking for. Here's the segment of code:
INSERT INTO @table (address_id,address,email)
SELECT i.address_id,'Customer Name: ' + n.Cust_Name + '||CHR(10)||Address:
' + n.house_n...
|
3 |
3/30/2007 6:00:21 PM |
|
|
Last
what command in SQL Server is equable "last" in MS Access?
...
|
3 |
3/29/2007 8:14:40 PM |
|
|
SQL Backend with Access Front
We are considering to install SQL Server and Access frontend on the Network.
We can have anywhere from 75 to 175 concurrent users for this application.
How can I set up SQL server as the backend and use Access as the front end
without causing application slow down and possible corruption?
Can this solution even work and if so, what steps should i take?
I believe all the users will need th...
|
5 |
3/29/2007 8:11:40 AM |
|
|
Report by Date and Name
I am wanting to add a box that pops up when i click on a report. When i click
on "Drilling Report" (name of report) i have 2 msg boxes that pop up.."Enter
Perameter Value" - "Date", i enter the date and click enter..then "Enter
Perameter Value" - "Rig" comes up, i enter the Rig name, hit enter and my
Drilling Report comes up with all of the info i need. How can i make one msg
box that pops up...
|
2 |
3/29/2007 5:49:58 AM |
|
|
Link Subforms
I have a MainForm with three datasheet forms on it.
First form "SovItems" is auto linked to the MainForm
Second form "SovInstalled" is linked by a unbound box using txtLink, like I
found in the disucssin groups and it's working good.
The third one is where I have a problem.
I want to link my third form to the second form, but I'm using a composite
key.
My composite key is "ItemNo" and "Pa...
|
2 |
3/29/2007 1:37:14 AM |
|
|
Âí»Ô ²»ÊÇ°É
¶ÔÃÀ¹úÀ´Ëµ½ÓÊܵã¿Ö²ÀÖ÷ÒåÒ²ÊǺõģ¬Ò²½ÐËûÃǸÐÊܸÐÊÜÄÇ×Ìζ¡£µ«ÊǶÔÓÚÃÀ¹úµÄÃñÖÚ
ȷʵÓеã²ÐÈÌѽ£¬Ö»ÊÇÕë¶ÔÃÀ¹úµÄÁìµ¼È˶øÒÑ¡£
...
|
1 |
3/29/2007 12:37:54 AM |
|
|
Âí»Ô ÊÇÂð
ÕæµÄÓÐÄÇôʵ»ÝÂð
...
|
1 |
3/29/2007 12:33:04 AM |
|
|
how to use OpenRecordset
I am trying to write code in Access VBA. I am going to run a select SQL to
read a record from a table then copy it into a variable. I am using
Private Sub Form_BeforeInsert(Cancel As Integer)
Dim strSQL As String
Dim strTmp As String
Dim rst As DAO.Recordset
Dim myDb As DAO.Database
Dim intResult As Integer
strSQL = "select FirmID as firmid" & _
...
|
4 |
3/28/2007 8:04:33 PM |
|
|
Autonumber Increment
I have a MainForm called MainForm, on the main form I have two datasheet
forms.
The first datasheet Form called SovItems and is linked to the MainForm with a
field called Division
The second datasheet is called SovInstalled and is linked to the first
datasheet using a field called ItemNo by using a unbound txtbox called
txtLink (this Link works great everything is in sync.)
What I need to...
|
5 |
3/28/2007 5:06:39 AM |
|
|
tiantian
still
...
|
1 |
3/28/2007 3:30:52 AM |
|
|
hello
good
...
|
1 |
3/28/2007 3:28:05 AM |
|
|
still
maybe
...
|
1 |
3/28/2007 3:16:34 AM |
|
|
22
33
...
|
1 |
3/28/2007 2:37:53 AM |
|
|
how to read RunSQL output
I am working on ACCESS and SQL server. I am using Access ADP to development
some forms to read/write table on SQL server. I want to use RunSQL to execute
a select query and copy the output to a variable. How can I do that?
Thanks everyone...
|
2 |
3/28/2007 2:16:58 AM |
|
|
How to use Outlook View Control 2007 in Access 2007??
Hello.
How i can to use the outlook View Control 2007 in access 2007.
I can to use this control in access 2003 with Outlook 2003
But i change mi SO to Windows Vista an Office 2007 and mi aplication pop one
Error
"No existe ningun Objeto para este control".
I nedd help
Sorry by mi English!!!!
...
|
1 |
3/28/2007 12:03:32 AM |
|
|
123
qqqqqqq
...
|
1 |
3/27/2007 4:29:23 PM |
|
|
List Servers in Combo Box
Hi,
Does anyone have samples of how to list SQLServers on network in an ADP
combo box?
Thanks.
Alan
...
|
2 |
3/27/2007 4:01:02 PM |
|
|
Parameter Search Form
I have a parameter query (function), set-up with an SQL backend and ADP
frontend, that searches a table and the function works fine, but when I try
to set-up the combo box to the form, it isn't working correctly. When I open
the form it runs the function with the access default boxes and then it goes
to the form, but the entries you put into the form does not run the function.
If I don't set ...
|
12 |
3/27/2007 2:44:30 AM |
|
|
³ö¹ú¾ÆµêסËÞÊ¡Ç®ÇÏÃÅÓë·½·¨
"Ó¼ÙÆÚ" Ϊͬҵº£Íâ¾Æµê¼´Ê±Ô¤¶©Ó뼴ʱȷÈÏ£º
¢Ù άҲÄÉ - 3ÐÇ 42 Å·ÔªÆð
¢Ú ºº ±¤ - 3ÐÇ 55 Å·ÔªÆð
¢Û ¶¼°ØÁÖ - 3ÐÇ 59 Å·ÔªÆð
¢Ü ²¼Â³ÈÕ - 3ÐÇ 66 Å·ÔªÆð
¢Ý ÈÕÄÚÍß - 3ÐÇ 73 Å·ÔªÆð
¢Þ ²¨Ê¿¶Ù - 3ÐÇ 73 ÃÀÔªÆð
¢ß ŦԼÊÐ - 3ÐÇ 99 ÃÀÔªÆð
¢à θ绪 - 3ÐÇ 85 ¼ÓÔªÆð
µç»°: 010-64892689, 010-64987025,
ÍøÖ·: www.cosmosholidays.net,
ÔÚÏß MSN : hotelwholesaler@hotmail.com, eurohotels@hotmail.com,
sh...
|
1 |
3/27/2007 12:24:22 AM |
|
|
º£Íâ¾ÆµêÕÛ¿ÛÔ¤¶© Ó¼ÙÆÚ www.cosmosholidays.net | µç»°£º 010-64892689£¬010-64987025
ÄãÖªµÀÈ«Çò6Íò¼Ò¾ÆµêÖ»ÓÐÒ»¸öµØÖ·Â𣿾ƵêÔ¤¶©×¨ÒµÅú·¢ÉÌÖ®Ò» È«ÇòÕۿ۾Ƶê
Ó¼ÙÆÚwww.cosmosholidays.netרҵÌṩȫÇò·¶Î§ÄÚ×î¼ÑµÄÐǼ¶¾ÆµêÔ¤¶©·þÎñ£¬ÊÇÒµ
ÄÚº£Íâ¾ÆµêÔ¤¶©µÄÅú·¢ÉÌÖ®Ò»¡£ÅÓ´óµÄ¾ÆµêÍøÂç°üÀ¨ÁËÔÚÊÀ½çËùÓÐÖ÷Òª³ÇÊÐÒÔ¼°Å·ÖÞµÄ
ÈÈÃŵØÇøµÄС¼Òͥʽ¾Æµê£¬Á¬Ëø¾Æµê£¬»ú³¡¾Æµê£¬¸ßËپƵ꣬ºÀ»ªµ½µÍ¼Û¾¼Ã¾ÆµêµÈ
µÈ¡£
·Ç³£¾ßÓÐÊг¡¾ºÕùÁ¦µÄ³¬µÍ¼Û¸ñ
ƾ½èÓ¼ÙÆÚÏò¾ÆµêÌṩÁËÅÓ´óÊýÁ¿µÄÔ¤¶©ÒÔ¼°ºÍËûÃÇÖ®¼ä½ô...
|
1 |
3/26/2007 9:14:55 AM |