Search:

Try:

Dim X As Integer

X = CInt(Me![TextBoxName]) + CInt(Me![TextBoxOtherName])

Msgbox X

Hans, thanks again, and again, and again.

Adding the "Loop Until InputDate >= EndDate" and your function did the trick. I'm still confused as to why the function without >= didn?t start with the...

Hi All,

The following functions return the next Sunday date from a given date. I am trying to find all the Sunday dates between two dates. Running the following function once returns the correct...

Hi Mark,

I have been to MS site and could not find if VB.NET comes in an upgrade for VB6. Do you know if it does?

Also where might be the most economical way to purchase VB.NET?

Thanks

Excellent Mark!! Just what I needed to know!! Thanks

Will VB.NET (Standard Edition) produce a distributable executable?

Does VB.NET contain an .MDB similar to VB6?

Thanks

Thanks Mark. I'll this a try.

I?ve tried the archives and Google but I?m not asking the right question?

Is there a way to detect if a browser has been launched? I need to know if Netscape or Internet Explorer is running. I...

Not sure if this will help but...

I think you can find a way to dynamically add tabs to a tab control in the Access 97 Developer's Handbook, by Litwin, Getz, and Gilbert (Sybex) Copyright 1997....

Thanks for the info. The service pack for Office is SR-2, and the WinXP is SP 1a. I visited MS site and the next service pack for WinXP is 2 but there was mention that it is a bata version. Am I...

I tryed: Me.strYearFrom = Format(DateSerial(2004 - 1, 3 - 1, 1 - 1), "yy")

It returned 03, but I'm not sure of the gotchas with this. Those more in the know will have to comment.

You could...

While running an Access 97.mde on XP Pro I am getting intermittent db lock ups. The lock ups are occurring in different places. The database is currently running on WinNT and Win2000 machines.
...

Try the Report wizard - AutoReport: Tabular based on a Crosstab query.

Thanks Hans and Charlotte for the info.

I am familiar with Access 97 security. In VB6, if by including a Jet mdb file as a data store, will security work in the VB app much as it does in Access?...

New to Visual Basic and I am not clear on VB and Access.

Is the ability to create .mdb files shipped with VB or does the end-user have to have Access on their system?

Create the query in the query grid. If it works without any errors copy the SQL from the View menu and paste it after SQL1 =

Get rid of:

'Dim db As DAO.Database
'Dim rst As DAO.Recordset

'Set db = CurrentDb

Have you set a reference to a DAO library?

Open any module. On the menu bar select Tools then References...

Correction:

Try the below in the Form_Open event of your subform. Don't forget to change MyTableName to the table name where your records are stored and the name of your form and the name of your...

Try the below in the Form_Open event of your subform. Don't forget to change MyTableName to the table name where your records are stored.


Dim db As DAO.Database
Dim rst As...

Try this:

Dim dbsNorthwind As DAO.Database
Dim strSQLRestore As String

Set dbsNorthwind = CurrentDb

strSQLRestore = "UPDATE Employees SET Country = " & _
"'USA' WHERE Country = 'United...

Thanks. Learned something new today.

Hans,

The SQL I posted seemed to work but now I am not so sure. In a Select statement with a Where, in which order is the SQL processed?

James

Try:

SELECT Trim([MyFieldName]) AS XX
FROM MyTableName
WHERE ((Right([MyFieldName],2)="-9"))

Thanks Hans.

I always appreciate the efforts of everyone who tries to help.

Thanks again.