Go Back   Access World Forums > Search Forums

 
Showing results 1 to 18 of 18
Search took 0.03 seconds.
Search: Posts Made By: MS ACCESS PROBZZZ
Forum: Forms 09-04-2018, 11:45 AM
Replies: 20
Views: 274
Posted By moke123
Re: Not In List Event to improve UX of Edit List Items

IIRC since your using compound keys,No. you cant enter a record without entering both values. Without the compound keys the code i originally posted works.
Forum: Forms 09-01-2018, 11:00 AM
Replies: 20
Views: 274
Posted By arnelgp
Re: Not In List Event to improve UX of Edit List Items

it will work without the hidden textbx if the pop uo was closed using thr button.
when the user closes the pop yp using the [X] on the form, what then, the record is not save and yiu have
a code in...
Forum: Forms 08-31-2018, 08:01 PM
Replies: 20
Views: 274
Posted By GinaWhipp
Re: Not In List Event to improve UX of Edit List Items

If it's working fine without the hidden text box then remove it and don't give it another thought. And after reading arnelgp's post the other code needed it the one I posted does not.
Forum: Forms 08-31-2018, 05:14 PM
Replies: 20
Views: 274
Posted By GinaWhipp
Re: Not In List Event to improve UX of Edit List Items

Okay, why? What is the purpose of the Text Box? That said, you should be able to add a line, something like...

Me.YourTextBox = NewData
Forum: Forms 08-31-2018, 04:52 PM
Replies: 20
Views: 274
Posted By GinaWhipp
Re: Not In List Event to improve UX of Edit List Items

I guess I'm not getting why all the extra code and why something like the below won't work...

On Error GoTo Err_Publication_IDFK_NotInList

Dim intAnswer As Integer

intAnswer...
Forum: Code Repository 07-10-2018, 04:54 PM
Replies: 3
Views: 3,479
Posted By isladogs
Re: How to calculate Easter for any year

You posted to the repository which is a moderated area.
In this case, luckily I saw the post almost as soon as you did it ...

Public Function GetEasterSunday(Yr As Integer) As Date

This is an...
Forum: Tables 07-10-2018, 04:27 PM
Replies: 4
Views: 246
Posted By isladogs
Re: What's a function for updating dates like Mother's Day?

I can't help you with Mother's Day which I believe varies depending on your country location but this thread includes functions for Easter Sunday and for several other holidays
...
Forum: Queries 06-22-2018, 12:54 PM
Replies: 16
Views: 22,103
Posted By Pat Hartman
Re: Append query without duplicates

This is an Access "feature" being overly helpful to you. You should turn off this "feature" and go to every single table and delete all the duplicate indexes it helpfully generated for you.
...
Forum: Queries 06-21-2018, 08:02 PM
Replies: 16
Views: 22,103
Posted By Pat Hartman
Re: Append query without duplicates

Here is a picture of a unique index. Chose a unique name. Then select each field one at a time. Leave the index name blank for fields 2 through 10 (max number allowed) to indicate that they belong...
Forum: Modules & VBA 06-14-2018, 03:35 AM
Replies: 20
Views: 981
Posted By arnelgp
Re: VBA not requerying form on not in list event

Had you post the db earlier, we might solved it the soonest.
Forum: Modules & VBA 06-14-2018, 02:11 AM
Replies: 20
Views: 981
Posted By moke123
Re: VBA not requerying form on not in list event

In the table set your display control back to textbox.
On your form bind the combobox to the appropriate field and then set your rowsource in the combobox properties.
Forum: Modules & VBA 06-13-2018, 04:20 PM
Replies: 20
Views: 981
Posted By Cronk
Re: VBA not requerying form on not in list event

@ MS ACCESS PROBZZZ

The data in frmGetData needs to be captured before it is closed.


varDataN was meant to represent local variables in the calling form to hold the entered data. It could...
Forum: Modules & VBA 06-13-2018, 02:14 PM
Replies: 20
Views: 981
Posted By Cronk
Re: VBA not requerying form on not in list event

In the case of capturing other data, I open the form in dialog mode
docmd.openform "frmGetData", , , , , acDialog
to stop the user switching to anything else.


On the OK button of frmGetData, I...
Forum: Modules & VBA 06-13-2018, 12:51 PM
Replies: 20
Views: 981
Posted By Cronk
Re: VBA not requerying form on not in list event

There is no need for another form to enter the new data in the combo.
Private Sub ProductSubCat_IDFK_NotInList(NewData As String, Response As Integer)

If MsgBox("Do you want to add " &...
Forum: Modules & VBA 06-13-2018, 09:54 AM
Replies: 20
Views: 981
Posted By arnelgp
Re: VBA not requerying form on not in list event

It is very simple. Look at the sample that i have created to mimic your forms.
Forum: Modules & VBA 06-13-2018, 01:02 AM
Replies: 20
Views: 981
Posted By arnelgp
Re: VBA not requerying form on not in list event

here again.
add an unbound textbox (txtHidden) to frm_AddSku.
set its visible property to No.
some unnecesary codes were commented.
the folkowing is a modified code:

Private Sub...
Forum: Modules & VBA 06-12-2018, 05:16 PM
Replies: 20
Views: 981
Posted By arnelgp
Re: VBA not requerying form on not in list event

There are many ways to fix this. The one you missed is that after the new sub cat is added you need to set the Response to acDataErrAdded.

But the question is how will you know if the sub cat is...
Forum: Queries 04-27-2009, 02:11 PM
Replies: 2
Views: 9,063
Posted By HiTechCoach
Re: Convert AutoNumber to Number

Bill,

Yes it is possible to do. Here is how I do it.

In the query used a calculated field with the Clng() to convert the data type.


Example:
MyFieldName: Clng([MyAutoNumberField])
Showing results 1 to 18 of 18

 
Forum Jump



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