Search results

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 have many heating units each heating unit can use many controllers rather than code everything, how...

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 30 yrs and 30 days before I need to register..... There are some good security modules about. Sage...

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 description ) What happens if the person has 2 days off in between? How are the time sheets logged? Are...

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: I've had many downloads but not one installation... I get a notification for installs. I'm notified on...

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

Hi Yes no problem. I'll do it tonight / tomorrow depending on how much my jetlag takes over lol

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 for typing but hooked into the whole MS certified thing. At the end of 6 days, I was able to...

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 of my apps, I needed to hide the window so read in depth what I could get away with. I placed the text...

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

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 iris or moneysoft. Doing it your way will no doubt get you into trouble. Bear in mind that if...

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 http://www.ebay.co.uk/itm/231032603676?ssPageName=STRK:MESELX:IT&_trksid=p3984.m1555.l2649 Pro...

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 are relevant to Access users? Thanks Nigel

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 code in the OnOpen event of the report form- fSetAccessWindow(SW_SHOWNORMAL) Let me know how you...

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 have to load a form with an address each time, you can pass the email address via code and loop...

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 taskbar), but completely hide the window from the taskbar too and show it in the systray (bottom right). This...

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 and I'll send my email address Thanks

Hi can you post your code where your error is? its very hard to second guess thanks

FYI there is way of reading a db password in hex. im not going to post it on here but there is a way ;) N

I would agree and disagree. It's not gospel, you're totally right. It's more a programming preference. The only reason I keep to a standard of sorts is to stop me getting confused. When looking through reams of coding, it's to remember whether your record set is collecting from a table or query...

well, you 'could' do it at your own peril..... using vba, you can loop through the forms, queries and tables opening them in design view and change the name that way, then try and sift through the code to change the same with a find/replace? N