Search results

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...

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 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...