|
Maintenence Cleanup Task does not delete backup files
I'm testing a new Mainentence Cleanup Task that runs inside the same
subprocess as the backup task. I have it set up to delete .bak files in
the backup dir that are older than 1 hour (for testing). When I run the
task, the backup runs successfully but no older backups are ever
deleted. Can anyone offer a suggestion as to why?
The cleanup task is enabled; it's looking in the correct dir ...
|
2 |
12/2/2008 7:41:49 PM |
|
|
Problem in communicating with the OLE server or ActiveX Control
When I attempt select an item in a form combo box to activate an
'AfterUpdate' event, I get the following error:
"The expression After Update you entered as the event property setting
produced the following error: A problem occured while Microsoft Office Access
was communicating with the OLE server or ActiveX Control
* The expression may not have result in the name of a macro, the name...
|
1 |
12/2/2008 7:26:12 PM |
|
|
Does a cmdButton have a value
Does a cmdButton have a value before a click and a different value
after a click?
I'm trying to hide a button immediately after a click but can't due to
the fact "It has focus". Could you please give me a suggestion or is
there a better way to do this?
Thanks...
|
2 |
12/2/2008 6:57:00 PM |
|
|
Validating start and end dates
Greetings all,
I have a quick question...
I have a simple pop up form designed just to count days with the following
text boxes:
txtStartDays set to short date
txtEndDays set to short date
txtDays set to general number with the control source
=Nz(DateDiff("d",[txtStartDays],[txtEndDays]),0) which works fine counting
the days.
I am trying the ensure that the start date is not g...
|
9 |
12/2/2008 6:09:00 PM |
|
|
Import data for all tables
Hello,
If I want to import data from excel/access for consolidation of data, how
can we import all tables at once. I need it because of the following:
In members table there is a forein key for address table primary key. FK in
member is a required field and we need to import all data at once, otherwise
it will be rejected.
Anyone can help me how can we do it?.
Thanks in advance f...
|
4 |
12/2/2008 5:42:07 PM |
|
|
Frustrating Form Coding Error
I am trying to create a simple user defined report form for a range of
records between a chosen start and end date but keep getting this compile and
syntax error instead of the report, am I missing something?
Private Sub Command4_Click()
Dim ReportName
ReportName = "Stores Start Order" _
DoCmd.OpenReport _
ReportName:=ReportName, _
view:=acViewPreview, _
WhereCondition:=...
|
4 |
12/2/2008 5:26:00 PM |
|
|
Unhiding a detail form by double-clicking the primary key in a sub
Hello,
I am working on building a database from the ground up and am fairly new
to this, but I have created a form that has everything nested so there are no
pop-up forms/windows. Most of the people that are going to use this need it
to be ID10T proof.
The way I have it set up, I have a main form [frmDefaultMain], which has
several hidden subforms. When a user clicks on the navbutt...
|
3 |
12/2/2008 5:21:02 PM |
|
|
requery lookup information
I have a lookup form that displays information based on what is
selected from an unbound combo box (cboLU).
I've added a cmd button (cmdRemove) to the bottom of the form to
delete (make inactive) the current record. It takes the name out of
cboLU, but it doesn't requery the main information. I end up with a
blank in the combo box, but the form stays filled in.
My current code is:
...
|
3 |
12/2/2008 3:23:13 PM |
|
|
expected: end of statement error on DatePart
the error is located in the TabCtl0_Change event at the
Datepart("yyyy",[DateDep])
What I'm trying to do is click on List13 which queries List15 and a click on
List15 will query the Deposits_Subform to those dates of that year and month
in List15.
I will say when I delete the yyyy and mm criteria with just the Fund and
Account criteria in strFilter, the query works showing only the r...
|
2 |
12/2/2008 3:08:05 PM |
|
|
The purpose of these query
Hello,
Anyone canhelp me what is the purpose of this Query?, Is this just to list
all our tables and queries?
SELECT MsysObjects.Name AS [List Of Tables and Queries]
FROM MsysObjects
WHERE (((MsysObjects.Name) Not Like "~*" And (MsysObjects.Name) Not Like
"MSys*") AND ((MsysObjects.Type)=1 Or (MsysObjects.Type)=5))
ORDER BY MsysObjects.Name;
Thanks in advance
--
H. Frank Situm...
|
3 |
12/2/2008 1:46:10 PM |
|
|
Me
I looked up what 'Me' in Help and this is what it says:
<<The Me keyword behaves like an implicitly declared variable. It is
automatically available to every procedure in a class module. When a class
can have more than one instance, Me provides a way to refer to the specific
instance of the class where the code is executing. Using Me is particularly
useful for passing information ...
|
3 |
12/2/2008 10:12:59 AM |
|
|
Control Tips text foreing language
Hello,
I have been able to use foreinlanguage for the labelcaption of the source
control in the forms/reports using like the follwoing VBA, my Question is
instead of just CAPTION, how can we make it for Control Tips Text in Foreing
language too. Can we make it by; Me.Form.Control Tips Text = .Fields(1)
WE appreciate your help.
Dim db As DAO.Database
Dim rst As DAO.Recordse...
|
1 |
12/2/2008 9:27:02 AM |
|
|
Local Language in name of the church
Hello,
In my Churches table I have chruch ID and ChruchnameE for English Name and
ChurchNameL for Church Local Name.
What should should mention on the textcontrol to say if language in Defaults
table is not English, then it will take the Local Name.
Anyone can help me please?
Thanks in advance
--
H. Frank Situmorang...
|
3 |
12/2/2008 4:56:05 AM |
|
|
Warning for duplicates with multiple conditions
Hi,
I have a form that shows info for students that have applied to magnet
schools in the district. The form has student info (name,address etc) and a
subform that displays one record for each of the schools they have applied
to, linked by a student ID. They can apply, register and be accepted to
multiple schools but they can only be admitted to one. To further complicate
matters, the...
|
6 |
12/2/2008 2:20:02 AM |
|
|
Using a form for more than one use
I would like to use an existing form "frmMaterialMasterADD" for two
different applications within the same DB. The path to the form comes
from two different CmdButtons. The bound information and format would
not change but I would like to place/show/activate a CmdButton on one
showing of the form and not show it on the other. Where and how would
I code this?
Thanks as always....
|
2 |
12/2/2008 1:10:47 AM |
|
|
Copy SQL from query - paste in form
Hello there,
I have two query's; one to get totals for pallets received on Mondays
and the other to get the average from the the first query...
Query one - Week Day Totals - SQL VIEW
SELECT RecyHistory.DateRec, Sum(RecyHistory.PalletCount) AS SumOfPalletCount
FROM RecyHistory
GROUP BY RecyHistory.DateRec
HAVING (((DatePart("w",[RecyHistory].[DateRec]))=DatePart("w",2)));
...
|
3 |
12/1/2008 11:25:07 PM |
|
|
shortcut menu reuse issues
I've got a shortcut (popup) menu that I want to use with several forms. It
is a simple menu and function call, but I would like to avoid multiple
similar copies of the shortcut menu or function that the menu implements to
just handle the name of a table. Basically, the popup calls a function
(fnSelect) and passes it a value (-1, 0, or 1) which will determine whether a
field (IsSelected...
|
3 |
12/1/2008 10:33:25 PM |
|
|
Run-time Error '2046' when using DoCmd.RunCommand acCmdCopy whilst browsing
I have a simple form in access.
There is one field on the form , DocID, which has the name of a document.
When the form is loaded, I want the docID to be copied onto the clipboard so
the user can paste this into another program without having to do a manual
keyboard or mouse routine. After doing the copy, it moves the focus to the
next field where a user could paste his results.
So, for ...
|
1 |
12/1/2008 9:15:31 PM |
|
|
Convert number to date field?
Hi,
I have a tableA have 3 number fields mm,dd,yyyy.
How do I write update to another table have a date field DOB in tableB?
Thanks you in advance....
|
7 |
12/1/2008 9:07:03 PM |
|
|
Multiple controls to a Query on a form
I am a college student working on a semester project and I have a form that
is supposed to allow a user to input multiple critera to a query, like
LastName, Date, etc. I've tried it out multiple ways, but I cannot make it
work consistently. Here are my findings:
The query, when blank, runs fine. All records show.
If one form-based criteria is added to the query, (like
[Forms]![Swi...
|
12 |
12/1/2008 8:38:33 PM |
|
|
onExit and Current conflict?
When entering data into the location field of my table, I want the users to
be able to eliminate any leading zeros from the location number. I will fill
them in myself so that "587" will be changed to "00587". I do this by the
following:
Private Sub Location_Exit(Cancel As Integer)
Me.Location = Format(Me.Location, "00000")
End Sub
I also want focus to be transferred to the loc...
|
4 |
12/1/2008 8:09:01 PM |
|
|
Find missing numbers
Hi all,
Is it possible to find missing numbers from a sequence? For example, if my
table data (in a column) is 1,2,3,4,6,7,8,9,11,12... the desired result
would be 5,10
Is this something that can be done? A while back, someone mentioned setting
up another table that has the complete number sequence and then do a
comparison, but is there something else that can be done?
We have some b...
|
6 |
12/1/2008 7:42:08 PM |
|
|
Disable Deleting and Enable Adding more Data
Hello,
In my database there is an unbound main form having four controls ie.
cboNumber, cboName, cmdOK, cmdSave. Depends on these selections and
click on cmdOK will open a subform (Datasheet view) which is bound to
a table, for data entry purpose. The subform is having fields called
“Description”, “Ref”, “Status”, “Comments”, “Status1”, and
“Comments1”. On click event of cmdSave will save th...
|
1 |
12/1/2008 7:40:41 PM |
|
|
Help with this code please.
.....
Set RsA = CurrentDb.OpenRecordset("dbo_A", dbOpenDynaset, dbSeeChanges)
strSQL = "SELECT * FROM dbo_A WHERE lname = '" & Trim(Me![lname]) & "' and "
strSQL = strSQL + "fname='" & Trim(Me![fname]) & " '"
Set rst = CurrentDb.OpenRecordset(strSQL)
If rst.RecordCount > 0 Then
If (Me![lname] = rst![lname]) And (Me![fname] = rst![fname]) Then
DoCmd.OpenForm "frmA", , , "Lname...
|
3 |
12/1/2008 7:33:01 PM |
|
|
OLE in report
I am trying to paste 40 cells from an Excel worksheet (which I used in order
to format the cells with rotated text) into the page header of my report and
two things happen - when I copy the Excel cells and paste them into the
report, only half of the cells actually paste so I have to break into 2 sets
of cells. Then when the report spans 2 pages due to width being greater than
page widt...
|
1 |
12/1/2008 7:21:01 PM |