Search results

I created a sample table for me to try it in 1 criteria and it always gives me "Nothing Found" Private Sub Command2_Click() Me.Text0 = Nz(DLookup("stfee", "course", "sname" = "'& forms!form1!text3 & '"), "Nothing Found") End Sub i had 10 records of students, my fields are sno, sname, scourse...

are my syntax correct? im confuse about the "fieldname" where should i get it from table that im using? Im doing trial and error with this dlookup coz im really newbi with access. I tried to use my query instead of dealing with so many criteria but the problem is I always getting Runtime Error...

I have 4 criteria to be pass thru my dlookup(), and it seems I coded it wrong, my level in access is not that high so I'm asking your help with this. criteria1 = combo1 (string data type) criteria2 = text38 (value) criteria3 = <> "12:00:00 AM" (date) criteria4 = between [start] AND [end]...

Hi, this is the code i am working: Text476 = DLookup("TDirect", "Smdr Qry_Total_Direct") Text474 = DLookup("ttcec", "Smdr Qry_Total_CCEC_PC") Text479 = DLookup("TQueue", "Smdr Qry_Total_Queue") Text481 = DLookup("NCCEC", "Smdr Qry_Total_CCEC") Text483 = DLookup("SumOftime", "Query of Total Talk...

A strange Runtime Error appears after a click my command button containing my Dlookup functions. Any idea what does it mean? ******************************** * Runtime Error: '2001' * * You canceled the previous...

I have a combo box and 2 text boxes in my main form to enter my criteria for my query, every time I run the main form (frmLog), instead of showing it, a small screen will appear to "Enter Parameter Value", how can I use my main form to enter my criteria? Please i need you help. Thank you.

Is there a way not to show the screen asking for the criteria since i have a main form that i should enter all the criteria? This screen "Enter Parameter Value" shows before my main form (frmLog).

Got a confusing screen, i suppose to run my main form to enter criteria for my query when a strange small screen saying "Enter Parameter Value" appears. Please is there something wrong with my query? SELECT Count(*) AS TDirect FROM TabLogs WHERE...

Ok here's the result: I put a textbox on my form and inside the CONTROLSOURCE in "Expression Builder" I typed =DLookUp("TotalCCEC","Smdr Qry_Total_CCEC (PC)") In order to get the count of TotalCCEC my criteria is this: SQL: SELECT Count(*) AS TotalCCEC FROM TabLogs WHERE...

All of my queries in my main form need criteria before i get the value of my query, shall I put the the Dlookup in my ControlSource inside "Expression Builder or do i need to create a button that will call the dlookup function after entering the criteria?

i want to run my query using command button and after i ran it, i want to put the value of my query in one of the text box on my main form. I want to get rid the command buttons on my main form (such as "All calls", "talk CCEC", "TotalCCEC" etc.) If possible to put SQL as String in VB editor and...

hi, i attached a copy of my db: callLog and my main form: FrmLog I also put some notes on my main form how to get started. Thanks.

hi, to give you an idea and maybe you could give me more information. I had several queries in which the criteria is not constant, I mean the user need to enter the criteria on the main form. I used subform/subreport to get the value of my query but i need to open the query first and data grid...

Hi Dkinley, I have similar problem, but mine is 3 x 3 records, 3 cols and 3 rows. Like what you said me.txtcontrolName = me.lstListBoxname.column(x) which it works fine, how about if i want to transfer the row 2 and row 3 records, what should i do? Please need your help. Thank you. JE

hi pbaldy, What should I need to do to show the value of my query into my main form? I created a query with =count(*) and the criteria needs to be enter in my main form. How can I get the value of my query and show it into my form? After I enter all the criteria in my main form, and using...

Im confusing on how to get my query to be done and show the value on my subreport using command button. I need help about the procedure and the correct syntax on how to put my query inside the command button, when you click the button on your main form, it will run the query and result will come...

So, usually what did you do to get those value of query in order to store it in your table as new record, if you have 3 fields {top1, top2, top3) in table. I just need those values for report. thanks Je

I created a query on how to get the TOP 3 most called numbers with count functions. I had my subform on my main form showing the results of that query. How do I save those 3 called number into table. Some fields associated with this TOP 3 values are already saved in my table tab_summary. How...

Thank you for the information. I appreciated.

How can we add Date Picker in my main form. I tried to search on the net but they gave me lots of sites to download. Please help how can I add date picker on my form. Thanks Regards, Jerry