Search results

Hi Even if macro's are selected there is always a way to hack into an Access Database. You can right click on a ribbon and alter the settings in an around about sort of way. Also, users must also have access to the tables for the database to work. I guess malicious users will be able to find...

Hi There are a couple of threads with email stuff in including one i have posted to: Alternative to SendObject to achieve automation. Access will not be able to fully automatically do this... someone will need to click a button to run a query to give you the results about the approaching...

Hi The F# can be autogenerated from the last number. you need to break the F#down into a string and integers. I assume that the 16 part of the F16 comes from the year. i do this from January in one of my db's. You will have to allow for your October implementation. So concatenate 'F' &...

Hi There this is what I use Sub send_Email() ' email dims Dim appOutlook As New Outlook.Application Dim msg As Outlook.MailItem strcc = "Insert CC list addresses here" ' strTO = "To email addresses go here" 'Create new mail message...

just looking at your text here, I don't think that you will be able to achieve this.. the forms are just looking at the current records and therefore will look to be the same for all the records in the field. At this moment in time, I am wondering what you are achieving by this. do you need to...

Hi Jass I think I follow now..... You do not want the value from the field in the form. This will give you the same value for all records. (there is only one active form, even if you see more than one) You need to get the information from the relevant tables (not the form). Perhaps via a...

Hi Again Radek I think you need to go back to first principles. in my field we have the 7 Whys? So ask yourself : why do I have to have more than one colour in a field? Why do I have to know the number of matching fields? Why cannot this be achieved by using a related table? I don't think anyone...

I am not sure of the best way but I would open a new .accdb and then drag all the relevant stuff across .. other than that I would have to search the forums :) T

Try Public Sub AddRecordset() Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("tblStudentreview") with rs .AddNew !FirstName = "Jane" !Location = "Newyork" !Course = "Anatomy" !Status = "Done" .Update end with rs.Close Set rs = Nothing db.Close End Sub...

Hi I am not sure about storing 3 colours in one field... Or about noting the number of changes as looping through the records. ( If a new record was added then perhaps I would be interested in a new element However this is how I would go about solving this problem. Each value in your colour...

Is your database in Access 2007 or 2010 format? If its 2003 or an MDB format then this, i believe, does not have the attachment datatype. If the datatype attachment is not in the dropdown box when creating/editing a table then your format is probably an earlier one. I hope this helps

This is very useful http://www.buch.andreasstern.de/Syntax_for_subs.pdf Also this http://btabdevelopment.com/ search for subforms I have printed the top one, years ago and I still refer to it some times. you should be able to work out your answer from these links. Happy programming :) T

Re: Converting string to variables [Solved] Hi This is a working version of code that I need. I need to go through and add any error handling that is required but it does basically what I require Private Sub cmdEmail_Click() ' string handling dims Dim strTemplate As String Dim...

Update: I have now worked out how to use the Eval function I originally tried it using the Me. tag. If I replace me with the full monty "Forms!frmMain!CurrentStage" then I get a value. My plan is to use "Forms!frmMain! " & variableName and then put that in a eval function. I will still...

Hi CJ Thanks for replying. Sorry for not being clear. The sample I posted has not been split. Its one string in code. The question was how to split it so the parts that look like variables (highlighted) actually become variables. I have read elsewhere on the forum that this cannot be done :(...

Hi All I'm looking for a bit of guidance. I am trying to set up some template emails using text someone has entered in a form with a variable indicated with a key word in brackets aka. [ChangeID] or [ChangeDate]. The field on the form is formatted as Rich Text so I am getting http code. (No...

Hi Again, This method is used on a multi user system. However, it is a bit more refined to account that it needs to stop booking and allow for work in progress. However, it should be said that if 5 computers need booking in to a system then it an exception to have someone book more than the...

This is roughly how my database deals with an issue like yours 1. You have a number of computers that need to be booked in [BOOKED_COMPUTERS] 2. In table tblSerialNumbers then you need to count the number of records that are associated with the records in tblPurchaseLines (I am assuming that...

Hi I have this sort of thing in one of my databases. The trick is to count the number of records as you add them to the table. Then disable the addition of any other records when the total number expected has been reached. HTH T

Hi in formB field A control This does depend on both forms being open. The code builder will help with this.