Search results

Barry Will be trying Mailman's offer. Your question. me.recalc or docmd.recalc sends you back to the first record. I have a bunch of records. Could be anything from 1 to 1800 depending on criteria selected. Users are reviewing stock status as shown on the main form and then entering their...

Basically I have a Form with Sub form I add soem data to sub form and then need to refresh the Main Form which will use sub form data in calculation. That's basically okay using Me.Requery. All teh calcs work no problem Problem is that this returns me to first record in the query results...

Basically you never copy records from one table to another EVER. You need to read up on Normalisation, Entity Associations, Primary Keys. Foreign Keys Basically you have Clients Events Then you have a table called Events_Clients The PK from each participating table are FK's in the...

Okay my comments are as a person who has nowhere near the knowledge of the previous posters but does consider themselves as a reasonably good developer in the areas they tackle. Yes I understand normalisation, Ansi Sparc Architecture, Referential Integrity, Associations and those things that in...

Sincere condolences Len

Richly deserved Doc Seems to me that this forum is really fortunate to have so many MVP's. There are also quite a few who are at the moment unofficial MVP's Len

You could use ASccess Security but do not just run the wizard unless you know what you are doing. I have some papers about security if you are interested. They are principly Access 97 based but all the details follow through. I cannot post them here they are too large. PM me with an email...

In a world where the misguided think that Access is but a toy it is really good to see that enlightened people do get the recognition they deserve. Not only for their own knowledge but also their willingness to help and guide us mere foot soldiers. Good One Bob Len

Thankyou for sharing and I have enjoyed. That will teach the buggers Len

Good advice above. Access is absolutely not Excel in another wrapper.... as you will soon learn. So take the time to find out and you will save weeks of work. Len

A lot of experience coming out on this thread. Yup been there are been lumbered with the quick and dirty to resolve. Fortunately I am at the age where I can say "We either do it properly or you get somebody else". Not everybody is in that position ... I understand but I totally agree with...

rsmonkey speaks a lot of sense. The sort of progression I would look for 1) Get some formal education in Access because understanding the technology of databases is essential. 2) use this to get a foot in the door. 3) look to move up heading for Oracle 4) get a certificate for all courses...

Are you aware of Learning Tree International ?. If you want to start learning these are people who offer trainingcourses and certifications thatI believe are recognised in the US. Even better if you canpersuade somebody else to pay the course fees Len

Thats what I call respect :D:D L

Done some checking It seems Secure the BE. tight Secure the FE no changes to design of anything Take copies (One more than you think you will need) and play on your C drive Len

Just a maybe on this one Basically on your form have a field where you select X. X being 3 or whatever "top" you want Then a command button with a DoCmd.RunSql event procedure. The rest of the DoCmd string is the SQL but you substitute in X at the appropriate place. Need to declare X as...

Now you have got me I really do not know Suggest a search on Security and see what turns up. There are piles of threads on this and it may take a while but the answer is probably there Sorry cannot help from here My suspicion is that you make the FE open and secure the BE but I could be very...

Cheers Had noticed the changes ;););) Len

Having just changed employment they wanted somebody who could take them to the next level. Next level I hear you say. At the moment they are in a hole and digging furiously. No ERD, No Relationships, No Referential Integrity, No Normalisation. At the moment after just over a week I have put...

Cheers Rabbie Of course its badly paid since all Access Developers are grossly undervalued but it will be enjoyable because it is working with Access. Anway the pension from last employer helps the finances as well Cheers again L