Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 15.01 seconds.
Search: Posts Made By: missinglinq
Forum: Forms 10-14-2019, 05:32 PM
Replies: 14
Views: 15,811
Posted By missinglinq
Re: Highlighting the contents of a textbox on entry.

Never run into this before but you are indeed correct! Only workaround I could come up with (it's been a very long day and I going to La La Land soon) is to assign the field as Text then use this
Forum: Forms 10-10-2019, 03:04 AM
Replies: 10
Views: 160
Posted By missinglinq
Re: Forms not able to insert new record

When validating multiple fields, you have to Exit the Sub each time a validation fails, giving the user a chance to correct errant Control, before moving on to the next validation check...otherwise...
Forum: Forms 10-08-2019, 02:45 AM
Replies: 7
Views: 109
Posted By missinglinq
Re: Write Conflict

Is this app being used in a multi-user environment?

Is it split into a Front End/Back End configuration...with Tables in the Back End and everything else in the Front End?

If so, does each user...
Forum: Modules & VBA 10-02-2019, 05:47 PM
Replies: 5
Views: 196
Posted By missinglinq
Re: Button to kick everyone out of database

Not directly related to your question...but the above statement is kind of worrisome. This is a multi-environment database...so I have to ask...is the database split into a Front End, holding...
Forum: Forms 09-30-2019, 03:24 PM
Replies: 6
Views: 166
Posted By missinglinq
Re: Me.Refresh causes error

Have no idea why Access would balk and give that kind of error with


That error usually pops when you try to use Me. in the Control Source Property of a Control.

If your concern is...
Forum: Forms 09-28-2019, 02:48 PM
Replies: 3
Views: 102
Posted By missinglinq
Re: Error 3197 in bound form / linked to SQL Server back end

Do the Tables tied to the errant Forms both have Primary Keys?

Linq ;0)>
Forum: Forms 09-21-2019, 04:23 AM
Replies: 3
Views: 118
Posted By missinglinq
Re: Message Box not returning focus to the right field.

There are a number of ways to approach this, all variations of Paul's suggested method, such as

Private Sub Form_BeforeUpdate(Cancel As Integer)

If Nz(Me.Control1,"") = "" Then
Forum: Modules & VBA 09-18-2019, 04:47 PM
Replies: 41
Views: 460
Posted By missinglinq
Re: Populate the name of the active control on focus in a form.

You could display each Control's name (or anything else you'd like) in the Control itself, when the Record loads, by, in each Control's Format Property, simply entering the name, or whatever, like...
Forum: Modules & VBA 09-12-2019, 04:26 PM
Replies: 15
Views: 257
Posted By missinglinq
Re: Sequential number generator that resets

Actually, in a multi-user environment, the number is usually committed at the last possible moment (i.e in the Form_BeforeUpdate event) to avoid duplication.

Committing the Record as soon as it is...
Forum: Forms 09-09-2019, 09:07 AM
Replies: 6
Views: 154
Posted By missinglinq
Re: spell checker

Just to be clear...is your complaint that Focus moves to the next Textbox on the Form...or that it moves to the next Textbox and tries to SpellCheck that Control as well?

Linq ;0)>
Forum: Forms 09-09-2019, 09:00 AM
Replies: 19
Views: 263
Posted By missinglinq
Re: Centering forms on any computer when maximized

When you open a Standard Module, it'll already have an Option Statement at the very top of it...simply go to the very top of the module (above the code you pasted in) and delete this.

Linq ;0)>
Forum: Modules & VBA 09-05-2019, 01:20 AM
Replies: 5
Views: 112
Posted By missinglinq
Re: Duplicating Form and Subform records

Allen Browne has a well-written tutorial on this very subject found here:


Linq ;0)>
Forum: Modules & VBA 08-27-2019, 04:42 PM
Replies: 7
Views: 144
Posted By missinglinq
Re: save button notification

First, you complain that it is not displaying a new record...then you complain that it is displaying a new Record...which do you want?

