Search results

1 or 2 db still doesn't get me correct result. Data is usually pulled 3 to 5 days after the current month is over. so to pull the data for the month of January we need to do it on February 1st or beyond. For the month of February we need to pull it on March 1st or beyond. Original Working...

Hello CJ_London & Sxschech, I have modified my query a bit which seems to be working at 95% right now. Let me explain: My query is given me 2.25hrs which is not what I see in excel. Excel sheet gives me 2.3hrs. How can I round that to 2.3 which is what excel sheet gives when you apply this...

Hello Sxschech, Thanks for the link. I am guessing this code needs to be copy pasted into a module which shouldnt be hard. how to do I call this module and also what fields I need to change on this code to match with my database? sorry I am at a beginner level when it comes to access. Thanks,

Hello CJ_London, I have made change by adding a coding to the current form but it is just rounding the main form and I still don't know how to export that in my query. Do you have any example I can use? can you please take a look at my example and guide me. I would really appreciate it!!! My...

Hello All, I have been using excel for sometime now and it does what I wanted to do but frankly I am tired of creating new tabs and editing fields every month as new tab gets created monthly and new sheet gets created yearly. so I have decided to move to access. In my humble opinion access...

Hello All, I have built a database for storing partnumber and serial numbers of various products. tbl1x main table tbl1xdetail subtable use for serial numbers tblparts for storing partnumbers On my main form I have fields like date, order number etc. On my subform I have partnumber as a...

Just how exactly do we register these dll files?? Also do they go into system32 or system folder? thanks

thanks I really appriciate it Sir Ghudson, Thanks

Hello Experts, i have this small problem with my qry results not being displayed in the text box. tbl Issues= status field and many other fields tbl Status= Active or Closed here is my qry SELECT Count(Issues.Status) AS CountOfStatus FROM Issues GROUP BY Issues.Status HAVING...

Thanks for the attachment, here is the porblem with this one, After i enter name and then ordernumber then if i try to go to next record it stops me which is fine but then if i want to enter anything on subform i simply cant. Or if i enter subform first then when i enter name and order in the...

here you go in 2000 format now thanks

its 2003 are you sure you have access installed properly??

works fine here i have just extracted it.

you need winzip to extract it. If thats what you meant?

Anyone at all??

Hi all, I have a database which is being used for storing name, order #, part number and serial to that part number. Name and Order Number is setup on the main form, part number and Serial Number is setup on the sub form. I have many users that use this database and I have recently noticed a...

Anyone out there wants to take a shot at it?? THanks

try this I am attaching a sample database try and see if that helps you. more questions just ask.

I have two reports i run every so often in those reports i have a criteria set which asks me to type yearly, lifetime or three year and then after report prints out it also has total member quantity query on top of the page which counts whatever membertype i am typing it in, however right now...

Thanks alot RV before i try that method i found this string that actually did what i wanted to do about 85% of it. >#1/1/2000# and <#12/31/2005# in the criteria window problem with that is i have to change the year after every year when membership expires. Also i am still trying to figure out...