Search results

Thankyou for this tip, much appreciated.

I have a form called frmNon_Compliance, on that form I have a field called Non_Compliance number which is an auto number. The form is linked to tblNon_Compliance. When the user fills in the form and clicks on the button that is called "email report", I have the report based on a query and I have...

Hi I have been reading the recent posts about memo feilds and sizes, missing contect etc, also have researched Google beofre positing here. I can't seem to find what I need to know, well I found half of what i needed. I have a memo field and a text field in tblContract_Clause which stores a...

Thank you, there are no controls on the form called AreallFieldsFilled. I only have the function in the code.

The error is Run time error '438' Object doesnt support this property or method This code works fine on all other fields, both storing numbers and text, but only falls over on this field.

Thank you, but even with the S on the end of control, it still stops at the same row of code.

Thankyou, i fixed that.

Hi I'm using the code below to check the form for validation once the user moves to another record or the current record has lost focus. This is doing want i want, except for the staff_Name field. When the message box pops up to indicate that you need to enter a field in Staff_Name and you hit...

I'm not sure what you mean about where do I have my code set, i guess it's in the form. Yes C_response_date is bound to a table. Yes, it is a visible field on the form, however if i could get the calculation working, i would hide the field off the form. A little confused now.

I tried this and the date worked, however it would not write the date back to the table. So now the field is bound to the table.

Thankyou, i will try this.

Thankyou, I treid that but it didn't work, debug highlighted this code txtCDate.Value = strResponseDate I find the spaces, underscores etc inconsistent, as many people say don't use them and others say use underscores etc. So I was never really sure whether to use them or not, very confusing...

Hi I have a field on a form called C_Date and another field on the same form called C_Response_Date. Once I enter a date in C_Date, I have the C_Response_Date populated from the control source =C_Date + 12, which automatically enters a date which is 12 days greater than C_Date. However the...

Yeah I understand the normalisation and mentioned that Access will not allow me to import the data in stages, which is what I wanted to do to solve the problem.

Hi I have Access 2003 database and trying to import 120,000 rows of data for a properties table from Excel. The Excel book has 4 sheets and I need to import all the data from the 4 sheets into the one table. Access will not allow me to do this. Can anyone suggest a way around this? Thankyou...

Thanks Paul, worked like a treat. Just wondering, is there anyway to change the colour of the message box to red? Garry

Thankyou, I'm looking for something that would be a little more in your face. A message box would be great so they need to read it and click ok to proceed to the next job. Thankyou Garry

Hi Hopefully someone can assist me with this. I have a table and a form. tblAccess & frmAccessDetails The table has many fields, but one is called job_closed. On the form, this field is a combo box with 2 options that the user can select, yes or no. it always defaults to no unless the user...

Any chance of sharing your search form.

Just a dumb question, does ActiveControl mean the name of the field where you are netering the data?? So you need to rename. Me.ActiveContol = StrConv(Me.ActiveControl,3)