Search results

Guys, I have this query which works fine when sometimes but other times i get an error message? Also, when i run it via a report it does not pull through the name but it does on the query. Any ideas? SELECT tblCalDates.CalDate, qry__approved_requests.Name, qry__approved_requests.datDatefrom...

Guys, Is there a way to link results from a query into a form? I have a query named "Remaining" and field within that query named "Days Remaining" which is an expression. I would like to see this in a form is possible? Hope this makes sense?

Hi Guys, is the below possible? If datDatefrom or datDateto in frmexample contains any of the dates in tblHoliday, then show a message box saying "you have selected a bank holiday" else do nothing

Guys, Does anyone have a sample 2016 database with a working days function in it? I have found the below link but i can't download as i have 2016 I need to be able to subtract dates from dates but exclude public holidays. I have found several examples online but can't quite figure it out. If i...

Guys, is there a way to do the following on the attached form? If "type" is equal to kickback, show closed, else show active

Hi Guys, Is there a way of auto populating a date based on another date whilst excluding weekends and bank holidays? So with regards to the attached database, can date due in frm_1 show 1 WORKING day ahead of the date input (eg date input is 14/10/15 so date due should show 15/10/15). This...

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

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...

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...

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...

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...

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...