Search results

I want to change the ACCESS ICON by code. for example: select case me.s_icon case 1 path= "c:/1.ico" 'put it in access... case 2 path="c:/2.ico" 'put it in access icon... is it possible? thanks!

hello, I try to insert images to a listview. and alltime same error: imagelist must be initialized before it can be used if I write: ListView0.ListItems.Add , , "abc" it good and the value insert but if I change to ListView0.ListItems.Add , , "abc", "img1" I got the error, <pic1> I tryed...

I got but not all I success insert listview, but from recordset. <file attach> I want the listview from a value list. for example I want to view the listvalue with the value: "father", "mother",... how can I got it :rolleyes:

thanks now I am looking for an example of "listview" and how I work with it. do someone have a link or a small example/ thank alot. s,

I have textbox and click. I want if I insert the value in the textbox and then click "ENTER" then the event done. I dont want afterupdate because then if I go to another object it will done and its not good for me. JUST when key "ENTER" down thanks...

>>> if your filed name is LastName. then in the query you write len(LastName) and order this Column hope u understand

another question Good night (from here) I have 2 tables 1. (BOOKS) ______________ IDBOOK (identity) Name …. 2. (ALL_BOOKS) _________________ IDallBOOK (identity) IDBOOK (number) [from the table BOOK] B_number (number) For example: The book "my sun" can be twice or more. My question is...

if I understand well, you can to insert to the table 5000 rows. For i = 1 To 4999 strsql = "insert into city(cityname) values ('123')" CurrentDb.Execute strsql Next then delete the rows strsql = "delete * from city" CurrentDb.Execute strsql after that the ID number start from 5000

ghudson thanks alot exeactly what I want. :)

I have a from with some buttons, and 1 text. for example: button1 button2 text = "GOOD LUCK" -when the mouse on the button1 the text change to "you are on 1". -when the mouse out of the button then the text change to the first value "GOOD LUCK" is it posible? thanks s.

and another example office XP put the 3 files in c:/ Good luck!

>>> my idea is to make a table "pathName" pathID (autonumber) [1,2,3...] path (text) [c:/letter.doc, e:/sticker.doc...] pathDES (text) [letter, sticker... in your form you do a combobox <recordset from the table>, than you can choose what to open. hope that u anderstand me ;)

>>> to open the word from access and apply the results merged >>> Set objApp = CreateObject("Word.Application") objApp.Visible = True strDoc = "c:/letters.doc" objApp.Documents.Open strDoc With objApp.ActiveDocument.MailMerge .Destination = strPrint...

3 points some question: 1. do you have a query with the name "qryYourQuery" 2. do you have in the query filed "ID" 3. the query "qryYourQuery" take the details from the form? the basic code seems good :) good luck

with OLDVALUE confirm = MsgBox("are you sure you want to update?", vbYesNo, "UPDATE") If confirm = 7 Then Me![name] = Me![name].OldValue End If DoCmd.OpenForm "formName" End Sub

Try it FullName = "abc def gh" x = Strings.Split(FullName, Chr$(32)) For i = 0 To UBound(x) MsgBox x(i) Next

... for example: firstname - text age - number the SQL is: select * from MyTable where firstname='Mechele' and age=32 if the filed are text than u need to put ' between and after goodluck!

Try it Dim objNewMail Dim strTo As String Dim strDisplayName As String Dim strSubject As String Dim strBody As String Dim strToField As String Dim strMessage As String ' use the Me.[FieldName] to get the value from any field. strToField = "your@email.com" strSubject = "subject please"...

maby its can help u good luck!

thanks :) There is a very good man that gives me an example <zip file attach> write into text_a something…