Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: missinglinq
Forum: Modules & VBA 11-14-2019, 04:05 AM
Replies: 8
Views: 108
Posted By missinglinq
Re: ActiveX OLE error

Was the error something like this:

"A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control."

This type of error, usually but not associated with...
Forum: Forms 11-12-2019, 09:07 AM
Replies: 9
Views: 608
Posted By missinglinq
Re: Form Before Update Cancel Event doesn't work

Nothing! You're right...trying to do too many things at once!

Corrected above!

Good catch!

Linq ;0)>
Forum: Modules & VBA 11-09-2019, 12:31 PM
Replies: 15
Views: 232
Posted By missinglinq
Re: only numbers function

That's true...but I'm getting old and forgetful...and I like making things as self explanatory as possible!

Linq ;0)>
Forum: Modules & VBA 11-09-2019, 11:54 AM
Replies: 15
Views: 232
Posted By missinglinq
Re: only numbers function

That's true...but the provided code uses the KeyDown event.

Glad we could help, amir0914!

Good luck with your project!

Linq ;0)>
Forum: Modules & VBA 11-09-2019, 06:49 AM
Replies: 15
Views: 232
Posted By missinglinq
Re: only numbers function

Here's a hack from the vaults that's the kind of thing that theDBguy suggested...(Replaceing YourTextBoxName with the actual name of your Control.)
Private Sub YourTextBoxName_KeyDown(KeyCode As...
Forum: Modules & VBA 11-08-2019, 03:49 AM
Replies: 11
Views: 183
Posted By missinglinq
Re: Function for auto dropdown for all combobox

Because in Design View he can select all 20 Comboboxes at once...go to the OnGotFocus Property...and enter =ShowDropDown() once...as opposed to having to create 20 events, one at a time...explicitly,...
Forum: Forms 11-07-2019, 06:46 PM
Replies: 8
Views: 123
Posted By missinglinq
Re: Avoiding #Deleted

I agree, of course! Preventing an error, rather than covering it up, is always, well at least always, the way to go!

I just wondered if anyone knew of any other reason for #Deleted to show except...
Forum: Forms 11-07-2019, 05:28 PM
Replies: 8
Views: 123
Posted By missinglinq
Re: Avoiding #Deleted

Actually...the OP says nothing about Deleting a Record!

Does #Deleted really show if data is simply 'unavailable?'

Or is this a sign of corruption?

Linq ;0)>
Forum: Forms 11-05-2019, 03:17 PM
Replies: 31
Views: 627
Posted By missinglinq
Re: Copy previous record fields into new record form fields

You can't enter this in the AfterUpdate event on the Event Tab in the Properties box...it has to be entered as VBA code, in the Form's code module...as simply

Private Sub Product...
Forum: Forms 11-04-2019, 01:25 PM
Replies: 31
Views: 627
Posted By missinglinq
Re: Copy previous record fields into new record form fields

As theDBguy said, you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close...
Forum: Forms 11-04-2019, 05:32 AM
Replies: 15
Views: 280
Posted By missinglinq
Re: scroll text in bar form caption

Stephen Labans, as is frequently the case for matters complicated, has a hack for doing this that requires little in the way of resources, he says...and you can always take him at his word:
...
Forum: Modules & VBA 10-28-2019, 02:52 AM
Replies: 4
Views: 102
Posted By missinglinq
Re: Access: Set focus cursor after character in a text box

See if this suits your needs:

Private Sub txt_Name_Click()
Me.txt_Name.SelStart = 3
End Sub

Private Sub txt_Name_Enter()
Me.txt_Name.SelStart = 3
End Sub
Forum: Forms 10-18-2019, 05:13 AM
Replies: 10
Views: 190
Posted By missinglinq
Re: question about froms

That's your problem! You can't have the Checklist Form as a Subform if it's not related to the Assets Form! You need to have the Checklist Table related to the Assets Table!

You need to

Add a...
Forum: Forms 10-18-2019, 02:36 AM
Replies: 10
Views: 190
Posted By missinglinq
Re: question about froms

Like Pat, I don't see a Table that looks appropriate for your Deployment Checklist...but, going by

it sounds as if you don't have a Field that is common to the assets Table and the checklist...
Forum: Forms 10-14-2019, 05:32 PM
Replies: 14
Views: 15,952
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: 185
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: 132
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: 226
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: 185
Posted By missinglinq
Re: Me.Refresh causes error

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

Me.Refresh

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: 114
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: 128
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
MsgBox...
Forum: Modules & VBA 09-18-2019, 04:47 PM
Replies: 41
Views: 465
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: 261
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: 157
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: 270
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)>
Showing results 1 to 25 of 500

 
Forum Jump



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