Hi,
I'm trying to abolish all macros from my aplication, but I'm new to VB so I
need some help.
I have a macro that "setvalue" to the following form:

I have the following code that is to open a folder when the command button is
clicked...however i get a runtime 490 error.
Private Sub Command34_Click()
Dim MyPath As String

I got a function to search in a subform it works good but i only get a beep
everytime i press a key.
Is there a way to disable the error beep sound?
thanks

Hi I'm having problems trying to work out how to do this.
I am writing a database to store audit data and one of the things that needs
tracking are the ISO clauses that aplly to the audit.
I have set up a main form for the audit details and want to click a button,

I'm wondering if you can do a with statement, then another with statement
within that (to add onto the first with statement).
I have a problem with Excel VB not accepting Access VB (as described in a
post about 4 posts down), and i'm trying to find ways around it.

I have a query that is the bases for a report. The query two fields
(number-errors, and cost-errors) that I need to totaled. I am trying to use
the following to do the job:
TotalErrors: ([number-errors])

I have a button that causes a report to print to file.  Within this button I
would like to add code that renames (and relocates) the file just printed.  I
would appreciate suggestions.  thank you all very much!
Ken C.

In VB code I open a table which has records in it and add new records to this
table.  After I've completed adding the new records, I go to the last record
in the table (movelast) and I get an error message - invalid use of null.
Anybody have an idea what's going on?

Hello Group
I am trying to create a report based on a query that will allow the
report results to be ordered by a field that is selected by the
user.

I have created a date field (A) to keep track of which books to destroy.  I
have it set up to populate the field automatically when we add a new book
into the database.  It is set up in the BeforeUpdate of a form, and I am
trying to write a formula to add 10 years from the date ...

Hi, I am trying to run this code below, and cant find out why I keep getting
error message - Data Type Mismatch in Criteria Expression, this appears on
line
rs.Open sQRY, cnn, adOpenKeyset, adLockReadOnly

I am getting that stupid "Enter Parameter Value" message, but I am 100,000%
sure that it isn't a simple typo in a field name or anything.
The where clause works fine when it looks like so:
myWhereClause = "tblProjectInfo.[ProjectMgr] = " & "'" & Me.cboProjectMgr &

Is there a max no of rows or a max physical size in gigabytes for an Access
table?
I have a static text file with 12 million rows and 23 gb in size. Can I load
this into Access?

I have three Menu bars (can be toolbars) that I want displayed in my
application.  I am using the docmd.showtoolbar all 3 toolbars are appearing.  
However, I want them displayed in a specific sequence...   Toolbar1 on top,
Toolbar2 in the middle and toolbar3 on the bottom and I ...

I have the following problem:
I need to have data in a table (or query?) sorted ascending by a field. I do
this with SQL (INSERT INTO table SELECT fields FROM table2 ORDER BY fieldx
asc), but I have noticed that when I open the table the records are not