Search results

you can either have a calender control hidden on your form or make up a form with a calender control in it. then in the on doubleclick or click event either open the form or make the calender visible use the calenders on click event to set the date value you select eg...

Dim db As Database Dim rst As Recordset dim PRm as parameter dim Qdf as querydef Set db = CurrentDb() Set QDF = DBS.QueryDefs("qryFindDuplicate") For Each PRM In QDF.Parameters PRM.Value = Eval(PRM.Name) Next PRM Set RST = QDF.OpenRecordset(dbOpenDynaset) If rst.RecordCount >= 1 Then...

if your talking about opening a table in datasheet view then you could just assign a hyperlink address to the command button

if query criteria is from a open form select * from student where stud_name=" &"""" & forms![yourformname]![controlname] & """"

have you tried using iif Total: iif([SumofTotal$] >0,[SumofTotal$] ,0)+iif([qryYearlyTotalsOptions].[SumofAmount]>0,[qryYearlyTotalsOptions].[SumofAmount],0)iif([qryYearlyTotalsCounterTops].[SumofAmount]>0,[qryYearlyTotalsCounterTops].[SumofAmount],0)

use datediff function currentsales/(DateDiff("d", currentcollectiondate, previous date))

your welcome huge doors ,or possibly a lot more frustrating times ahead

sorry i left a variable name of mine in the code delete the word ADDRUN at the bot

i think you would have to use a query substitute tablename with your table name and field name with your field name Dim Dbs As DAO.Database Dim Qdf As DAO.QueryDef Dim rst As DAO.Recordset Set Dbs = CurrentDb() Set Qdf = Dbs.CreateQueryDef("", "SELECT tablename.fieldname,FROM tablename" _...

sorry file is a tad to big to attach.but it is a sample db from m/soft site

here is an excellent db with examples,from the m/soft site

yes its possible,m/soft have an excellent article on the knowledge base site.you need to read up on query by form QBF

did you try what i posted before? did it work? use the setvalue option in macros if you dont want to overwrite memo field 2 item =iif(not isnull(forms![yourformname]![memofield2] , forms![yourformname]![memofield2] & " " & forms![yourformname]![memofield2] ,forms![yourformname]![memofield2]...

use the setvalue option in macros select setvalue item =forms![yourformname]![memofield2] expression=forms![yourformname]![memofield1] select setvalue again item =forms![yourformname]![memofield1] expression=null

it may be better if you had 1 table of prostitutes and as field names have ProstituteId Firstname Lastname HairColour Nationality Likes DisLikes AreaofExpertise etc etc that way would make it easy to run a query based on hair colour,nationality or what ever

you could also in the after update event of the textbox insert the code Frame95_Click that way the code will run back through the option group click event without the need to reset the option

one way to attack your problem 1.why not have a combo box filled with department no's for the user to select their department 2.place a new command button on your form the command button wizard will guide you through the steps to open a form at a particular record,based on the value of your...

i should add that when you look at the query that is the rowsource for the combo box firstname the first column is number 0 the 2nd column is 1 the 3rd column is 2 etc etc

have a look at the after update event for the first name combo box you will see code there that says Me.LastName = Me.FirstName.Column(1) Me.Address = Me.FirstName.Column(3) Me.WorkPhone = Me.FirstName.Column(11) you need to add code there to to fill in each text box that you want to see...

how many columns have you set in the column count property of the combo box you may find it is set at 1, set it at how many columns is in the rowsource