Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.22 seconds.
Search: Posts Made By: David R
Forum: Modules & VBA 12-12-2019, 01:46 PM
Replies: 12
Views: 279
Posted By David R
Re: Writing SQL to open a recordset, then it VBA gets confused...

contrs is used lower in the code (.to field of the email).

As noted elsewhere, I eventually seem to have pushed the error off of this plane of existence, without actually changing anything in the...
Forum: Modules & VBA 12-12-2019, 01:44 PM
Replies: 12
Views: 279
Posted By David R
Re: Writing SQL to open a recordset, then it VBA gets confused...

Yup, the same breakpoint suffices (sorry, I'm probably spending too much time on the form variables because that is what ate my head yesterday).

But for whatever reason (quantum mechanics?)...
Forum: Modules & VBA 12-12-2019, 12:53 PM
Replies: 12
Views: 279
Posted By David R
Re: Writing SQL to open a recordset, then it VBA gets confused...

Thanks Doc; long time no see!

Here's the thing. If I resolve the variables during a breakpoint, I get valid SQL:SELECT ProjectNumber, BidPackage, CaseAddress, CaseID
FROM tableCases
WHERE...
Forum: Modules & VBA 12-12-2019, 12:28 PM
Replies: 12
Views: 279
Posted By David R
Re: Writing SQL to open a recordset, then it VBA gets confused...

Yes, I did check it against Immediate via breakpoints. The SQL agrees exactly with the stored query version, except of course that the variables have been given values.

CaseID is alphanumeric, in...
Forum: Modules & VBA 12-12-2019, 11:06 AM
Replies: 12
Views: 279
Posted By David R
Angry Writing SQL to open a recordset, then it VBA gets confused...

I've done this dozens of times, I don't know why this database is flipping out on me. (Apologies for the convoluted code, it started out giving the "too few parameters" error when runSQL referenced...
Forum: The Watercooler 02-25-2015, 07:53 AM
Replies: 6,024
Views: 551,154
Posted By David R
Re: Are you an atheist?

My gods outnumber your god and could take him in a fair fight.
Forum: Modules & VBA 11-10-2014, 09:49 AM
Replies: 6
Views: 773
Posted By David R
Re: OutputTo hangs on Error 52

I reiterate because I already answered your question in the OP, spike. I'd already done everything you suggested, hence the testiness. I'm not a new user here.

Nonetheless, the seventeenth...
Forum: Modules & VBA 11-10-2014, 09:36 AM
Replies: 6
Views: 773
Posted By David R
Re: OutputTo hangs on Error 52

Correct. Other users (including myself, with full server access) can write to LockedDownServer just fine, which is why I never noticed it during testing. I can simulate it now by changing the...
Forum: Modules & VBA 11-10-2014, 09:23 AM
Replies: 6
Views: 773
Posted By David R
Re: OutputTo hangs on Error 52

Typo (hadn't cleared out all of my latest attempt). That line has been fixed.
Forum: Modules & VBA 11-10-2014, 09:03 AM
Replies: 6
Views: 773
Posted By David R
OutputTo hangs on Error 52

Some of my users do not have access to all of our servers. In trying to automate I've hit one user whose system hangs up when Access tries to write to a server folder she does not have write (or even...
Forum: The Watercooler 10-31-2014, 09:48 AM
Replies: 6,024
Views: 551,154
Posted By David R
Re: Are you an atheist?

Yeah well, my religion is excluded from the poll, so I have to get my jollies somewhere... :D
Forum: The Watercooler 10-31-2014, 09:43 AM
Replies: 6,024
Views: 551,154
Posted By David R
Re: Are you an atheist?

So there's some bill, or maybe a law, that you don't know the name or number of, that will do a blatantly unconstitutional thing? Nice try, thanks for the laugh Blade.

You might be thinking of SB...
Forum: Forms 07-09-2014, 08:28 AM
Replies: 3
Views: 879
Posted By David R
Re: Form Control still 'saving' after Undo/Cancel

Bumping. This is still/again a problem, and I can see no reason why.
If Me.NewRecord = True And IsNull(Me.CaseNumber) Then
MsgBox "Enter the Service Order and Increment first, please.",...
Forum: Forms 05-22-2014, 10:54 AM
Replies: 3
Views: 879
Posted By David R
Re: Form Control still 'saving' after Undo/Cancel

Aren't I reversing the value change, though?
Me.frameCitationType.Undo
Cancel = True

It's impossible to 'change' the value of the frame from within the BeforeUpdate event. My...
Forum: Forms 05-22-2014, 09:23 AM
Replies: 3
Views: 879
Posted By David R
Form Control still 'saving' after Undo/Cancel

This frame controls an option group. If they are in an existing citation and want to start one for another type, this offers to write a new record in when they try to switch. Problem is, if it DOES...
Forum: Forms 05-02-2014, 08:29 AM
Replies: 1
Views: 1,745
Posted By David R
Forum: Forms 05-02-2014, 07:39 AM
Replies: 1
Views: 1,745
Posted By David R
Filter subform based on main form combo.column.(x)

This has to rank up there with one of the stupidest problems ever, but I've been staring at it for several hours now and nothing seems to work.

Problem: I want to automatically filter a subform...
Forum: General 04-03-2014, 01:23 PM
Replies: 7
Views: 520
Posted By David R
Re: Comparing programs

Sorry for the delay, work has been eating my head.

Assuming you haven't found it yet, I get it by right-clicking the object in the Navigation Pane (left edge of the screen) and picking Properties....
Forum: Tables 03-10-2014, 12:15 PM
Replies: 1
Views: 487
Posted By David R
Re: Date Display change in Table view

Is this a one-time operation to fix bad table design, or will you always get this data in this format?

If this is a one-time fix:

backup your table.
Make a new field for the corrected...
Forum: Forms 03-10-2014, 12:08 PM
Replies: 2
Views: 463
Posted By David R
Re: open other forms in form main

Or explore http://access.mvps.org/access/queries/qry0002.htm to give you a list of all the Forms in your database... use at peril if you're trying to lock down some forms/only open some after others...
Forum: General 03-10-2014, 12:06 PM
Replies: 7
Views: 520
Posted By David R
Re: Comparing programs

You could give a Compare/Diff program a crack at it with Binary matching turned on, but I'm pretty sure you'll get garbage output... :banghead:

Only other thing I can think of is open the two side...
Forum: Queries 03-10-2014, 11:50 AM
Replies: 10
Views: 1,193
Posted By David R
Re: Query Table1 date to Table2 column1 begin date range to column2 end date range

It looks to me like the 'rule' might actually be that the workweek with X/1/201Y is the full week that starts a fiscal month, and your fiscal calendar starts June 1. Would that be true in other...
Forum: General 03-10-2014, 11:48 AM
Replies: 7
Views: 520
Posted By David R
Re: Comparing programs

This is still the answer then. You cannot easily go back and retroactively figure out which is newer without examining your code/tables/forms, but this will make it trivial going forward.
Forum: Forms 03-10-2014, 11:47 AM
Replies: 6
Views: 524
Posted By David R
Re: Date input shortcut

Not plain enough.

WHY do you want today's date to be zero, rather than Date() automatically prompted?
WHAT do you want to do with a day ago, and a week ago, and why can't they be autocalculated...
Forum: Forms 03-10-2014, 11:04 AM
Replies: 6
Views: 524
Posted By David R
Re: Date input shortcut

Can you explain in plain English what you are trying to do? You can autocalculate a lot of dates based on Today() or the input in your 'first' date field.

The DatePicker I am speaking of is an...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:03 AM.


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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World