Search results

Hi Guys, Don't worry too much about the single elements, all I need to know is a way of getting the image value from images/image and format from images/format. All the other values I can extract fine, its just these array values i'm struggling with. Cheers,

I forgot to remove the text saying there was something attached, I embedded the json instead. I am not using your parser, to be honest I probably didn't know about it until now but the one I am using is working fine. I just need to know how to get these array values out. It's a right pain.

Hi ridders, I already have a json parser which I probably got from here which works really well. and I can pull the values from every element other than the arrays. This is my result from the json parser. [{"productId":"33e3e81d-2b78-475a-8886-9848116f5133","identifier":"TPP","name":"Test pre...

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

yeah i've tried doing a me.requery but doesn't appear to do anything. Everything else updates great, so queries and reports all seem to pull the updated info, its just the textboxes that won't display the new info. How is it possible for the form to display information from a a backend that its...

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

Cheers Guys,

Thanks so much, thats works a treat. I get a little confused with the criteria and the quotes. 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...

Cheers bud, i'm not sure what was going wrong with my DSum but i built my query again and now it works fine. I'm still very new at this and learning ways to do things. Cheers, Si

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

Hi, Thanks for the reply, after i posted this i carried on trying to figure it out and eventually got it working with a DSum and setting the criteria Between 2 Dates. Thanks again, Si

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