Search results

RuralGuy - Yeah, I meant 'cells' sorry. I do know how to format cells and obviously I have done this. To clarify, all cells in my sheet are formatted as text. John.Woody - thanks for this. I'll look into any way that it can be ran automatically at opening of the file, and when saved.

All files in the sheet are formatted as text, but it still imports blanks as '0'. Very strange...

Thanks! I was just about to post that I had figured it out. The only problem I am having now is that the blank cells in my range are importing into Access as zeros. Is there any way to prevent this? Thanks again.

Hi folks, I am using the following code in one of my databases, and it is working as it should but not as I would like it to. Dim strPathFile As String Dim strTable As String, strBrowseMsg As String Dim strFilter As String, strInitialDirectory As String Dim blnHasFieldNames As Boolean...

When I try to create a command button in any Access database, including new blank ones, I get the following messages. I have reinstalled Access over and over. I don't know what registry keys to delete and the problem still remains. Any ides would be helpful! "The database cannot be opened...

Hi all, I have got a database solution that I need some help with. The main problem is that it was designed in Access 2007 and I need it to run in Access 2003. When I try to convert the database, it tells me there are some features present which prevent it from being converted. I know...

Thanks for your reply, but that does not help. They are random blank rows. My datafile in Excel has no blank rows or formatting and I have made sure of this. No one uses that file other than myself, and I am 100% sure of this. Going in to the Access table and deleting all the blank rows is...

Hi, I am trying to append the data I have stored in Excel format into an Access table using the following code: Private Sub Command0_Click() If MsgBox("This will open the Excel folder for spreadsheet imports. Continue?", vbYesNoCancel) = vbYes Then Dim i As Integer Dim tblStr As String...

Yeah thats what I thought too. Unfortunately it still doesn't work. Would appreciate any other ideas.

I've placed the Me.Requery command in the 'On Enter' and 'On Got Focus' of the text box, but I still have to manually click the box to get it to update. My form has tabs and I would like it to refresh whenever the tab that my 'Date of Last Review' text box is swtiched to. Thanks.

Yeah, I realised that after an embarrasingly long time. The only thing is, if I change the last review date in my forms, it takes closing the form window and re-opening it for this to update. Is there any way to improve that? Thanks.

Ok, I spoke too soon. That isn't working the way I would like it to. It is displaying a negative in front of the number, and I would like it to just show the number of days that have elapsed since the last review date without symbols.

Got it! For reference, I used =DateDiff("d",Now(),[Date of Last Review])

pbaldy - many thanks that works really well! On a side note, there was some additional functionality I was hoping to achieve with this. I have another field on my form just below the 'Date of Last Review' called 'Time since last review'. Is there I could make this cell show the time since...

Thanks for your perseverance, but I'm still not having much luck: =DMax("[Review Date]", "qryReviews", "[Client Code] = '" & forms![Patient Details]![Client Code] & "") Query name = qryReviews Column name in query = Review Date & Client Code Field name on form = Client Code Form name =...

I tried to follow the link in that post, but I get '#ERROR' displayed in the field on my form. My syntax is in the post above.

Tried using this, but to no avail: =DMax("[Review Date]","qryReviews","Criteria = #" & [Forms]![Patient Details]![Client Code] & "#")

Thanks for your prompt reply. Yes, I simply want to display the most recent date, but only for the client who is active on my form. The query contains data for many different clients. Could you give me an example of how you would do this on the form. I presume it involves setting the field's...

Hi, Hope someone can help here. I have a field on a form, 'Date of Last Review'. This form is based on a query storing the details of all the patient reviews. The two important columns in this query relating to this query are 'Client Code' and 'Review Date'. Basically, there will be more...

Thank you CEH! Worked for me too.