Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.04 seconds.
Search: Posts Made By: Micron
Forum: Modules & VBA Yesterday, 07:18 AM
Replies: 33
Views: 322
Posted By Micron
Re: SendKeys problem w/Win10

My guess is a newer dll, olb or tlb file with the same name that doesnt get overwritten by a 2003 install?
Forum: Forms Yesterday, 06:54 AM
Replies: 8
Views: 108
Posted By Micron
Re: How to Delete Record on Subform Whose Source is a Query

Too bad you didn't try the layout option, assuming you have it as "allowed" as it seems it was a known bug about 10 yeara ago. I always turn it off so I'd never know if it was fixed. Not being in the...
Forum: Forms Yesterday, 02:22 AM
Replies: 8
Views: 108
Posted By Micron
Re: How to Delete Record on Subform Whose Source is a Query

Try deleting from the query itself. If you can then
- maybe Allow Deletions is set to no on the form, or
- try unchecking "allow layout view" from 'current database' options
EDIT : the table...
Forum: Modules & VBA 08-17-2019, 05:13 PM
Replies: 33
Views: 322
Posted By Micron
Re: SendKeys problem w/Win10

People find ways to use functions/methods for devious purposes all the time. What usually happens as a result is that we lose some functionality that we once had. While poking around for this one, I...
Forum: Modules & VBA 08-17-2019, 03:26 PM
Replies: 33
Views: 322
Posted By Micron
Re: SendKeys problem w/Win10

I agree that sendkeys is probably best avoided. I don't trust F1 either. I read somewhere not too long ago that anyone who attempts to use F1 to direct to their own Help gets over-ridden by M$ -...
Forum: Modules & VBA 08-17-2019, 10:33 AM
Replies: 33
Views: 322
Posted By Micron
Re: SendKeys problem w/Win10

Did you look first? There's tons of posts saying it is no longer supported - some of which at least say why. It's apparently a security issue.

Or are you including the possibility if you use a...
Forum: Modules & VBA 08-17-2019, 10:21 AM
Replies: 8
Views: 93
Posted By Micron
Re: ADO connection

just as an fyi, do some research on ADO vs DAO and watch out for old posts. At one point M$ was going to stop developing DAO so I suspect many panicked and started developing in ADO. Guess what? M$...
Forum: Forms 08-17-2019, 05:56 AM
Replies: 13
Views: 163
Posted By Micron
Re: Unbound Form "RunTime Error 3134"

My point is we shouldn't have to. If I'm in one of my moods and there's (e.g.) 100 lines of code and no code tags or an error number with no description, I just move on.
Forum: Modules & VBA 08-16-2019, 06:23 PM
Replies: 20
Views: 206
Posted By Micron
Re: refresh with code after update

Be it the form AfterUpdate event or a control AfterUpdate, how do you cancel this update? The whole premise of After update is that the event fires after the control or form is updated. There is no...
Forum: Forms 08-16-2019, 04:05 PM
Replies: 13
Views: 163
Posted By Micron
Re: Unbound Form "RunTime Error 3134"

See? I didn't remember it correctly after all. Seems I can't recall it 20 minutes later, either.:o
Forum: Forms 08-16-2019, 04:01 PM
Replies: 13
Views: 163
Posted By Micron
Re: Unbound Form "RunTime Error 3134"

syntax error in sql statement. I had to look it up because wouldn't you know, it's the only number I couldn't remember...;)
Wish so many people wouldn't assume we know what all of the numbers mean....
Forum: Modules & VBA 08-16-2019, 03:53 PM
Replies: 20
Views: 206
Posted By Micron
Re: refresh with code after update

If you want to prevent duplicate data and can't simply prevent it by having a unique index or primary key on a particular field, then the time to detect that a value would be a dupe is BeforeUpdate,...
Forum: Forms 08-16-2019, 03:31 PM
Replies: 13
Views: 163
Posted By Micron
Re: Unbound Form "RunTime Error 3134"

In this situation, always debug.print the sql statement, copy from immediate window, paste into new query sql view and a) switch to datasheet view (which won't attempt to run it) or b) try to run it....
Forum: General 08-16-2019, 03:18 PM
Replies: 17
Views: 286
Posted By Micron
Re: Can I link photos stored on Office 365 (OneDrive, etc.) with an Access Database?

On a home pc, One Drive is a subfolder of the user profile. An image control will display an image with a path like C:\Users\Micron\OneDrive\Pictures...
Not sure where that leaves anyone in a...
Forum: Forms 08-16-2019, 03:02 PM
Replies: 20
Views: 209
Posted By Micron
Re: sub form as form view not datasheet

If by "subform" you mean the form and not the subform control, then it is possible. Subform view set to single form BUT allow datasheet view must be "no". I don't think that should have any effect on...
Forum: Modules & VBA 08-12-2019, 07:10 AM
Replies: 6
Views: 141
Posted By Micron
Re: Beginner trying to make a string of text appear with toggles

You can help us help you by using the correct terms and names. Maybe go into your form in design view and select your controls one by one and note what the property sheet calls them (you might have...
Forum: Forms 08-11-2019, 10:30 PM
Replies: 13
Views: 137
Posted By Micron
Re: SubForm Height

Interesting. Have never tried either of those, rather always clicked once to select then right clicked and chose "Open subform in new window" or whatever it says in the menu.
Forum: Forms 08-11-2019, 10:16 PM
Replies: 13
Views: 137
Posted By Micron
Re: SubForm Height

If you click on the detail, header or footer sections, you'll always activate them. As for the other, think of it this way: if you click on a textbox, you expect to activate it. Same goes for the...
Forum: Forms 08-11-2019, 10:08 PM
Replies: 8
Views: 131
Posted By Micron
Re: Can't Open Form

Nope, at least not if I recall correctly. Would you believe that was my next guess? I figured if you could open the form in design yet the break(s) did nothing, it had to be the form record source....
Forum: Forms 08-11-2019, 07:54 PM
Replies: 8
Views: 131
Posted By Micron
Re: Can't Open Form

Because that computer still has a drive mapped to E and that's where you put the files?
Open event, then load event. More here......
Forum: Forms 08-11-2019, 07:20 PM
Replies: 8
Views: 131
Posted By Micron
Re: Can't Open Form

Your post is not clear. What does "cannot run" mean? You can open it, yes? But you get an error message and the form doesn't open correctly? Or the form doesn't open at all but your code window opens...
Forum: General 08-11-2019, 10:52 AM
Replies: 8
Views: 119
Posted By Micron
Re: How to update to most recent set of data

Not much to go on so IMHO, comments can only be in general terms. If the sheets are guaranteed to be consistent in layout, that will help a lot. Whether or not you do a complete replacement of the...
Forum: General 08-11-2019, 07:35 AM
Replies: 8
Views: 119
Posted By Micron
Re: How to update to most recent set of data

Have to make this short: didn't look at your posted db but your situation is not all that uncommon IMHO. Where I worked, there was a copy of a huge production db that those with permissions were...
Forum: General 08-10-2019, 07:01 PM
Replies: 33
Views: 480
Posted By Micron
Re: Building Security system for Access Database

Never said that they would be. I DID say there was no mention that the distributed db was an accde, meaning more prone to meddling if not.
Forum: Forms 08-09-2019, 05:49 PM
Replies: 13
Views: 180
Posted By Micron
Re: Incorrect SQL Statement while using more than one criteria

If you want to add one WHERE criteria based on a combo, then you have to test for it having no selection. If not, don't concatenate. If yes, then do concatenate. However, I think there are issues...
Showing results 1 to 25 of 500

 
Forum Jump



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