Dear Doug,
I tried whatyou said b4 as well.But anything I change from dblquote to single quote will be highlighted red (ERROR). This form is base on query already.SQL just don't work!!!What is wrong in the code above? How do I modify so that it will be workable?
Please help anybody...
Dear Ken,
I have also tried that way u said....by using the bracket. I did tried using [Task folders] but still it doesnt work as well. What is the problem? when I use bracket in the Task folders, there is another error message saying lack of 3 more bracket , when add all the...
Dear Ken,
My table name is Task Folders. But when using it in VBA I need to put as Task_Folders to hold it together if I don't put _ then it will read as table Task instead of Task Folders. But somehow neither of it work. THe same error message came up...saying can't find the table or...
Dear Ken,
I tried Me! but then the whole 4lines of statement turn red,that is why I change to the long-winded one.Another error pops up saying Microsoft Jet couldnt find input table or query'Task Folders.make sure it exist and check spelling.SQL just dont works well in this db...
Dear Willir,
Thanks for your time but Me have no idea what are you talking about.Me not good in programming. Can you modify from the code that I send? DOes it make any sense to you?I checkout OpenArgs,isn't it more like a specific lookup? There is error on that FROM clause .The table...
Dear PPL,
What is wrong with this SQL statement? THere is error say expected end of statement.This whole SQL is red in color.When run , error says compile error!!
SQLStmt = "SELECT Task_ID, Due_Date, Surveyor, Time_Start " _
& "FROM Task_Folders " _
& "WHERE...
Dear Willir,
Another thing is, SQL doesnt seems to work well on this damn database.I tried this but there is compile error message appear.What's wrong with this?
Private Sub Ctl0800_DblClick(Cancel As Integer)
On Error GoTo Err_Ctl0800_DblClick
Dim CurDB As Database
Dim Rs As...
Dear Ken,
WHat you define are partial right. Ihave 2 forms ( frmTask & DiaryPlannerfrm)which have bounded table( Task Folders & DiaryPlannertbl)
Primary key for Task Folders is TaskID
Part ONE
In form DiaryPlannerfrm I have textboxes for time which have properties name as...
Dear Roltrap,
The problem is the criteria doesnt work at all. When dblclick it open Form B directly without fulfilling the criteria. I used link criteria,but only 1 criteria can be use at a time and not all 3 can be use. Wat codes should I be putting in , in order to get it go...
Dear PPL,
I am really desperate to get this database working. I have Form A which have many textboxes each for specific time E.G : [time1]7.00,[time2] 7.30,[time3]8.00. Form A also have an activeX calendar and also txtbox1 for name.
Form B will have many textboxes for many field but only...
Dear Dalenz,
Thanks for the reply but that is not quite what I wanted.In Form 1,will have many textboxes,each with different time.It actually function like a daily planner.E.g TextBox1 is for 7.00am & TextBox2 is for 7.30pm.
Form1 will also have Employee Name and calendar in subform...
Dear PPL,
I would like to know how to write coding for FilterCriteria function. Can you give me an example on that? I would like to do a filter criteria in a form. When button is click, it will open another form displaying specific record. I have 3 criteria to fulfill before it can...
Dear Paul,
Thanks for the reply but bookmark is not the thing Iam looking for!Bookmark is just putting in words into document.Where as I wanted VB coding to get the selected contact from the form.That is the main part.Getting it from the form and putting it in to a document which is a...
Dear Dawson,
I tried to build a query like you said. But this query doesn't seems rite. THere's error on this query. These are the SQL.
SELECT Project.[Proj No], Project.[Comp Name], Contacts.[Cont Name], [Company Test].[Comp Fax]
FROM Project, [Company Test]...
Dear PaulBent,
I couldn't seems to find any bookmarks that you mention for this case. I click on the help index just some example but there isn't a function like that.Please let me know where I can find it.
Thanx,
Liwan
Dear DawsonUK,
I understand partial of your suggestion but my form is already base on a query that select the few fields I wanted and I also have a button that open the Word Document(which is a ready template in J:\ drive)The word document is all ready template to be open as word.doc...
Dear Ppl,
I am not good in programming. I have a database full of company's contacts. In my database,I have a from that shows particular contact person when the project no is entered. The form show the list of contact, at the same time able to be selected and place in another lisBOx...
Hey guys!!
It works perfectly the way I wanted it thankS you so much. Thank to you David & Rollie!! I have another thread which is unanswered at all. Any idea on that! How do I putmy selected contacts from the form to a word document?
Regards,
liwan
Dear dzepeda,
I tried using the code butthe compile error : Method or data not found in Form B. Whereas Form A say variable not defined.I am wondering what do I defined it AS () I tried textbox and fields but it say for intrinsic use only.Btw, I am using Access97.Please advise, thanks...
Dear Rolliee,
SO glad somebody answered!! Is a different form. E.g: Form A have 10 fields,and 4 of them are the same with Form B's fields. When I finish entering data in FormA , I'll click on a command button in FormA to open Form B.I would like the 4 fields to be filled when it is open...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.