Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: MarkK
Forum: General Yesterday, 03:26 PM
Replies: 1
Views: 158
Posted By MarkK
FE must be on the user's machine, and user must...

FE must be on the user's machine, and user must have full control of the folder in which the BE resides on the server.
hth
Mark
Forum: Modules & VBA Yesterday, 11:49 AM
Replies: 12
Views: 191
Posted By MarkK
All things being equal, the simplest explanation...

All things being equal, the simplest explanation is probably the right one.
- Occam

Mark
Forum: General Yesterday, 10:03 AM
Replies: 6
Views: 219
Posted By MarkK
I think you should avoid thinking of a trip from...

I think you should avoid thinking of a trip from origin to destination as one thing. Instead, think of arrival and departure events as distinct things, and think of a trip as having one or more...
Forum: Modules & VBA 08-18-2018, 02:36 PM
Replies: 16
Views: 245
Posted By MarkK
The two recordsets you create at the start of the...

The two recordsets you create at the start of the routine never end up getting used.
Private Sub Command20_Exit(Cancel As Integer)
'...
Set db = CurrentDb()
Set rsDetail =...
Forum: Modules & VBA 08-18-2018, 12:38 PM
Replies: 16
Views: 245
Posted By MarkK
So this code you posted opens outlook and...

So this code you posted opens outlook and constructs an email message? Not sure how this is related to the earlier post.
Mark
Forum: Modules & VBA 08-18-2018, 11:43 AM
Replies: 16
Views: 245
Posted By MarkK
I don't see how your 'set things up' code is...

I don't see how your 'set things up' code is related to your 'problem' code. The setup code opens a couple of stand-alone recordsets, but your problem code is consuming recordsets exposed by what...
Forum: Modules & VBA 08-18-2018, 11:36 AM
Replies: 5
Views: 178
Posted By MarkK
Here's one idea... Private m_eightCount As...

Here's one idea...

Private m_eightCount As Integer
Private m_tenCount As Integer
Private m_elevenCount As Integer

Sub Form_Load()
Me.TimerInterval = 1000 * 60 ' one minute
End Sub
Forum: Modules & VBA 08-17-2018, 08:23 PM
Replies: 11
Views: 156
Posted By MarkK
Here's code you can use to kill a windows...

Here's code you can use to kill a windows process.
Set service = GetObject("winmgmts:{impersonationLevel=impersonate}!\\localhost\root\cimv2")
Set procs = service.ExecQuery("SELECT * FROM...
Forum: Queries 08-15-2018, 08:43 AM
Replies: 7
Views: 141
Posted By MarkK
I don't understand what this means. Maybe...

I don't understand what this means. Maybe explain exactly how this filtering works.
Cheers,
Mark
Forum: Modules & VBA 08-15-2018, 07:41 AM
Replies: 5
Views: 144
Posted By MarkK
But, looking at this pattern, I expect you'll...

But, looking at this pattern, I expect you'll need something more along the lines of...
Private Sub DateIn_AfterUpdate()
SetAvailability Me.DateIn, Me.DateOut
End Sub

Private Sub...
Forum: Forms 08-14-2018, 07:44 AM
Replies: 3
Views: 191
Posted By MarkK
Also, the Set keyword is used to assign an...

Also, the Set keyword is used to assign an instance of an object to an object variable...
Sub AssignmentExample(AnyTypeAtAll)
Dim obj as Object
Dim var As Variant

If...
Forum: Modules & VBA 08-12-2018, 03:02 PM
Replies: 14
Views: 249
Posted By MarkK
All forms that you create inherit from...

All forms that you create inherit from Access.Form, so you can run code like this...
Private Sub Command7_Click()
Debug.Print "The current form is type:", TypeName(Me)
Debug.Print "Is Me a...
Forum: The Watercooler 08-10-2018, 12:09 PM
Replies: 10
Views: 328
Posted By MarkK
I did not follow the link, but I agree. It is...

I did not follow the link, but I agree. It is not a crime for the police to lie to you, but it is a crime for you to lie to the police. This discrepancy in the basic ground rules of interaction...
Forum: Forms 08-10-2018, 11:52 AM
Replies: 8
Views: 128
Posted By MarkK
What is the value of [policy] when you get that...

What is the value of [policy] when you get that error? Possibly it is null?

Form_Current fires every time the form loads a new record, so if you navigate to a new record perhaps the value of the...
Forum: Forms 08-10-2018, 09:55 AM
Replies: 8
Views: 128
Posted By MarkK
I would be tempted to do this in code, like... ...

I would be tempted to do this in code, like...
Private Sub Form_Current()
Dim pol As String
Dim tmp As String
Dim nte As String

pol = Nz(IIf(Left([policy], 1) = "R",...
Forum: General 08-10-2018, 08:22 AM
Replies: 53
Views: 1,452
Posted By MarkK
If you give users access to data, there is a...

If you give users access to data, there is a chance they will copy it. There is no reasonable way to prevent this.

My 2c? Only be trustworthy. Only deal with people you trust.

hth
Mark
Forum: Forms 08-10-2018, 08:12 AM
Replies: 8
Views: 128
Posted By MarkK
How much data are we talking about here? Maybe...

How much data are we talking about here? Maybe add another textbox, not hidden, with a control source like this...
=Len(Replace(Nz(DLookUp("NOTES","tblInvoiceLog","[VOUCHER_NUMBER]= " &...
Forum: Forms 08-10-2018, 06:40 AM
Replies: 8
Views: 128
Posted By MarkK
Why is it important, on a form with three unbound...

Why is it important, on a form with three unbound textboxes, to have a fourth unbound textbox that shows exactly the same thing as two of the other textboxes? :confused:
Mark
Forum: Tables 08-09-2018, 10:20 PM
Replies: 3
Views: 181
Posted By MarkK
It may be easier to discuss this topic if you...

It may be easier to discuss this topic if you describe the problem you are trying to solve. What are the tables you think you need? Show us your thoughts about that, and then we can help you...
Forum: Forms 08-09-2018, 10:16 PM
Replies: 5
Views: 160
Posted By MarkK
The above information describes a relationship...

The above information describes a relationship where one reference might have many projects.

This verbal description is about a relationship where one project has many references, which is not...
Forum: Queries 08-09-2018, 09:57 AM
Replies: 4
Views: 168
Posted By MarkK
Show your code. Describe your process exactly. ...

Show your code. Describe your process exactly. We can't troubleshoot a specific problem from this vague a summary.
hth
Mark
Forum: Theory and practice of database design 08-09-2018, 07:48 AM
Replies: 6
Views: 309
Posted By MarkK
The side end itself, the entire file, should be...

The side end itself, the entire file, should be deleted, not just the tables it contains.
Mark
Forum: Forms 08-09-2018, 07:40 AM
Replies: 2
Views: 93
Posted By MarkK
Probably you mean to run the Replace() functions...

Probably you mean to run the Replace() functions on the result of the DLookUp(). You are running the DLookUp() on the result of the the Replace() functions. See the difference?

Also, you can...
Forum: Forms 08-08-2018, 08:46 AM
Replies: 8
Views: 144
Posted By MarkK
Re: How to get an instant sum

If you are in datasheet, and there is no footer, then where, in the description of the form's design you posted above, is the summary?
Mark
Forum: Modules & VBA 08-06-2018, 07:10 PM
Replies: 5
Views: 173
Posted By MarkK
I'm not sure what you are trying to do, or what...

I'm not sure what you are trying to do, or what tables there are in your TableDefs collection. If you've linked MSSQL tables into there, they should be present in the collection. You can see what...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:50 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