I have a form that the user will input a value like 0133232
I would lkie to use this to create a table
Excerpt of my code is
dim two as string

I understand that I can't declare a Public array in a class module. The help
says that I can use  As Variant property procedures to emulate this. I guess
I vaguely understand what that means, but even that I'd like to find an
example of. More to the point, I want to nest these ...

I've got a combo box (UnitSN) which displays values from a table (tblUnit)
where status = "Available" and the limit to list property is set to Yes.
If the user types in a different entry, the not in list event fires which
asks the user if they want to add the new data to the list. ...

Access 2000 SP3 (.adp)
I have a form with box's, using the onCurrent event the sizes of these box's
alters to fit the contents of the text or pictures, but does NOT go over 1
page ever.

Hi Experts,
I’m trying and learning to write a codes in access. Appreciate if you could
show me
how write the code for the looping process. I can create a query or a macro

I am wondering if there is any possible function code to convert a number to
a Roman numeral.  Anything that is out there is excellent.  Thanks!

I am really new in Acces VBA. I thought it would be more or less the same as
Excel and Word, but it is quite different.
I have the following question. I have created a new database and table which
is updated via external data. I have added three more columns, which should

I want to create a database that will send up a flag - to my email, to
another database, etc when a date field (a due date) is nearing.
Can this be done?
Or should I just monthly (periodically) run a report that will show when

I have a table that does not (and can not) have a primary key.  I want to
open a new form to display a record that I have already selected.  If you are
in table view you can type in the number of the record that you want to go to
but the user won't know what that number is from ...

I really need help with this.  I've posted a few questions, but not having
any luck.  I have a report that is filtered by an input form that contains a
multi-select list box.  Normally I would use a query to filter the data then
use that query as the report data source.  Since I ...

UPS Worldship can import shipment records from a single Access table that has
all fields: Name, Address, etc. as well as the package data: service, weight,
reference, etc.  If there are to be multiple packages to the same
destination, Worldship needs a separate record for each.  ...

Hi, I am creating a program in access, but i am using VBA to insert the code.
I have created a program that would not allow a user to enter duplicate
numbers, if the number is duplicate then a msgbox will be displayed, but the
code is not working correctly. I want the code to ...

    I want to create an Excel like output from my code in VBA, How can I do
this? As I know there is a component to do this. What is it? I tried
flexgrid but it seems that I don't have license to use it. Is there any grid
like component that shipped with VBA for access?

I have read many ways of controlling drop-down boxes in a userform
.setfocus, .dropdown, etc....  Does anyone know of a way to instruct a
shape (combobox) to "drop-down" in VBA.  I am able to select the shape
as follows but I am really hoping to be able to drop it down so the

I want to generate a report that show only items that have not been closed
out.  There is a field in which a date is entered if the item is closed.  If
there is no date then it is not closed.  How do I go about generating a
report that shows only the entries without this date?