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.

Hi James Thanks....Im going to get on with the rest of the queries that need to be put in place and come back to this. Will let u know how it goes, or if I run into any problems. Thanks for trying to help - much appreciated!

Umm...althouth there is no data in the database atm...all the other details that are going into the database must remain confendential as it gives away other info...its complicated!

Nope. Cannot change the layout - its the way the application is designed...I didnt design it! :)

Hi JamesMcS All the dates (there are ABOUT 15) may be in different tables. The individual's ID is contained in every table. So for example date1 may be in tbl1, date 2 in tbl2 but date3 and date4 will be in tbl3. I know I can compare it all to one variable to see if its within 7 days of...

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

Hi boblarson Just tried that...and it opens up perfectly! :) Many thanks...i was in a bit of a panic there but your solution has saved the day! :) Enjoy the rest of your day and thanks again! :)

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

Ahh...tried on other computers on the network - worked okay. Then came back to my machine and opened the 'corrupt database', and when clicking on any of the main forms buttons the error described in my first post occurs!!!

Hi, Sorry for the VERY late response! Been very busy the past few weeks! I just opened a copy of the 'corrupt' database (or what I assumed was corrupt) and everything seems to be working perfectly - haven't changed anything in the database or on my computer/network! Strange!!! Any ideas...

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

I do usually try to post my solution, but its not always possible due to timing constraints! Many apologies for that. My solution: All the variables that will be displayed in the report are populated into another table first at runtime (this happens in my program for other reasons, not just for...

Well in short, vStrOrderBy gets assigned a column name if a certain criteria matches - the code is too long to post here. If it doesn't match the criteria it will be assigned an empty string. The code itself is fine, apparently the external ordering is ignored by the group ordering in the...

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, Dont worry - FINALLY found the solution - and it worked using SubFormData.Form.Recordset.MoveNext!!! :D Just had to play with the code a little!!!

Hey MStef, You can use MoveNext for the forms recordset i.e. FormName.Recordset.MoveNext At any rate thanks for your example and the reply - much appreciated! :)

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

Thanks RuralGuy, but I have got it working! It was quite simple really - I was just having a very LONG day yest! The reason why the application crashes has been addressed and fixed. Recently however I have been building new features into the system and fixing minor bugs, and there have been...