Search results for query: *

Hi, it does work, but I am baffled as to why. Would you mind if I said this does not make sense at all? Thank you for your help, though. At least I can finish my project.

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

Okay... I did find the problem. Use acImportFixed rather than acImportDelim!

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

Hi all, Thank you for all your suggestions. I had to tweak a few things around, but eventually I made it work using Andrzejek's suggestion. .List(i) is not a valid item in the with .listbox. I used .column(row,i) instead. Thanks again for all your help. I appreciate it.

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

MajP: I totally forgot to let you know that your solution worked wonderfully with the latest additions that you gave. Well done!

Thank you for trying to help me on this. I have tried to implement both suggestions from Duane and MajP. Duane's solution still gives me the "not in list" error on my end. MajP's solution did solve the error message in combo3. Because the combobox is bound to 0, it doesn't store/hold/keep the...

Thanks for your help so far! I'll test the workarounds tomorrow. A little help for people that find this entry helpful: I did code Duane's solution (me.combo4 = Null). However, I first set the combobox to Null and then reset the rowsource. Doing it the other way around might also help. I'll...

I have created an example of my problem that shows my issue. to reproduce the problem: - Open database - Open Form1 - In combo1 select "tblTest" - In combo2 select "Field3" (Date type) - In combo3 select a date (can be any date) - Select "Field1" in combo2 - Select any value in combo3 This...

Thank you Duane for looking into this. I have narrowed this issue down to a point that I could actually reproduce it. First the code that I use is this Me.cboTable.RowSource="tblIssuer;tblCustomer" Me.cboField1.RowSource = Me.cboTable Me.cboSelection1.RowSource = "SELECT DISTINCT " &...

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 appreciate all your input and thinking with me on this. Your suggestions helped me closing this gap that gave me a huge headache initially. I could not find the solution to my request anywhere, either, so I hope that after the search engines indexed this page, this question will help other, as...

I didn't try that! The solution can be so obvious at times. Thank you for this paradigm and opening my eyes. You solved my mystery.

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

Hello Duane, When trying your solution, I get an error, saying "Method or data member not found" with the cursor highlighting me.txtCount. This is the code that I used for the detail section event in the report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...

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

Great! I found the solution myself. This might be useful for those coming across the same problem. the Listbox.Column property also works with rows!!! So, to solve this mystery in my example, I have to use me.lstMainScreen.Column(#ColumnNumber, varItem) where varItem is the rownumber of each...

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

Thank you everyone for your input. The way I solved this problem is by creating an invisible field on my form and using the following code: Private Sub lstIssues_AfterUpdate() If Me.lstIssues.Value = Me.txtOldIssueValue Then DoCmd.OpenForm "frmIssues", acNormal Else...