Search results

Thanks for the response Peter. I have learnt some new things from going through the "Data Entry" help topics which is really good but unfortunatly it has not solved my problem. Can anybody help? Regards Adrian

Thanks for the pointer. I have just remembered that i am flying to Ireland tonight for a few days (Girlfriends birthday present) so won't be here to post anyway. If you do get a chance to have a look that would be appreciated. Regards Adrian

With his new

Hello All I am creating a production line database for use on a touch screen (no keyboard or mouse) which has to be really easy to use. At the start of the week i got to the point were i thought i would test what i had done to date and have come across a serious issue. I thought that the data...

In case this thread is useful to other people here is another link that i found initially which came up with the same solution but when i read it initially it didn't make sense. It does know after it has been "worked through" above...

Thanks FoFa and Peter I came in this morning refreshed and determined to beat this issue (albeit with slightly less hair after pulling it out yesterday) and Peter's solution worked great. I can also understand what is going on so hopefully the problem will never darken my door again (give a man...

I can't even set the value of a text box to the global variable it is not available as an option in the drop down list in Control Source (this i was expecting) and when i go into the expression builder i can pick up the GlobalVariables module within Functions but the last selection box is blank...

Thanks for the reply's FoFa I have ceated a standard module - GlobalVariables and a variable within it as GLB_CustomerId and using the immediate window this is working just great. However i can't seem to refernce it, specifically i am trying to restrict the contents of a list box by using...

I have a handle on the theory but i am having trouble setting it up in practice what i really need is a very simple step by step walk through preferably with examples. I thought it might have been a common query so yourself and the other members who have a lot high level of experiance than...

Hi Kieth Still no joy perhaps a little more explination on my part is required frmDetailsCorrect collects all the details of a production line process e.g. crew size, product name etc. based on selections made on previous forms in an enforced order. I am trying to collect the time that these...

that is exactly what is happening i will give it a go straight away. Thanks for the response Keith i hope it works as a small win is needed at the moment :-) Adrian

Could anybody point me in the direction of a simple / step by step tutorial on global variables. I have searched the site and read through other threads but I am still having trouble defining the listbox selections on my forms to a global variable module so that i can use them in other forms...

I have a number of forms with options on and then the user clicks a command button which is meant to insert a an InstanceEnd time into the underlying table (the InstanceStart has already been populated) Create a new record and insert a new InstanceStart time into the new record the user is then...

Hello all I have searched the site for an answer to this but still a little confused i would like to set the height, width and header height of all my forms to a value which i know and also the positioning, size and font size etc of the list box which appears on these forms ( i have tried...

I will give this a try. Thanks for the responses Adrian

Just noticed something the only 2 fields from teh record i am trying to populate that i cannot bring up are text fields the rest are all there and they are number or date/time is this why i am encountering a problem? and if so would i be best advised to assign a unique number to each of the...

Showing my inexperiance here as i am not sure what you mean. What i have done is added a comand button to a form. It is the only button on it as it effectivly inserts a time value at the start of the day, inserts a text string in another field of the same record and then opens a new form and...

Hello everyone I am reasonably inexperianced with Access and VBA development and need some help with something i thought would be realitvly easy . I have a number of forms that are linked to tables that allows users to select variables which complete the fields in a record. However in a...