Search results

I gone with a dcount to check the data, it work first time and it's simple of my brain to hold in storage... Thank a lot

Hi i have finally got back to this just now. been busy on other issues. Yes what am trying to do it use the fields named SirName ( sir name) and DOB to check the details entered on a form are not already in the staff table. I was assigning the result of the dlookup using...

thank for your comments, which are very useful, i be testing the ideas later.

Hi and thank you. I have not tried your method yet, but i could not for the life of me remember the nz function. so that alone is very helpful. i will keep you in formed

When i Add this Dlookup below to my code "DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & forms!NewStaff!txtdob& "#") " I get the errror message the field DOB in the table and the venerable are both date type values The full bit of code looks like this sn = DLookup("[Sirname]"...

Hi WELL TANK YOU FOR THE INPUT I GOT IT WORKING WITHIN 5MINS. Much appreciated. Thank you

sorry the are no time elemets in the values just the dates

hI your points note d about the ashtag when I run the dsum it given results that are way to high example the return value should be 188 but it returns 838, I check to see if I could find out it got that value. I check the total value of all the date in the invtotal field and that's 1035. I...

tamount = DSum("[Invtotal]", "tblsalesinvoice", "[InvDate] >= #" & [Text150] & "# And " & "[invDate] <= #" & [Text152] & "#") Hia all, I was wondering if any of you have come across an issue I am having with the code above. It is simply calculating the total value of the field “Invtotal”...

& [Text150] & "#")worked first time. thanks al lot saved me a lot of time

thanks for help will let know how ifi get on

HI am a bit stuck on a small problem I am using the dsum to get a total value from a field in a query. When I use the code 1 below it works fine 1) DSum("amount","QryPandLcaptialInvest","dateofinvestment >= #1-1-19# ") But I want the user in in put the date in a text box on the form. But I have...

What what can I say Good night's sleep and back to work. on running a few test runs the problem seems to have fixed it self. the only change I have done was last thing last night ( before the pub) was to tide up the data, I had a few records that were blank, which I delete. which in normal...

Thank for the information. yes the query has no real task other than to display the table on a form in a standard display ,making it easer for the user( who is a none it person) to view the table. my point was the is no reason I should be getting a prompt box, it's such a simple query. But...

HI sorry am still learn, I forgot to add the code.. it's very simple SELECT TblStock.StkName, TblStock.STkBrand, TblStock.Stkquantity, TblStock.stockID FROM TblStock;

The problem I have is this when i test a query in the datasheet preview they work no problem. But as soon as i put the query in to a form or a report. I get a prompt box asking me to enter a parameter value. If I click ok without entering any thing. It go to the report or from and work fine...

Thanks I will try it later and let you know how I got on

Good morning every one. I have been up since 4.30. watched some tv and had a coffe then set to working at 5. 10. it's now 7.30 and am ready to go back to bed for a hour to recharge my body and my peanut size brain. But I have brain block, or am just stupid. My simple problem is I have a form...

Well that was great. I fixed the problem, having read the comments about. I noticed the home form was still open in the background but not visible. closed the form and every thing back to normal. Thank you all.

Thank you all for the quick replies. I am currently, testing some of the solutions given and will let you know how I get on.