Search results

Hi i have a macro that runs a number of queries- each one assembling data- populating tables to finally make a master table of all the data i need- it runs about 8 queries in a row- works great except i get this message at each stage of the macro: you wont be able to undo the changes thois...

cheers dubs

yeah, our IT dept refuses to add the db locally via a logon script due to it's size so they have to access it on the network... so what is happening to cause it to leave a backup file every time?

only because it has backup in the filename: ie Junior School Pastoral Log becomes: Junior School Pastoral Log_Backup if a user was crashing out it would aslo leave the locking file behind so am confused as to what's causing this.. any ideas? dubs

hi, every time i look in or shared area i see a new backup file of one of my mde's... junior school pastoral log_backup it seems every time i delete one a new on is there next time... what's causing this? is a user not logging out of the software properly or what? cheers greg

Hi all, i have an access db which uses a vb command to piece together data fields into an email which is sent via smtp, the problem ive recently encountered is that the mails are being truncated, they don't seem to truncate at the same number of characters, but after 17 lines... ive included...

Hi all, i have a report with an embedded subreport. both come from the same table- the main report use a distinct select to get studentid, examid, yearid. the subreport matches the studentid, examid, yearid with the main report and shows the subject and result values. therefore in theory by...

Hi all, an app an ex-colleague created produces an error message when i right click on a form field. It says: mircosoft access cant find the macro 'ucas' now the macro isn't there but i need to find out what is invoking this macro, there are no vb events programmed for the field so it's not...

Hi all, an app an ex-colleague created produces an error message when i right click on a form field. It says: mircosoft access cant find the macro 'ucas' now the macro isn't there but i need to find out what is invoking this macro, there are no vb events programmed for the field so it's not...

i cant but i always get this (i put it down to accessing db's in design mode over a poorly maintained network) and what i do is copy the sql of the offending statement, delete it and then copy that sql into a new blank statement. yeah i know, not really a solution when it's happening regularly...

Here is the declaration: Public Function SendEmail_CDO(strFrom, strTo, strCC, strSubject, strBody) Dim mail Dim config Dim fields Set mail = CreateObject("CDO.Message") Set config = CreateObject("CDO.Configuration") Set fields = config.fields With fields...

yes, thats right greg

Right, had a go- im getting a runtime error '424'- object required on this line of code: .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = termite.pgs.org.uk ' SMTP SERVER .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "212.219.13.252" ' IP OF SERVER...

hoiw do i call the procedure in my code? greg

ah sorry yes, i see now, cheers greg

ah this wasn't exactly right, seemed to pertain to using outlook, which i cant. greg

nice one, cheers bud greg

Hehe, to say that our IT dept is shite would soimply be the understatement of the century- want another funny one? our sql database has no primary keys!!!! yup- you heard it, the company who designed it felt it best not to include any unique identifiers...nightmare!! anyhoo, yes they do have...

Hi all, after spending wweks perfecting a database which centres on the ability to email the contents of what you have just entered i find that our stirling IT dept haven't actually setup any of my intended users with outlook profiles and do not intend to. Therefore whenever they try and send...

Hi, i have a db which everyone uses which has started throwing up error messages whenever someone logs in: unsafe expressions not blocked.... despite setting my macro security to low when i log in as the user to test it i get the same message, looking at the macro security shows me it is set...