disable double click to change window size
Hi All,
I would like to be able to disable the double clicking of the main access
window, my application starts maximized and i dont want anyone restoring it
to a window size.
Can this be done with VBA ?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201006/1
|
6/7/2010 9:06:20 PM
|
0
|
"trevorC via AccessMonster.com" <u44...@uwe>
|
|
|
Change control in dialog form
Using Access 2003.
Using VBA to change the content of a text control on a dialog form. (The
form is opened from another form using doCmd.FormOpen ,,,,, acDialog)
The value of the control will change from the form Open by simply using
ControlName = "New text" or Me.ControlName.Value = "New text"
This does not work from a function located in the form vba code.
--
RobGMiller
|
6/7/2010 6:20:32 PM
|
1
|
=?Utf-8?B?Um9iR01pbGxlcg==?= <RobGMil...@discussions.microsoft.com>
|
Access runtime ribbon - export to word option missing.
When you create a 2007 runtime application the option on the print preview
ribbon to export the report to word disapears.
I have had to create my own Ribbon code to export data to excel (see below -
this works by the way I am just positing it for info) because that option
also disappears.
Do I have to create an equivalent for word, and how would this look (needs
to cope with older version of word), or is there an easier way?
Thanks, Lou
This is what I did for Excel.
' Export whatever records currently displayed to excel. Uses late binding to
allow for different
|
6/7/2010 6:06:10 PM
|
0
|
=?Utf-8?B?TG91dmVycmls?= <Louver...@discussions.microsoft.com>
|
Insert Into -- expected end of statement error
I need to add a record into a table. I'm getting "expected end of statement"
table name: tbl_details
field: ID (key, number, long)
syntax I'm trying to use in the module:
INSERT INTO tbl_details ([ID]) VALUES (999)
Your help would be VERY appreciated!
|
6/7/2010 4:02:42 PM
|
7
|
=?Utf-8?B?bGFhdmlzdGE=?= <laavi...@discussions.microsoft.com>
|
Assistance with Output
I fould the below code demonstaring how to output multivalue fields;
Sub BrowseMultiValueField()
Dim db As Database
Dim rs As Recordset
Dim childRS As Recordset
Set db = CurrentDb()
' Open a Recordset for the Task Table
Set rs = db.OpenRecordset("Tasks")
rs.MoveFirst
Do Until rs.EOF
'Print the name of the task to the immediate window
Debug.Print rs!TaskName.Value
'Open a Recordset for the multivalue field
Set childRS = rs!AssignedTo.Value
'Exit the loop if the multivalue field contains no records
Do Until childRS.
|
6/7/2010 3:33:37 PM
|
0
|
=?Utf-8?B?Sk1heQ==?= <J...@discussions.microsoft.com>
|
Set Variable to lookup field
I need to set a string variable to a lookup field on a form.
I have two tables
"tblCase" with fields:
CaseID autonumber (key)
CaseType, text, 15 char
"tblClient " with fields:
Last_name
First_ name
CaseType, number, long (lookup to table tblCase)
etc.
In the "client" form, case type correctly displays the case type text. I
need to set a string variable to the "case type" text in the form.
The following returns the CaseTypeID which is a number, not the case type
text.
strCaseType = Forms!f_Client![case type]
The following did not
|
6/7/2010 4:08:56 AM
|
2
|
=?Utf-8?B?bGFhdmlzdGE=?= <laavi...@discussions.microsoft.com>
|
Conditional updating
I have the following working updating function which is ok:
CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72"
I want to add on a condition depending on the field “code” in the same table
products. But I do no know how to do it.I do not want to use a form but
otherwise is it possible to do it ?
What I want to achieve is the following:
If Products.code = 10153 or Products.code = 10567 or Products.code = 324555
Then
CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72"
Else
CurrentDb.Execute "UPDATE Products SET office = products.gross
|
6/6/2010 1:21:45 PM
|
2
|
"samotek via AccessMonster.com" <u15...@uwe>
|
Conditional updating
I have the following working updating function which is ok:
CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72"
I want to add on a condition depending on the field “code” in the same table
products. But I do no know how to do it.I do not want to use a form but
otherwise is it possible to do it ?
What I want to achieve is the following:
If Products.code = 10153 or Products.code = 10567 or Products.code = 324555
Then
CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72"
Else
CurrentDb.Execute "UPDATE Products SET office = products.gross
|
6/6/2010 1:21:35 PM
|
0
|
"samotek via AccessMonster.com" <u15...@uwe>
|
Sendkeys "{ESC}"
Hi
untill now I used the Sendkeys "{ESC}"/Cancel in the event BeforeUpdate, but
occassionaly I had some problems. From now on I follow the instructions of
some users in the duscussion Groep and I replaced the Sendkeys "{ESC"} by the
..Undo. It works fine except in a ComboBox. Is this normal?
|
6/6/2010 10:12:36 AM
|
1
|
=?Utf-8?B?THVjIEJhbGxvb25QbGFubmluZw==?= <LucBalloonPlann...@discussions.microsoft.com>
|
OLE, INK and Reports
Hello everyone, here is my problem.
In my app I have 7 spots where a signature can be required. They are all
OLE controls that when they get the focus they are scaled in size, 4 x, when
you double click the control paint is opened and an existing empty bmp is
opened so you can sign your name. When the control loses focus it returns to
it's original size. I also have 3 OLE controls that when double clicked they
open an Exel template file. In this Excel file all tool bars except for the
drawing tool bar are invisible. These controls are used for drawing
sketches. So I have
|
6/5/2010 9:19:35 PM
|
0
|
=?Utf-8?B?V2hpY2gx?= <Whi...@discussions.microsoft.com>
|
Select Case question - Comparing strings
I am passing variables into a subroutine, and comparing these to some
parameters in a array. If all 4 of the variables passed in are equal to 4
values in the array, I run a a loop adding values to the array.
I can make a series of If..Then statements work but cannot get the equivalent
Select case statements to work.
I am attaching the entire subroutine;
Any suggestions appreciated.
Thanks
JDB
' --------------------------------------
Sub Add_ClnLoins(idxdate As Variant, _
idxSpecies As String, _
idxclnshift As String, _
|
6/5/2010 8:11:36 PM
|
1
|
"JDB" <u60...@uwe>
|
Allen Browne's Calendar97.mdb
This may be asking too much, but does anyone know how to use the calendar
(frmCalendar) from Allen Browne's Calendar97.mdb as a subform on a main
form, rather than as a modal popup?
I would like to use the calendar's default date (today) or change to another
date as needed,obviously, but also make selections on other controls on the
main form without closing the calendar. Having a hidden text box to hold the
calendar's value would not be a problem.
I tried using it as a subform, but when I open the main form I get an error:
"The expression you entered refers to an object that is cl
|
6/5/2010 12:57:20 PM
|
4
|
"Mark" <...@mountain.net>
|
If this correct use of Select
Hi there
I want to use the following statement in the RowSource for a report but am
unsure of whether it's correct:
SELECT *, *
FROM T_Participants RIGHT JOIN T_General ON T_Participants.[Student_ID] =
T_General[StudentID_FK];
Does this look correct to anyone?
Thank you in advance for your help.
|
6/5/2010 2:29:32 AM
|
3
|
=?Utf-8?B?Zm9yZXN0OA==?= <fore...@discussions.microsoft.com>
|
show number of records updated
I have a form which selects a 'source' table and a 'destination' table and
allows the user to select fields from the source table to update or insert to
the destination table. The form generates and runs SQL code and works well as
it stands, however I want to be able to put into a log the number of records
affected as reported when you get a message if setwarnings=true.
I have seen responses to similar questions when the query exists as an
object but not when it is run as code but since there is no query object I
cannot see how to use this.
At the moment the only solution I c
|
6/5/2010 1:02:19 AM
|
1
|
=?Utf-8?B?Q0o=?= <...@discussions.microsoft.com>
|
quantifying overlapping time spans
Hi all,
I am trying to write a query to calculate the amount of time that any two
individuals overlap in their use of a location. My table currently looks like
this:
Date Time IndividualID ArrivalTime DepartureTime
Individuals can arrive and depart at different times, and stay for different
amounts of time. Individuals remain at the location for as little as a few
seconds or up to 20 minutes. I am trying to determine the following:
1) for each pair of individuals, how much time were they both at the location?
(shared presence)
I need the results to appear something
|
6/4/2010 11:46:56 PM
|
1
|
"EHobs via AccessMonster.com" <u60...@uwe>
|
"%" character
I am using the following code:
Val(strValue)
where strValue = "0.1%"
I am getting a type mismatch error.. what does the "%" character do to a
string?
|
6/4/2010 11:42:21 PM
|
1
|
=?Utf-8?B?V2F2ZXF1YXRpb24=?= <Wavequat...@discussions.microsoft.com>
|
Form Name as Variable
Hi,
I have the following subroutine:
Public Sub SetMeterBasic(p As Single)
' This subprocedure is used to update the progress meter bar
With Forms![FormA]
.shpMeterBar.Width = p * .lblMeter.Width
.lblMeter.Caption = Format(p, "##%")
.Repaint
End With
End Sub
FormA is a form from which I called the main subroutine of the program which
then later called this procedure. Is there a way I can pass a form name to
Sub SetMeter e.g. so its first line is Public Sub SetMeterBasic(p As Single,
FormName as String) where the variable FormName can function as "FormA" does
|
6/4/2010 9:36:02 PM
|
1
|
=?Utf-8?B?Q2hhcmxlcw==?= <Char...@discussions.microsoft.com>
|
Calendar control conversion issue
Hi all,
I still do most of my development at home using Access97. At work, I convert
the FE to the default 2000 format on a computer running Access 2002(or maybe
it's 2003, I'm not sure which). I can then distribute that converted FE to
either Access 2002/2003 and Access 2007 computers and everything works fine.
Someone showed up with Access 2010 and the Calendar Control that I use
(MSCAL.Calendar.7 on the Access97 computer) produces a "cannot open object"
(or similar) error message when I try to open the form that contains that
control. I've not run into other problems on the 2010
|
6/4/2010 9:29:12 PM
|
3
|
"Mark" <...@mountain.net>
|
Checking for Null & Select Case
I have a form called fSearchforCompany with two unbound fields. After
selecting a field from lstQuickSearch (list box) and tabbing to txtSearchBox
to enter data, the correct form should open with the text from txtSearchBox
entered into the designated field. But, first the code should check for null,
and if Null, open the correct form.
The problems are the code is not doing anything on Null and when there is
data it is not selecting the data.
The two fields are:
1. lstQuickSearch
ControlSource is empty
Row Source = 1;"Company ID";2;"Company Name";3;"Dat
|
6/4/2010 8:54:19 PM
|
14
|
"lmcc via AccessMonster.com" <u59...@uwe>
|
run query message
Every time a SQL statement is ran the "run query" message is display in the
status bar, is there a way to prevent this so a useful message could be
displayed?
Thanks
Jim
|
6/4/2010 8:26:06 PM
|
2
|
=?Utf-8?B?YWlub3c=?= <ai...@discussions.microsoft.com>
|
Public variable
I am calling a public sub from a form, and I am trying to get the sub to be
able to access a variable from the form. I declared the variable as public
in the forms code, but it isn't available to the subroutine... is this normal?
|
6/4/2010 4:28:19 PM
|
1
|
=?Utf-8?B?V2F2ZXF1YXRpb24=?= <Wavequat...@discussions.microsoft.com>
|
"item not found in this collection"
I try to send mass emails in my VBA codes, but I got the above error message.
Can you help me to debug it. Here are the codes.
Dim email1 As String
email1 = "a@hotmail.com" + ";" + "b@yahoo.com" + ";" + "c@c.com" + ";" +
"d@d.com" + ";" + "e@e.com" + ";" + "f@pony.ocn.ne.jp"
Dim email2 As String
email2 = "g.1@g.com" + ";" + "h.52@h.com" + ";" + "i.34@i.com"
Dim strEmail As String
Dim strE As String
Dim rstE As DAO.Recordset
strE = "SELECT * FROM qryPullDataForEmails"
Set rstE = DB.OpenRecordset(strE, dbOpenDynaset)
rstE.MoveFirst
Do Until
|
6/4/2010 3:35:55 PM
|
5
|
=?Utf-8?B?VGlt?= <...@discussions.microsoft.com>
|
VBA Reference Libraries-Access 2003 vs 2007
I'm in the process of converting from Access 2003 to Access 2007. When I
converted my 2003 db to 2007 the VBA code would not run. I changed the
Reference libraries in 2007 to match what I had in 2003 and then the code
worked. I'm looking for some clarification on what the difference is between
my 2003 set up and the default set up for 2007. What is the difference in the
libraries?
All of the references were the same in 2003 and 2007 except for the following.
2003
Microsoft DAO 3.6 Object Library
2007
Microsoft Office 12.0 Access database engine Object Library
Microsoft Vi
|
6/4/2010 2:00:19 PM
|
6
|
=?Utf-8?B?ZGpm?= <...@discussions.microsoft.com>
|
create a form that collects parameters
Hi,
i need a form where we search for a detail and the result should be
published in the bottom, based on the result the user will decide what to do
next in acess 2007.
i refered the link below
http://office.microsoft.com/en-us/access/HA100963141033.aspx#form_param
in this some mistake is there in the macro can somebody help me out.
if any template for search form is available please let me know.
thank you,
--
Kalai
|
6/4/2010 11:35:14 AM
|
1
|
=?Utf-8?B?S2FsYWk=?= <Ka...@discussions.microsoft.com>
|
Updating .nsf lotus notes server file - from access
Hi,
Using the below code i can fetch data from the .nsf file kept in the server.
Dim LotusWizard As DAO.Recordset
Dim session As Object
Dim notesdb As Object
Dim notesView As Object
Dim NotesEntry As Object
Dim notesdoc As Object
Dim Item As NotesItem
Dim doccollection As Object
Dim datetime As NotesDateTime
i = 0
Set session = CreateObject("Notes.NotesSession")
Set notesdb = session.GetDatabase("Server", "path\file.nsf")
'Check if open
If notesdb.IsOpen = True Then
Else
notesdb.OPENM
|
6/4/2010 8:22:33 AM
|
2
|
=?Utf-8?B?Qm9zcw==?= <B...@discussions.microsoft.com>
|
populate a text box with multiple records based on combo box selec
Hi,
I have made one form with a combo box (dropped down) , a search button and a
Text box. when a user selects a value (ie. Project No.) and click on search
button the text box should display all the records which is related to that
Project no. The search record should display Drawing no., description , date
created etc. in a datasheet view from the table "Drawing details". the
searched result can be one or more.
can anyone help me with the code. How to search records and display it in
text box.
Thanx
AP
|
6/4/2010 4:20:54 AM
|
2
|
=?Utf-8?B?QVA=?= <...@discussions.microsoft.com>
|
Like operator case sensitive
I need to look for a case specific letter in a string (e.g. I need to be able
to distinquish "m" from "M"). Is there a way to test for case?
|
6/3/2010 11:37:40 PM
|
2
|
=?Utf-8?B?V2F2ZXF1YXRpb24=?= <Wavequat...@discussions.microsoft.com>
|
Running a continuous VBA loop while allowing the user to click but
I want to run a VBA loop that increments a progress bar but allow the user to
click buttons on the same Window that activated the loop to perform various
actions. I've tried the standard Timer loop using DoEvents but sometimes
clicking the buittons works and sometimes it doesn't. Any suggestions?
|
6/3/2010 10:22:14 PM
|
1
|
=?Utf-8?B?RGF2aWQgVw==?= <Dav...@discussions.microsoft.com>
|
SQL statement with LIKE need to show Numeric paceholders
I have a need to find 4 digit or 5 digit numbers.
strAppend = "INSERT INTO PurchasingTable ( PurchaseOrderNumber, WorksNo,
Code, PO_Sum )" _
& " SELECT [OrderNumbers Query1].PurchaseOrderNumber, [OrderNumbers
Query1].WorksNo, [OrderNumbers Query1].Code, Sum([OrderNumbers
Query1].[SumOfSum Of ExtPrice]) AS PO_Sum" _
& " From [OrderNumbers Query1]" _
& " GROUP BY [OrderNumbers Query1].PurchaseOrderNumber, [OrderNumbers
Query1].WorksNo, [OrderNumbers Query1].Code" _
& " HAVING ((([OrderNumbers Query1].WorksNo) Like '%____%' Or ([OrderNumbers
Query1].WorksNo) Like '%_____%') And (
|
6/3/2010 9:52:53 PM
|
2
|
=?Utf-8?B?QmlsbHA=?= <Bi...@discussions.microsoft.com>
|
Unsaved Record Indicator
I do not want the record selector displayed. Is there a way to fake an
Unsaved Record Indicator using an image? I tried:
Private Sub Form_Current()
Dim ctl As Control
If Me.Controls!ctl.Change Then
Me.Image124.Visible = True
Else
Me.Image124.Visible = False
End If
End Sub
Of course, it didn't work.
Has anyone done this or have any ideas?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201006/1
|
6/3/2010 9:52:15 PM
|
2
|
"lmcc via AccessMonster.com" <u59...@uwe>
|
access form not listed in access class object
I'm using Access 2007. I have several forms that are not listed in the
"Microsoft Office Access Class Object" list. I've searched on-line help to
no avail.
How can I add it?
Your help will be greatly appreciated!
|
6/3/2010 9:31:19 PM
|
4
|
=?Utf-8?B?bGFhdmlzdGE=?= <laavi...@discussions.microsoft.com>
|
Create Table with Date Appended
How would I create a new table (tblNew), based on information in an existing
table (tblCurrentData), with today's date appended to the end of the tblNew
name? ( ie: tblNew06032010)
What I am trying to do is, I need a mechanism to store the last four days
worth of data so that comparisons can be made. I can then delete the tables
that are at least 5 days old.
|
6/3/2010 7:56:29 PM
|
3
|
=?Utf-8?B?Q2F0aHk=?= <Ca...@discussions.microsoft.com>
|
.iqy in Access
Is it possible in MSAccess to convert or reproduce in VBA a .iqy ?
I need to bring the data that the .iqy will extract directly in an Access
table
without using Excel at all.
--
Message posted via http://www.accessmonster.com
|
6/3/2010 7:31:24 PM
|
0
|
"Fuz via AccessMonster.com" <u60...@uwe>
|
Navigation Button error (using Access 2007)
I am using my own Navigation Buttons for my form with an lblNavigate label.
(I created lblNavigate on the form by using three spaces.) I am using
lblNavigate to try and duplicate the record "x of y" label that appears in
the standard navigation toolbar). I found some code that works except for
one problem: When I open the form it says 1 of 501 instead of 1 of 1564. I
have to press the Next button and then the previous button to get the
accurate count. Any ideas of what’s causing this error?
I put the below code in the form's On Current Event:
Private Sub Form_Current()
|
6/3/2010 5:45:16 PM
|
3
|
"lmcc via AccessMonster.com" <u59...@uwe>
|
Code Event Criteria
All,
how can, with the code below, have the f![Location] = Filename line to only
run if everything else occured?
Function SaveAppItem()
Set f = Screen.ActiveForm
surl = f![Hyperlink]
Filename = "\\Bcp\bcp\cmcc\cmcdb\20080922_CMCDB2\Documents\CE\Appendix\" &
f![UpdateNum] & ".pdf"
'With CreateObject("Wscript.Shell")
'Shell ("explorer.exe Filename")
Sleep (3000)
Dim oIExplorer: Set oIExplorer = CreateObject("InternetExplorer.Application")
oIExplorer.Navigate surl
oIExplorer.Visible = True
Sleep (3000)
Do: Loop Until oIExplorer.ReadyState = READYSTATE_COMPLETE
Sleep (200
|
6/3/2010 2:12:57 PM
|
2
|
=?Utf-8?B?dGlnaGU=?= <ti...@discussions.microsoft.com>
|
Error messages as if "Option Explicit" were declared, but it isn't
Hi,
I have a database that I and one other user access. I run reports, she does
data entry. We've both been using the db for over a year, and I've made no
recent modifications. As of today, she is unable to process, because I have
some validation code on the back-end of the data entry form that generates
errors. It fails exactly as if "Option Explicit" were declared, but it isn't.
It works fine on my computer, but I was able to replicate the errors by
introducing the Option Explicit statement. The error message may be the same,
or may be different, I don't have access to her m
|
6/3/2010 12:44:12 PM
|
4
|
=?Utf-8?B?VGltIEdyZWVu?= <TimGr...@discussions.microsoft.com>
|
Filter Records after FindRecord
I created a cboQuickSearch combo box, where I can choose the field I would
like to search on. The txtSearchBox text field is where I enter the search
data. I have three issues:
1. I would like to filter the records once found.
2. I want to be able to enter a few characters instead of having to
enter the whole word.
3. Is there shorter code to do the same thing?
Below is the code I created:
Private Sub txtSearchBox_AfterUpdate()
If Me.cboQuickSearch.Value = 1 Then ' Company ID
Me.txtCompanyID.SetFocus
If Not IsNul
|
6/3/2010 4:24:02 AM
|
2
|
"lmcc via AccessMonster.com" <u59...@uwe>
|
Access 2000 to 2003, get error 438
Hello,
We have a Access 2000 program which is running fine on old PC. After we
changed to new PC(Win7 with Office 2003), we can't get it work correctly
anyway. When running the fuction, we always got "error 438: Object doesn't
support this property or method". We check the references, all are
registered.
The problem code is the first line:
If [Forms]![aMAPIStsF].Form.MAPISess.NewSession Then
MsgBox "Session already established"
Exit Function
End If
Any advice?
Thank you very much.
Fox
|
6/3/2010 3:59:01 AM
|
3
|
=?Utf-8?B?Zm94?= <...@discussions.microsoft.com>
|
What is the meaning of the "$" in say the left$ function
Hi Guys,
Just a quick question with regard to the dollar sign at the end of the Left,
right, mid etc type functions.. i do not know what the $ means and am unable
to find/track down what it means ??
Does anyone know when /where it should be used??
The help is unhelpful in this particular case!!
Many thnaks for your support!!
Cheers,
|
6/3/2010 2:29:57 AM
|
3
|
=?Utf-8?B?RG9udEtub3c=?= <DontK...@discussions.microsoft.com>
|
Get Displayed Text of a ComboBox
I've been playing with programically getting the text value of a ComboBox,
but I keep getting an error message that the control has to have the focus
in order to reference the .Text property. If I explicity set the focus, I'm
able to get the value without any problems.
Is this normal?
|
6/3/2010 1:58:22 AM
|
2
|
"David C. Holley" <David.C.Holley>
|
Complex query problem
Just because MS wants to stop using Usenet doesn't mean we have to.
:-)
Anyway, I'm trying to figure out a way to export survey results from
an Acc2k3 db to Excel for number crunching. I have a BUNCH of columns
(227 fields broken into 7 sections, representing each question of the
survey) with the possible answers for each one being Yes, No, or N/A.
I need to count the number of each response for each question. A
simple crosstab ain't gonna do it. I could do individual IIf's for
reach response for each question but that would literally triple my
column count (and amount of effort) in
|
6/2/2010 4:56:22 PM
|
2
|
RD <pr...@mming.zen>
|
Help with vba autorunning macro?
Hello,
How do I automate (write code in Access) to tell it to run a macro I had
created in Access everyday at 6AM?
I tried using Windows XP Task Scheduler, but it didn't work. Any help is
appreciated. THanks
|
6/2/2010 2:47:01 PM
|
2
|
=?Utf-8?B?Q2Ft?= <...@discussions.microsoft.com>
|
How to delete embedded Word object?
I have an embedded Word document in an unbound object frame. I want to delete
the object from the object frame using VBA. How do I do it?
My goal is to let the user select Word documents and edit them in-place in
the unbound object frame, so I have to remove the existing object and replace
it with another. I've tried changing SourceDoc, but it does nothing. I've
tried setting the Action to acOLEDelete and that also does nothing.
|
6/2/2010 1:53:01 PM
|
3
|
=?Utf-8?B?Qmx1ZUJ1bGxEb2c=?= <BlueBull...@discussions.microsoft.com>
|
Setting a subform to a member of a collection
I'm attempting to write a class module that will act as a multiple
subform manager.
I've got a form in Access 2007 which has a large empty subform
container, a list box, and a set of command buttons for opening up a
couple of types of subforms and doing a couple of other things. The
subform is simply a holder for the currently active form; in no case
is there any need for a parent/child relationship. The idea is that
this database is an event log and we have a couple of different
subforms that we use to record different types of events during a work
shift. I need to be able to open up
|
6/2/2010 11:12:17 AM
|
2
|
Dennis Snelgrove <snelg...@computan.on.ca>
|
Modules
If remote data files has to get appended to the remote DBs; Is it better to
add modules in remote DBs and invoke them locally or better to link tables to
local DB and do everything from local DB?
Secondly, any VB module or macro that can add user to a DB or its mdw?.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/201006/1
|
6/2/2010 8:59:01 AM
|
1
|
"igg via AccessMonster.com" <u53...@uwe>
|
Copy Photo To Clipboard
I have a database that catalogs photos. The photos are located in varies
folders based on date taken, special events, etc. The photo name and path is
sorted in a table along with associated information. Knowing the path, is
there a way that I can click a button and copy the photo to the clipboard?
Thanks
Jim
|
6/2/2010 2:40:01 AM
|
0
|
=?Utf-8?B?YWlub3c=?= <ai...@discussions.microsoft.com>
|
Make new Outlook Contacts, Update existing Outlook contacts via packaged program
I need to be able to send my database (contact information) to several users
in various parts of the country. What I'm looking at is if I can package
just my "PersonInformation" table and have a command button on a form that
the user would click. This would 1) update existing contacts (I already have
a unique ID set up that would be the link between the old and new) if the
contact exists, 2) create a contact if it doesn't exist, 3) delete a contact
as needed.
I wouldn't need to compare the Outlook contact with the information to import
as I could just overwrite the necessary fields
|
6/2/2010 1:40:13 AM
|
1
|
"prairiewind via AccessMonster.com" <u33...@uwe>
|
Auto FE Updater
I have been successful so far at completing the steps and understanding how
the Updater is to work on the workstations but in running a test to ensure
what I am changing is actually being updated to the workstations, I run into
a problem. When I first copied the database to the workstations, they all
were missing the following reference..outlctlx.dll but i added the reference
to each workstation when I opened the database and each time I opened it was
fine and didn't ask for the reference. But now when I make a change to the FE
and the user clicks the icon to the updater, the following
|
6/1/2010 6:54:50 PM
|
4
|
"Konchetta via AccessMonster.com" <u22...@uwe>
|
Can I Share a MDE (which only has VBA Code) with other apps?
I am using Access 2003, and I was thinking of creating a databe with just VBA
code in modules. There will be functions in there that I would like to
reference with other applications.
Is it possible for me to reference some of the functions in the MDE database
with Excel and use the function I was created in the MDE ???
Thanks,
G
|
6/1/2010 6:22:01 PM
|
2
|
=?Utf-8?B?Rw==?= <...@discussions.microsoft.com>
|
How to Export VBA Code to a text file
Howdy.
Is there a built-in function for exporting ALL VBA code in a database to a
text file? I can do it for each VBA object - form, report, and module - but
this takes a long time.
Thanks.
Danny
|
6/1/2010 5:40:04 PM
|
2
|
=?Utf-8?B?RGFubnk=?= <Da...@discussions.microsoft.com>
|