Search results

Hi, 1) Let me see If I got it right, a) Create new form just for this sales thingy. (With relevent controls like text button etc) b) New Queries to generate sales. (Lets start with total daily sales, ignoring by model) 2) In my << form_sales.recordsource = docmd.runquery...

Hi, 1) I am pretty newbie to this access programming, do forgive me if my questions sounds stupid. 2) Basically I create an application in access capturing or production information for my company. now the top management suddenly wanted whats their main concern:- Total Daily/Monthly...

It Works Thanks, man. It works. Regards & God Bless

Linking Query with Calender Input Erm.. Now is the tricky part. I am thinking of running a query to display a daily, monthly, yearly to a form. but again how to link thatquery with a calender return value ?

Hi, 1) Is there anyway whereby I generate on total sales from user input from Calender control? 2) Eg: I insert a Calender control to my form, Once User Click on particular date I generate Sales for that particular Date? Thanks (In advance for advice sharing & God Bless)

Hi , 1) Currently I set my db project startup to loginform, only able to edit using exclusive rights by prssing <shift> + double click/<enter> on icon. 2) Is there other way whereby I can load project as per normal startup screen still goes into edit (tables, forms) ?

1)I settle it already, Basically I just did output to user accordingly if their budget is within range continue to next function Else their budget lower/higher Reenter their input 2) Tried it with set rd as new ADO.recordset 3)Do a loop through, within by do loop, if found bicycle model>...

Erm, sorry not really knows how to go about using dmax() & dmin() though

Recordset ? 1) Yes Thats right, You summarise it for me what application should does. 2) Erm For Combo Box to check Model Through accomplished it. 3) Left the price portion though. 4) Is there anyway whereby I can use recordset function to retrieve the value of high new low new, high old and...

Hi, (Its going to get slighly lenghty below, My Apologies) 1) I have a form whereby I need to compare value input by user with values from 4 fileds in my table. 2) User supply 3 input : (a)Model of Bicycle, (b)Budget for New bicycle, (c)Budget for Used bicycle 3) System Perform following...

Right Will go and try Thanks, will go n check it out. Thanks & God Bless

Hi, 1) My application calls up differents form. 2) In every form I wrote coding creating .ADO & .Recordset instances to compare user input data with previous record in my table for some error checks. (Eg: Login Screen Test for existing UserId, Account Name Test for correct account no) 3) I...

Extract String Hi CyberLynx 1) I have Input from scanner 40 characters. 2) I have 2 text box 3) How do I put first 10 characters input into textbox1, while16th - 23th character input into textbox2 ? Cheers & God Bless

Sorry, Yes ! Sorry_Click() Dim CyberLynx.. I manage to solve it at last ! !! :D as Friend Sorry not for the fact of your part but I felt I ought to get a slap onmy face. Indeed, it is stupid mistake, for my table does not save the right file extension. Right one should be .wmv ! NOT WMA ...

HOW (SET Windows Media Player.Play)? In Access 2000, - How to set my Windows Media Player Control to play my video (01.wma) file? - I have table consist of all link to my video files. - So I set windowmediaplyaer1. url = [forms]![movietable]![Link] - So my questions is : How to activate...

How to Auto-Run Window Media Player in VBA ? 1) Well.. apparently you are right. I am playing a video file. sorry for the misunderstanding. :p 2) Guess I almost give up that function if not I saw your reply. 3) As I check my VBA> Tools> References It doesnt have Microsoft 10 Object Library ...

Setting Required Do I need to do any setting adjustments on my access 2000 or VB editor or other location like system, windows... etc etc.. to enable window media player control ?

I saw your windowmediaplayer1 control. but they isnt any code tied to it nor playing any animation. does it have any significance?

Error Again *Sign* Hi CyberLynx: 1) Had heed your advice, but still not working:( 2) I copy my file (.wma) to desktop & try to paste it to your code. 3) What your program does was pop out a message and state the file name., I cant view the video clips at all.. :( *sign* Code as follows ...

Error Playing file extension thanks for replying.. however, I try below code: Dim wmdpAs WindowsMediaPlayer Set wmdp= CreateObject("WMPlayer.ocx.7") wmdp.url = "file.wma" wmdp.play Error Display >> Windows Media Player cannot find the specified file. Be sure the path is typed correctly. If it...