Search results

Get well soon Bob and take it easy

Point taken, but if Adobe and Microsoft have problems what chance have the rest of us mortals. The onl;y other sanction I have is the usres in my particular industry have to be registered with a very pwerful government body and as such are suposed to be ultra professional, hacking and pirating...

Whats the bug you have seen?:eek: My view is if someone wants to pirate they have to be very good and is any software safe against the determined hacker. I am just trying to make it as difficult as poss, the level of computer savy of my potential users is not that advanced and for my first...

I use KeyedAccess from Peters Software, great tool for doing exactly what you want, £200.00 but well worth the money in my opinion.

thanks for that Gemma and Moniker, added the CInt bit to the SQL and got the whole number. The importance of the calculation is so that I can target advertising to the right age group ie Saga magazine readers as opposed to trying a younger magazine. My database contains 12,000 records so far...

still reading :confused:

I am trying to calculate the average patients age from 2671 records using this SQL: SELECT tbl_Customer_Details.DOB, CalcAge([DOB]) AS Age, DAvg("[Age]","qryAvgAge") AS Average FROM tbl_Customer_Details GROUP BY tbl_Customer_Details.DOB, CalcAge([DOB]); why am I getting the result...

Hi RuralGuy, thanks for the help but you've lost me now. The deeper I go into Acces the harder it gets to understand. Can you explain this binding thing in relation to the problem I am having. I have read your link and I am trying to get my head round it, why would a simple piece of code like I...

thanks Rural, function done, query done, how do i reference the query (qryCalcAge) in the txt box (Age) on my form? bound or unbound. It was bound before... thanks for your help once again.

thanks ByteMyser, so the answer is to use an mdb file or buy 2003 or 2007, is that what you advise?

I have converted my 2000 mdb file to a 2002 mde file. When I run the mde on another pc using 2003 In ' get #name? ' error on a control (Age) that holds a persons age calcultated from a DOB control ( DOB) which is populated from a popup calendar. The age is calculated using the following...

Thanks for the reply, but thats using a form with text control boxes which I know how to do. What I would like to do is have the start and end date system dialog boxes that are generated by a parameter query popup with a date picker I use on them or just have the date picker popup. I hope this...

I use a 510 almost on a daily basis in the UK and on occasion in France ,no problems as yet and the price has fallen rapidly. I don't know what the difference is between the 2 models, probably extra features.

I have a parameter query that requires the user to input a start date and end date into dialog boxes generated by the query. My question is: it possible to have a date picker control actually on the dialog boxes when they show for a date to be entered, or is this only possible when using a form...

You also need full admin permisions on the folder, if you have'nt allready

you need to create a folder in my documents or on your HD, I called mine MY Downloads and down load stuff to there. I had this (for want of a better word) problem when I upgraded to Vista recently, stopped me opening sample DB's from this site until I worked it out.:mad:

No probs, just dipping my toe. I would allways defere to to Bob, he and many here have probably forgotten more than I will ever know..! looks like I am going to have to invest in the developer extensions if I am to progress my humble effort any further, I would however have prefered to to...

I stand corrected Boblarson, however I know what he wants and I know what I meant in my reply. I have the same problem !!

For this standalone version you need MS Access developer extensions to produce a runtime version (.exe) otherwise you are limited to users with Access installed on there pc so they can run the mdb or mde file.

With the help and support of this forum I have managed to Build my mdb application. So far I have managed to: Build the thing Turn it into an mde turn off shift bypass hidden toolbars /menus etc hide tables I need to log on/ off done can deliver it via cd self extracting installer as an mde or...