Folks, I have vba code that processes a translation and transfer of fields
and data from one table to another. The table I am coming from has cryptic
field names and some data that needs to be evaluated and changed before
delivery/matching to the new table which has more ...

I'm new to Access 2007.  I've converted an Access 2003 .mdb file to an Access
2007 .accdb file.  The application uses tables linked from other Access 2003
databases.  When It opens, the correct form appears but none of the command
buttons work.  What am I missing?

I'm formatting excel via Access.
Most of the code (from klatuu) works.
Some stuff returns error messages though.
For instance,

I am declaring a public variable in the declarations section of a form's
module, and assinging it a value in a private sub in that module.  I would
like to use the variable in a module for another form, but the variable loses
it's value.  How do I deal with this?

Is there a way, through code, to determine who or what called a specific
function?  For instance you have Function A that calls Function B or you have
Macro C that call Function B.   Is there some code that would reside in
Function B that could determine that it was called by ...

I have access application which gets the data from Excel sheets and upload
to the Oracle.
I have to automate the whole process in the background. The process should
execute automatically and complete its job.

I thought I read or heard that there is some basic code every access database
should contain for maintenance reasons.....like an auto compact and
repair....I'm just curious if this is the consensus out there and if so, what
would you suggest I add to my database.  Thanks for the ...

Function NFile()
 Dim FSO As FileSystemObject
 Set FSO = New FileSystemObject
FileSystemObject.Renamefile "C:\Test.txt", "SecondTest.txt", False

I have two different forms(A and B) that contains a button to open another
form (C).
This form (C) is populated with information contained on the first two forms.
Is it possible to check, on form_load method of form (C), what form_opened

I keep getting this error message - Item cant be found in the collection
corresponding to the requested name or ordinal
I dont understand what it means to be honest.
I am trying to get the code I have written to fill the textboxes on the

I'm calculating values to a query with VBA. When I do the calculation the
results also go into the table which I use as a base for my query. Why? I
don't really mind, because I intend to use the query in the next step of my
project, not the table, but should I be concerned that ...

I have been thinking what would be the best way to "flatten" a table. I
think the easiest way to explain what I'm searching is by a simple example.
Beware, this is only to show you the idea, this isn't an actual table of mine

I'v created rst but its not working please let me know where I m doing wrong:
Set rst = CurrentDb.OpenRecordset("SELECT * FROM [Overtime Data] WHERE
CardNo = " & CardNo & " and OTMonth = # " & Format(OTMonth, "mm/dd/yy") & "#")
   If rst.EOF Then

I have the following Tables and a search engine form to suite but its
slow as hell!!!
Table 1: (2.7million items)
FirstName

Hi - I posted in Module Coding but not sure if it was the right place,
I'm using Access 2003.  I have a request from one of my departments that is
stumping me.  It is essentially a billing report request.  Here’s the
scenario.  Units come in for testing. Some units come in for ...