Search results

It appears another member has your app opened so expect a response soon.

Sorry Debs, don't know what's happening but I still can't open it. On of the issues may be that some of the features you have used in your app arre not backwardly compatable with 2007. Hopefully someone with 2010 can interject and help out. I have an idea what the issue is but I don't want to...

Still can't open it. You need to create a blank 2007 accdb and import all the objects into it.

My 2007 version does not recognise it. You also need to compact it first before posting.

Thanks Chris. Now this is where it gets tricky. A product has a Yield an opening stock, Purchases, Credits & closing stock all of which are expressed as afore mentioned. Yield = PackSize (6,8,10,12,15,24) in this example i'll use 15 OS = 3.13 - 3x15 + 13 = 58 Pur = 6 - 6x15 = 90 Less any...

Do not have 2010 only 2007, if you can save it to an earlier version then post it

Couple of things Are you adding new comments to existing comments Or are you adding additional comments to existing comments for existing records? Or both? What version of Access are you using?

Have you tried setting it as an hyperlink and use the FollowHyperLink method.

Mine is not to reason why. If the delivery note states 6X24 50cl bottles then I need to be able to record it or calulate it back to 12 dozen bottles. Because products can be bought in various pack sizes the consumption analysis needs to be consistant that is why everything is converted to...

Today:Format(Date(),"dddd") = Saturday

Now this is where it gets complicted I want to convert the remained from 10ths to 12ths Where as 1.11 = 1 dozen and 11 cans or 12.01 = 12 dozen and 1 can. I have managed it now, but not in the conventional way. It's all about consumption costing. Say you buy 6 and a half cases of beer and there...

Silly question, I want to find out what the remainder is from any given number. It may be 11.01, 3.24, 0.10,0.11, etc. I need to be able to split the value into two parts A everything before the decimal point B everything after the decimal point I need to retain the precision though Stried...

Hey Bob Not being a member of Utter Access I did not know they have a Job Category, maybe I may enlist and you never know might get some more work:D:D

Adam Although powered by the same vBulletin I don't think Jon utilises these tags.

Click on the General Section and you should see a button that says Create new thread. Click on that to add your question.

That was the intention of the demo, but it looks like I never got around to finishing it. Although there is a sample in the Sample databases section if I remember correctly

Don't get on your high horse. What I was saying was that you posted your own personal question underneath another persons introduction comments. By creating a new thread under your own name and title will prove more fruitfull.

Well I suggest removing all the criteria and add it back one at a time to identify which filter is not working. Kind of process and ellimination

How are you calling this sql? Is this the code from an actual query or are you running it in vba?

Debs Suggest you post your own question instead of hijacking another one. More likely to get an answer that way.