Recent content by slaterino

I like your thinking, and I have just tried it using it on the following line: #" & DateValue(Format(datThis, "dd/mm/yyyy")) & "# But alas, no luck. The results are as per usual. It does feel like we may be getting closer though!

The problem with Format([Datefield], "dd\/mm\/yyyy") is that it then converts the Date into a String and I end up with a date some time in 1989. The computers that it will be used on are all based in the UK.

Sorry, all my form fields, as well as the field in the table which the date is being saved to, are set as Short Date. This unfortunately makes little difference. I have also tried using Medium Date as I thought the combination of dd-mmm-yy might be harder to get wrong but it doesn't work with...

I have tried using the Format function but the problem is that it converts it into a String as opposed to Date, and so ends up giving some crazy date in 1989. Is there any way to use Format as a Date? I wish there was!

I have designed a way of creating a schedule using a Microsoft Access form and Visual Basic, which works exactly how I want, except for the fact that the date doesn't know which continent it's in. I know a lot of people have had problems with date, and I have looked at lots of solutions on...

Hi, I am hoping to create a datasheet that uses data from a field as its y-axis. At the moment my datasheet looks like this: First Name | Last Name John | Smith Wendy | McDonald But I am hoping to change it into this: First Name | Last Name | Session 1 | Session 2 | Session 3...

Hi, I am trying to do what I thought would be a simple SQL query but am having some problems and can't find the answer to this on the web. Put simply I want to add three values into a table using an append query. One of those values I want to retrieve from another table and which is dependent...

Hi, I am trying to design a system where I can monitor attendance. The reason for this is that my client wants to know how many total hours students have attended per course. I have a good idea of the structure of my tables for doing this but am not sure how to run the queries. This is my idea...

Thanks for your help! I'm almost there but having a few problems just getting the final code. I don't know why I find Visual Basic so hard to code. Anyway, this is my current code, but I am getting an error message on the DoCmd line. I'm presuming this must be because my strFind line is...

Hi, Can someone help me put together this small VB sub. I need a way that once I click a button, a form will find a specific record using two values from two different combo boxes. The source of the form is tblSrvRspns. This table includes the fields RspnsID, SrvID and URN. My two combo boxes...

I am currently getting this error message when opening a form from a DblClick function on another form. This is the code that I am using: Private Sub Completed_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmSurveyResponses"...

Hi, I have created a Sendmail function on one of my pages but am having some problems getting it to work the way I want. At the moment it opens a seperate e-mail for every e-mail address in my query. How can I change the script below so that it opens just one e-mail with all the e-mail addresses...

Hi, I think I've solved it! My SQL was: INSERT INTO tbl_Notes ( Date_Written, Notes, URN ) SELECT Date() AS [Date Written], [Forms]![frmSearch]![AddNoteBox] AS Notes, [Forms]![frmSearch]![URN] AS URN FROM tbl_notes; I've now removed the line 'FROM tbl_notes' as it was superluous and hey...

Hi, I have created a form with a text box. Under the text box is a button with a command to open an append query and enter the contents of the text box along with two other fields into a table. This works fine except that it always appends 8 identical rows instead of just the 1 it should be...