SharePoint 2007 and Access 2003
Fri, 5 Dec 2008 16:24:00 -0800
I am linking to a SharePoint list from an Access database. The SharePoint
list updates a Project Information table. A query on the Project Information
table and several other tables is the record source for a Project Information
form.
When the Project Information form is opened, an update query runs to load ...
|
MS Automation - Saving database
Fri, 5 Dec 2008 14:23:06 -0800
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 ...
|
Option to Support multiple companies
Fri, 5 Dec 2008 13:23:22 -0800
Existing DB has lots of Queries (30+) and Forms based on a single company.
Now, need to add another company. The output reports for the new company
would be the same as the existing company. Would like to avoid having to
modify all of the Querys/Forms to support both the existing and new company.
For exam ...
|
Can I bring the code of a procedure into i a textbox?
Fri, 5 Dec 2008 10:58:29 -0800 (PST)
Can I bring the code of a procedure "myfunc" in the module "mymod"
into i a textbox or variable and work with it?
Can I edit it and save it into the procedure afterwards?
I think there may be a wau using some "VBA extensibility"? but I'd
prefer not to reference that.
Thanks for any help. ...
|
Default Field
Fri, 5 Dec 2008 10:17:01 -0800
I have a field called Priority.
If the priority is high, I want to reflect today's date in a field called
Due Date.
If the priority is Medium, I want to reflect the next working day in the
field Due Date.
If the priority is Low, I want to reflect two working days in the Due Date
field.
Another ...
|
Median Calculation, Dates, & Group By
Fri, 5 Dec 2008 09:56:02 -0800
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 ...
|
acCmdAppMaximize ignored when opened w/Hyperlink
Fri, 5 Dec 2008 08:57:03 -0800
I want the Access app to maximize when it opens, and it does this if I open
it from the icon in the folder when I code the acCmdAppMaximize command. If
I open through a hyperlink in an Outlook email, the application does not
maximize? I also tried using the apiShowWindow Windows API, and I have even
more ...
|
|
|
Check whether form is is 'edit' mode
Fri, 5 Dec 2008 07:46:05 -0800
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 ...
|
Help me to solve error '2115' in this case!
Fri, 5 Dec 2008 03:47:00 -0800
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 ")
...
|
Error 52 finding if Path exists
Fri, 5 Dec 2008 00:51:01 -0800
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 ...
|
