Search results

Hi Guys, I'm currently working on an API feed in Access but the one thing I am struggling with how to extra the values for that are in the nested arrays that come form the Json reponse. The array are basically image urls, sometimes there maybe more than 1. Can anyone help me cycle through the...

Hi Guys, So i currently have 2 different back ends for 1 front end. Now i have managed to get it so i can switch between the backends and this is working great, the only problem i am having is that the bound textboxes on my form are not displaying the new data when i switch backend, they appear...

Hi All, I have database that is currently split, however i now have a duplicate backend that i am to keep historic record. What i would like to do is from the front end press a button and switch the linked table paths so i can search the data from the backend with the historic information in...

Hi Guys, I'm using access 2007 and on my form i have recently added to charts, but since adding these charts, access now crashes when i open it. Any idea's Si

Hi Guys, I have a user form with 2 textboxes. the first is to enter a 5 digit site code and the second is for the sitename. What i am trying to do is in the afterupdate of the first textbox in VBA is do a DLookup to pull through the site name from the sites table and populate the second...

Hi Guys, I've created a Pass Through Query but my problem i have created a calculated field as below: CASE WHEN(PERS_VISA_EXPIRY_DATE < GETDATE()) THEN 'EXPIRED' WHEN(PERS_VISA_EXPIRY_DATE > DATEADD(Month,4,GETDATE())) THEN 'OK' WHEN(PERS_VISA_EXPIRY_DATE < DATEADD(Month,4,GETDATE())) THEN...

Hi Guys, So i'm in the middle of a project but have found myself against a brick wall. My project is to build an employee holiday calculator. I have alot of of it already working but the bit i am stuck at is this: Employees in the holiday calculator have their holidays calculated as below...

Hi Guys, Can't get my head round this at all and was wondering if someone could shine some light on my problem I have 2 table, 'Employees' & 'QHrsWorked' The employee table has columns: Empno, Cont_Hrs1, Start_Date1, Cont_Hrs2, Start_Date2, Hols_Yr_End_Date The QHrsWorked Table has columns...

I have a table for holidays taken as below Payrollsite------SiteCode----Hours----Element----PE_Date----PE_Year----PE_Period 123456SH001---SH001------45-------3007-----01/02.2011----2011---------34 123456SH001---SH001------50-------3007-----03/05/2011----2011---------38...

Hi Guys, I'm not sure what i'm missing here. I have a query but want the results to appear in a textbox. I believe the best way is to do a DLookup which i have tried but it the problem im getting is that its just says calculating in the bottom left until i click on the textbox and then the...

Hi Guys, So, i'm in the process of creating a holiday calculator for work but have come across a few problems. I have a listbox which displays the search results from the employee table, this is good but i can get it to filter by more than one criteria at a time ....Help The idea is that you...

Hi Guys, I have a form with text boxes and a listbox on. The text boxes are used for criteria for the query and i want the list box display the query results. All i want to be able to do is enter the critria, hit a button and the results appear in the listbox but for the life of me i can't get...

Hi All, I am pretty new to access and need some help. I have a multipage form with a tab called 'Admin'. The visible property for this page is currently set to 'No', what i want to do is enter a password, click a button and the tab appears. Can someone please point me in the right direction...