I have a file with packed numbers that I need to convert into decimal numbers.
I've written my 1st-ever Access Function but it does not return a result and
I get an error when I try it in Immediate Mode.
A "packed" number replaces the last (right-most) digit with a letter to

i am writting a access programme, in which i have a tabel name"marketers"and
one form based on it.
one of the filed in tabel  i need is id,  and one control on the form is
based on this column,i need this control  to  generate numbers automatically(

I know that there are many ways to get the first and last records.  What if I
want to get the first and last records of a two column table or recordset?  
So basically, the first row, and last row, but 4 seperate records.  Thanks!

I'm familiar with the first day of week, year, etc functions. But I have yet
to come across a good function or suggestion to default to the first day of
the month when given a particular month.
Can anyone help out on this? [in VBA]

I'm trying to do this:
txtTaxes = IIf([State] = "KS", [txtPriceEa] * DLookup
("CityRate", "tblTaxAuthoritiesNew", "[City] = " & rsCust!City & """), 0)
rsCust!City has an apostrophe in it.  How do I handle this?

How can I find out how much free space is available on a network drive
referenced using the "\\xxx..." terminology?
It appears that fs.AvailableSpace and fs.FreeSpace only work with "lettered"
drive designators.

I asked this once and didn't get any responses so I'll try once more. I have
an access application that will be running on multiple workstations on a
network. One of those workstations will have the Access DB that has the
tables, which the application will be linked to, and will ...

I have an input field which allows an input of DD/MM/YYYY, this then goes
into a VBA SQL query which converts the inputted numbers to MM/DD/YYYY.
How do I stop this?
Cheers Nick

Hey folks,
I have a date field (Dept_Suspense) that I use to update 2 other fields:
Report_Suspense  = Dept_Suspense + 30 Days
Office_Suspense   = Dept_Suspense - 10 Days

 i know this question has come up alot, and i have read the forumns and
looked at the sample code provided, but i have a slightly different request
that im hoping some more experienced users can help solve.
At startup, Id like to checks for valid links, if present, simply ...

Hi can anybody help
I need some code to delete everything in a folder and the folder itself.
Sometime the folder may contain both files and folders or may even be empty.
myPathDel = "C:\test"

I have a access 2003 database and i need to export a table to another db.
This target Db doesn't exist, so i need to prompt the user to select the
target directory for this db.
How can i programatically create a new database ?

Have a question here.  I need the Acess VBA that can do this and I am having
troulbe writing VBA in Access because Excel VBA is my forte:
I created a new column for a sub form.  This new column needs to calculate a
value that will be determined by looking at another value in that ...

I have done the programming groundwork to produce a filtered recordset.
Can anyone help on how I now get this to export in the specified ".txt" file
format, please?  It MUST be TAB-delimited to be imported into another
database.

I have a Main form with several button it. I put a CloseButton on it. I want
to close the form as well as the database window when the user click the
CloseButton.What code should i write for it.
Thakx