I would like to display a Combo box without seeing the down arrow on either
the left or right.  I plan on using the Me.MyCombo.Dropdown statement when I
set focus on that Combo box.
Please advise.

Is there an SQL to create a table from Query Results.
I have a query. Then I export the query results to a table by, file->get
external data.
Is there any way I can stream the query results into a table.

I am working on one table. After a month I need to transfer the records from
this current table to another table (as my history file table). Then after
the transfer I have to delete the records from the current table so I can use
it for the next month. Can somebody give me a simple ...

please help me!
I have made a VBA code to form SQL:
This is working OK:
BLASql = BLASql & "  HAVING (((Calendar.Day) Between #25/7/2007# And

MS Access 2003 on XP Pro.
So I have a little code snippet.  I know there is a more direct way to do
what I am doing but I tried it and I don't like it. (Link the form to the
table so that changes to field link back to the table directly.)  

I have got a little problem. My form has a textbox where the user can enter
a decimal value and after LostFocus event a second textbox gets a value from
a SQL query.
The problem is that the user insert "10,36" and the SQL query only works

I am hoping this is a relatively simple question.
I am importing through one database and placing the information in another
for storage (Type Front End / BackEnd I suppose)
I know the path and name of the table I am creating, however struggling to

Dear Friend:
I use a table, name ChqInfo that store data like ChqID (PK), ClientID ( FK),
ChqNo, Chq ReplacementDate. and another table, name Cumtomer Info, store date
like ClientID, ClientName, RepamentDate., Installment

I have a report that needs to print a detail line item from an unbound
control.
I read a database to populate this unbound control (see code below). However,
the problems that I'm having is that the vba code works correct meaning that

I am using Access 2003 and Excel 97.  I have successfully coded  a subroutine
to transfer an Access file to a pivot file in an Excel 97 spreadsheet.  The
first line of code in this routine is:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Activity

I do not even know if this is possible.
I would like to ask the user for two number a start number and a end number.
After that populate a table with the start number and all of the number till
it hits the end number.

That following is an example of what I am trying to do:
I have an access table (SourceTable) with the following 3 records (2 of them
are for the same patient):
Patient#   Date1           Result1      Date2        Result2

I'm trying to use the replace command to pull out all the horizontal ellipsis
characters [chr(8230), or '...'] from a string, but the chr() command won't
accept anything higher than 255. I likewise can't search for three dots
because they've already been converted into a single ...

I have a problem in Windows XP since I created a FileSystemObject to
manipulate folders and files in an Access procedure.  In XP (from the Access
File menu), when I try to rename a file, copy/paste a file, or delete a file,
the directory screen doesn't immediately refresh.  I ...

I have an application that is Access as a Reporting frontend for an old
FoxPro system - has been running successfully for a couple of years.  There
is a multi select list box with 100+ reps listed (details from linked foxpro
data) - the user is selecting about 35 reps, a date range, ...