Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 51
Search took 0.01 seconds.
Search: Posts Made By: scallebe
Forum: Forms 09-25-2019, 10:36 PM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

#arnelgp,

I can imagine that… :o

No problem, I am grateful for what you have done already.

I added the "Exit sub" and it works fine.

I just wanted to know if my solution is the right way.
Forum: Forms 09-25-2019, 09:07 PM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

Good morning arnelgp,

Thanks for reply :)

I figgered out the changes you did… :p

One thing didn't work yet :

When the "msgBox" apears (to save the record or not), I click to No and the...
Forum: Forms 09-25-2019, 09:49 AM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

#arnelgp,

Thanks for reply.

It's not working yet like it supose to… :(

I'm gonna do my best to explane… :rolleyes:

What happens in the orignal version :
Forum: Forms 09-25-2019, 03:11 AM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

#JHB,

I still have the same error, even with the database I posted. Even after Compact & repair...

See photo…


#arnelgp,

Your solution is working…
Forum: Forms 09-25-2019, 01:14 AM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

#JHB, #arnelgp

Thanks for reply.

#arnelgp : I have the same result with your solution.

I mannaged to reduce my DB with the form in question.

Fill in the green fields, click next and click...
Forum: Forms 09-24-2019, 10:29 PM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

JHB,

Thanks.

I already try that. I'm having the same message and my Form doesn't clear. :(
Forum: Forms 09-24-2019, 09:48 PM
Replies: 16
Views: 223
Posted By scallebe
Re: Microsoft access warning

JHB,

Thanks for reply

But I don't know what you mean…:(
Forum: Forms 09-24-2019, 09:14 PM
Replies: 16
Views: 223
Posted By scallebe
Microsoft access warning

Good morning Specialists,

After input my form fields I click a button to create a mail. Works fine.

Before the "email code" starts, the user has the possibility to save the record and continue...
Forum: Reports 09-23-2019, 01:33 AM
Replies: 8
Views: 210
Posted By scallebe
Re: Sum of fields with "INT" function

ok, sorry about that...:(

The 2 formula's of Isladogs worked fine...

Working with a query was also a good method #arnelgp

And AllanBrown's solutions : Works fine too… #CJ LONDON


Thanks...
Forum: Reports 09-22-2019, 11:17 PM
Replies: 8
Views: 210
Posted By scallebe
Re: Sum of fields with "INT" function

Thank you all for reply.

I tested all your solutions…:):)

#Pat Hartman,

That was something I didn't know, It explanes a lot in my other DB's … :rolleyes:

See you all next time.
Forum: Reports 09-22-2019, 01:12 AM
Replies: 8
Views: 210
Posted By scallebe
Sum of fields with "INT" function

Good morning everybody,

I have in my report some calculated fields and I want to calculate the sum of these fields in my pagefooter.

From the calulated fields I need the integer part of the...
Forum: Modules & VBA 09-19-2019, 02:44 AM
Replies: 3
Views: 105
Posted By scallebe
Re: Chow password gives me a strange result

#CJ LONDON, #isladogs

Thanks for reply,

Once my DB is ready, I'm gonna use a longer password. Now I use a short one because it's easyer as long as I'm in the design mode of the DB.

I used...
Forum: Modules & VBA 09-18-2019, 11:29 PM
Replies: 3
Views: 105
Posted By scallebe
Chow password gives me a strange result

Good morning specialists,

I find a code on the web to show or hide the password in my Loginform.

Private Sub lbl_Click()
If Me.lbl.Caption = "Show Password" Then
Me.UserPassword.InputMask =...
Forum: Modules & VBA 09-16-2019, 06:52 AM
Replies: 11
Views: 183
Posted By scallebe
Re: Clean-up map with pdf's

arnelgp,

Thanks…

I am a little jealous of what you all realize as if it is nothing …

I also want to delve more into VBA, but time is not on my side at the moment...


Thanks again :):)
Forum: Modules & VBA 09-16-2019, 04:14 AM
Replies: 11
Views: 183
Posted By scallebe
Re: Clean-up map with pdf's

Good afternoon arnelgp,

In #6 you set a code to clean-up my PDF-folder. Works perfect:):)

I have a second pdf folder to clean-up the same way...

in following path :

CurrentProject.Path &...
Forum: Reports 09-14-2019, 09:54 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

I didn't work in the afterupdate event of the textbox.

My LoginForm stays open but hidden after input password. For various reasons. In many cases I refer to certain data in that...
Forum: Reports 09-14-2019, 09:09 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

The code in post #13 is in all forms (for users) in the on open event to enable or disable the shortcutmenu in the forms.

Now I want to use the print_menu & print_menu2 in the...
Forum: Reports 09-14-2019, 08:31 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

Arnelgp,

To enable or disable the shortcutmenu for all forms the code is placed in every on open event of the form. And only the forms who are available for users. Not in the Admin forms.

So...
Forum: Reports 09-14-2019, 07:58 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

That's where I'm a little confused,

Do I put in the Loginform or in a module?:confused:
Forum: Reports 09-14-2019, 07:20 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

So the first line of code (Tempvars.Add……etc.) I put in in my LoginForm?

Because I don't know what you mean with public variable… (sorry):confused:


Thanks again

Greetz
Forum: Reports 09-14-2019, 07:12 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

Sorry,

I didn't see you last post... :o
Forum: Reports 09-14-2019, 07:10 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

I realy appreciate what you do, fantastic!!!


With you last code you disable all the shortcutmenu's for all users in forms and reports. But now the users can not print any report...
Forum: Reports 09-14-2019, 05:28 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

For the forms the users don't need a shortcutmenu. So it is not necessary to create a menu specially for forms. I disabled the standard shortcutmenu for users and enabled it for admins.
...
Forum: Reports 09-14-2019, 01:35 AM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

arnelgp,

That's indead a little diffirent :rolleyes:

Thank you so much. :):)

In my forms I enable or disable the shortcutmenu depending on user or admin as follow :

Dim Dienstlevel As...
Forum: Reports 09-13-2019, 09:42 PM
Replies: 27
Views: 299
Posted By scallebe
Re: Run code before close report

Good morning arnelgp,

I'm experimenting a little and I added a 3th command in the short cut menu.

Private Sub subCreateReportShortcut()
'arnelgp
Const SHORTCUT_NAME As String =...
Showing results 1 to 25 of 51

 
Forum Jump



All times are GMT -8. The time now is 03:39 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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World