|
running sum
Hi; all
I have a table with four fields:
Fields: name month days monthlysalary
Records: jack 1 15 10000
jack 2 30
20000
jim 1 3
10000
jim ...
|
2 |
27.09.2006 19:37:32 |
|
|
adding a record from one table to another
I have 2 tables "Current TB" and "Chargebacks" They both have the common
field of "Line Number" What I want to do is when I type a line number in the
field in my Chargebacks form I want to populate certain fileds with data from
my "Current TB" table. I thought an update query would work but I can't get
the data to show in the current record in my chargebacks form. Any help
would be g...
|
1 |
27.09.2006 19:30:02 |
|
|
VB version difference
I developed a database in Access 2000 w/SP3 applied. However, when I
installed my latest phone software, it was necessary to update my Outlook to
2002 and my VB to 6.3. Now, the database I developed in this environment
will work fine on my computer but won't work on my client's computer. I'm
assuming that the difference in VB versions is the problem. They also have
Access 2000 w/SP3 ...
|
4 |
27.09.2006 18:47:02 |
|
|
Check if a table object exists
Is there a way to programmatically check if a table object exists in a MS
Access 2002 Database?
Any help would be greatly appreciated!...
|
2 |
27.09.2006 18:12:11 |
|
|
VBA References
I ran into a unique situation this morning where my boss couldn't access the
functions of a database I created in order to automate some tasks that
normally take 2 hours to do manually. Our "opening" person is out this
morning on training and I'm the closer so he was pretty hacked to find out
that he was going to have to do the process manually this morning (he could
have just called me...
|
10 |
27.09.2006 17:18:02 |
|
|
Reminder for a date field
I need a reminder based on a due date in an Access form. How can I
accomplish this? For example, 3 days before due date I like to get a reminder
about that particular customer or task listed in the form....
|
4 |
27.09.2006 17:15:01 |
|
|
Copy a table and rename it
I splitted my database, and I placed the backend on the network.
I would like to know how can I copy a table called,"EXAMPLE", from my database
called, "DATA.mdb", and placed the table into an nonexisting database that
will be namedaccording to the current date and then it will be added to
I:\DATAE\... For example, for today, I would like, "EXAMPLE", to be copied
to the non-existing datab...
|
10 |
27.09.2006 15:28:17 |
|
|
Public Sub Help
I have the following public sub in a button on my 'NewPartInputfrm' that
works great to delete a record as long as the button is clicked. I'm also
calling this same sub from another form, which first opens the
NewPartInputfrm to the last record, which was just created, then calls the
sub to delete that last record. It works fine except that after the record
is deleted, "#deleted" is in...
|
4 |
27.09.2006 15:26:49 |
|
|
Controlling the column widths in a form shown as datasheet
How can I control the width of the columns when for instance a form show data
in the datasheet view. I want to have the columns just as wide as the wides
string of characters in any record. I know i can put the mousepointer between
the columns and doubleclick for adjust. But thats just temporary. I want to
control the width in advance.
Martin Bolbroe
www.titit.dk
Denmark...
|
5 |
27.09.2006 15:22:17 |
|
|
Current module name?
Hi all,
I am trying to find a way of returning the currently open module's name so
that I can programmatically insert a sub or function code template into it
without having to type out the module's name when calling the procedure.
I think can do it with an API call on the VBA IDE's Title bar Caption, but
would prefer to stay within VB.
Any Ideas?
Thanks in advance for any answers.
R...
|
3 |
27.09.2006 15:12:19 |
|
|
Read-only error
Hi,
I copied a form & table to a different access project, renamed the table,
but had the form data source point to the correctly named table. The controls
worked fine for a while, but now I get a "Runtime 2135" error saying this
property is read-only and can't be set. The "help" button shows a blank
screen.
The control simply increments the value in a text box by one. The value in
t...
|
1 |
27.09.2006 14:01:04 |
|
|
Get the data from a single cell in table
Hi,
What do I have to write in my VBA code to get the data from a single cell in
MS Access table. I mean the field which is formed when crossing a column and
a record. I don't know the term for these cells used in Visual Basic.
If someone knows please tell me.
Thank you in advance....
|
5 |
27.09.2006 12:53:01 |
|
|
accessing Windows scheduler
Anyone know how to access Windows (XP) scheduler from within a VBA program.
...
|
1 |
27.09.2006 12:51:50 |
|
|
Calculating an average from SQL
I have inserted an SQL statement into the properties of a chart so that it
will include information for the ten most recent weeks.
SELECT FTE.WeekID, [count]-[FTE] AS Admin
FROM FTE INNER JOIN Query2 ON (FTE.WeekID = Query2.WeekID) AND (FTE.Dept =
Query2.Dept)
WHERE (((FTE.WeekID)>=DateAdd("ww",-10,Date())) AND
((FTE.Dept)="Administration"))
ORDER BY FTE.WeekID;
What I would like...
|
1 |
27.09.2006 10:43:01 |
|
|
OLE Registration
I purchased Visual Studio Tools(2003) mainly for the Developer Extentions so
I could package my Access DB's. I have now finally have had a need to give
them a try.
What I am running into is in the "Startup Wizard". When I check the
"Startup" and the other "Checking" features( VBA etc.) I get the "on-click"
OLE registration error. The message doesn't identify the OCX/OLE name and I
kno...
|
1 |
27.09.2006 09:59:01 |
|
|
anyone help me?storing the path...
hi...anyone can help me???actually...i have a code on vba for storing
path for files into database..but i not really understand what it is
all about...can anyone explain to me...this code is for call path in
database:
Option Compare Database
Option Explicit
Type shellBrowseInfo
hwndOwner As Long
pIDLRoot As Long
pszDisplayName As Long
lpszTitle As St...
|
1 |
27.09.2006 06:25:33 |
|
|
Access to Excel
I am pretty new to the design game so there are a lot of scenarios I
haven't yet come across and here it is. I am trying to set a connection
in access to an excel file. From there is it possible to manipulate
data at the cell level, and if so can you take values from cbo boxes
etc and insert them into the cells?
Thank for any help,
Navy Guy
...
|
1 |
27.09.2006 01:23:16 |
|
|
Assign yes/no field
Hi,
i need a proper code to automatically assign yes/no field when a certain
field is insert. i want when the user key in a certain record, the yes/no
field will automatically filled with yes or no in the table.tq
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200609/1
...
|
3 |
27.09.2006 01:15:07 |
|
|
Re: typing in word using table
I work for an accounting firm. We often use the table, rather than the excel
table to create a table of words & corresponding amounts. Often times the
amount are negative. If I set the column to right justify, that is fine if I
do not use a $ sign or a negative shown with ( ). I have been setting a L
tab in the column and then a right tab at the right side of the column. This
allow...
|
1 |
26.09.2006 23:53:01 |
|
|
reduce queries by using code
hi all
I have around 30 queries for one particular report due to each
parameter having different formula and format.I will try to explain and
needs advice and help if it will be better to convert it into code and
in which way.
first is parameterized query which is based on many tables and gets
'Date' from the form and other filters such as type = 'R' and model.
In next query it filters ...
|
3 |
26.09.2006 23:05:21 |
|
|
Bug? Properly formatting fields with "/" in the name, Access 2007
I'm working in VBA in a report where some underlying fields and text boxes
have names containing a "/" in the middle.
Say, I have a field named "One / Two"
If I type:
Me.one
.... then the suggestion for the field "One / Two" pops up. However, when
that's selected, here's what happens:
Me.One / Two
It's not bracketed! Naturally, when you do something with that and press
ret...
|
6 |
26.09.2006 21:35:57 |
|
|
When does automation object get cleaned up?
I want to generate an Excel spreadsheet from my Access data, open the
resulting Excel file, and let the user decide what to do from there.
So, my module will not close the Excel application object.
I remember a time when I was first learning about automation, and I kep
forgetting to close the application objects, or didn't set them to Nothing.
Windows got very upset, and I had to rebo...
|
4 |
26.09.2006 21:34:55 |
|
|
Expression Building in VBA Code View (Access 2007)
I have a suggestion that comes out of using the domain (dlookup, dmax, dmin,
etc.) functions quite a bit in my VBA code.
In form and report view, traditionally a field can be populated by one of a
few things. Usually a) a field straight out of the source for that
form/field, b) an expression built by the expression builder or c) a
function, event, etc.
My suggestion comes out of a bi...
|
4 |
26.09.2006 20:29:26 |
|
|
alpha blending
I am trying to create a semi-transparent image, but cannot for some reason
get the color method to work in the system.drawing class. I've included the
system.drawing.dll in my project, but the following won't compile:
v(i) = color.argb(100,255,0,255). doesn't work.
v(i) = color.FromArgb(100,255,0,255) doesn't work either.
Anyone know how to do this?
Thanks
Pete M...
|
7 |
26.09.2006 19:28:55 |
|
|
Copy a table and rename the table
I splitted my database and put the backend on the Network. I would like to
know how can I copy my table called ,"EXAMPLE", from my database called
"DATA", and place the table in a nonexisting database which will be renamed
according to the current day, then place it in I:\DATA\? For example, I would
like "EXAMPLE" table to be copied , but the new database would be named
"DE20060925". "...
|
4 |
26.09.2006 19:10:51 |