could anybody please suggest the working code  to print form,and  appear all
pages reports like page 2 ,3 because my report only show page 1 and the
others page missing although l enter data on it.

I have a database where data is entered for student's disclipline records.  I
want to be able to have a user enter a student's ID on the main form in a
text box, called txtstudentID.  Then have the user click a Search button that
will then open a continuous form and display all ...

Dim MyArray() As String
MyArray = split(MyString, " ")
If an array currently has two valid string
elements, MyArray(0) and MyArray(1), how

How can I combine these to DCounts into one?  Is there an or that I can add?
Me.TxtCount = DCount("[MenuID]", "MenuDetails", _
"MenuDetails.TerminalID = " & Forms!Patrons!TxtPatTermID & _
" AND MenuDetails.StartDay = Forms!Patrons!TxtDay " & _

I am in the process of creating a databse to allow our IT dept to put onr
daily schedules online.  I have two tables, tblSCHEDULE and tblTIME.  The
first table holds the date of the schedule with a primary key of ScheduleID.  
The second table links to the first table via ...

(excuse my ignorance; I'm a self taught XLVBA office geek now transferring
to ACCESS, and this is my first time around the block...)
I have the following
TABLE     - tblTable, w/ fields: [ Type, Manufacturer, Product, Notes...]

Does the IsDate work in Access like not the project one the other one?
Because I used a Not IsDate(textbox) and Not IsNull(textbox)_beforeupdate and
well its def not going to it. or something any ideas? I may not have been
specific enough with my version, but it uses the jet ...

With strSession, strYear, intMtgNo, strTopic and strChariman
having been set in code, the following SQL statement is created.
I don't see what's causing the 3061 run-time error.
          strSQL = "INSERT INTO TopicHist(Session, Year, MtgNo, Topic,

Anyone have an example of how to read records (lines)
from a txt file in VBA code?
Like:
Dim strMyString as String

hi currently i have a text box and a subform. I want the user to end a
value into the text box and it will automatically fill up the result in
the sub form with the value. But currently it only does it for the
first record.

I am using a subform where I need to have the many side of the connecting
field (account) in the main form because the form's primary purpose is to add
new requests.  
Many of the requests will have a new account number.  So I want to let the

When a user clicks on FieldTwo, which is a combobox, is there a way for a
msgbox to appear saying that FieldOne needs to be populated before FieldTwo
is changed?  Thanks.

I am trying to use a form with a multi select list box to create a query and
then export the data to Excel. Everything works, except the query that is
exported includes all of my data, not just my selections in the list box.
I read in another post that I would need to Save the ...

I keep getting an error message that DayID and MenuID are not
Updateable.  The statement works fine if I take Day and Menu out so I'm
thinking that it's my syntax.  The fields are all number fields.  Any
help appreciated.

I need to Right Align a column in a listbox that has numbers in it.
I'm uisng this expression in a Query as the rowsource.
EQuantity: IIf([SalesDetails].[Quantity]=1," ",[SalesDetails].[Quantity])
How can I accomplish this?