Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.88 seconds.
Search: Posts Made By: JHB
Forum: Modules & VBA 10-08-2019, 08:54 PM
Replies: 3
Views: 136
Posted By JHB
Re: Code Prob

The control name isn't ALLOCATION but Combo32, so the event isn't triggered.
Forum: Theory and practice of database design 10-05-2019, 03:48 AM
Replies: 14
Views: 311
Posted By JHB
Re: The pitfalls of VBA proficiency

I think it is normal. We are too busy to get our idea to work, that we can't see the forest for all the trees! :)

A break does wonder, is my experience. :)
Forum: Forms 09-30-2019, 07:46 PM
Replies: 6
Views: 166
Posted By JHB
Re: Me.Refresh causes error

Post a printscreen of the error and the actually code, or post your database with some sample data + description to reproduce the error.
Forum: Forms 09-30-2019, 07:13 AM
Replies: 7
Views: 161
Posted By JHB
Re: Corruntion from AMD Radeon

Did you try to create a new database with a new form and a date picker in it?
If that works okay, I would delete the control in the old database with the date picker and create it from new!
Forum: Forms 09-29-2019, 07:42 AM
Replies: 7
Views: 161
Posted By JHB
Re: Corruntion from AMD Radeon

What Windows version were you running before and after the computer update?
Also what version of MS-Access before and after?
Forum: Forms 09-25-2019, 01:56 AM
Replies: 16
Views: 214
Posted By JHB
Re: Microsoft access warning

I do not get the error you mention, (but something else according to the Error$)!

Did you try the database you posted?

Do a "Compact & Repair".


And please next time, if you want people...
Forum: Forms 09-24-2019, 10:56 PM
Replies: 16
Views: 214
Posted By JHB
Re: Microsoft access warning

Could you post your database with some sample data, zip it!
Forum: Forms 09-24-2019, 10:01 PM
Replies: 16
Views: 214
Posted By JHB
Re: Microsoft access warning

The line marked with red:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strMsg As String
Dim iResponse As Integer

' Specify the message to display.
Beep
strMsg = "Wil je...
Forum: Forms 09-24-2019, 09:22 PM
Replies: 16
Views: 214
Posted By JHB
Re: Microsoft access warning

Try to comment out the "Me:Undo".
Forum: Forms 09-24-2019, 07:48 PM
Replies: 6
Views: 147
Posted By JHB
Re: Problem while communicating with OLE or ActiveX

Try by creating a new form, then copy a part of the controls into the new form, if no error copy a part more and so on, until you get the problem one, (or until the all controls are copied).
Here is...
Forum: Reports 09-21-2019, 01:44 AM
Replies: 9
Views: 206
Posted By JHB
Re: Report with subreport excel export alignment problem

Could tell me why you want to export the report to Excel?
Forum: Reports 09-20-2019, 10:35 PM
Replies: 9
Views: 206
Posted By JHB
Re: Report with subreport excel export alignment problem

Don't think you will be able to succeed because there is no way to influence how the data is inserted into Excel. But another thing is why do you want to export the report to Excel?
Only option as I...
Forum: Reports 09-20-2019, 02:47 AM
Replies: 9
Views: 206
Posted By JHB
Re: Report with subreport excel export alignment problem

How do you export it to Excel?
Is it possible for you to post your database with some sample data, (zip it because you haven't post 10 post yet!)?
Forum: Modules & VBA 09-19-2019, 09:49 PM
Replies: 18
Views: 318
Posted By JHB
Forum: Modules & VBA 09-18-2019, 11:48 PM
Replies: 18
Views: 318
Posted By JHB
Re: Problem communicating with OLE server or ActiveX Control

The problem is related to two of the controls in the form, so first delete them from the form, then run the form and click the button to test if all is okay.
Then create them from new.
The first...
Forum: Modules & VBA 09-17-2019, 08:56 PM
Replies: 18
Views: 318
Posted By JHB
Re: Problem communicating with OLE server or ActiveX Control

<br>
Okay - but still missing the database with the data!<br>
Forum: Modules & VBA 09-17-2019, 08:02 PM
Replies: 18
Views: 318
Posted By JHB
Re: Problem communicating with OLE server or ActiveX Control

<br>
The backend database isn't attached and because you removed the picture in the first post, you need to tell the form name!
Forum: Forms 09-17-2019, 04:46 AM
Replies: 4
Views: 100
Posted By JHB
Re: chart + button

And what is the problem with that?
Forum: Modules & VBA 09-16-2019, 09:32 PM
Replies: 18
Views: 318
Posted By JHB
Re: Problem communicating with OLE server or ActiveX Control

Try to decompile the database, the link explain how.
https://www.fmsinc.com/microsoftaccess/Performance/Decompile.asp
If that not helps, create a new database and import all into it.
If that...
Forum: Modules & VBA 09-16-2019, 09:27 PM
Replies: 16
Views: 273
Posted By JHB
Re: To 'Call' or not to 'Call'

I use it exactly like arnelgp.
Forum: Forms 09-15-2019, 06:46 PM
Replies: 11
Views: 3,917
Posted By JHB
Re: Forms Disappear

Check like below pic:
https://access-programmers.co.uk/forums/attachment.php?attachmentid=76495&stc=1&d=1568601957
Forum: Forms 09-12-2019, 08:45 PM
Replies: 17
Views: 510
Posted By JHB
Re: Running out of Memory Errors ....

I'll not say that it isn't a Win10 / Office 365 problem, but I lean more to the assumption that something in your database is corrupt or maybe something in your data is wrong.
Is the query based...
Forum: Forms 09-09-2019, 09:38 PM
Replies: 17
Views: 510
Posted By JHB
Re: Running out of Memory Errors ....

What if you open the query without open the form?
Is that the only form that have the problem?
Forum: Forms 09-09-2019, 07:35 PM
Replies: 4
Views: 110
Posted By JHB
Re: Forms

I'll just say good luck, I don't think someone here will make your project for you, so show what you have and where you've the problem.
Learning VBA in a short time, forget it, it take years if you...
Forum: Tables 09-09-2019, 06:20 AM
Replies: 11
Views: 175
Posted By JHB
Re: Property not found

Does it say which property that is not found?

Create a new database and import all (tables) into it.
If that not succeed, create a new one again and import 1 or 2 tables at a time, until you get...
Showing results 1 to 25 of 500

 
Forum Jump



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