|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Tuesday, 8 August 2006
|
| runtime error 2110 can't move focus Guest 00:49:46 |
| | I have a combo box in which a user can select a number of "1" or "0".
if the user selects "1" it changes the visible property on other
controls that were initial set to "Flase" to "True" .
the code works until i added the set focus.
why do i get this the runtime error? it says it cannot move the focus
to the control.
the cboVehicleLog IS enabled and NOT locked
here is my code:
If tester = "1" Then
cboVehicleLog.Visible = True
cboFleet.Visible = True
cboVehicleLog.SetFocus
End If
|
| |  1 answer | Add comment |
|
| Upsizing Wizard - OH PLEASE HELP................ Anns via AccessMonster.com 00:40:13 |
| | ok, I used the wizard (1st time) to upsize to SQL Server 2005. Once I
completed the wizard, I remote logged in (at work) to SQL Server 2005 and
went to the Manager and I seen that it pulled it over (objects - folders),
but when I go to double click on the tables to see all my tables, it shows
none. What did I do wrong?
Is there a way to do this from SQL 2005?
On one of the steps during the wizard, it asks if I want to check/add
attributes to the already tables, do I check any of these. I just want to see
my tables/BE in SQL
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200608/1
|
| | Add comment |
|
| Don't link to system tables in backend rdemyan via AccessMonster.com 00:35:31 |
| | My front-end code manually links to the backend file.
I was wondering what stops Access from linking to the system tables in the
backend file. Is it just by virtue that they are hidden?
This has recently come up because I've been playing around with converting my
front end to A2003 format. At some point, I had a corruption issue with a
system file MSStorage something. Access kept saying it couldn't find it.
When I looked in the db Window I could see a link to it.
So I ran the code that deletes all links and then restarted my app. At
startup the app recreates all links. That solved the corruption problem.
But it got me thinking about the linking to backend system files.
Should I explicitly include VB Code that prevents linking to system tables
(and maybe other tables that I'm not aware of) contained in the backend.
Thanks.
--
Message posted via http://www.accessmonster.com
|
| | 13 answers | Add comment |
|
| Slow record navigation Andy Khosravi 00:30:54 |
| | I'm having a problem trying to optimize the performance of one of my
A97 databases. I have very slow record navigation after a change I made
to the table structure, and I'm not sure how best to correct it.
For purposes of explanation, lets say I have two tables: tblIssues and
tblLocationHistory. The tblIssues table contains 'incidents' along with
the incident header information. The tblLocationHistory table contains
a list of all locations that incident has been to along with time
stamps and owner information.
tblIssues
PK: IssueID (autonumber)
~Many misc fields
tblLocationHistory
PK: HistID (autonumber)
FK: IssueID
OwnerID
Location
DateBegin
DateEnd
I have a primary form, which contains information from tblIssues that
contains a button to pull up another form, which then shows that issues
location history. This works just fine.
The problem is that I need to show the original location (first record
for that issue in tblLocationHistory) as well as the last location
(last record for that issue in tblLocationHistory) on the Primary form
for a 'dashboard' view.
Originally I tackled this problem by adding de-normalized fields in
tblIssues that contained the original and current location. At the time
I figured the performance gain and simplified query structure would
outweigh the problem of trying to keep the current and original
location information in tblIssues correctly synchronized with the data
in tblLocationHistory. Turned out I was wrong. Despite my best efforts,
there were still occurrences where the two were not synchronized, and
it created major workflow and reporting problems when it did occur. So,
I decided I would try and do it properly and represent those fields
with queries rather than duplicate data fields.
First, I built a query (qryOrigin1) based on tblLocations that
performed a Totals function to GroupBy IssueID and display the Min of
HistID for original location. (I did same thing but Max of HistID for
Current Location) I then created another query (qryOrigin2) which
utilized the results of qryOrigin1 to display the rest of the fields in
tblLocationHistory. The queries qryOrigin2 and qryCurrent2 were then
linked to tblIssues in another table and used as the datasource for the
primary form. It works great (really fast) except for one big problem:
the fields on the form were no longer updateable because of the sum
functions performed in qryOrigin1 and qryCurrent1.
I started over and tried something else. I returned the datasource of
the primary form to tblIssues and used dLookup functions to access the
information in qryOrigin2 and qryCurrent2. The fields on the primary
form were now updateable, but now those fields with the dLookup
functions were taking north of four seconds to display after a user
navigated to a new record. This was an annoyance for users, so I tried
a new method.
This time I created two separate sub forms on the Primary form that
contained the Current and Original location moves. This solved the
problem of the information taking 4 seconds to display, but also
introduced a new problem. Record scrolling now takes over 1 sec going
from one record to the next.
I had assumed A97 set up the sub forms to automatically requery the
entire dataset displayed in the subforms with each record move, so I
tried removing the linkchild fields and applying a filter instead on
the OnCurrent event. While this worked, there were no observed
performance gains.
At this point the only thing I could see doing to increase the
performance would be to transfer everything over to a manually coded
recordset. That sounds like a PITA, and I'd like to avoid it if
possible.
Right now, this slow performance is not much more than an annoyance for
users. However, the database is set to grow in size significantly and
I'm worried that these annoyances will turn into more serious
performance issues. It seems to me that if it's possible to make a
single query that can display everything I want it to and has great
performance (but is read only), I should be able to recreate something
that is editable and has similar performance. Since I'm almost entirely
self taught, I'm wondering if there isn't a more practical way to go
about doing this that I don't know about.
Thanks in advance for any advice any of you might add
|
| | Add comment |
|
| Access to Word Mail merge Simon 00:14:39 |
| | on my database i have a customers Table (tblCustomers) on the form of
it (frmCustomers) i would like a button what will open up word and open
up my comapny letter head template and then merger the customer details
currently on the form into the Word letter so i can send an individual
letter.
Can any one help me
Thanks
Simon
|
| | 4 answer | Add comment |
Monday, 7 August 2006
|
| Form General question Erick-Flores 20:57:06 |
| | Hello all
quick question, how do I make my form to not show the record navigation
at the botton/left of the form. I just want to use my form for input
data, but i dont want to see that navigation bar.
Thank you
|
| | 1 answer | Add comment |
|
| Running Sum / Cumulative Total Graph James Hallam 20:16:42 |
| | I have searched through the news groups and found many threads close to
what I want but cannot get any of them to work...
I have a table with expenses and invoices, what I want is a bar chart
with value on the y-axis, time on the x-axis and two series...
cumulative expenses and cumulative invoices so I can compare them
against each other against time.
What I have tried to do is create a runing sum column using the SQL
code as follows...
SELECT qryAllOut.mKey AS [Key], Sum(qryAllOut.mAmount) AS
CumulativeOut, DSum("[mAmount]","[qryAllOut]","[InOutQuote] = 'Out' And
[mKey]<=" & [Key] & "") AS RsumOut,
DSum("[mAmount]","[qryAllOut]","[InOutQuote] = 'In' And [mKey]<=" &
[Key] & "") AS RsumIn, qryAllOut.mDate
FROM qryAllOut
GROUP BY qryAllOut.mKey, qryAllOut.mDate;
The gives me a column of cumulative expenses going out, and a
cumulative invoices going out. However this table looks something like
this...
mKey SumIn SumOut Date In/Out
-------------------------------------------
1 1000 31/03/2006 In
2 2000 28/04/2006 In
3 4000 05/06/2006 In
4 4000 50 10/03/2006 Out
5 4000 150 15/03/2006 Out
etc.
Firstly is their any way to stop the SumIn column registering a value
when the In/Out value is Out? Otherwise this screws up my values when
i reorganise by date.
Is it possible to do running total by data and not using the unique
key.
Is it possible to not use SQL all together and create sum kind of
function in VBA to do it (I hate SQL and am much more familar with VBA)
My only other problem is that when I try to create a graph out of what
I have, it will not let me assign the Sum of the columns SumIn and
SumOut only the count... this is because the columns are defined as
text and not numeric values - however SQL will not allow to change
these column as it results in an error in my code.
Please help as I am pulling my hair out here! SO frustrating!
Cheers,
James Hallam
|
| | Add comment |
|
| Page footer with page total and previous page total CaptainDahlin 19:47:00 |
| | I know the basics about access reports and putting page totals in the
page footers. What I can't figure out is along with the current page
total to display the previous page total:
At the bottom of every page:
Page 1 page footer:
Total brought forward= $0.00
Current Page total = $100.00
Grand Total= $100.00
Page 2 page footer:
Total brought forward= $100.00
Current Page total = $75.00
Grand Total = $175.00
Page 3 page footer
Total Brought forward= $175.00
Page Total= $20.00
Grand Total= $195.00
How can I get the the previous page total to display if the code
automatically resets
the page total to zero when it draws the next page?
Here is the code for doing the page totals in the page footer:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
txtPageCashSum = txtPageCashSum + txtDonorCashAmmount
txtPageCheckSum = txtPageCheckSum + txtDonorCheckAmmount
End Sub
Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As
Integer)
txtPageCashSum = 0
txtPageCheckSum = 0
End Sub
page tw$
|
| | Add comment |
|
| Problem with SetFocus Vincent 19:23:23 |
| | From an Access form, I am trying to change the focus from a flex grid to a text box. Whenever I call the setfocus method for my text box, I
receive the following error: Microsoft Office Access can't move the
focus to the control txtJobNotes. What would prevent Access from
changing the focus to the text box? Thanks for your help.
-Vincent
|
| | 6 answers | Add comment |
|
| Disable X Nick 'The Database Guy 19:17:09 |
| | Hi Guys,
When my database opens it run the following code.
Private Declare Function GetSystemMenu Lib "user32" (ByVal hwnd As
Long, ByVal bRevert As Long) As Long
Private Declare Function EnableMenuItem Lib "user32" (ByVal hMenu As
Long, ByVal wIDEnableItem As Long, ByVal wEnable As Long) As Long
Const MF_GRAYED = &H1&
Const MF_BYCOMMAND = &H0&
Const SC_CLOSE = &HF060&
Public Function SetEnabledState(blnState As Boolean)
CloseButtonState blnState
ExitMenuState blnState
End Function
'Disable the Menu Option
Sub ExitMenuState(blnExitState As Boolean)
Application.CommandBars("File").Controls("Exit").Enabled =
blnExitState
End Sub
'Disable the Close Button Option
Sub CloseButtonState(boolClose As Boolean)
Dim hwnd As Long
Dim wFlags As Long
Dim hMenu As Long
Dim result As Long
hwnd = Application.hWndAccessApp
hMenu = GetSystemMenu(hwnd, 0)
If Not boolClose Then
wFlags = MF_BYCOMMAND Or MF_GRAYED
Else
wFlags = MF_BYCOMMAND And Not MF_GRAYED
End If
result = EnableMenuItem(hMenu, SC_CLOSE, wFlags)
End Sub
This greys out both the close button on the access window and the exit
command on the file menu. What I want to know is how to disable the X
in the database window.
TIA
Nick
|
| | Add comment |
|
| filtering form onchange event Dave 19:05:51 |
| | I am having difficulty filtering a form as the user types in a onchange
event
here is my code
strFilter = cboCriteria.Value & " LIKE '" & Me!txtCriteria.text
& "*" & "'"
If Len(strFilter ) > 0 Then
Me.FilterOn = True
Me.Filter = strFilter
Me!txtCriteria.SelStart = Len(Me!txtCriteria.text)
' End If
My problem occurs when the filter produces no results
The line
Me!txtCriteria.SelStart = Len(Me!txtCriteria.text)
gives me an error in the likes of: Cannot reference a control which
does not have the focus
can anybody help me
thanks
|
| | 4 answer | Add comment |
|
| GUI:Instructions in the Title Bar Tim Marshall 18:31:17 |
| | I notice in http://homepage.mac.com/bradster/iarchitect/controls.htm
that in the comments on the "Click & Print Certificates" dialog (less
than a quarter way down the page) that "instructions in the title bar"
are frowned upon.
Why? Here are two examples where I did something I thought OK.
1) On a data sheet subform, a double click action brings up a modal pop
up with more details on the selected record. The pop up has navigation
keys which allow you to next, previous, first, last your way through the
data sheet without having to leave the pop-up. The data sheet is a
listing of work orders and fuel tickets. The title bar of the pop up
displays: "Work Order: FM-30012345" or "Fuel Ticket: 123456", depending
on which record is selected/is current in the data sheet. These titles
are repeated in each tab on the tab control on the pop up, albeit in
smaller lettering. I like my approach, especially when I have the auto
repeat property of the first/next/previous/last buttons I've installed
set to yes, as the selection blazes through on the background data sheet
and the only indication anything is changing on the pop up is the fast
changing notation in the title bar.
2) Error messages. Here are two typical of what I use.
The first is my standard case else for select err.number:
MsgBox "Error " & Err.Number & " " & Err.Description, vbCritical,
"sReportFormat", Err.HelpFile, Err.HelpContext
I usually put the name of the procedure in which the error takes place
in the title argument of the message box.
Another example might be, in an error handling routine or as part of a
loop, when a numeric is required instead of a non-numeric character:
MsgBox "You entered a character that was not a number!", vbExclamation,
"Enter a Number!"
What's critically wrong with any of the above examples?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
|
| | 3 answer | Add comment |
|
| Linked Table Problem Guest 17:43:44 |
| | Hi
I have a a fairly large Excel sheet that I linked to from Access.
Everything seems to work fine except for one field.
The priority field is a text field and can have values such as
1,2,3,3a,3b,3c, however, when viewed in access the values 3a, 3b, 3c
appear ok, but those with just 1,2,3 have the value #Num!
The cell format in Excel is set to text and the field format in access
is set to text. So does anyone have any ideas how to resolve this?
Thanks for any suggestions.
Paul
|
| | 2 answer | Add comment |
|
| Solved thank you Richard 15:25:29 |
| |
Richard wrote:> I have a Report and subreport where the rows in the Report are selected> on a three part primary key. ID,YEAR,PERIOD.> The subreport has a data select statement on a second table related to> the first with the same> three columns ID,YEAR,PERIOD>
I have an problem when there is no data for the subreport on PERIOD but> there is data for ID,YEAR but the previous PERIOD this is selected.> When data exists for the correct PERIOD the previous PERIOD data is not> reported (correctly).> I wonder if this might be to do with the underlying relationship in the> SQLServer database.> I found this did not pre-exist the report creation on my production> system (though it exists now)?> Any clues?
I found that the report creation wizard had only used the first part of
the key in childlinkfield/masterlinkfield.
|
| | Add comment |
|
| Report - Totalling an Unbound Field? ZRexRider 15:01:35 |
| | Hi,
I have a report driven by a SQL database. I have a populated recordset
having a user name and a number of data/time fields. I process these
time fields in the report's Detail_Print event. Basically I'm coming
up with a duration between 3 sets of dates (subtracting off hours -
eve, lunch, weekends, holiday) and coming up with the number of
seconds. In the detail list I can easily print the value of n days,
n hours, n minuts, n seconds.
However now I want to make a simple Average Report which just lists the
User and the average time. Using Access 2002 I have not been able to
figure out how to use group totalling to even get a total of an unbound
field.
I have an unbound field called: txtSubmitReviewDateDiff which is
updated from VBA in the Detail_Print event. This works great for the
basic detail print.
I added a hidden field to the detail line called: txtSubmitRunningTotal
which is set to be a "running sum" and has it's control source set to
=[txtSubmitReviewDateDiff].
When I run the report (with the hidden sum field temporarily unhidden)
I see the same value in both columns.
Can I use the reports built in methods to sum an unbound field? Any
suggestions are greatly appreciated.
Thanks
|
| | Add comment |
|
| counting distinct entries with groupby Jason Teen 14:42:07 |
| | Hi
I have this scenario:
group | id | value
---------------------------------
x | location | QLD
x | location | NSW
x | location | VIC
x | location | VIC
x | location | NSW
x | location | NSW
x | location | NSW
I want the final count to be:
group | id | count
---------------------------
x | location | 3
Basically it is the number of distinct values, relating to that group
and id. I DONT WANT the number in the grouping x | locaion | 7 nor do I
want..
x | location | qld | 1
x | location | vic | 2
x | location | nsw | 4
but i cant get it.// please help.
|
| | 2 answer | Add comment |
|
| Removing SQL pop-up Guest 09:40:38 |
| | Whenever I execute a sql command (using docmd.runsql), it always gives
a popup when executed asking if I want to confirm deleting 3 rows, or
updating 1 row, or whatever. Is there a way to prevent this popup from
appearing?
|
| | 2 answer | Add comment |
|
| Updating a table with specific info from another table John T Ingato 09:04:09 |
| | I have a contacts table with name address and such but are missing all phone
numbers in the phone number fields. I have just received an updated
customer list in Excel and have imported into a new table.
Can I run a query that will take the phone number only from the new table
and update the old tables phone number fields from empty to the proper
information?
|
| | 15 answers | Add comment |
|
| Adding additional value to Row source John 05:10:22 |
| | Hi
I have a query as a rowsource to a list. Is it possible to add a single
additional value to the row source to appear in the list in addition to what
is coming from the query? Such as by union of the query with the fixed
value?
The reason I need is that I have several values coming from the query but I
also need to add 'ALL' in the list for user to select which is not coming
from the query.
Thanks
Regards
|
| | 2 answer | Add comment |
|
| GUI Issues Tim Marshall 05:03:09 |
| | After following the responses of Rick & Emily in the "Is there a way to
link a checkbox to a radio button?" thread, and remembering similar
discussions here in the past, I realize my major app, which I've just
released in our offices has some GUI gaffs.
Is there a forum somewhere or is it appropriate here on cdma to ask
about GUI choices made?
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
|
| | 4 answer | Add comment |
|
| Getting database fields (rows) to appear as columns in datagrid Dallasfreeman 04:18:06 |
| | I'm looking at a quick way to get results that are displayed as rows to
display as columns.
I have three tables:-
- The Questions for the survey
- The Results of the survey (Columns are listed as question numbers)
- The Survey Extra Results (As additional questions can be listed into
the Questions table, has 3 columns (a link/id to the survey id, a
link/id to the question id, and the answer the user gave).
I need to list the results of the survey and the extra results for the
survey on one row in a datagrid for each survey.
Any ideas?
|
| | 1 answer | Add comment |
|
| Can't use "Add/Remove; would removing refferences in Registry Keys Work? Jphelan 04:02:07 |
| | I was testing the install and uninstall, on my WindowsXP Pro SP2
machine, of software that I created, called, "inbusiness". Because of
the following error message that I received on attempting to uninstall
the program through, "Add/Remove", I assume that I will have to find
some other way to remove it.
"An installation package for the product InBusiness for - Nonprofits
cannot be found. Try the installation again using a valid copy of the
installation package 'InBusine.msi'."
The, "inBusine.msi" file does exit. However, because of the way the
original installed was handled, I think, it's not being recognized as
valid. Is there any back door routines, procedures, methods that I can
use to get it removed from my, "Add/Remove"?
I tried using: "msiexec /uninstall inBusine.msi", and got the same
error message. Is there a "white paper" that will help me with my
problem in the registry keys? Are there other issues, procedures,
instructions, etc. that I should be aware of regarding using the
registry keys in dealing with my uninstall problem?
I've located 2 areas in the Registry, SourceList: "Inbusine.msi" next
to PackageName and under Products: "InBusiness for - Nonprofits" next
to ProductName. Would eliminating one or both these references solve
my problem? Are there other areas of the Registry were I should be
looking to delete any references to my software?
John
|
| | 2 answer | Add comment |
|
| Club Membership Stephen Doyle 01:58:07 |
| | If I am in the wrong forum, please point me in the right direction.
I am looking for an access database compatible with office 2000 to help
manage the membership of the surf lifesaving club I belong to. If it could
go to financials as well that would be a bonus. As a voluntary organisation
we would prefer freeware.
Any ideas?
Cheers
Stephen
|
| | 4 answer | Add comment |
|
|
