The following vbscript displays a record count of 6318 records from my DSN. However, I have 94858 records in the DSN. If I use the DSN in the Excel 'Get External Data' (MS Query), I can retr...
FYI: My programming platform is:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: VB Express
Microsoft Visual Basic 2008 ...
I am taking two inputs from a form to get data from an Access db. One input is the radio button and the other is a text box. the radio denotes which table the user wants to retrieve data fro...
Hi Experts,
Im trying to manipulate a file in access 2003 using vba. i have a .txt file that contains strings such as
OLD=1+5050854479878++:007415144+8+12'
ok, firstly i set the fso and ...
Hi All,
I have several text fields in a database table where it is probably that at some time someone will put double quotes in the text. Since the data in sql queries is delimited by double...
hi
i was using VB 6.0 and MS access 2003 for my application.
now i have migrated from access 2003 to SQL Server 2005 Express.
the connection string i am using to connect to SQL serever fr...
What is the best method to use to interact with an MS ACCESS database, where I can have the most SQL functionality?
I have been using the OLEDB class, however it appears to be some what ...
Hi experts,
I want to populate a combo box with all the available SQL Server instances in the local machine.
Can you please help me? I need the code in VB NET.
I have an external application which exports data as an Microsoft Access MDB database file, however unfortunately the new version of the application exports the Access Database with the extens...
In my MS access DB, when i try to open a recordset for a table, I get all the records expected in that table. However, if I try to do the same for a query (which I created an know has over 30...
I've got a datagridview set up with checkboxes in the first column, data is then loaded into the datagridview from an access database.
What I am looking for is a way to identify which rows ...
Hi All,
I have 3 tables, one called rules and one called output and onecalled data. the data table has over 450,000 records.
The rules table has a memo field which contains a SQL string of...
Currentdb.Execute "INSERT INTO newtable (ToyID,ToyName)"
Currentdb.Execute "SELECT ToyID,ToyName FROM Toys2"
not worken for me
I have a need to extract data from a table which has columns with special characters, in this case parentheses, in the name. The SQL string which I have tried to executed using ADO looks like...
I am trying to write code that will keep users from being able to schedule more than three visits per week. I think the code should be in the Public Sub SetCalendar(frmCalendar). I wrote out w...
Hi,
i have a form that has datagrid . in my datagrid i have a column that is a primary key in my sql table that called idnumber and when i enter data in datagrid after i press save button ...
Can anyone recommend a good book or websites to direct us in the best way to merge many DB platforms (SQL, Progress, Informix, Unify Relational Database called Data server) All can be ODBC, S...
I am performing a select of a view in ASP. All was fine until I added a Nullable column to one of the tables referenced in the view. The new column in question is not referenced in the view....
I have an application which uses ado recordsets and MS access as backend and when i generateVB data report, it generates same records from the recordset.
If the search results return 6 reco...
Hi
I have a VB6 Application which contains code like this ...
IN A BUTTON :
Dim db As ADODB.Connection
IN "ExecuteDB" FUNCTION
Public Function ExecuteDB(ByVal QueryStr As String, By...
I'm altering a MS Access table (via ADODB) to append a field. I want this field's display control to be a checkbox. Is there a way of doing this from within the program code?
Related question: http:/Q_24813268.html
In a VB6 application using ADODB, I have 1 point at which 1 customer sometimes gets Error 5, Invalid procedure call or argument.
We have a functi...
I have a dmaged mdb, can you export the tables, forms, reports from one mdb to another via code? I have a dmaged MDB that I need to move a large number of tables, froms and reports to a new u...
Hi,
I got a ListBox with the style set to "1-CheckBox". When the user viewing the form they will select few of them but I wanted to put a validation so I can make sure that the user atleast...
This is a follow up question to one I posted earlier. I am developing an application in VS 2008 that will require a remote connection to SQLExpress server. I need to have a table for Logging i...
