Replies

Check out the “datedif” function in help

HTH

Peter

Unfortunately the PC I was working from will not open another window from a link so I could not get to the “1-Click TagPanel”. A failed attempt by IS to block the internet on that machine I think. I have gotten so used to using the tag panel that I could not work out how to activate the link with out it

Peter

(Edited by HansV to activate URL – see Help 19)

This link looks as if it might be helpful to you
http://www.computorcompanion.com/LPMArticle.asp?ID=126%5B/url%5D

HTH

Peter

Sorry

Adding GetMod:Left([ConstUnit], InStr([ConstUnit], ” – “) – 1) to a field in the query grid will create you a new column called “GetMod” when you run the qyery

HTH

Peter

You do need the Update Query.
Once you select the “Update query” from the “Query” menubar, Access will add an extra row called “Update To” in the query grid.
In the grid add the PID field plus the rest of the fields that you want to update from tblStudents.
In the “Update To” box under each field that you wish to update add the table/field name that you are getting the data from Ie. [newTable]![SSN].
When you click the Run button this will then update your records.

Hope that makes sense!

It would be a good idea to back up your data first just in case!!

Peter

Close
GetMod:Left([ConstUnit], InStr([ConstUnit], ” – “) – 1)

Peter

The Security FAQ has some details on restricting data by Rows/columns.

HTH

Peter

If its just to protect your own App’s cant you put in userlevel security anyway but with its own .mdw file so that it only affects your Apps?
Peter

On the cover disc of this months “Personal Computer World” magazine in the UK they have “The Ultimate 3D Garden Designer”

HTH

Peter

Not a very nice piece of code either LOL

Peter

Building on Toms approach you could use a custom function in the query behind the form to create a new column which just shows the dates once and display this column in the Form. The code for the module would be something like,

Function CheckDate(dDate As Date) As Variant
Static lastDate As Date
If dDate lastDate Then CheckDate = dDate
lastDate = dDate
End Function

In the Query you would use “ShowDate: checkdate([Mydate])” in a new column to create the new field for your form.

However with this approach if anyone sorts the data in the form you are going to get some screwy results!!

HTH

Peter

A blank form usual indicates that there is no Data for it to display. Check that your record source is returning data.

HTH

Peter

A function to add a 0 to your ID would be something like

newid: Right(“0” & [PID],5)

If you have your levels in a filed you could just concatonate them on as well. This could be done on the fly when you need the levels rather than storing them.

Hope this helps

Peter

Adrian

I found this site to be useful for Access SQL, University of Bristol Computing Service

HTH

Peter

I haven’t tried it yet but Ikea do a planner for kitchens

HTH

Peter