Search results for query: *

Thanks both, i will check out all of these programs.

Ok thanks, work perfectly. Yes the database needs a bit of clean up. I am pretty sure i once came across a program that automatically look for issues within an access file and allows you to; Look for fields that are no longer used If you change a field name it updates through the forms and...

Thanks works great, school boy error, thanks for all your patience. Yes i think i had a go and a few difference versions in terms of command buttons albeit, not 719. I am assuming some of these would be for other buttons as apart of the database. The database may have about 75 buttons. This...

Great the PDf works, thanks. The email still does not format the currency properly. I did try the code below. strBody = strBody & "Payment Amount: " & FormatCurrency([Forms]![frm_ladnownerpayments]![paymenttotal]) & Chr(13) Also any ideas on how you attach your email signature? Private...

Final thing I can get the word document to automatically save as a word document, but not as a pdf, any ideas. objWord.ActiveDocument.SaveAs ("\\dfkuusdb\payments\" & Me.IDoptionpayments & "_" & Me.site & ".pdf") , FileFormat:=wdFormatPDF'

Sorry i could not log in the other day for some reason, thanks very much it works really well. I also have a button that i click from a form to create an email. It takes data from the form. I have the same problem with the email in the number does not display in currency format, it comes out...

Thanks for the reply albeit it did not quite work, I am getting the message 6028 the range cannot be deleted. I did manage to get the code below to work, however it only put a $ in front of the number. i.e $10000. I am hoping for formatting as per $10,000.00, bearing in mind it could be 3...

I have the following code that takes text form a from and inserts it into a word document. It works well however I would like the text inserted to be in currency format. In access the format is as follows. $10,000.00. When converted to word as a bookmark it displays as 10000. The bookmark...

Found this on teh web and makes no reference to deleting related database objects. Looks like it has to be deleted manually, unless anyone is aware of a handy tip. When you delete a field, and if other database objects, such as queries, forms, contain references to the deleted field, you need...

I am tidying up my database, and have some fields that I no longer require. The problem is every time I delete a field in the table design format; I then have to go through and manually delete the same field referred to in all my 50 queries and reports. Otherwise, obviously the query or report...

I have created a drop combo box in a subform that generates a list of names from a table. The drop down menu has the following Row source. SELECT [employees].[employeeID], [employees].[planner] FROM employees; Now I need to use this table data for three new fields in a sub form. I would also...

I found this page and it appears to solve the problem, however it is not ideal as it would seem this process needs to be followed for every PC using MS Access 2003 http://support.microsoft.com/?kbid=825765

I have just installed Access 2003 on my machine and opened up an access file developed in 2000. The problem is that some of the functionality appears to have been lost. For instance I have a mail merge document that when I click on a button within Access; the word document opens and populates...

Thanks Tony Jollons Works well, although I do have over six fields and the above function would start to get a little complicated with additional fields. Is there something similar to the excell function MAX(A1:A5)in access Oggstar1

Thanks for the advice Bastien Any help with the code or function would be appreciated. Sorry should have mentioned that i am just starting to learn VB.

Got it, works in the before insert. thanks

I have 3 feilds in a access databse with numbers in all fields [score1]4 [score2]6 [score3]8 I would like a formula to determine the highest number in the three feilds and display in a seperate feild Max number;[score1][score2][score3] Answer = 8 Any ideas on the code or function.

I tryed both the after update and after insert in the primarty form. Me.Accountstab.Visible = True On form currnet i have Me.Accountstab.Visible = Not IsNull(Me!ID) This does work but only after i click out of the form or channge records and come back to the form, before the accounts forms...

Thanks works well in the current event procedure, I have also tried to change the ID (primary key autonumber)feild event afterupdate so it changes the first time the feild is updated. Rather than changing the record before the Accountstab appears. Any ideas As the following does not work in...

Thanks for the reply; you have summed up the situation very well. It is unlikey that the user will enter details in to the 3rd" generation table without a matching record in the "2nd" generation table. However it is posible because my second and third generation tables are...