Search results

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

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

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

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.

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.

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.

Hello, I'm trying to build a report for mass printing of all the applicants i have in a database with their items they should apply. Below i descibe how i designed the report. I have a specific page header (Application Title) that appears at top of every page in the report. Then i have an...

Hello, Is it possible to create a script which will do the following? 1. Copy file1.mdb from location A to location B 2. Import Query1 in file2.mdb to location B 3. Import Macro1 in file2.mdb to location B 4. Run Query1 and Macro1 in file2.mdb Any ideas? Thank you in advance!

Hello, I searched the forum but i haven't found anything, it there a way to make text alligment set to justify (as ms word does it)? I use distribute but it's not effective with dynamically set text. Thank you in advance.

Hello, If <if clause> then ' can't save record end if How can i prevent the user from saving the record when <if clause> is true? I'm using a continious form and i want to prevent save only in those records that <if clause> is true. Thank you in advance.

Hello, I have the following lines of code: If Len(cbo.Column(13)) > 0 Then If Suburb.Column(13) = -1 Then Me.Suburb.BackColor = 255 End If End If When column(13) becomes -1 in one record i want the combobox sururb of that record to become red but with the above code i get all records red...

I have a combobox that loads data from a table with 60.000 records. The source table is not local, is linked from SQL Server with ODBC. I save the combobox value into an access linked table. The problem is that is taking too long to load the data into the combobox. Is there anything i can do to...

Hello, i have a problem with function round. Result 1: round(3.215,2) --> 3.21 (fuction's result) Result 2: round(3.215,2)-->3.22 (wanted result) Is there a customization to round function in order to get the second result? Thank you in advance.

Hello, these are data from a query i have and i want to create a report based on the query with a chart as following: Date Score Average 1/1/2006 45 50 1/1/2007 43 48 1/1/2008 56 32 Axes X -> Date Axes Y -> Average Type of chart -> Line Lines ->...

Hello, Is it possible to have a PDF file as background to a report? I tried to convert it to an image file but the resolution it's pretty bad. Any ideas? Thank you in advance.

Hello, Is it possible to return a value from a query in VBA, something like the following? codeNumber=DoCmd.OpenQuery ("qryGetCodeNumber") Thank you in advance.

I have a form full of radiobuttons in groups. They just informed me that they need to be able to uncheck a radion button without selecting another one from the group. (be able to reset their choice) Is this possible with radio option group? Thank you in advance.