Can I edit the list of the blogs I've read?
MS Access database development
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What is interesting here?
• Duels
  • Опросы
• Аватарки
• Интересы
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Register!

QAIX > MS Access database developmentGo to page: 1 | 2 | next »

  Advertising:
  Top users: 
  Рейтинг сообществ: 
  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Модератор:
воскресенье, 2 мая 2010 г.
Topic awaiting moderation nikejordanaaa 14:24:14
вторник, 13 апреля 2010 г.
Topic awaiting moderation nikejordanaaa 12:13:26
воскресенье, 21 марта 2010 г.
cheap wholesale nike jordan fusion shoes Jordan 2010 shoes nikejordanaaa 14:17:03
 Our company's name is NikeJordanaaa. Our Co.was set up in 2000 as one foreign trade corporation,which is united by lots of footwear manufacturers in Fujian of China
We deal with brand shoes like Nike, Adidas, Timberland boots, etc. We have especially Nikes like Shox NZ, R4, TL, TL2, TL3, Turbo, Monster, OZ; Air Max 95, 97, 2003, 2004, 2005, TN; Air Force 1, Dunk, Air Jordan I-XX. We prefer to wholesale of cartons, but we can also supply mixed colours and sizes as you like. Drop shipping can be done also. Normally we need 24 working hours to process your order after receipt of payment. You can expect to receive the shoes in around 5--7 days. Buyers please feel free to contact us. Please conect us:
email : nike_jordan_aaa@yah­oo.com.cn
MSN is :nike_jordan_aaa@ho­tmail.com and nikejordanaaa@hotma­il.com
and browse our website : www.nikejordanaaa.c­om We are waiting for you.
Add comment
понедельник, 8 февраля 2010 г.
Why does the code work with a reference of CurrentDb, but... Guest 18:24:19
 Why does the code work with a reference of CurrentDb, but not CurrentDb directly?
comment 1 answer | Add comment
среда, 23 декабря 2009 г.
the corruption of affected databases can be easily... Guest 16:12:31
 the corruption of affected databases can be easily prevented by the corrupted file mdf mssql 2003 program: http://www.recovery­toolbox.com/any_way_­to_extract_the_table­s_from_mdf_file_of_s­ql_server_2005.html It is often used by our database administrators to prevent issues
comment 2 answer | Add comment
вторник, 12 мая 2009 г.
how do i do this problems:-? :^) i just dont know what u r... Guest 04:12:30
 how do i do this problems:-?­ :^)­ i just dont know what u r talking about....sorry=,B­
comment 1 answer | Add comment
понедельник, 10 ноября 2008 г.
I have a problem in a setfocus comm... Guest 15:26:29
 I have a problem in a setfocus command. Can any1 help? Any advice is much appreciated

Private Sub btnFind_Click()
Dim strSQL, strSelect, strFrom, strTitle, strDescription, strSubmitter, strOwner As String

Set db = CurrentDb

strSelect = ("SELECT tblCore.[c_ID], tblCore.c_Title, tblCore.c_Descripti­on, tblCore.c_Submitter­, tblCore.c_CloseDate­, tblCore.c_LastUpdat­e, tblCore.c_Owner ")
strFrom = ("FROM tblCore ")

strTitle = ("WHERE (((tblCore.c_Title)­Like " & Chr(34) & "*" & Chr(34) & "&" & Chr(34) & [Forms]![frmCoreMain]![txtSearch] & Chr(34) & "&" & Chr(34) & "*" & Chr(34) & "));")

********** Continued

Select Case Me.optSearchCriteri­a.Value
Case 1
strSQL = strSelect & strFrom & strTitle
Case 2
strSQL = strSelect & strFrom & strDescription
Case 3
strSQL = strSelect & strFrom & strSubmitter
Case 4
strSQL = strSelect & strFrom & strOwner
End Select

Me!txtSearchDump.Se­tFocus 'Problem occurs here Run Time Error: cannot move focus to the control txtSearchDump'
Me!txtSearchDump.Te­xt = strSQL
CurrentDb.QueryDefs­("qryCoreSearch").SQ­L = strSQL
Me.lstCoreSearch.Re­query
End Sub
comment 1 answer | Add comment
понедельник, 22 сентября 2008 г.
Check new report is already exists in CurrentDb. Guest 01:36:09
 I am currently using MSAccess 97.
I created a new report from coding. I want to know this report's name is already exists or not in CurrentDatabase.
Add comment
пятница, 11 июля 2008 г.
I can confirm the Form_Current event "running twice"... Guest 02:35:16
 I can confirm the Form_Current event "running twice" behaviour as described by Bri. It's very frustrating as the RecordCount of the form's recordset can be greater than 0, and the CurrentRecord can also be valid, but any attempt to access a field in the form's recordset produces a "No Current Record" error.
Add comment
среда, 18 июня 2008 г.
I think have exactly the same problem but I'm not able to... Guest 08:27:54
 I think have exactly the same problem but I'm not able to fix it by just editing a filed in the form.

I have 2 List fields both getting data from the same table while one of the listfields only show the entries where a special data is set to True in the table. Setting thet property to True is done by a button in the form. The hole thing should work like a shopping chart.

Wether I edit that boolean by DAO or with a query doesn't matter, I always get that "The Data has been changed" error.

