Search results

http://www.sdss.org/news/releases/20000413.qso.q.html

An interesting idea but there is a possible explanation why this may not be the case. Gravity is actually a very weak force. A small child can throw a ball into the air that defeats the gravity of a whole planet - if only for a short time :) - The gravitational reactions between two bodies...

Hi Unfortunatley you can't display additional controls on a pivot chart/table. I tried that idea in design view but once you view it the button disappears :mad:

Hi Rich The point is that pivot tables and charts are designed to be manipulated by the user then printed. As far as i am aware they are only available as forms? Cheers TS

Hi, Bit of an odd one here. I have a main form with a subform -Frame1-and a treeview control. The form displayed in Frame1 changes depending on the selection made on the treeview control. Some of the subforms are pivot tables and charts that are designed to be manipulated by the users. The...

Hi Doc, That's certainly comprehensive :eek: Yep you've hit the nail on the head a management hierarchy enumeration. The Topological sort sounds the most robust way of handling this problem and i think it will make creating an underlying recordsource for the staff form easier than the...

Hi, My intention is to limit access to records depending on the relationship between the user and the staff under them. i.e. you will only be able to view/manipulate data for staff in your line. Ideally both forms and reports but certainly forms. Cheers TS

Hi all, I'm a bit stuck with a db relationship design. I need to hold information in a staff table about a person's Line-manager. My initial idea was to just have the Staff Table and use the PK of a member who is a Line-manager as a FK in the Line-manager field in the same table for their...

Hi, Does anyone now how to use a parameter request within an In() funtion like In([MyParameter]) where the parameter would be something like 19,20. It's a little complicated but i'm passing the parameters via VBscript in an ASP page and i thought i'd tried and work out how access handles this...

Hi Pat, thanks for clearing that up :) TS

Hi all, I'm thinking about writing my latest DB with an MSDE backend and have a few questions. I'm aware of the client server relationship and this has made me unsure about the following. If i link the tables to the access front end am i defeating the point of using a database server such as...

will i dance!

Got a fetish?

Underwear for reference.

what of it?

in his kecks

Hi Try Application.CurrentDb.Execute "INSERT INTO tbl_ReportLog (DateTime, Report) VALUES (#" & Now() & "#, " & RPT & ");" HTH TS

No worries :)

Hi, Try this. Go into the code and alter the name of one of the form events like an onclick. Use the clear all breakpoints item on the debug menu. Compile the code and then save the code. Then change the event back and compile and save. Hopefully that will sort it out. TS

If you highlight the function or sub you are calling as you would to copy some text i.e. - the bit in bold - X = Myfunction("Test") and then press shift and the F2 button you will "jump" to the sub or function that is being called. Hope that helps TS