Is it nessassary or of any value to convert access front ends to VB? I wish
to develope and sell software so knowing from the start would help. Also I
have a number of commercial access databases, is it possible to purchase a
conversion to VB tool?

my code text keeps going red while I am typing. Is VB trying to tell me
something? It happens during the most simple code and accepts it when I have
finished a line very strange. Have I switched something off or on?

Is there a simple way to keep a SQL Server database that was created by
upsizing an Access database synchronized with the original? I'd like to keep
the SQL data current with the data that's still being used in Access.
Thanks,

In a report I have this syntax which calculates the total Net Profit
If the value IsNull (no Data) then it gives me the #error in the field
How can I eliminate this? (Currency Format)
=Sum([NetAfterCom])-[Reports]![RProfitLoss]![RProfitLossSub].[Report]![SumOftxtRate]

Is it possible to use a subform so that when data is added it is added in a
column format instead of rows?  
In other words, my fields are Depature, Destination, Depart Time, Arrive
Time, Distance, etc...  There can be several legs for each trip; the number

What are people's thought doing development between web interfaces and
client server?  I have a new client that wants we to convert their current
dos based accouting system.  I'm going to use SQL Server as the back-end.
I'm going to do the front-end either as a Access 2003 app or ...

I have 2 table columns mapping to 1 drop down and 1 text item fields,
I want to take [column 1 (based on a selection in the drop-down) * column 2]
and place the results in text item 3,
something like:  [Get value from table where drop-down = &1] * [column 2]

when open a form apears next message:
"The expression On Open you entered as the event property setting produced
the following error: A problem occurred while MYDATABASE was communicating
with OLE server or ActiveX Control"

Is it possible to create multiple field unique index on the table.I want to
have two fields that are uniquely
identifying a record in the table. I also need to make an
AutoLookup query which require a unique index but in my

I have a form "Decs" with a subform "Runners Ratings"
with a Field "Own". What I am trying to do is
calculate the the average of the "Own" field in
the "Runners Ratings subform" and display the result in

I'm trying to get into two text boxes called "Start" and "Finish"
Start = "01\01\" & DatePart("yy", Date)
Finish = Date
But I can only get

I kind of a newby and haven't learned VBA yet so I'm doing this project all
with macros.  I have a form with a combo box that I want to use to select a
record to modify in a table.  Whenever I select an entry in the combo box it
changes the first record of the table to that value ...

in a report I need to insert a sentence, if a boolean field (EU) is true or
false.
My need is the following: if a sample is sent in EU (European Union), for
the custom, in the proforma-invoice (report) the incoterms must be

I've tried to open a form (frmReidProductDrawings) with matching field
(Initials) to a particular field (Originator) in the existing form
(frmStaffList) after clicking a command button. My trial code below opens
frmStaffList alright, but it doesn't go to the record with matching ...

I have a table that lists letters A - M
Code       Min      Max
A           1          10,000
B            10,001   100,000