Search results

So I am using an excel sheet to transfer small amounts of data to a backend access database using ADODB - and to do this we need to set a reference to 'Microsoft ActiveX Data Objects x.x Library'. I typically try and use the most recent version but some of the machines here are somewhat older...

well, just in case anyone is still interested I resolved this using the shell function instead: Private Sub cmdView_Photos_Click() On Error GoTo Err_cmdView_Photos_Click Dim strPathName As String Dim strBeforeAfter As String Dim strCamNum As String Dim lngTaskID As Long Select Case...

Have you tried capitalising 'UTF-8' ? I know xml is strict when it comes to case. Other than that, no idea...

happy to help where I can :D

Ah, this will probably lead access to look for a literal value '[Forms]![getMonthData]![dateparam]' in the date field. I think that you can only pass 'naked' date info in this way... try assigning two text boxes on your form, one with the start date and one with the end date.. something like...

Does the query have any joins? I have had this error in the past when joins were not defined properly in my SQL expression (a mismatch in data type between 2 joined fields could be a problem also..). Also might be worth checking your SQL output and make sure you have left spaces in where they...

Glad I could help :D

Try ------------------------------------------- Me!List212.RowSource = "SELECT record.ID, record.vendor_code, record.invoice_date, record.period_covered, record.amount FROM record WHERE vendor_code = '" & vendor & "';" records.Open "SELECT record.ID, record.vendor_code...

the help file says that the '?' is not required if using ExtraInfo. I have tried using a single string for the Address as you suggested (including the '?') but that didn't help matters. I'm half tempted to use an intermediary batch file...

Yeah it just sends everything before the ? to the browser (so basically no change) this is really bugging me, I just can't see what is wrong with it. maybe it's a security thing, I'll talk to IT (although I can use html forms to pass variables in the url...) Edit: IT don't seem to think it's...

So the below code is supposed to open an html file and pass some extra info to it which is then used by JavaScript to display the correct photos (pictures of cameras before or after 'drop test') Using Firefox the page opens OK, but the extra info is not passed (I know it is in the correct...

code to create XSL stylesheet... Public Function XSL(strSQL As String, strRoot As String, strChild As String) As String On Error GoTo Err_XSL '18/08/2006 R.Stevens 'This function will take an SQL string and use it to create an XSL stylesheet to go with an XML file created by the XML function...

Yep, I know access has the capability to export XML files, but they use the parser in IE and so cannot be viewed by Firefox.. so I wrote some code to create (basic) xml and xsl files to display data in a table... It is probably in need of some refinement, as I do not yet know a great deal about...

Thanks Shane, but no joy :( It's frustrating, this is not a problem if the subform is in form view, as it doesn't generate the DefaultValue before updating, as it seems to in datasheet view. I'll probably end up typing it in by hand or having it in form view... Edit: after some tinkering, I put...

Basically, we have different camera modules on which we perform a given test a number of times, giving rise to 2 tables, tblCamera which will store basic info about the module and tblTest which will hold info for each test perfomed. The camera module has a unique ID (CameraID, the Primary key...

Pat, thanks, I somehow missed the 'linked to a table' bit. Heat must be getting to me :rolleyes: Edit - problem below is due to null handling problems, I found 'If Len(Nz(Forms![YourFormName]!txtCode, "")) = 0' seems to work if value in field is deleted. This won't happen if it is just left...

Hey, I wrote a sub to do this recently, which will check the value as soon as you have finished entering it on the form assuming the field in your table is of type 'text' and the box on your form is called 'txtCode' this should work (obiously, substitute YourFormName, YourFieldName and...

So I have a list box on a form from which users can select which fields to display in a query... There is a default set of fields to display, which at the moment is hardcoded in the associated VBA (far from ideal). I was wandering if there is a specific way to open a list box with a number of...

Just a quick question, it appears that I can't Enforce RI for relationships where one of the tables is linked from another *.mdb (the checkbox is greyed out)... is this a general thing with linked tables? Thanks, Bogzla

Thanks, I had suspicions something like this might be the case... Guess it's just another of those things we have to live with :D