Thanks for your Time

Benjamin
comment 1 answer | Add comment
вторник, 20 мая 2008 г.
Hi, Maybe you need to check your database and perhaps the... Guest 05:42:07
 Hi,

Maybe you need to check your database and perhaps the mdb file is damaged or something. If necessary, you may try Advanced Access Repair at http://www.datanume­n.com/aar/ This tool is rather useful in salvaging damaged Access MDB files.

Alan
comment 1 answer | Add comment
среда, 12 декабря 2007 г.
Hi John,While searching for something completetly diiferent... Guest 17:11:16
 Hi John,

While searching for something completetly diiferent I came across what might be the solution to your problem if it sill exists. It was on Access Monster, on the left hand part of the panel click on General2 and then going to the bottom of the page choose July 2003. Set choices to Titles Only and click through to page 5. Click on the fifth item.

Jon.
Add comment
понедельник, 19 ноября 2007 г.
hi all,i have problem to create sum if in VBA code like sum... Guest 04:28:45
 hi all,
i have problem to create sum if in VBA code like sum if in excel.

I have two table
table 1 have item1 and qty1
table 2 have item2,qty2 and result
how to create code VBA when statement is
In table 1, for multiple item, i want to sum qty1.(sum if)
In table 2, if item1=item2, then sum(qty1) - qty2 then value sum(qty1)-qty2 insert to column result.
This code active or process when i click one button.


pls help me.....
Add comment
вторник, 7 августа 2007 г.
:-) =,B Good ansAditya Guest 20:33:55
 :-)­ =,B­ Good ans

Aditya
comment 1 answer | Add comment
суббота, 23 июня 2007 г.
I want to have the ID selected from... Guest 07:38:40
 I want to have the ID selected from the listview of one form to the textbox of another form
where txtcontactid is the textbox &strcontactid is taking the selected value but on running this error is coming "No value given for one or more parameters"
what I am doin is On the form load of form2 I have written this querry

Dim strContactId As String
strContactId = Search.ListView1.Se­lectedItem.SubItems(­1)


rs.Open "select * from contactinformation where txtContactid=" & strContactId, connection, adOpenDynamic, adLockOptimistic
Add comment
суббота, 16 июня 2007 г.
I need code to open TeacherDetailFrm. Guest 19:05:55
 Hi
I need code to open TeacherDetailFrm.

I have TeacherStudentSubFr­m on the Mainform, FirstNameTxt on the TeacherStudentSubFr­m, and TeacherDetailFrm.
I need code to open the TeacherDetailFrm By double click on the FirstNameTxt.

I use this code but no data come:

Private Sub FirstNameTxt_DblCli­ck(Cancel As Integer)
Dim DocSubForm As String
Dim DocText As String
DocSubForm = "TeacherDetailFrm"
'DocText = "[Result]=" & "'" & Me![result] & "'"
DoCmd.OpenForm DocSubForm, , , "[ FirstNameFld ]=forms![TeacherStudentSubFrm]![ FirstNameTxt]"

End Sub
comment 1 answer | Add comment
понедельник, 21 мая 2007 г.
I have the same problem, so if u have a solution, send me a... Guest 08:09:19
 I have the same problem, so if u have a solution, send me a email to neosun@gmx.de please.
Thank u very much!
Add comment
пятница, 4 мая 2007 г.
:-D Guest 07:28:32
 :-D­
Add comment
четверг, 31 августа 2006 г.
:-( I'm afraid that doen't work!! Guest 20:26:41
 :-(­ I'm afraid that doen't work!!
Add comment
четверг, 24 августа 2006 г.
]:-) 8-| ;-) :-( X-( ]:-) :'( :'( :-[ ;~) Guest 19:16:42
 ]:-)­ 8-|­ ;-)­ :-(­ X-(­ ]:-)­ :'(­ :'(­ :-[­ ;~)­
Add comment
пятница, 16 июня 2006 г.
ODBC AS400 Linked Table - refresh Link - Guest 17:39:57
 I am trying to refresh the connection on a linked table from Access to an AS400 based ODBC table. I need to put the password in the string. I keep getting the AS400 asking me for the password. What sort of code should I be using, where does the password go? I want to be able to use the linked table in a SQL query without having to input a password. Can I put the password in the SQL?
Add comment
среда, 14 июня 2006 г.
Email alerts when something is expiring Ashley 17:30:55
 I have been asked to make a database in access, but the big thing is that they want an alert system. So is there a way in access to send out alerts? ie. One of the permits issued expires in December, and we would like and alert a month before. Maybe an email alert?
comment 1 answer | Add comment

Add new topic:

How:  Register )
 
Login:   Password:   
Comments by: Premoderation:
Topic:
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или законы РФ. Ваш ip-адрес записывается.


QAIX > MS Access database developmentGo to page: 1 | 2 | next »

see also:
pass tests:
see also:

  Copyright © 2001—2010 QAIX
Идея: Монашёв Михаил.
Авторами текстов, изображений и видео, размещённых на этой странице, являются пользователи сайта.
See Help and FAQ in the community support.qaix.com.
Write in the community about the bugs you have noticedbugs.qaix.com.
Write your offers and comments in the communities suggest.qaix.com.
Information for parents.
Пишите нам на .
If you would like to report an abuse of our service, such as a spam message, please .
Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .