Search results

Ok, I built a database that is to be used by multiple people across the network. I built it so that it required minimal interaction with the backend. Im now in the testing phase, and one of the checks I did was to see how it handled when two people accessed it simultaneously. Well it didn't...

Hey, I have to create a series of subforms that are used to display information that is currently stored in spreadsheets. This is ok, as for a couple I have simply created a series of text boxes and bound them to a table. My issue is that some of the spreadsheets contain upto 200 columns...

ahhhhh brackets... you just saved me from a mild mental breakdown there pbaldy.. i was worried i had to rewrite a whole heap of code... thanks

Hi, I have some code that runs through and pulls out a value from a table based on the following code SELECT tbl_Users.UserId FROM tbl_Users INNER JOIN tbl_Secondary_Location ON tbl_Users.Department = tbl_Secondary_Location.LocationID WHERE ((tbl_Secondary_Location.Quality_&_Food_Safety = -1)...

yeah i dont think that'll work too well since this db will be distributed to a large group of people.

Ok, I have my db sending off emails with a report set as the body of the email. However I loose the formatting of the report in the process. One of the key items that I require is Check Boxes, which seem to refuse to be displayed. Is there another way of achieving this? Are there any...

haha your right.. i thought i had that field in there so i dismissed that as a possibility... cheers gemma

Sorry for the delay Geroge, i've working on a bigger issue.. Here is the SQL.. SELECT tbl_Change.ChangeNumber, tbl_Change.Initiator, tbl_Change.Title, tbl_Change.Description, tbl_Change.Primary_Location, tbl_Change.Secondary_Location, tbl_Change.Status, tbl_Change.Date_Start...

Ok, I fear I may have fixed it by uninstalling Avast anti virus... Could that have been the cause? and if so, how would i combat it?

Yes... as well as office and access and a bunch of others.. Is it possible to have a corrupt reference? So far I have found the that the issue is that Outlook refuses to be opened by Access. If I use the OL = createobject("outlook.application") method then I get an automation error. If I...

Anyone got any ideas?

hmm? I used your code with real values yes... I build a list of emails in the form of --> "name@domain.com"; "name2@domain.com" <-- That is called list That's what i had in the reference above , when testing i was just using "fred", but it works out the same. I've reverted...

yeah, the above line is what i had, still didnt work... I've made progress though guys. I've found that the issue im having is not with the code, but rather the task of launching Outlook when it isn't running.. If I have Outlook going the code works a treat. So, how do I fix this? I assume...

@Nightmayor using this line DoCmd.SendObject acSendReport, "report2", acFormatHTML, list, , , "subject here", "message body here" i get an error Runtime 2293 "my project name here" can't send this e-mail message

not really no.. I still think the issue is with the docmd.outputTo is there another way to do this? since i want to have a Report be the body of the email

That gives me a different error Bob. RunTime 424 Object Required on the ' Set OL = CreateObject("Outlook.Application")' line

I might give that a go.. However I think i've narrowed the problem to this bit of code If Not rejected Then If newEmail = True Then DoCmd.OutputTo acOutputReport, "report1", acFormatHTML, "C:\myreport.html" '' seeking approval Else DoCmd.OutputTo acOutputReport...

nah it just stopped working... on more than one computer.. the computer it originated on had office 2003 uninstalled, 07 installed, then uninstalled and 2003 put back on... if that could have caused something to go wrong how could i fix it?

I have a report that is filled via a query. This works, however one of my fields does not always contain a value, and when this happens, Access jumps up and asks what you wish to put in there. Does anyone know how to stop this?

Ok... Im trying to generate a list of users with role 'STC' and department given from a form. Im doing this by first building a recordset of all users with the role of STC, and then based on that, building a second recordset to reference the department. I.e. Usertable User - Role - Department...