Search results

Bump This was posted on sunday so it Prob. got missed. I would really apreciate some help with this. I just cannot get my head around what goes on. Cheers

Oh Dear; Definatley have the monday morning blues. Try remembering to look Here First :D

Can't find a lot of info on this I have an example from MS but I can't work out what goes on. I have a tree view control listing items from a table. What I want is when someone moves the mouse over an item it displays additional information stored in the same table and some information from...

I concur. The only reason that I suggested the long way was, while it’s slightly slower, I find it more flexible to build the SQL into code for this sort odf a task

I wouldn't use a stored query in this instance. I would type the SQL into VBA and run it directly from there. Others may have other ideas If you don't have any idea of what the code should look like then look at the SQL for your stored query. This will be similar and will give you an idea where...

I don't think the number of entries can be specified because Access dosn't appear to limit this. However the maximum table size is 1Gb for Access 2000, With alimit of 2000 characters per record. This does not include graphics or memo fields. I don't know about other versions. HTH

I would put it in the after update property of the form Docmd.RunSQL

Yes Why not just add another col to your list box? Then you will get the item ID and the item. Or do you mean to place an item description in another control for use with another routine?

Here ya go. Sorry it took a while but I've been a bit bogged down. Lots you could do with this one but it should get you on the right track. 2 versions (97 & 2000) All graphics have been removed so the main form looks a bit empty.

No your bang on target, Good too see you are finally getting somewhere and happy to here that you are going to meet your deadline. Sorry I din't have the time right now to give you an example but if yopu lookn in Access help do a search on criteria and pick 'Enter criteria to affect when...

Hootie when you say you created security ---- what sort of security did you create? and how involved was it?

First save a copy of what you have done -- do a compact and repair first. Work with thw copy for development. Right now we have that out of the way you are now talking about one of the things I suggested earlier -------Availability. Create a table to store another set of times and dates...

You could but I don't understand why. Reorder Quantity = The number to reorder to replenish stock Safety Level = Here in the UK this can mean two things. I have seen it used to indicate the minimum level of stock on hand before placing a reorder. But in the military it is often used as a...

you could use VB with an IF loop to capture the input and set the mask accordingly. Be sure to include an error routine so that anyone doing it wrong will get their wrist slapped. :D

NO NO NO NO NO ! Time worked is time worked Time schedule is time shedule. If I tell one of my staff there working for 16hrs on Next Sunday they may agree(not if the've got any sense) but they may phone in sick on Saturday. What are you going to do then? Print a new rosta so everyone knows...

As I said to you on another thread. I would store time worked seperate from the sequence for calculating rosta.

What about overrides for double shifts etc? What happens when someone changes shifts? Or are you saying that this never happens?

Hmm this gets confusing with the routine you are using for word. If you where using a standard Access report then you could just display the date in two fields on the report and alter the format for each on the report. But, using a query it is more difficult without having two independant date...

Like this?

Ok I'll try and deal with this point by point First having a form that looks like Excel is not really necessary nor is it necessarily desirable but this is done with on screen formatting. The ease of use of an application depends a lot on how easy and self explanatory the input process and...