Search results

if i do this: DoCmd.RunSQL "Delete * from tblOutlookFolders" it prompts the user to confirm??? don't really want it to. anyone know a way round this? is just a temp table to hold values for a minute.

hahahahahaha!!!! did it all on my own!!! yay me. i wing my entire life from online forums etc, and OFTEN people work out final result and don't post it cause they are happy. for posterity and the help of others: here is the code to read the subfolders in the outlook inbox. u need to have a...

i'm thinking more that you jump into a form for attaching mail, it loads whatever subfolders are their for user selection at the time. import only, not pushing into outlook at all. frankly only have 10 users max here, 3 that might use this facility (for now fast growing company) and i'm happy to...

OK, trying to import and attach emails from outlook to my access dBase. have working code to do it, but need to give the user a way to only link emails related to a specific project. I've been toying with the idea of using subfolders, ie emails related to job 096 live in the 096 subfolder in...

*grin* i appreciate your candor. frankly 90% of what i do is supposition but surprisingly goes pretty well - LOL. Hopefully someone can clarify the gritty details at some point...

so ignore my post and just attach stuff to the onclick for ok and cancel or the onclose event. thanks, i'll just do that.

ok but the reading i had (see link above) said it stayed open and invisible till unloaded, making the user selection available. riddle me this: user selects from listbox on custom dialog, hits ok. if code execution stops till the ok button, and the form is dismissed immediately, how can you...

i swear i'm not spamming: http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html seemed to imply otherwise and seemed pretty sure of himself lol.

just tried: If CurrentProject.AllForms("frmModClaimOrVariSelector").IsLoaded = True Then MsgBox "Isloaded" Else MsgBox "NotLoaded" End If but STILL no joy. like hitting ok on the dialog closes the form not makes it invisible.

ok, did some reading on loading forms in the acDialog setting. all SEEMED to make sense. as i understand it, u call a form to dialog mode like this: DoCmd.OpenForm "frmModClaimOrVariSelector", acNormal, , , , acDialog and when the user his the ok button the form does a behind the scenes...

got it. never worked out why it didn't work but this: Between [Forms]![frmCivilMinorJobsMYOB_Overview]![txtExpDateToDateStart] And [Forms]![frmCivilMinorJobsMYOB_Overview]![txtExpDateToDateEnd] in the QBE worked

i've hit a bit of frustration here, thought i would throw it to the group. i have a form with some dates on it, you hit the button and the next form interprets the dates and filters results on a between date to date basis. I'm international btw, so it gets a bit confusing. once you have...

ok worked. with very little but not no code lol. but thats my requirements, thanks much for the help - does seem a bit slow to adapt to scrolling (you scroll, 2 seconds later the format changes) - is that normal?

looks good but not very flexible, i have tried the expression: IIf(DateDiff("d",[me]![DateSubmitted].[Value],Date())>14,true,false) in the "expression" options, but it does nothing, can i refer to the value in the field in my expression there?

i have a datasheet(see attached jpgs if ya like) which if you click on the "description" field will open the relevant form with the record. simple....so far lol. this was easy; a simple onclick macro solved it. now i need to adjust the color of description based on the time it was entered -...

i've been trying to copy all objects from 1 database to another to tidy it up. all went well but when i try to compile it stops at Dim xlApp As excel.Application 'stops here Dim xlWb As excel.Workbook Dim xlWs As excel.Worksheet Set xlApp = New excel.Application now...

yeah it doesn't seem to be code related - opening a blank form has slowed down... The rebuilding idea actually makes me feel slightly nauseous lol but i kind of saw that coming as it just keeps growing. i will compact for now. frankly figuring out everything being used and not used will be a...

i've been "growing" a database. build a bit, get feedback, build more on request. working good but notice that forms seem to take forever to save and change between modes, any ideas?

are you saying microsoft is phasing out active-x altogether? i hadn't heard that. not sure what u mean by lack of 64-bit versions as i'm on windows7 64bit and calendar control always worked. but your right; getting rid of it didn't kill me. i wasn't really using them for date selection *though u...

except i'm meant to deliver asap and they upgraded the office without telling me. i know i can write around it but far prefer to deliver and then get a new version to them asap. i get datepicker -but the calendar control seemed unlikely to go and gave a great visual reference to before and after...