Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: MarkK
Forum: Modules & VBA Today, 10:49 AM
Replies: 5
Views: 81
Posted By MarkK
Just tidying up your code commonly helps find...

Just tidying up your code commonly helps find errors. Consider a more consistent indenting scheme, like...
Dim Titles
Dim Counter As Long

Range("A1").Select
...
Forum: Modules & VBA Today, 08:23 AM
Replies: 2
Views: 41
Posted By MarkK
If I copy this code into my VBA IDE, I get a...

If I copy this code into my VBA IDE, I get a 'variable not defined' compile error for 'fOSUserName' at this line...
DirName = "B:\" & fOSUserName & "\EMC Export\"
If I declare that variable, I then...
Forum: The Watercooler Yesterday, 05:29 PM
Replies: 14
Views: 215
Posted By MarkK
Don't trust anyone over 30...

Don't trust anyone over 30...
Forum: Reports Yesterday, 09:55 AM
Replies: 5
Views: 75
Posted By MarkK
You bet, all the best, :)

You bet, all the best, :)
Forum: General Yesterday, 08:54 AM
Replies: 10
Views: 136
Posted By MarkK
Thanks Colin!!!

Thanks Colin!!!
Forum: Reports Yesterday, 08:53 AM
Replies: 5
Views: 75
Posted By MarkK
Does the error have a description, or is Access...

Does the error have a description, or is Access just crashing without warning?
Mark
Forum: General Yesterday, 08:52 AM
Replies: 13
Views: 119
Posted By MarkK
Is the TextFormat property of the field in the...

Is the TextFormat property of the field in the table, and the TextFormat property of the control on the form set to Rich Text? If so, see if it makes a difference to change this back to Plain Text....
Forum: General Yesterday, 08:44 AM
Replies: 10
Views: 136
Posted By MarkK
How do your users do anything? How do they open...

How do your users do anything? How do they open the report?
Forum: The Watercooler Yesterday, 08:41 AM
Replies: 14
Views: 215
Posted By MarkK
I'm quite certain that if I could go back and...

I'm quite certain that if I could go back and tell my teenage self something, my teenage self would not listen.
Forum: General Yesterday, 08:24 AM
Replies: 10
Views: 136
Posted By MarkK
Have you tried setting the run option to...

Have you tried setting the run option to maximized on the shortcut? Is that the problem, that the Access window is not visible?
Mark
Forum: Forms Yesterday, 08:22 AM
Replies: 2
[SOLVED] Combo Box Values
Views: 71
Posted By MarkK
You want to make a 2 column combo, with a pure...

You want to make a 2 column combo, with a pure number in a hidden column, and that text in the visible column. To do this you'll need to use the ColumnCount property and the ColumnWidths property of...
Forum: Reports Yesterday, 08:16 AM
Replies: 5
Views: 75
Posted By MarkK
Because a report formats and prints sections...

Because a report formats and prints sections repeatedly, and because some report sections, once they've been printed, cannot be un-printed and changed (the page might have already left the printer,...
Forum: Modules & VBA 04-18-2018, 08:51 AM
Replies: 18
Views: 220
Posted By MarkK
Split returns an zero-based array. In the...

Split returns an zero-based array. In the demonstrated problem, we are interested in returning the second element, so we use the subscript (1).
This code to me is overwrought...
Dim strTemp as...
Forum: Modules & VBA 04-18-2018, 06:36 AM
Replies: 18
Views: 220
Posted By MarkK
Building on Colin's example, I would use...

Building on Colin's example, I would use Split()...
Sub Test193487091243()
Dim tmp As String
Dim d1 As Date

tmp = "Transaction Summary for 10 April 2018 to 18 April 2018"
...
Forum: Forms 04-17-2018, 04:25 PM
Replies: 3
Views: 111
Posted By MarkK
Your QRY_SearchAll doesn't return any records...

Your QRY_SearchAll doesn't return any records even if you delete its WHERE clause, so even wide open with no constraints, it doesn't return any rows. There is not way, therefore, as you add...
Forum: Forms 04-17-2018, 01:14 PM
Replies: 5
Views: 111
Posted By MarkK
Also, there's also no need to do that strDocName...

Also, there's also no need to do that strDocName thing that the wizards write for you. Just put the name of the form in the open command, or use a constant, like...
Const FN as string =...
Forum: Modules & VBA 04-17-2018, 10:06 AM
Replies: 4
Views: 112
Posted By MarkK
Another small tweak you can do is... sWhere =...

Another small tweak you can do is...
sWhere = "[COST_CENTER] = " & iCost_Center & " And [CATEGORY] = '" & sCategory & "'"

See what changed?
I also sometimes code that as...
sWhere = _
...
Forum: Queries 04-17-2018, 08:15 AM
Replies: 7
Views: 120
Posted By MarkK
For a particular UserID you can get the latest...

For a particular UserID you can get the latest RowID like this...
SELECT TOP 1 RowID FROM tYourTable WHERE UserID = 123 ORDER BY LoginTimeStamp DESC
Then delete all the row IDs for that user that...
Forum: Modules & VBA 04-17-2018, 08:01 AM
Replies: 4
Views: 112
Posted By MarkK
"[COST_CENTER] = " & iCost_Center And "[CATEGORY]...

"[COST_CENTER] = " & iCost_Center And "[CATEGORY] = " & "'" & sCategory & "'"
In your code, the two parts in red are strings, and you are trying to AND them together with a boolean operator. This...
Forum: Queries 04-17-2018, 07:56 AM
Replies: 7
Views: 120
Posted By MarkK
If it's just a one-off operation, delete them...

If it's just a one-off operation, delete them manually. No need to design a process or query to do so, but also, in an indexed table, I doubt that even in Access you could notice the time difference...
Forum: Modules & VBA 04-17-2018, 07:51 AM
Replies: 11
Views: 138
Posted By MarkK
Its a strong indication that your data is not...

Its a strong indication that your data is not normalized if you need to change the field name in your DLookup(). A row should never contain multiple 'sibling' values from which you then might need...
Forum: Queries 04-17-2018, 07:29 AM
Replies: 7
Views: 120
Posted By MarkK
Why delete this data? It is doing no harm in the...

Why delete this data? It is doing no harm in the table, gives you a historical record of usage patterns, and it's easy enough to query the table to find the latest record. If it not broken, don't...
Forum: General 04-16-2018, 11:11 AM
Replies: 7
Views: 266
Posted By MarkK
I would not likely leave an Access app running...

I would not likely leave an Access app running with an enabled timer. I don't know this for sure, but I think that would be a resource hog. You can test this by opening task manager, and starting...
Forum: Modules & VBA 04-16-2018, 11:00 AM
Replies: 3
Views: 97
Posted By MarkK
This line... See how the result of the...

This line...

See how the result of the previous loop, as stored in GroupThis, is overwritten in this iteration of the loop? To concatenate, you will need GroupThis to appear also on the right...
Forum: Forms 04-15-2018, 07:55 PM
Replies: 2
Views: 109
Posted By MarkK
It looks like in your relationship diagram you...

It looks like in your relationship diagram you have joined tblChild to tblChildNotes using different fields than you are using to join the frmChild main form to the 'tblChildNotes subform1' subform. ...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:14 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World