Search results

Morning All! I'm sure I've done this before but I can't remember how... I have a form with four combo boxes on it, the four boxes all open the same form and return a record based on the selection from a different column from the same query. To make it work smoothly I think I need to make it...

So, I was wondering if I am making this too difficult... I have a linked table and I am making a new table based on this which has fewer columns. I would also like to reduce the number of rows by only including data from the current financial (Fiscal in America?) year and the last two...

Is it possible to add time in a query? I have to add the number of hours overtime worked and I'm getting a data type mismatch error message. The time field is in hours, so I am wondering if I need to covert it to a decimal to add it up? Please could someone point me in the right direction...

Hi all, I wonder if anyone could give me a starting point to set up a rolling year query? My companies month runs from the 15th to the 14th. On the 16th of each month, they want to run a report showing how many hours of overtime have been worked in the last 12 months. So on the 16th...

Dammit, I'm back... I first registered in 2007 when I managed to get heaps of ideas from existing posts and some great one to one help with the database I was building. Someone at work spread the word I had made the database, and now I've been asked to make another one :rolleyes: So here I am...

Hey there, Please could somebody point me in the right direction? I would like to add multiple identical records to a table via one input form. All the details to be added to the table will be identical with the exception of the primary key, which is an autonumber field. It will usually be...

I wonder if someone would be able to advise me on this. I sending fields from access to word, and placing them in the word doocument using bookmarks. One of the fields is a long memo field, and only part of the field is arriving in the word document. Would someone be able to advise me if the...

Could anyone help me sort this out. My database inputs records into a template document in word. I have the template set up with bookmarks, but as soon as there is a blank record, the whole process stops. This is what I have been using Private Sub MergeButton_Click() 'Start...

Hi I need a way of showing decimal time in minutes and seconds. i.e I need 14.75 to be 14hours and 45minutes. Is this possible? Thanks

I have a form which sends an email when closed using a button with a SendObject macro on it. I was hoping to put a hyperlink in the message text, but I don't seem to be able to make it be a hyperlink and not simply appear as the file path in text. I have looked at other posts and used things...

I want to close a form and I am using Private Sub Form_Close() Application.Quit End Sub as the form opens with the access application window hidden, and I found that the .ldb file didn't close if I simply used the X. I have a series of fields with validation rules which activate on exit...

I have set up a validation rule "Is Not Null" in the properties field of my form. I have added validation text that I thought would appear when this rule was not met. The field in the table is set to required "No" I have a macro which OnClick closes the form and sends an email and when I...