Search results

As I may or may not have mentioned, i'm new to access. Thanks for the post but what do I do with it? :o Can I just insert it somewhere? TIA Aron

I have a form with fields like Company Name on it. I wish to be able to type a company name into that field when it is blank and Access pull up that record. Is there any way of doing this? TIA Aron

Thanks, It sounds great! However i'm currently working for a company on a 2 week contract and it takes 4 working days to have WinZip added to the NT / Novell node i'm working on! (I don't have that) :mad: Installing stuff for myself is not an option sadly, tighter than a ducks .... So please...

Thanks ColinEssex, For anyone viewing post above, it works! But needs another closing bracket at the end of first line. Thanks again everyone, ;) Aron

Counter not functioning as planned I now have a counter which is incremented by a click of a commmand button. However the text box and the field it refers to is blank ATM. The code I used was: Private Sub cmdCallCounter_Click() Static counter 'Me.txtCallCounter = 0 Me.txtCallCounter =...

(Hope I'm the correct forum) I have a template (word dot.) with field names in all the right places. I want to create a button on my form that when clicked will throw open this word template and populate the fields with the currently active Access record. However I am unsure of how do this. If...

I hope this is the right forum. I wish to insert a few fields from my database, such as address, into a word document. However when I try the "merge it with MS Word" and "Create new document" option I get the message: File could not be found. It suggests trying another file and checking the...

My query has fields; score1, etc. and myTotal. If I create a totals query I can sum a column (correct me if i'm wrong). How do I sum a row? The other route which was to create a standard query with same fields and "bang in expression" into control source worked. But but basically adds up all...

The Total field is in the detail section. This calculation has to be record specific. When viewing a record in the form and entering scores the result will get applied to the total column for every record in the table (I just discovered how to update thread) thanks once again for your help Aron

Thanks Howlsta, It now calculates the fields, however when I scroll through the records the total field stays the same. I have a command button on the form which updates the data, still nothing changes. This total field needs to be record specific and write its calc. to a table / query column...

Hi, I'm relatively new to Access. I have a form with customer details applenty. I want to be able to have a button on this form which, when clicked increments itself by 1. This represents the number of phone calls a particular record has recieved. (The value held by this counter then needs to...