Search results

Hello everyone, I have been trying to calculate the number of working days a person has off sick between two dates.I was aware of how to calculate the difference between two dates using datediff, this was not quite hat i needed. after much experimentation and a little searching I came across...

Just thought, i could override this problem by changing the field type from number to text! it is my primary key tho

Hello, one of tables requires me to store sickness details, the sickness codes are all unique, they do however start with at least one 0 for example code - 000003 Description Stress. When you enter a code access automatically trims of the 0's to leave a 3. Is there a way to override this im...

Code i have used Anyways, here is the code i have used, it may need some ironing out Option Compare Database Private Sub cmdInsert_Click() On Error GoTo CustomErr Dim strTheme As String Dim message As String txtTheme.SetFocus strTheme = Me.txtTheme.Text If Me.txtTheme.Text = "" Then...

theres no need to be scared! The structure was already created, and the database contains data already, if i start making fundamental structure changes some of the info will not be available. only got a couple of days to complete the work so this seemed easiest way

mainly because it is quite a complex table structure and the fact a theme may relate to a document and a organisation. Thanks tho i have considered this already, the structure just makes it near immpossible!

Ive been looking through the posts to see the merits of using bound and unbound forms. I have the following scenario and think that a unbound form would be best solution, what does anyone else think? I have carried out normalisation of the system and have ended up with two identical tables...

do you have to set the focus to the main form first?

From my main form i have a pop up form that allows user to enter data into the one side of a relationship. When the form is closed i want to refresh the form that called it so the value can be selected from a combo box. Is it not something simple along the lines of Me.Visible = False...

no its numeric, is this affecting the outcome? thanks

the above method does not appear to work either, i keep getting same error msg

Can you use dLookup to look into a table if a record in it doesnt exist? A summary of what im trying to do. The admin guy can view a invoice and its breakdown, there may be many invoices for each application. In the form footer is a button that allows the admin to make a payment ( insert sql...

what does the err.source return?

i have an error handler method that i have built that passes the error number & description and form.name to a global error handler. It would be useful to expand this to include the sub/function that produced the error. Is their a generic way to refer to the sub/ routine that produced the error...

how would i go about numbering records in a continuous form? I would like the report to look similar to when you have a numbered list in word. e.g Grant conditions 1) the offer is.. ..... 2) it is applicants responsibility . .. 3) etc

they are all there, but more worringly in the new database none of the code is visible and im getting the message - error accessing file - network connection may have been lost

Im having some big problems with my database. If i make any ammendments in my vba code it refuses to let me save them. I get the message 'save operation failed'. Is the only way around this to insert existing objects into new database? This method causes a further complication! forms open fine...

hi, i have two continuous subforms on a main form. each of these subforms has a txtGrant textbox that totals up the values in the subform using a control source procedure. on my main form i would like to add these two grant text boxes together using vba code. i can do it using the control...

hi, i have two continuous subforms on a main form. each of these subforms has a txtGrant textbox that totals up the values in the subform using a control source procedure. on my main form i would like to add these two grant text boxes together using vba code. i can do it using the control...