|
MS Automation - Saving database
Hello....I'm trying to build a button that will loop through records by
extracting a store number and save the current database as a different name.
For example, If I have a database that is named store_audits.mdb and a table
on it named tblStores with the following info:
StoreNumber Location
1 Seattle
2 Dallas
3 New York
I want...
|
7 |
12/7/2008 8:03:00 PM |
|
|
Median Calculation, Dates, & Group By
I want to calculate the medians for a string of values that are going to be
"group by" date, specifically the year (and I would like to group by the most
current quarter as well, but let me just deal with the year first).
I have tried the median modules that were posted by John Nurick,
TimFerguson, Matthias Klay, Tom Wickerath, (in the Median Calculation post
dated 1/4/2007 to I believe...
|
2 |
12/7/2008 3:54:32 AM |
|
|
Creating user level access based on department
This forum has been great and I really appreciate it. I'm looking to expand
my database a step further. We have a database for incident reporting which
tracks things within our facility. For every incident there is a department
assigned.
What I want to do is allow the department heads to open access and view only
their department(s). I am using the windows log in username and passi...
|
7 |
12/6/2008 11:25:07 PM |
|
|
"Fit to One Page" in Access 2007
I need to make a report fit to one page in Access 2007. Any advice?...
|
3 |
12/6/2008 9:33:05 AM |
|
|
Updating Excel links from Access Vba
I thought I had this issue resolved about a month ago, guess not. What I
have are 5 different spreadsheets that have links to external sources.
Unfortunately non of them are the same format and aren't compatable with
access in there current format. So what the code is supposed to do is open
up the Excel workbook and automatically update the links, save the data,
close the workbook exp...
|
2 |
12/6/2008 8:02:05 AM |
|
|
subtotal group records in Access 2007
My report is based on a query. In the details section I have two query
fields, price and quantity. I also have a calculated field, txtLineTotal,
that multiplies price times quantity. My records are grouped by Supplier
then Material then Destination. Everything works great. However, I also
need to subtotal the txtLineTotal per group. in Access 2003 I created a
txtSumLineTotalPerSup...
|
4 |
12/6/2008 1:08:45 AM |
|
|
Access 2002 VBA Handbook
Hi,
I've been struggling for years to upgrade my programming skills,
manly
using Access as it is the only software in my organization that could
enable me to complete a project (thanks God, this is a long term
project....)
Anyway, I bought several years ago Access 2002 VBA Handbook (Novalis-
Jones) which was recommended for people like me with average
programming skills. I must admit tha...
|
2 |
12/5/2008 3:58:22 PM |
|
|
Check whether form is is 'edit' mode
Is there any way to determine programmatically what state a form that s
currently open is in? Whether a record is currently being edited (i.e.
pencil showing on navigation bar) or not. I want to allow users to toggle
between forms, but want to notify them if a record is currently being edited.
I am using the 'IsLoaded' AllForms property to test whether the form is
loaded. How can I t...
|
2 |
12/5/2008 3:49:47 PM |
|
|
Access runtime & Adobe Acrobat toolbar buttons
How can I do either or both of these?
1. Prevent Acrobat toolbar buttons from appearing in my app when used on a
computer on which Access runtime and Acrobat (full version) are installed.
2. Turn off this toolbar once it appears in such a situation.i
Without normal toolbar access (this is an MDE with all standard menu &
toolbars being supplanted by only very rudimentary toolbars and all...
|
2 |
12/5/2008 2:14:17 PM |
|
|
Error 52 finding if Path exists
Hi,
I have one customer with Local Disk being D: or E: on a couple of pc's &
can't change the bootdisk letter designation.
Previously I have checked the existence of a folder using
Len(Dir(C:\FolderName, vbDirectory)) checking for "" if it doesnt exist.
but if I do an If/ElseIf loop to check D & E drives I get an error 52 when a
Drive letter exists (testing on mine D thru K exist as ...
|
8 |
12/5/2008 12:30:05 PM |
|
|
Move to a new added record
After having added a new record with among others an index field "NID", I
want to display the new record in the Form. I have tested with the following
code, but end up in the NoMatch line. I have traced that the right value of
NID in the new record is assigned correctly to strSearchName, but apparently
the new record has not yet been added to RecordsetClone. Do you have a
solution for me...
|
4 |
12/5/2008 8:19:01 AM |
|
|
Runtime Error 432
I have a database report that is exported to Microsoft excel. Everything is
working fine up to this line of code: Set XlBook = GetObject(FNAME)
The code to define FNAME is as follows.
strFilter = ahtAddFilterItem(strFilter, "Microsoft Office Excel Files(*.xls)
", "*.xls")
FNAME = ahtCommonFileOpenSave(Filter:strFilter, OpenFile:=False,
DialogTitle:="Save file as:", Flags:=ahtOFN_HIDERE...
|
2 |
12/5/2008 2:30:14 AM |
|
|
Touch screen
Is there a way to create an on screen keyboard to be used with a touch screen?...
|
6 |
12/5/2008 2:22:51 AM |
|
|
Bookmarking
Hi,
I am trying to setup a subform double-click event on a textbox to set the
focus on one of the main form's tabs forms and then goto a specific
recordset. Here is what I have but which is not working.
NumChng = Me.[ChgNum]
'Move focus to the appropriate control
Me.Parent.[118-Changements Main].SetFocus
'Retrieve the proper recordset
Set rs = Me.Recordset.Clone
...
|
2 |
12/4/2008 8:17:41 PM |
|
|
Print Multiple copies of a report or Label from within a vba proce
Hi, is there a simple method for printing multiple copies of a label or
report from within a VBA function.
Basically I want a user to be able to click on a print button from within a
form showing the contents of a product record and then specify how many
labels will be printed. I also need to store a default number of labels to
print with each record in the record itself.
I know ...
|
2 |
12/4/2008 5:47:01 PM |
|
|
Track changes made to all tables in a database
Is there a "relatively' simple way to track all changes made to my database?
I want a separate single table that tracks what was changed and who did it.
Thanks....
|
2 |
12/4/2008 4:15:21 PM |
|
|
Error when Filtering on Unbound Form with Subform
Hi I'm using Vba code to filter for stauts, date etc. but the code is not
reconizeing my subform. Its just showing all records.
Here is my code:
Private Sub Search_Click()
Const cInvalidDateError As String = "You have entered an invalid date."
Dim strWhere As String
Dim strError As String
strWhere = "1=1"
'If Property Name
If Not IsNull(Me.Proper...
|
8 |
12/4/2008 1:48:23 PM |
|
|
CompactDatabase needs a Flush ?
Hey,
I am using the CompactDatabase method of the DBEngine on every system startup.
The system is running on XPe and so I can not be sure that a proper system
shutdown will always be done. Sometimes the system will be shut off by a
simple switch off of the PC.
So to be sure that the new created database is not still in some file-buffer
and not already written to the harddrive, do I need...
|
1 |
12/4/2008 8:36:04 AM |
|
|
How to lock records until specific conditions are met?
Look at the table (tbl_Main) below. The first 6 records are Locked because
they have Null in Date_Completed. Records 7-19 & 25 are not locked because
The Date_Completed is Not Null. This is easy enough and I can implement it
with a Lost Focus event on the Date_Completed control.
However, for records 20 & 21 and 22-24 each of which is associated with its
Project_# but with possibly diffe...
|
2 |
12/4/2008 3:57:55 AM |
|
|
code to unlink a table?
I want to link to a table, run a query, and then unlink from the table.
I have the code working to link to the table:
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"c:\data\db.mdb", acTable, "sourcetbl", "linktbl"
Does anyone know how I can unlink (in code, not by clicking)?
Thank you,
Judy...
|
3 |
12/4/2008 3:42:38 AM |
|
|
Get "Open File" dialog
I want to select a file by opening tha standard Windows "open file" menu -
i.e. be able to go through a folder structure and then select a file.
Please show VBA sample code for that.
I think it is something like using the GetOpenFileName Function - but the
sample code found so far is quite comprehensive - and I cant really
understand how to use it...
--
Diane...
|
15 |
12/4/2008 3:25:01 PM |
|
|
Save a Word document as .txt from within Access
Is there a way to save a Word document as a .txt file using VB code? I don't
want to ask my users to "save as" because they will be working with
thousands of documents on many different servers.
--
Carol...
|
4 |
12/4/2008 7:49:01 PM |
|
|
to specify a read-only Recordset in Access 2003 Visual Basic
I'm trying to program a Database with Access 2003 where Several Rotas may
occur on a Weekly, 2-Weekly or Monthly basis staffed from a pool of
volunteers.
More than one rota, coded A, B, C (for example) may occur on the same Date.
The Rota Table's primary Key is Date and RotaCode.
A Volunteer may not appear in more than one rota per day.
Forms indicate how many Volunteers are required for e...
|
7 |
12/6/2008 3:10:17 AM |
|
|
Help me to solve error '2115' in this case!
I make a list box in a form and write this code for this form:
' Code in module
Public noi As DAO.Database
Public Sub Ketnoi()
Set noi = CurrentDb()
End Sub
' Code in form
Dim rs1 As DAO.Recordset
Private Sub Form_Load()
Ketnoi
Set rs1 = noi.OpenRecordset(" select * from LOAISACH1 order by MaLoai asc ")
Set LstMang.Recordset = rs1
LstMang.Requery
End Sub
Private Sub LstMang_Click...
|
5 |
12/6/2008 8:35:00 AM |
|
|
Network access
I have an Access VBA app on a network folder that I'd like to run
simultaneously by multiple users. I can run one instance over the
network, but not two at once, unless the second instance is from the
folder in which the app resides. The second instance doesn't even get
to the security warning. I can run one instance from any computer on
the network--so it seems not to be a matter of ...
|
9 |
12/7/2008 5:45:00 PM |