Search results

Thankyou, I will try this.

Sure is, use the SendObject action. Here you can, add the to email address, a CC email address, BCC, subject of the email, body text and more. Go to Macros, select new and in the drop down box for the actions, select SendObject. You will see all the options appear in the bottom left of the...

No, as I only created in password on the BE. Didn't think I needed to touch the links for the tables on the FE. Will this fix the problem??

Hi I have split my DB, FE & BE. The BE is located on a network drive and the FE is located on several local network drives for staff to use. Once I created a password for the BE, the main form would not open for the user on the FE. How can I secure the BE so the data can't be opened...

Hi, I have the following code in my DB. What I would like it to do is attach 2 reports to the one email. You can see one report is attached "rptCST_Access_Request" I would also like to attach "rptCST_Access_Request_Message" to the same email. Any VB Gurus out there that would have a better...

Hi, I have hidden all the menus and added one of my own custom menus to a DB that I was creating. That DB has been completed. Now when I open a blank DB to commence again, I have the same hidden menues and my one custom menu. Is there away in Access 2003 that I can replace the template, for...

Hi Have been working on my DB for some weeks and I'm now at the stage where I'm having a few difficulties that I feel might require code. I'm happy with what I have put together and have been learning lots along the way. Can some assist with these issues, Have a table called tblAccess_Issues...

Found it Thankyou for all the replies, you hold the shift key down when you start the DB right. Garry

Ok Yeah, I guess I can do this at the last minute and this will block access to design views. Garry

Hi I went into tools, startup and unchecked allow full menus. Now when I open the DB, I don't have the tools menu so I can check the allow full menus. I need to get this back so I can continue working on the DB. There must be someway to get this back/reverse it. Access 2003 Thankyou Garry

Hi On my main form, I would like to disable the right click so user can't change the form to design view. I checked the properties and could only see allow form view, and that is set to yes. Can anyone help? Garry

Output file Thankyou, where would i put this code you sent. Also I want the report to load as an email attachment, to to a file location. Can you help.

I new it was something simple, thankyou. What about my other post, would you have a solution to that? Much appreciated Garry

Hi When i hit the command button to email a report, a small window appears asking what output would i like to use, Excel, RTF, Snapshot etc. I always want the report to output using snapshot, is there someway I can tell the button once clicked, I would like the output to be snapshot viewer to...

Hi Can some assist with this problem. tblAccessDetails frmAccessDetails I have the above table and form. I use the form to add the data to the table. However I can't add all the data I want for that record, so I need to go back later to continue to add data to the same record. But I need to...

Error Hi, but the field must contain data so I can't set this to allow null. Garry

DB error, sent DB Hi I sen the DB to your email address. Let me know if you can open it. Garry

Data not appearing in table from form Hi When I tested the DB, I have an error message, see attached doc. Basically the message is saying that the Property Reference field cannot contain null value, as the field requires data. I have used the property ID as the drop down box and the...

It worked Thankyou for providing this info. Worked just fine. Garry

Hi, my first post and I hope someone can assist. I have one combox on my form. When I select a property identification number, I would like the following text boxes on the form to update auto as a result of the property identification being selected. So I need the unit Number, street number...