Search results

I am exporting versions of a table from Access to Excel each month and would like to use an existing workbook by adding a new sheet (and naming the sheet appropriately). I have drawn a blank so far. Any advice or pointers gratefull received. Thanks for your support

I have a form which contains a continuous subform. Next to every record in the subform is a button which opens an email to the contact in the current record. We don't have e-mail addresses for some contacts so I'd like the button to be invisible for those records. Using... Private Sub...

I have a query, qryFindEMails with a field containing e-mail addresses. I want to combine these e-mails into a string: email1-at-wherever.com; email2-at-wherever.com; email3-at-wherever.com ... and then append this string to a textbox on a form. (I have removed all the @ symbols hereas they...

I have a form containing data as follows SchYear Subject GpBased (Yes/No) GpCount At the press of a button, I'd like to be able to append new records to a separate table, "Classes", where the key field, SubjSetCode, is filled with: SchYear & "/" & Subject1 SchYear & "/" & Subject2 SchYear &...

I have a database storing exam info: Studentid exam date session duration Some exams are actually due in the same session on the same day, so a student may be doing 20 exams, two or three of which are due in the same session. I therefore need to combine those records into Studentid...

I have a form containing a listbox (lstGroupList) containing all the subject groups for a particular student (selected in a further listbox) and a listbox containing all the possible groups for the student (lstFullGroupList). I'd like to be able to select an existing group in lstGroupList and a...

I am trying to count letters and word lengths in a piece of text using code. I have two problems ans suspect that solving the first will solve the second. Here's the first: I have a loop which (if formatcount=1) looks at each letter in turn and adds 1 to the counter for whatever that letter...

I have a datbase which gave me problems when I replicated it (answers to the question on a Replication crisis would still be gratefully received). I used replication because I have users who may log in from various places - did I really need to replicate? What is the maximum number of users...

I have a form in which users enter exam marks for a group. In a subform the names are listed and in another sumform the Maximum marks and grade boundaries are given. Staff enter the marks and it converts them into grades using the % boundaries. My problem is getting the command button...

I have a report in which the Detail section has some code in the On Format section. The code checks to see if the value of one field exceeds the value in another and then pops up a message box if it does. I have set it up like this: If FormatCount = 1 then If [FirstField] > SecondField...

I have a report which goes to various people – they each get their page. The group of people who receive the report are drawn from a pool and this changes each time it is used. On each use the data covers a period of three days (Sat, Sun, Mon) BUT this means that those involved with more than...

I have been given a set of photos to use in a report. The 900 or so files of type *.bmp are all distorted and so I'd like to set the Size Mode under Format to stretch. However, all the jpeg files (about 200 of them)are fine, so I'd like to set the Size Mode to Zoom. I'd like something like...

I have a report which shows photos in four columns. The photos are grouped with a group header. I'd like each new group header on a new page (no problem) but would like it to go right across the page and to start on the left hand side of the page (no luck). At the moment, if the last photo is...

I have a form containing a subform. Each line of the subform contains a memo field "Notes". There is inadequate room on the subform to enter data into this section so I'd like the current record's "notes field to be duplicated asd a field on the main form. Can anyone help me do this,please? I...

I have a table in which each record contains assignment results for an individual. I want to create a scattergraph plotting the value of one field (ETot)for each record against thae vale of another (MTot). I can do this in Excel but I am drawing a total blank in Access - I get the total of...

I'm setting intStandardCount(1 to 4) to zero in my report header and then have the following in On Format for the detail If FormatCount = 1 Then Select Case [Ability level] Case Is = "B" intStandardcount(1) = intStandardcount(1) + 1 Case Is = "I" intStandardcount(2) =...

I have a form which gathers student choices (1,2,3 or 4) for each of 10 different questions. I want to know how many of each response there is for each of the questions so I can put this into a report. I want to get: Question1 - 3 people answered 1, 4 answered 2... Question2 - 5 answered 1...