Search results

Sorry Plog, I dont have time to read up at the moment as this is pretty urgent. Thanks for the advice though, if anyone else can help with the current format it would be much appreciated Many thanks

Hi Guys, Not sure if this is possible but if it is it will be perfect. The attached database tracks staffs working times and any time out throughout the day. Each day their Team Leader (FL) will update the individuals details in ‘Frm_Input_V2’. Currently they have to complete a record for...

Guys, I want to be able to create a vlookup in access. I have 2 tables, table1 and table 2 which contain an ID and numbers. I want to run a query to only bring up the numbers which are in both tables only. Is this possible. Please see attachment. Regards

Awesome, works like a treat and you have designed the query that now makes complete sense. Thanks very much

Hi Guys, I wonder if anyone can help? I’ve adopted a database from previous employee and I’m trying to modify one of the querys. Basically, qry_individual runs based off the drop downs from the frm_reports. I have added 3 combo boxes on the frm_reports, Workstream, Flow Leader and FLM. At...

Thanks Paul but that doesn't really help I'm kind of new to this. Still unaware of how I do this? Is there any way you could show me an example on the attachment?

Hi Guys, I've tried various versions of this following the above link and can't get this to work. I ow have a message showing 'Microsoft access cant find the object Me, if me is a new marco make sure you have saved it and you have named it correctly. Any help would be greatly appreciated

Thanks for that, I'm a little confused how that works, you you be able to give me an example on the attachment? No worries if you cant

Hi All, Quick question, I have built the attached database and have an issue the getting data from the form into the table. Tbl_data is the main table where all data is stored. Within Frm_data I have added 3 text boxes that pull the FL, FLM and area from tbl_staff depending on the name...

Sorry to come back on this, just one last questions. How do I know get the auto populated info in the form to feed into the table?, ie, skill on the form to feed into skill on the table? Many thanks

Thanks for that it makes sense. However, its kind of doing the same as an iif statement I have already written in the form. What I'm trying to achieve is to ensure if the Total Standard Hours (Text62) is not Between 0 And 0.3125, then the user cannot physically log the entry. Thanks for your...

thanks for that, its a little above my access abilities unfortunately. I have very little experience with functions

Hi All, Is there a way to add a validation rule in an access form on an unbound text box. This box is currently doing a calculation of others. If the figure is not between 0 And 0.3125 then I do not want the user to be able to move on. For some reason if I enter ‘Between 0 And 0.3125’ in the...

Perfect, makes complete sense now. Thanks again

ok, thanks for that. I'm a little confused as I can't see where I am going wrong, would something be able to help? Many thanks

Hi, yep count of the combo box looks ok I think

Text box based off combo box selection Hi All, I’m trying to auto populate the text boxes in the form based on drop down from the combo box. As you can see in the form Frm_Input, this works fine for FL, but for some reason it will not populate for Skill, Role, FLM and Location. The table it...

Thanks, that would work, any idea how I do that?

Hi Guys, I wonder if you can help. Is there a way to only allow users to select todays date or future dates in a date picker. I do not want any users to be able to change the date prior to today? many thanks Craig

Hi All, I have a from which uses time in some of the formats. I want to be able to minus time from time. The following calculation does not currently add up and I cannot figure out why? Available hours = Base hours minus unavailable hours. Available hours should surely be a negative value...