Search results

I have quite an extensive Access (2003) database stored on a shared server. However, new staff PCs are being rolled out with Office 2010, which is causin no end of problems. Further, there are several Mac users around who can't use the database at all. I don't really have to time to implement...

Hi, I've written an extensive database using Access 2003. However, not all users have the same version of Access. The database works absolutely fine with 2007, but with 2010 I get the old 'Your Database or project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0.'...

Hi, I'm having a problem with Access XP, in that when I change the orientation of my labels in a report, the text doesn't display. I can copy and paste it, so it's there, but I just can't see it no matter what I do to it. I've had a little search on here, and found someone else who had the same...

Hi there Access-Experts I've got a strange problem in that when I use docmd.close acForm, "formname" it doesn't actually close the form... I have a form which is exporting data to excell. As the process takes ages, I have another form which is a progress bar. The progress bar works well, but...

Hello Access heroes.. I'm using the following code to dynamically link to images in a popup form: thisPicString = GetPath(CurrentDb.Name) & DLookup("details", "infoTbl", "Item = " & Chr(34) & "Image Folder" & Chr(34)) & "\" MsgBox thisPicString Me.Image1.Picture = thisPicString & "DNA.gif"...

I think I may have done somthing fundamentally wrong here, but I'm not sure, and I've spent a long time on trying to sort a work-around so I want to see if I can solve this... Basically my table relationships are thus: [table A] | one-to-many | [table B]--one-to-many--[table C] | many-to-one |...

Hi There, I'm building a database for a friend's company. My query is really to do with the best way to add new records to their database. The database has four tables: [Species] which is linked to multiple loci in the [Locus] table. For each Locus their are multiple alleles in the [Allele]...

Hi there, I'm sure I'm not being dim, but I really can't figure how to do this. I have a list box with two columns. One column (bound) is a name, the other is a unique ID. I need to transfer both the Name and the ID to a second list box (again, two columns). I can get it to do this with...

Hi - Question number two.. Is it possible to transpose the subform data set. I have a subform which lists alleles. There are a variable number of alleles in the subform, which is linked to a second subform. Each allele has a size and a frequency. It is listed in a tabular format, but the...

Hi, this is frustrating, and a little complicated, so I'll try and explain it as best I can.. I have a form with two sub forms. The main form "fmMain" contains a list of species. the subform which is causeing me the problems lists loci specific to each species. The user can search by a species...