Search results

No I am not clickin' the button rapidly. I am taking enough time between two consecutive clicks

My advice was in conjunction with yours...as ain't got a clue which form is Shealee in and which form is (s)he referencing from... I seek most of the help from this forum How ever even I wasn't convinced but it somehow worked for me... Look Here and here

However it is advisable to solve the criteria part before using the Dlookup function...In your case try to store the value of into a seperate variable and then pass it to the DLookup as a parameter... Hope sounds a bell...Order of Evaluation...

Play around with the below code... Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("tblName", dbOpenSnapshot) rst.FindFirst ("[StudentID] = " & StudentID.Value) If found then use the below code to populate the fields Ex: LastName.value=rst.lastname and so on NB: However if the...

Is your appointment_type a list item or stored in a seperate table..? However If you could upload your DB, we can look into it...Only to solve ASAP..However if it is in a seperate check what column is it bounded to...alternatively Dlookup function might be of some help....Good Luck

Error #91 - Help - Solved Hello All, I have a wierd problem. I am using a tempVar in my database...Basically I am calling a Navigation form (Which In-turn has 5 different forms with vertical tabs). Somehow an error #91 appears abruptly. I mean the error appears sometime and sometimes it...

Wonder why not. Some people argue and recommend to use square brackets around [] but there is no evidence if thats not gonna fail in a long run. However the Naming Convention may help you to decide whats best.

Even better if you can use the below formula in control source. you can use as many conditions as possible. DSum(ColumnPaid, TableName, Criteria<<paiddate=todaysdate>>)

I am bit confused with the above info. Are you sure you've named the Columns as 100 & 220 or you referring to the values...? However please look at this example n see if this is what you meant.

Try the below code... MsgBox DSum(Textboxname.Value, "TableName") MsgBox DMax(Textboxname.Value, "TableName") MsgBox DMin(Textboxname.Value, "TableName") MsgBox DAvg(Textboxname.Value, "TableName") MsgBox DStDev(Textboxname.Value, "TableName") Good Luck

try the below code and play around. DoCmd.OpenForm "frmAssessment", , , "ClientID =" & Me.ClientID, acFormAdd Good Luck

Can you elaborate your question? Where would the user enters the diameter are there any forms involved? If yes is that form a Single form or Datasheet form? If you could upload the db, we can look into it.

Yo! I've managed to get this work. However may be not the most efficient way but still works fine for me....Just felt to share it just in case... Dim X as Integer Code in the form_load of the main form { X=1 Forms!MainForm.SubForm.Form.RecordSource="Select * from tblCustomer" } Code in...

Hello All, Could anyone please help with the following. I've got a datasheet view form and got a couple of Subforms in a separate Tab Control (Ofcourse on different tab pages). All these three forms (The Datasheet view form and the two subforms) have a Customer ID in common. I want to...

I hope you are not trying to go past the 10 Post barrier (Cap).......RFLOL Look Here

I am Developing a database which uses an Online form developed in Java to get the quote. However the Info on this thread has answered so many questions. Thank you ever so much once again.

Hello All, Just wondering Is there a way to make my search Text box to behave like any other search box on different browsers... For Example How to create Text Box input field watermark effect in MS Access with a default text displayed and when the user enters into the textbox, the...

Hi, I've got a webbrowser on my form which displays an online form with a submit button. Is there a way to capture the details of the fields values as soon as the user clicks the submit button. Any help would be appreciated. Many Thanks

Hello All I have got a database with a form to enter addresses. All I want to do is be able to type in the postcode on the form and click the button called LookUP which should lookup for the relevant address depending upon the house number provided and populate automatically into the...

Hello All, Does On_Change event triggers only when the data is changed physically or does it triggers even when it populates from some where else (Like calculated field) ? Basically, I got a text box "A" which gets the value depending on the value of another text box "B" or "C". I want to...