|
Difference Between Global Const and Public Variable
Hi,
I have an application where a user must sign in before continuing.
Would it be better to assign the user's sign in status to a public
variable or a global constant or are these virtually the same......
|
6 |
12/19/2008 7:22:03 PM |
|
|
Which event to use to detect combo-box selection?
Which is the best event to use to detect changes in a combo box selection?
I need to detect the date/time of every change to a combo box selection even
if it changes multiple times before the BeforeUpdate event.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime"....
|
3 |
12/19/2008 7:14:48 PM |
|
|
Access 2002 MAR not opening in 2003
I have some reports that were created in Access 2002. We now have several
2003 users and they are complaining that they can't open these reports. An
error pops up that eventually seems to incriminate the code below as not
being valid in Access 2003. Just wondering if anybody might spot a problem
with this code, or have other suggestions on how to fix this.
Option Compare Database
...
|
5 |
12/19/2008 6:41:49 PM |
|
|
Linking to Documents in Sharepoint Via an Access Form
Hi All
I am working on a database being built in Access 2000 - the client
wants to link do documents stored in Sharepoint - I have no problems
creating links to documents on a hard drive location but have never
done any links to Sharepoint.
All I really want is a way to grab the link to the document on
sharepoint and then when the user clicks on the link have document
opened
Question...
|
1 |
12/19/2008 4:43:22 PM |
|
|
Deleting a row - Efficiency question
I need to delete a row from a table if it is there (it may or may not be).
Is it better to first do a select to see if its there, then delete it if
present or just always do the delete which may not delete anything? I'd say
most of the time the row will not be there. Thanks.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime"....
|
3 |
12/19/2008 4:30:56 PM |
|
|
Word does not present mail merge prompt from Form button
I have created a word doc that has a mail merge connection to an Access table.
When I open the doc from Windows Explorer I get the prompt "Data from
database will be placed in the document. Continue?"
However when I open the doc from a form button i do not get this prompt and
I have to run the Open Data Source procedure.
I use the following code:
Dim LWordDoc As String
Dim ...
|
1 |
12/19/2008 3:35:01 PM |
|
|
Command button errors in forms
Hi Guys and Gals
This is kind of a revisited topic. Please refer to my post on 15/12/2008
entitled Errors loading/opening forms using command buttons.
The problem I am having is similar to the previous issue. Last time I
created forms in 2007 and when I used them in 2003 the error occurred as
described in the previous post. That was solved by creating a fresh
database in 2003 on a mach...
|
3 |
12/19/2008 2:53:05 PM |
|
|
Listbox, Dropdownbox, Data in one column not visible
We use MS Access for our Account Managers, we work with a front.mdb
and a back.mdb. At some point in time (say two weeks ago) a listbox
shows all records however one column (field) is not filled. The source
for this listbox is a query. When I run the query, it shows all
records and all data in all columns.
The same for a dropdown box, this will show all records but this
specific column sho...
|
3 |
12/19/2008 1:24:30 PM |
|
|
Passing a Where cause to a report
When and while in a form I start a report, the report opens, and it's
query reads the content of a listbox so that query's where clause
works as expected. It works OK, no problem.
In order to use the same report with other forms, I need it to work
the other way around: to pass the where clause to the report.
The problem is that the report has it's own query and I don't know how
to combin...
|
3 |
12/19/2008 10:03:40 AM |
|
|
Errors loading/opening forms using command buttons
Hi Guys and Gals
I have a database that was originally created in Access 2000, then modified
in 2003 before I got it. I have since upgraded it to a 2003 format file and
it has since been modified in both Access 2003 and 2007 depending on what I
was doing.
All of the original objects have been deleted after migrating old data to
new tables to remove design flaws.
Finally, I am at t...
|
4 |
12/19/2008 8:50:22 AM |
|
|
RecordSet Unable to Update?
hi,
There is this 'funny' situation I don't quite understand.
1. I had a recordset open>> rd.Open table, conn, adOpenStatic,
adLockPessimistic
2. Data is able to be extract and perform arithmatic operations.
3. Programatically I tried>>
OnCancel_Button_Click()
TotalDays_Text = CDec (TotalDays_Text)
Taken_Text = CDec (Taken_Text)
Balance_Text = CDec(Balance_Text)
'Bef...
|
11 |
12/19/2008 7:00:30 AM |
|
|
Top N values using textbox
How do I use a textbox to decide on the top number of records in a query? Eg.
If I want Top 12, I will enter 12 into the textbox and so on.. Click a button
and the query will open with the Top 12 customers.
Below is my Select SQL statement. I want the Top 10 to be controlled by a
textbox.
SELECT TOP 10 qryTblOrders3.custcode, qryTblOrders3.CustName,
Sum(qryTblOrders3.Sales) AS Top10S...
|
4 |
12/19/2008 6:27:00 AM |
|
|
Value pushed to textbox doesn't invoke LimittoList
I have a form that uses a combo box called txt_Status with 3 options,
Draft, In Process and Approved. When the Status box is Approved, it
pushes the persons name from the thru code by using Environ
("Username") to a combo box called txt_Senior. Txt_Senior is a combo
box with 6 persons names in the list. It also has Limit to List
enabled. I have code in the Not in List of txt_Senior that te...
|
4 |
12/19/2008 5:12:16 AM |
|
|
Computer Freezes Up
I’ve got something in my programming for a form that freezes up the computer
when certain unknown conditions occur. I imagine it’s got to be a loop in my
logic, but I can’t find it. I’ve stuck counters in a number of spots in the
code so when the counters hit 50 they will stop the code in debug mode, but
it must not hit the counters because they don’t stop it.
From the stand...
|
3 |
12/19/2008 4:08:08 AM |
|
|
Formatting currency to show cent symbol
I have to refer to a series of currency amounts (less than $1 each). I can
easily format them to show "$0.45"; is there any way to show that as 45
cents (using the cents symbol)?
...
|
2 |
12/19/2008 4:00:26 AM |
|
|
form question
I am new to Access (2003), and am having a basic problem that I think
should
be easy (but it's obviously not for me).
I have two tables, lets call them customers and invoices. The invoice
table has
the customer id in it.
I want to create a new form for data entry for invoices. Since every
invoice has
to have a customer, I want to make it easy for the data entry operator
to be able
...
|
2 |
12/18/2008 10:47:34 PM |
|
|
Combo is null
I have 3 unbound combos on a form. Combo2's rowsource uses combo1's value as
criteria. Combo1's AfterUpdate Event requeries combo2. Upon making a
selection in combo1, there are no choices in combo2. Also after update of
combo1, if Combo1 = "this value" then do this. In testing with a code break
there, combo1 is null even though "this value" is selected.
Combo1 Rowsource:
SELECT DIS...
|
5 |
12/18/2008 10:42:07 PM |
|
|
pressing the button without... pressing the button - mouse click?
I have a button on a form, which has to be pressed repeatedly an awful lot of
times (it's a quiz answer reveal button).
My question is..., can I somehow have it so the mouse can be clicked
anywhere else on the screen, or just simply clicked 'nowhere' without
explicitely having to press the button, (which is very uncomfortable after a
period of time), but still actions the button code. ...
|
3 |
12/18/2008 10:04:01 PM |
|
|
error 2105
Hello,
This was working fine until today.
I have a form with a subform. When I enter in the information on the form, I
have an "Add" button that moves the information to the subform. Today when I
tried to use it, it is giving me a runtime error 2105 and highlights my docmd
line. Please help me figure out what the problem is.
Private Sub cmdAdd_Click()
Me.subForm.SetFocus
DoCmd.GoToR...
|
4 |
12/18/2008 8:41:01 PM |
|
|
using batch file
On each user's machine is a copy of the mde front end. To open it, the user
double clicks an icon. Eventually the icon will be a batch file that will
run some processes and then finally open the mde file that is located on
everyone's machine. But, the batch file is not working properly in that an
"Automation error" appears just as the mde opens. I have traced it thru to
the line belo...
|
3 |
12/18/2008 7:25:01 PM |
|
|
Populate a combo box from another combo box
I have two combo boxes cmbApp and cbName
cmbApp RowSource is this: SELECT Application.ID, Application.Name FROM
Application;
And cbName is this:
Me.cbName.RowSource = "SELECT Deployment.[Verison] FROM Deployment INNER
JOIN (Application INNER JOIN Deployment_Application ON Application.[ID] =
Deployment_Application.[ApplicationID]) ON Deployment.[ID]=
Deployment_Application.[Deployment...
|
4 |
12/18/2008 6:14:02 PM |
|
|
cummulative sums
I have a form where I enter a date and amounts. It is set up where several
records may have the same date but different amounts. Also, earlier dates
could be entered after later dates. I have a text field where I am deducting
a cummulative amount from a fixed amount. When I am at any given record, I
would like to take the cummulative amount of a field for the year up to that
date.
...
|
2 |
12/18/2008 6:12:18 PM |
|
|
Clear items selected from multiselect list box
I have a form bound to a table (dt_accounts) with an unbound listbox that I
have set up to insert multiple records into another table (dt_accountrole)
that has a many to 1 relationship to the table the form is based on. The
field Account_id is the primary key in dt_accounts and a foreign key in
dt_accountrole. For every selection in the list box, a record is entered
into the dt_account...
|
3 |
12/18/2008 6:07:05 PM |
|
|
subform field and a combobox
I have a form that is a continuous form. In the footer of the form there is
a combobox. This combo box shows the same info as a field in the continuous
section of the form. What I am looking to do is have the combobox in the
footer show the info from the other field when the user selects the record.
And I am drawing a big blank on how this would be done. The code would be in
the On-...
|
2 |
12/18/2008 5:23:00 PM |
|
|
Auto name input
I would like to add a field in my form that will display a list of the user's
as the letters of the last name are typed i.e. auto find.
Is this feature available in access or must it be coded?
thx in advance for the feedback....
|
5 |
12/18/2008 2:32:01 PM |