Search results

That should work I think ?? Do you want to zip and post your DB and I'll have a look?? Louchey

Thanks mate !!! Just what I was after. Cheers Louchey

Hi guys It would be great if someone could help me with this code. Basically if the message box is triggered and the user selects "cancel" I DO NOT want the secondary bit of code to run, ie if the iso has already been issued and the user selects cancel, I want it to do exactly that! I've been...

Sorry I couldn't help. Looks like you've gotta find the code to disable - Good luck Louchey

Well if this isn't the solution I'm afraid I can't help !! Prevent or allow access to all built-in toolbars in an Access database or Access project On the Tools menu, click Startup. Clear or select the Allow Built-in Toolbars check box. Notes Changes to this setting in the Startup...

Is the DB a .mdb file ??

Tools-Customize then check the various toolbars ect. Louchey

No problem Your welcome !!! Louchey

Try searching the forums for "security" There are plenty of good threads explaining what you can and can't do to secure a database. Louchey

There are a couple of ways of doing this....... If you only want to see a blank record and none of the others...... Set the "Data Entry" option to yes under the forms properties If you want the form to open at the last record........ Add this code to the "On Open" event of the form Private...

Hi Guys, Could someone please have a look @ the code below and help me modify it. Basically it attaches a file to an email and sends it. It attaches the first object but not the second. Not sure what I need to add to make it send the email with both the attachments. Any help would be greatly...

Hi Guys, I have modified some code posted here to email various objects from my database using Lotus notes. All works fine, but would like to see the emails show up in my sent folder so I can double check what has and hasn't been sent. Does anyone know what code to add in or modify. Any help...

I presume the list box is looking up values from a table or query?? If so, go to the source and delete any blank records. Maybe set that field as a primary key so it wont allow blank records in future. Louchey

I had the same problem several weeks ago. From what I gathered from other members, this is a known access bug. I have a module and I have to keep changing the code format to get DD/MM/YYYY. Looks like just one of those things I'm afraid!! Louchey

Hi Guys, Wondering if anyone has come across this before. When exporting a table to excel, the font seems to default to MS Sans Serif. I have set the default for the excel file as Arial. Any ideas ??? Cheers Louchey

well, I have been in Oz for 5 years now, but I'm still just another pom !!!!

Do you want the picture to become visible on the same form or do you want a seperate pop-up form??? Louchey

Thankyou Pat, As a rule I don't use spaces. Not sure what I was thinking this morning when I put this example DB together. Many thanks once again Ben

Hi Guys, Think this should be reatively simple ( though can't get it right myself) I have a form and on the afterupdate of "ISO ISSUED AFC" it puts todays date in "Issued Date" The problem is when I back the ticks off, obviously the"Issued Date" updates to today. Basically what I would like is ...

Sorry - Please ignore my previous post !!!