on start up i have a form that opens but i want it to stay hidden.
i tried a few things so far and i had no luck.
i did :
Private Sub Form_Load()

I have a field in a recordset which is a string.  It can look like
this: 13-15-67-56
I need to break out this string into numbers to run in queries to open
recordsets.

I am working on an add-on and i have a form with a combo box. if the
user picks one option, the combo box is populated with a query that is
based on a table in the CodeDB, if the user selects another option, the
combo box is populated with a query based on a table in the CurrentDB.

so i'm new to access but i've done a lot in the last 3 months since i looked
at it for the first time back then.  so when i finished my first db for my
job, i cut it close to the end of the year trying to get it done in time for
january.  now that i can take my time and add new ...

Using MS Access 2K, I have a client with a number of seperate customer
tables for each country, approx 50 tables, stored on a SQL Server
backend.
I cleaned up the data in the tables and inserted all the records into

I am a promotional products Distributor. I am trying to get my site
similar to http://wwwcawholesale, which has an amazing site. My site is
http://www.dallaspromotionalproducts.com.  I have a supplier
http://www.foractivewear.com that has several items that I would like

I have a datefield that sometimes should store hours and minutes too ans use
following format and inputmask.
dd/mm/yyyy hh\:nn
09/09/0000\ 99:99;0;*

I have a (installation) date in a table that I put in manually.  It is
the date we want to complete a job.  In a form that uses data from that
table I want to add a text box that is bound to the installation date
but I want to subtract 7 days from the installation date.  I tried

I have to create an attendance list for a meeting that will have
attendees that are both on the committee and non member participants.
My thinking is to create a form that has the member names listed with a
check box next to their names in one section of the form, and a list

I have the following SQL string, but cannot get it working:
strSQL = "SELECT * FROM [pcbforecast] where [pcbforecast].[JobNumber] =
'" & [Forms]![PCBShipDateO]![PCBForecast].[Form]![JobNumber] & "' and
[pcbforecast].[ShipETA] = #" &

From an Access 2003 module: v = Shell("ftp.exe -s:D:\ftpCommands.txt")
Contents of D:\ftpCommands.txt
----------------------------------
open ftp.destination.com

I have the following table test3.
RESERVATIONID    Site    SitePrice
101                  RV2    $25.00
101                  RV3    $25.00

I created in design view a subform within a subform.  However the
subform within the subform in only visible in design view.  In form
view the subform within the subform is not visible.  I have only nested
from the mainform to a subform into another subform.  Any clues why my

I have a combo box that finds a record on the form, and for the most
part it works fine.  But, on occasion it brings me to the record just
before the one I am looking for.  If I compact and repair the database
it works correctly again.  Sometimes I have to compact and repair

I have an MDE file that is blowing up with "Error 3075 Function Not
Available", which is normally a reference issue, but, I have no missing
references.
It seems that offending function is a Format() over a date field in a list