technocraze
Last Activity: Oct 6 '07, 04:27 PM
Joined: Jan 12 '07
Location:
-
Tks for your prompt reply once again.
Yes, u are right!
May I know whether it is possible to achieve just using vb and not API. Well, opening a single file should be fine. In addition, may I know whether there is such Function or property called "DirList"....Leave a comment:
-
Hi,
What I want to achieve are:
Upon the button click event, the "Browse file" window will be loaded. When I clicked on the "Open" button, the chosen file should be appearing on the "FileName" Listbox, and the file should open. Eventually, the filename should display on the textbox. In addition, the prog should also open any files in the network drive.
What has been...Leave a comment:
-
tks for the prompt reply. However, the selected file cannot be opened when the prog is executed. It just display the name of the selected file in the textbox. What I need further is to open the selected file from the DirList. May I know how can that be achieved?
Logic of the prog:-
The prog should run in such a way, whereby the name of the selected file is displayed in the textbox as well as open upon execution. Tks...Leave a comment:
-
Using FileDialog property to open and display FileName in a textbox
Hi pals,
I would like to know how to display the FileName of the selected file in the textbox and open it using FileDialog property. I have imported the necessary reference from the library - Microsoft Office Object Library 10.0. Tks
Control:
TextBox - Display FileName
Button - Open
Code:
VBA:
[CODE=vb]Private Sub Command_Onclick ()
Dim fd As... -
DoCmd.OpenForm and DpCmd.OpenQuery issues
Hi community experts,
May I know is it possible to display an error message or not opening a form or query when users provide with the wrong inputs in the DoCmd.OpenForm and DoCmd.OpenQuery properties. If that is possible what must be done to achieve? -
display combo box value at Form load event isue
Hi community experts,
May I knw hw can the values of the combo box be displayed at combo box afterupdate event. I want to achieve in such a way whereby at the form load the value displayed at the combo box will be displayed at the textboxs as well.
Let say S1 happens to be displayed in form load, which mean that values (StudentId, name) corresponding to S1 will be displayed as well.
...Code:Combo box - StudentId (unbounded)
-
tks for the reply. issue has been solved...Leave a comment:
-
DSum function issue with conditions / criteria expressions
Hi community experts,
I am having an isue with Dsum function that is used to count the total number for a particular field (intake) at the textbox afterupdate event with condition/ criteria (subject). Below is the scenario in details.
What I need to do is summing the intake corresponding to what is selected from the dropdown combo box. For instance if the user choose maths in the combo box, the total no of intake should... -
combo box displaying corresponding value into textboxes issues
Hi community experts,
I am encountering a problem to display the corresponding values of the combo box into the textboxes. I have chose option 1 & 3 for this implementation but neither is working. My combo box only contains distinct values, once i select the values frm that combo box, the corresponding matching the values from the combo box from the table will be displayed in the textboxes. It wont make much sense if I bound the... -
Hi AdeZii & community experts,
I would like to knw whether is it possible to reset (empty) the fields at the form load event without affecting the values of the fields? Because StudentId is my primary key, if i rest the field at form load event, the table values got erase automatically. I want to achieve in such a way, whereby, the resetting of fields at form load wont cause any impact of the data in the table.
...Leave a comment:
-
tks MAN! that works greatLeave a comment:
-
display corresponding value textbox value issue
Hi community experts,
May I knw whether is it possible to display the corresponding value of the second textbox based on the user input in the first textbox? This means that once the user enters the value of first textbox - S1, the corresponding matching value based on first textbox will be displayed in the second textbox automatically.
I have tried using the AfterUpdate() event of textbox1 control to trigger this scenario... -
Cool MAN NeoPa! this is what i want to achieve. Once again tks for the concerted effort made.Leave a comment:
-
Environment
MS Acess and visual basic
Yes, NeoPa and Killer42 were right! What i need is what they have responded in the post. This mean that the entry will only take in negative sign and that sign cannot be erased, edited or replaced. Any ideas as to hw that can be achieved either through coding, expression builder or even macros?
I have been thinking hard for all possible combinations and solutions but it seems...Leave a comment:
-
Yes i do, but i have added some comments as an indication such as error...Leave a comment:
-
Correction
Private Sub Combo1_AfterUpd ate()
' Find the record that matches the control.
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClo ne
rs.FindFirst "[Serialcode = '" & Str(Nz(Me![Combo1],0)) - Error
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Error: type mismatch
I have tried with the single quotes but the error...Leave a comment:
-
How to create a static negation sign (-) in a textbox
Hi community experts,
Environment
MS Acess, visual basic
May i knw whether is there a way to create a static negation sign (-) in a textbox? Is there a possiblity that this can be done using expression builder or code wise. If so hw can it be achieved? It mean that whenever the form is being loaded, the negation sign will be there and it mux be static. tks
No activity results to display
Leave a comment: