Search results for query: *

Goodmorning, I've got a 2d-array with about 1000 rows and 5 columns, now I want to write this into the database. Now I just have a loop through the Array and write each line seperately to the database. for x=1 to ubound(array) rs.adddnew rs![Field1] = array(x,1) rs![Field2] = array(x,2)...

Goodmorning, I've got a query where some fields are the result of a subquery. The query that causes me trouble is: SQLs = "SELECT SecurityCode, Holding, iif([TypeSubCode] Like '161*', 0, 1) As TypeOption, " & _ "(SELECT Value FROM G_MarketData_BB WHERE G_MarketData_GP.Bloomberg =...

Goodmorning. I've have a question about building a query. Basically I have two simple tables: tbl_Securities ID Name tbl_BloombergInfo ID ID_Security (foreignKey) TypeOfData Value The first table consist of all kinds of securitycodes (stocks, bonds, options, cash) etc. etc. The second table...

Hello there, I am building an Access application to store information of Investments Funds and their Restrictions. There is more than one Fund and more than one Restriction. Each Fund can have multiple restrictions and each restriction can be attached to more than one Fund. So I created the...

Goodmorning! I was working on my database & VBA and saved my work. After that I was not able to enter the .mdb file again. The system prompts me: N:\.....\Administration.mdb The parameter is incorrect I just cannot open my Database. We are working in a Citrix environment. Access2003 / Windows...

Hello there, system: VBA Microsoft Office 2003, win XP SP2 I've got a very strange problem and I was wondering if somebody of you could help. Suddeny a VBA program does not work anymore. It stops at the following line: Open "Datafile.txt" For Output As #1 Then the system comes up with 'file...

Goodmorning, Is there a way to change the 3 FileDateTimes (creation, acces, lastwritten) of a file with VBA? Any help appreciated. Karja,

Hello there, This is more the less a follow-up on my previous post "Names of form Controls - Conditional Calling". I am making a card game. There are a lot of places on the table where a specipic card must be displayed or hided. The accomplish this I wrote the follwing: Public Sub...

Hello, The title might a bit fussy but I could not come up with something better. I was wondering whether somebody could supply me with a tip on the following: In a Form I've got lots of pictureboxes. Here is a bit of my code: If p = 1 And n = 1 Then Me.PictureBox11.Image = objImage...

Goodmorning, I've got a small question/problem: I am using a Form with complete data binding. When I make some changes to a record and I close the Form the changes are not reflected immediatly in the corresponding table. When I close de Access file en re-open it, the change are visible in the...

Goodmorning, I am trying to sort a listbox on a field that is the result of two fields combined with an iff-function. De query works fine untill I try to sort on one of the mingled fields (con1 or con2). The system just prompts for the variable Con1. Q: How do I tell the system that it should...

Goodmorning, I've got a (probaly very silly) question: I've written some VBA stuff to control some processes in Excel2003. On several worksheets I put some commandbuttons assiociated to macro's. This works fine. But now I want to change the locations of the buttons and some other properties...

Goodmorning, I am using a form in a small Excel application that uses default values. Now I am searching for a way that when the user actually enters te field by the tab or just by clicking the field the whole text is selected. So that you're not modifiying the text but in fact replacing it...

Goodmorning, I am building a small CRM for personal use and I want to be able to copy and paste emailconverstation is my database. The problem is dat the max. size of a text field is 255. I need more. As this problem isn't new perhaps someone knows a clever way to process large tekstfields in...

Goodmorning. I've got a irritating problem with my excel-application. This is the issue: I've got a quite complex application with several Visual Basic modules. Working with the application consists of three stages. The general idea is that after each stage the application copies itself to...