Search results for query: *

Hi, I am wondering if someone would be able to solve this mystery for me. I try to get information from tables on a linked server. Linked server is linked through SA account which has sysadmin rights on both the server as well as the linked server. The idea is that I probe the...

Hi, I have a txt file. Each line in this file has the same width for each record (fixed width). I have created an import spec by importing the file for the first time, putting the break lines at the correct positions and then save the spec in the import table. So far, so good. I have created a...

I have created a listbox with multiselect set to simple. I would like to create a recordset of the selected records that the user selected in the listbox. I could create a table of the selected records first, but I was wondering if there would be a more efficient way. Who has that brilliance...

Question applies to: MS Access 2003 This looks totally weird to me, so I hope that the forum could shed some light on this mystery. I have three comboboxes: Combo1: value list (manually filled with selected tablenames) Combo2: field list (automatically filled with all fields of existing...

I have made a listbox, which I maintain using an SQL string. Problem is that in The Netherlands most international settings on computers have dots as thousand separator and comma's as decimal separator (i.e. $1.000,00) I would want to convert that number to the american standard, because...

First of all I am impressed by the activity on this forum and the speed in which questions get different points of view. Thank you to those supporting. My question involves a report (fax layout). Because of the design of this report, I am unable to use the 'detail' section in the main report...

I am running MS Access 2003. I have a multiselect listbox, using the simple property in multi select. In the same form, I have a button that triggers opening a report, using a where condition. The code of that button is: Private Sub butCreateReports_Click() Dim varItem As Variant Dim...

I have an unbound listbox that I populate using an SQL statement: Me.lstIssues.RowSource = strSQL. The SQL statement works fine. The listbox is bound to column 1 which is an unique ID. When I click on an existing row in the listbox, an AfterUpdate event is triggered, which populates a second...