If you want it to move to a new Record...you need to tell...
Forum: Forms 08-26-2019, 03:17 AM
Replies: 11
Views: 117
Posted By missinglinq
Re: Conditional Visibility

I'd follow up on that! IT departments have a habit of 'updating' systems over the weekend when usage is lower/non-existent.

Does any code run?

Linq ;0)>
Forum: Forms 08-26-2019, 01:59 AM
Replies: 11
Views: 117
Posted By missinglinq
Re: Conditional Visibility

First...this kind of code needs to be in both the AfterUpdate event, as shown...and in the OnCurrent event.

Next...what kind of Form is this...Single, Continuous or Datasheet?

Lastly...if, as...
Forum: Forms 08-20-2019, 05:48 PM
Replies: 2
Views: 97
Posted By missinglinq
Re: Form layout keeps changimg

theDBguy's advice will separate the Controls so that they can be moved individually...but the phenomena you're experiencing, moving from one box to another, isn't caused by the size of the...
Forum: Modules & VBA 08-19-2019, 03:30 PM
Replies: 17
Views: 235
Posted By missinglinq
Re: can't run the macro or callback function 'GetEnabled

There's no way to convert a .accde file back to a .accdb file...that's why it's important to save your .accdb file after converting it.

WE really need to see all relevant code, as theDBguy said....
Forum: Forms 08-19-2019, 01:56 AM
Replies: 3
Views: 122
Posted By missinglinq
Re: How to adjust DLookup box effectively.

Haven't had my first cup of java, yet, but I thought in referring to a Control on a Form, in a Control Source for another Control on the Form, you simply use the Control name surround by brackets:
Forum: Modules & VBA 08-13-2019, 05:43 PM
Replies: 5
Views: 131
Posted By missinglinq
Re: HOW? hide application window and...

Per the original post

Going through the song-and-dance of hiding everything seems like an overly complicated way to accomplish this. Wouldn't simply saving/distributing the file as an accde...
Forum: Forms 08-12-2019, 03:09 AM
Replies: 21
Views: 365
Posted By missinglinq
Re: Looking for advice on Long Text/Memo fields

Here's a Function that can be used to expand a given Control by using the Double-Click event for the Control. You can create a Function to do the zooming, select the desired Controls to be included,...
Forum: Modules & VBA 07-25-2019, 06:33 AM
Replies: 6
Views: 109
Posted By missinglinq
Re: Runtime error 3075 in VBA

Presumably UserName is Text...then

"[UserName]=" & Me.TxtUsername.Value)

should be

"[UserName]='" & Me.TxtUsername.Value & "'")

Linq ;0)>
Forum: Forms 07-25-2019, 03:28 AM
Replies: 3
Views: 113
Posted By missinglinq
Re: Multi field fill from single field lookup

To expand on that just a little bit...

Set up your Combobox using the Wizard and include the Fields you need, from Left-to-Right.

Here's a general example of assigning values from a Combobox...
Forum: Forms 07-24-2019, 05:24 PM
Replies: 10
Views: 223
Posted By missinglinq
Re: Need to lock all fields except the search box

In doing this kind of thing...once you set AllowEdits to True, it'll stay True for that Record...even if you explicitly try to set AllowEdits to False, again, until you exit the Record.

The only...
Forum: Forms 07-18-2019, 09:15 AM
Replies: 6
Views: 135
Posted By missinglinq
Re: SubForm memo field - Spell Check

A Subform is a Control on the Main Form...so if LockBoundControls does what it says...i.e. locks all Bound Controls...the Subform is Locked and you could neither enter data nor Spell Check it.
Forum: Forms 07-13-2019, 03:27 PM
Replies: 62
Views: 922
Posted By missinglinq
Re: How to make a field mandatory

This kind of code is fine when only validating a single Control.

But when validating multiple Controls, as you're doing...to avoid the problem you're seeing you have to do each validating, adding...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 05:18 AM.

Microsoft Access Help
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