Search results

Yes I did, but I can't see how it can help me. What I need is to get an xml variable that a stored procedure outputs and save it to disk through a function. I'm sorry I'm not an expert so it's more difucult for me, if you could be more specific about the example I would appreciated it.

Hello, I need to have a function that downloads an XML file from a stored procedure and saves it to the disk. Is this possible with MS Access VBA? Here's my test sample in SQL Server: CREATE TABLE dbo.TestXML( ID int NOT NULL, PID] int NULL, Code int NULL, Col1 int NULL, Col2 int NULL, Col3...

Thank you that worked. Here's the code I added .... If Not (rs.EOF And rs.BOF) Then rs.MoveLast reCount = rs.RecordCount rs.MoveFirst Do Until rs.EOF = True With rs If .AbsolutePosition = reCount - 1 Then ....

The result is: 0/1 1/2 2/3

Hello this is my code, Me.Label323.Caption = "" Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM VALUEAPP_CAT") If Not (rs.EOF And rs.BOF) Then rs.MoveFirst Do Until rs.EOF = True With rs If .AbsolutePosition = .RecordCount - 1 Then...

Hello, I'm trying to build a chart in a report but it seems that I'm doing something wrong:( I need a chart that shows comparison of an item prices that different sellers sold Here's my query: SELECT tblItem.ItemID, tblSeller.SellerID, tblSeller.PriceS, tblItem.PriceB FROM tblItem INNER JOIN...

I used the following and worked Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) Cancel = Me.[Page] = 1 End Sub

Hello, What i need is to set invisible the page header in the first page. I'm using the following code, i succeed what i want in screen but when i print i get the page header in all pages. If Me.Page > 0 Then Me.PageHeaderSection.Visible = True Else Me.PageHeaderSection.Visible = False End If...

I added a field with default value =[Price] and Running Sum=Over group and worked :) Thank you for the help

Hello, I have a report that shows all products of a category of products as following: Page Header: Code Quantity Price Detail: 1. CV32 2 321,12 2. CV33 19 457,1 3. CV34 124 3241,0 is it possible to add a column as following Code Quantity...

Hello all, Is it possible to have one page header at the first page and a diffrent one at the rest of the pages? Thank you in advance.

I copied the code into a new query and worked, i don't know what happened :S Thank you though for your time!

No i just merge several strings into one.

Hello, i have two questions considering string with lenght over 255 characters. 1) How do i create a string more than 255 characters in a query without trancuted the string? 2) How do i set the type of field in Memo in a query? Thank you in advance.

Yes, but how do i do that in a query?

No it's more complicate than that, i'll try to explain. I have applications which must agree with a checklist of 50 diffrent points. If one or more points are not fulfilled then the particular point is marked as pending. So, i created a query that gets only the description of the missing...

Thanks! I managed to create the string but is more than 255 characters and some characters are trancuted.

Thank you for the quick answer! The problem is that i have to join a 50 fields of reasons [Reason1 - Reason50] (i used only 3 for the examlpe) and if i use the if function will get complicated. In an other thread i read that i could replace & with + ([Reason1] + Chr(13) & Chr(10) & [Reason2] +...

Hello, I have the following Fields that i use in a query: CompanyName ="Test Company" Reason1 = "Test1" Reason2 = null Reason3="Test3" I need to build a string for each Company which describes all the reasons. If i build the string as following [Reason1] & Chr(13) & Chr(10) & [Reason2] &...

Hello, If anyone knows, it there any similar to "after update" property of MS Access (e.g. textfield) in Visual Studio forms? Thank you in advance.