Search results

Hi All I have written some code to extract required data from a XML file and then populate my database tables. Which works fine. However, I now need to extract the 'id' variable from the XML file into one of my tables. Does anyone know how to do this?? Thanks in adv SW.

Hello all I have a selection of different types of dates for a particular individual i.e. date1, date2, date3, date4 etc all contained in different tables...I need to ensure that all the diff dates are all within a week of one another and if not produce output so that I can investigate...

Hello all I have a database that I need to work on which is a secured access database (2003) but I have access 2010 installed on my PC. I have the work group too I should add. Does anyone know how I can open up the database at home with 2010? Many thanks for all help in adv. sub

Hello all I’m trying to do something as simply as possible and was just wondering how I would go about comparing information from the different tables in my database using just access sql and no vba. Example scenario:- I have four tables within my database. The first table records...

Hey all Am currently having a major headache with my forms in Access! I currently have a menu, which allows the user to select an ID to correspond to a document that the user would like to fill out details for. Once the user selects the ID, the menu form becomes invisible and the first form...

Hi all, Does anyone know what causes the following problem in Access: 'The expression on click you entered as the event property setting produced the following error: object or class does not support the set of events' and what the possible solutions may be for this??? The database displays...

Hi all, I am setting the order of the data displayed in my access report using vba as in the example below: vStrOrderBy = " val ([" & vStrOrderBy & "]) DESC;" Reports(ReportName).OrderBy = vStrOrderBy Reports(ReportName).OrderByOn = True but the order does not get set....any ideas why...

Hey all I am having a severe HEADACHE trying to figure out what is wrong with a function I have written, so any tips/solutions to help me solve my problem will be VERY much APPRECIATED! Problem: I have a function that will validate data based on pre defined checks, that I have incorparated...

Hi guys, How would one go about deleteing all items from a specific menu on the menu bar i.e. all the menu items for the help menu? Any help would be greatly appreciated! Thanks