Help

Edit field data in TreeView
Hi, I have managed to populate the active X control microsoft tree view ver 6.0 but am stumped on how to allow the user to edit the fields that are displayed. Any help would be much appreciated Regards Al ... 19 Jun 2008 01:14

Column name spacing problem
Hello Everyone, i have a column named "Cell No" but when am trying to get data from it using query "select * from data where Cell No=?" it throws an error i know the problem is because of the spacing in the column name. For some technical reasons i cannot change the column name, so is there any way in which th... 19 Jun 2008 01:14

Datasheet formatting by date
I have a subform in datasheet form with the fields Date, Type and Note (sorted by Date). There are 4-5 records generally per date. Is there a way to group them visually somehow by date such as alternating colors/shading per date or a bold line between groups of records of a particular date. Any ideas? ... 19 Jun 2008 13:42

Microsoft office 12.0 object library for Access 2003
On May 5, 8:15 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...(a)msn.com> wrote: "Excel 009" <excelmodel...(a)gmail.com> wrote in message news:ff33fa17-f52f-4afb-8794- Thank you, Albert.  I am not quite sure if I need the 12.0 object or not, but assume I need it, how can I install it on a PC only with ... 19 Jun 2008 01:14

File cannot be updated
I have the following code to Open a form and set the form to the Survey_ID from the first form. I keep get errors like cannot update file --- The Survey_ID is an autonumber. Could this be the problem ? Private Sub Command259_Click() ' Open Form 'DoCmd.OpenForm "frmCHAR2", acNormal, , , acFormEdit 'Set Value ID... 19 Jun 2008 01:14

Advice on securing a sensitive Access database
In article <e2c26464-d28b-49b6-af91-0659579566be(a)m3g2000hsc.googlegroups.com>, The Frog <Mr.Frog.to.you(a)googlemail.com> Fri, 23 May 2008 02:05:50 writes Let me know if you want to bounce this around some more. I would just like to tender my sincere thanks for all your help. The project is coming to an end... 19 Jun 2008 17:49

How to create a VBA function which can be used within a query
On Jun 4, 9:36 pm, lyle fairfield <lyle.fairfi...(a)gmail.com> wrote: I think I'm in here way too deep and should have just shut up. Rereading your original post I think you want the median of price grouped on category. I expect that modifying the first several lines of your function would help: Func... 19 Jun 2008 01:14

"Record is too large"?
"tekctrl" <tekctrl(a)earthlink.net> wrote: There are nowhere near that many Date/Time fields in the record. I count 11 date/time fields in the entire record. That gives me 88 bytes reserved. But chances are there is one byte per field as overhead as a separator of some sort. That's just a guess though. Ton... 19 Jun 2008 16:48

DB Self-destructed! <GRRRR>
Perhaps, you are frustrated because you think Access should behave in a way which it does not. I think you start with a text-file of lines/records with fields delimited with something? and that you want to import this data into a JET table and edit it in a form. I suggest that you post a line or two from this ... 19 Jun 2008 01:14

How would you do a checkbook register?
I know I can keep a running total, but I was thinking that this would be very slow after a while and not very efficient. For example, if it calculates everything for three years, that's a lot of number crunching. I know I could narrow it by month or something, but other than that it'd be intense the larger the db... 19 Jun 2008 01:14