Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: NigelShaw
Forum: General 09-30-2019, 10:43 AM
Replies: 38
Views: 44,951
Posted By NigelShaw
Re: Access to Outlook Calendar for Alert or Alarm Message Reminders

It's been a while now but.....

If the appointment exists you need to edit it, if it doesnt exist, you need to add it

You cannot add what already exists
You cannot edit what doesnt exist
Etc...
Forum: General 09-15-2019, 09:24 AM
Replies: 18
Views: 6,924
Posted By NigelShaw
Re: Which image formats to use with ribbon buttons?

Hey

Most likely problem is the file referencing as 2010 is older than 2016 and might not have the required files that 2016 has natively.

Take a look at the references in VBA to see if anything...
Forum: General 11-27-2017, 01:01 AM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi

No i havent seen that site before. Mine was a bit of a frankensteins monster if im honest. I have written some code then found some code that nearly did what i wanted so i merged them together...
Forum: General 11-19-2017, 01:48 PM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi

Been a while since I have been on this forum, I moved to vb.net.

If the code you posted is the code you are using, then this maybe your issue. You can only have this at the top of a module
...
Forum: General 08-09-2015, 12:50 AM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi,

couple of things. What is the reason for a hyperlink to open the database instead of a shortcut? also, do you have an autoexec set up in the database to fires when the database opens? you...
Forum: General 08-07-2015, 09:59 PM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi

sorry i havent managed to reply before now, I dont use Access any more as i migrated to vb.Net. Anyway, This sample should help you all out. When it opens, the Access window is completely...
Forum: Tables 10-06-2014, 11:47 AM
Replies: 3
Views: 566
Posted By NigelShaw
Re: Table Structure

Hi

Thsnks for the reply. The database is more like a fault finding or solution database.cthe idea is, you select a boiler and only the controllers that work with that boiler will appear. From the...
Forum: Tables 10-06-2014, 07:07 AM
Replies: 3
Views: 566
Posted By NigelShaw
Table Structure

Hi,

its been a while since i have been anywhere near Access but i find myself in need of a structure and i cant think of the best way. I am hoping for a bit of help :)

I need to create a...
Forum: Tables 03-15-2014, 08:59 AM
Replies: 1
Views: 461
Posted By NigelShaw
Hi I did this once and I'm an expert...

Hi

I did this once and I'm an expert database programmer. I found it much better and far more financially viable to purchase an application instead from moneysoft :)


N
Forum: Tables 03-04-2014, 12:44 PM
Replies: 1
Views: 365
Posted By NigelShaw
database design

Hi

i havent been on Access for a while so im still in the process of getting the cogs turning....... i am trying to design a database structure for controllers and heating.

each controller can...
Forum: General 12-20-2013, 08:23 PM
Replies: 4
Views: 733
Posted By NigelShaw
Hey, You might want check about forward...

Hey,

You might want check about forward clocking. If I downloaded it today, I could reset my PC for 30 yrs forward, install and then rest the time. I would then be in - days effectively giving me...
Forum: General 12-04-2013, 11:45 AM
Replies: 4
Views: 527
Posted By NigelShaw
Re: Any idea's? Timesheet attempt

Hi

Yes it does explain better however, let's look at this scenario to help me understand more:

Job starts 01/04/2013
Job ends 07/04/2013
1 person working

6 days on the job ( based on your...
Forum: General 12-04-2013, 09:22 AM
Replies: 0
Views: 530
Posted By NigelShaw
Looking for a favour :)

Hi

In my signature is a link to my app download. Could someone please do me a favour and try to download and install then message me back with every / any error you may experience?

Reason:...
Forum: General 12-04-2013, 09:19 AM
Replies: 4
Views: 527
Posted By NigelShaw
Re: Any idea's? Timesheet attempt

Hi

You would need to give a little more info I'm afraid. Your question doesn't supply enough info to create any possible solution.

PM me if you like


Thanks
Forum: Modules & VBA 12-04-2013, 09:16 AM
Replies: 5
Views: 25,929
Posted By NigelShaw
Re: update linked table via VBA

Hi

Yes no problem. I'll do it tonight / tomorrow depending on how much my jetlag takes over lol
Forum: General 11-18-2013, 07:03 PM
Replies: 3
Views: 856
Posted By NigelShaw
Honestly, you'd be better getting someone to show...

Honestly, you'd be better getting someone to show you one on one even if you pay them. I went on a course, it cost me about 600 and all I got was some early retired woman who mainly tutored girls...
Forum: General 11-18-2013, 06:57 PM
Replies: 60
Views: 77,300
Posted By NigelShaw
Hi Just to clarify the 'Breach'....... ...

Hi

Just to clarify the 'Breach'.......

I read in MS documentation that it is in breach not to display the runtime text "powered by Microsoft access runtime" and the associated logo.

In one...
Forum: Modules & VBA 09-30-2013, 09:51 AM
Replies: 6
Views: 444
Posted By NigelShaw
Hi Couldn't you simply create a report to...

Hi

Couldn't you simply create a report to check for open cases? You could challenge that query with a VBA record set and fine tune it quite easily.

Nigel
Forum: Modules & VBA 09-30-2013, 09:48 AM
Replies: 4
Views: 524
Posted By NigelShaw
Hi Salaries can differ month to month due to...

Hi

Salaries can differ month to month due to tax deductions at the point of payment. Even if it differs by a few pence, it differs. You really need a proper, well established payroll software like...
Forum: General 08-16-2013, 06:29 AM
Replies: 0
Views: 556
Posted By NigelShaw
Access VBA books for sale

Hi

The time has come for me to clear out my shelf and sell my Access learning books. They are all on ebay so if you see something you need, make a bid :)

Brilliant VBA for Microsoft Access 2007...
Forum: General 08-16-2013, 04:19 AM
Replies: 0
Views: 608
Posted By NigelShaw
Selling access books

Hi

before i go ahead and potentially doing something wrong on the forum, i wanted to ask first.

I am selling all of my Access books on ebay at 5 each.

Can i post the links on here as they...
Forum: General 08-12-2013, 11:53 AM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi,

without checking i would say its the code. because the code wants to suppress everything that would include the report window unless you explicitly ask it not to

you could try putting this...
Forum: Modules & VBA 06-07-2013, 09:20 AM
Replies: 5
Views: 1,430
Posted By NigelShaw
Re: Email Without SMTP

900,000 records? id be surprised if your ISP let that happen? that many records in short time would flag up surely.

anyway, assuming that you can do it, your process is a bit long winded. you dont...
Forum: General 06-07-2013, 09:11 AM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hi Barrie

you dont need my permission as the code is readily available on the internet

FYI... i have also managed to not only hide the application window (where it is suppressed to the...
Forum: General 06-06-2013, 06:36 AM
Replies: 60
Views: 77,300
Posted By NigelShaw
Re: Hide Main DB window - only show form - ACCESS 2010

Hmmmmm that's odd. I have the same code on a runtime and it works great. I could take a look at your DB as it may be some other rogue coding. Search key wouldn't be related I think.

You can PM me...
Showing results 1 to 25 of 500

 
Forum Jump



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