Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.21 seconds.
Search: Posts Made By: MarkK
Forum: Introduce Yourself 09-16-2018, 08:35 AM
Replies: 6
Views: 255
Posted By MarkK
According to my understanding... You don't...

According to my understanding...

You don't issue an apology, you offer one.
As a confessed wrong-doer offering an apology, you do not declare resolution, you request it.

Just a couple of...
Forum: General 09-16-2018, 06:53 AM
Replies: 2
Views: 955
Posted By MarkK
Selectively lock or disable the controls based on...

Selectively lock or disable the controls based on the security level of your user. You have not told us anything about how your user is represented in your data so this is a guess, but something...
Forum: General 09-14-2018, 05:44 PM
Replies: 4
Views: 499
Posted By MarkK
Oh yeah, an' sorry 'bout not sayin' how u wanna...

Oh yeah, an' sorry 'bout not sayin' how u wanna do the update part, like...
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.UpdatedBy = < the username of the current user >
End Sub
So u...
Forum: General 09-14-2018, 05:32 PM
Replies: 4
Views: 499
Posted By MarkK
Yeah u betcha when u add a new record you just...

Yeah u betcha when u add a new record you just wanna handle the BeforeInsert event, and update the fields yur talking about, like....
Private Sub Form_BeforeInsert(Cancel as Integer)
Me.Username...
Forum: Modules & VBA 09-14-2018, 10:58 AM
Replies: 15
Views: 274
Posted By MarkK
Ranman is guessing that "didn't work" means...

Ranman is guessing that "didn't work" means "color was incorrect," but it's a guess.
Forum: Modules & VBA 09-14-2018, 10:56 AM
Replies: 15
Views: 274
Posted By MarkK
"Didn't work" is not enough information. hth ...

"Didn't work" is not enough information.
hth
Mark
Forum: Modules & VBA 09-14-2018, 08:07 AM
Replies: 16
Views: 281
Posted By MarkK
Pro tip: We can't troubleshoot your SQL if you...

Pro tip: We can't troubleshoot your SQL if you don't show it to us.
Mark
Forum: Forms 09-14-2018, 07:28 AM
Replies: 13
Views: 302
Posted By MarkK
I don't mind the use of the .Count property there...

I don't mind the use of the .Count property there as a boolean. If the list is empty the count is zero and the If expression is false. Done. No need for " > 0"
IMO
Mark
Forum: Forms 09-14-2018, 07:17 AM
Replies: 4
Views: 101
Posted By MarkK
Those five separate amounts should be in five...

Those five separate amounts should be in five separate rows in a related table. This is a table design problem, a normalization problem.
hrh.
Mark
Forum: Queries 09-12-2018, 09:02 AM
Replies: 32
Views: 473
Posted By MarkK
Individual numbers. Consider storing them in...

Individual numbers. Consider storing them in individual locations. Also, the smallest location in a database is the ROW, which is why when we add data to a database we always add rows.
Mark
Forum: Queries 09-12-2018, 08:30 AM
Replies: 32
Views: 473
Posted By MarkK
There are correct and incorrect ways to store...

There are correct and incorrect ways to store data. When data is stored correctly, there is no need for Split() in a query.
Mark
Forum: Queries 09-12-2018, 07:47 AM
Replies: 32
Views: 473
Posted By MarkK
VBA.Split() won't run in a query because it...

VBA.Split() won't run in a query because it returns an array, and the syntax of SQL cannot handle array subscripts.
Mark
Forum: Queries 09-12-2018, 07:46 AM
Replies: 32
Views: 473
Posted By MarkK
This data would be far easier to work with if...

This data would be far easier to work with if each value was in its own row in a related table. This approach, clumping distinct data points together in a single location, breaks basic principles of...
Forum: Modules & VBA 09-11-2018, 10:30 PM
Replies: 10
Views: 230
Posted By MarkK
'Me' is an object reference, and so only makes...

'Me' is an object reference, and so only makes sense if you are programming with class modules, which includes Access.Form objects. In a standard module there is no 'thing,' no object, just a...
Forum: General 09-11-2018, 06:37 PM
Replies: 9
Views: 795
Posted By MarkK
You can also handle subform events on the main...

You can also handle subform events on the main form, if you want, using the withevents keyword, like...
private withevents m_sfm as form

private sub Form_Open(Cancel as integer)
' set...
Forum: Forms 09-11-2018, 06:22 PM
Replies: 9
Views: 259
Posted By MarkK
Code sample... Private Sub Form_Unload(Cancel...

Code sample...
Private Sub Form_Unload(Cancel As Integer)
Cancel = True
End Sub
Forum: Forms 09-11-2018, 06:20 PM
Replies: 9
Views: 259
Posted By MarkK
The Access window won't close if you cancel the...

The Access window won't close if you cancel the unload event of an open form. One trick then, is maintain a hidden form, always open but never visible, and cancel its unload event.
hth
Mark
Forum: Queries 09-11-2018, 05:57 PM
Replies: 5
Views: 184
Posted By MarkK
There is no FROM clause in your UPDATE SQL. As a...

There is no FROM clause in your UPDATE SQL. As a result the table RawData_01 does not exist and the identifier "RawData_01!InputText" is assumed to be a parameter, which the query parser then...
Forum: Forms 09-11-2018, 09:59 AM
Replies: 10
Views: 258
Posted By MarkK
Ticket creation and ticket sale are not the same...

Ticket creation and ticket sale are not the same data. Your question is about sequentially numbering the ticket, and it would be simplest--as a solution to sequentially numbering them--if you create...
Forum: Forms 09-11-2018, 09:04 AM
Replies: 3
Views: 157
Posted By MarkK
What should the outcome be if EnrolledDate is...

What should the outcome be if EnrolledDate is null? What should appear, if #Name? should not?
Mark
Forum: Forms 09-11-2018, 08:40 AM
Replies: 10
Views: 258
Posted By MarkK
If there are 100 actual discrete and unique...

If there are 100 actual discrete and unique things--tickets in this case--that you create for an event, I suggest you make them all at once in a batch. Imagine code like...
for i = 1 to 100
'...
Forum: Queries 09-11-2018, 08:27 AM
Replies: 5
Views: 184
Posted By MarkK
I don't believe that bang character is legal in...

I don't believe that bang character is legal in SQL, but also, if I was stuck with a query, I would show my SQL text. If you ask, "What am I doing wrong?" but you haven't shown your work, we don't...
Forum: Forms 09-10-2018, 10:00 AM
Replies: 10
Views: 258
Posted By MarkK
And I totally agree with plog on this. A...

And I totally agree with plog on this. A sequence is a just a sort order, and you can assert any sort order you want, who cares? Is is uniqueness that has real value; being able to uniquely...
Forum: Forms 09-10-2018, 09:25 AM
Replies: 10
Views: 258
Posted By MarkK
How are you doing this? What problems are you...

How are you doing this? What problems are you running into? Showing your work will be an enormous help in our understanding of what is going wrong for you.
Mark
Forum: Reports 09-09-2018, 04:43 PM
Replies: 11
Views: 258
Posted By MarkK
Very nice arnelgp! :) Mark

Very nice arnelgp! :)
Mark
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:45 PM.


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

Featured Forum post


Sponsored Links


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