Search results

Yeah - I'll do so when I get home - I have 2003 on my trusty laptop. I knew it was something I had to do, just been putting it off really. Ha ha - they would say the same thing I suspect... ;) Yeah - I'm worried we're heading this way... I'm just hoping someone will know of a suitable...

Hi lagbolt, Thanks for your replies :) I can probably do that in theory, yes. But, it's a hassle and being as half the users are in South Africa and the rest in Australia it could be a little tricky... I didn't know about the version property - that could definitely be useful. However, I'm...

Hi lagbolt, Cheers for the reply. It's not split at the moment, but I'll do it when I can get to a PC with 2003 on it. (2010 doesn't want to do it for some reason...)

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

Gah. My mistake. Sorry about that - I'm just being a muppett. If I delete the path and then close the properties box it's all OK. I guess my only saving grace is it's 2.30am here. Cheers ;o)

It doesn't seem to like me deleting the path in the image control - it just puts the original path back in if I delete it in the properties box...

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

Ahh. Good point. I'll check, but the code I'm using is Form_sfmLocus.[Locus.Ref_ID] = n Could it be to do with the fact that both fields have the same name in each table? I though I was getting around that by specifying [Locus.Ref_ID] rather than Form_sfmLocus.Ref_ID which would be ambiguous...

Thanks for the reply. Please excuse my naïvety (I'm trying to wrap a very tired brain around VB and other logical things!), are you suggesting that table B should link in a one-to-one relationship with tblJournal (via maybe the Table B unique ID) and tblJournal then links to tblRef in a...

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 Kelemit, It would be a system for imports several times. Basically, editing and addition to existing records would probably be done via the user form. However, data sets (new records) tend to be completed in batches and stored in excel, these data would then need to be added in a batch as...

Ha! Cheers for the compliment.. though it certainly doesn't feel that way at the moment! I think I'm going to go down the root of scanning and inputting the data from a worksheet one row at a time, taking the keys as they're created.. It just seems a bit of a messy way to do it that's all -...

If users are accessing accross a network it's possible to use the network message application.. (netsend??) We used to use this where I worked a few years ago through VB and Excel. If you can get the user name by code, you can then send them a network message. I know it's possible to get the...

Ahh. Sorry, maybe I didn't make it clear - I've already got the database.. I've attached it here. (There is another part to it, but I havn't icluded it here.) Anyway, as you'll see from the tables (you'll need to hold shift as you open it), they're all linked via different keys. My issue is...

Thanks for the reply Bernard, The problam with linking/importing is that I can't see a way to generate the primary keys. They're generated as the data are input, and obviously I need to make sure the tables are linked correctly in the one-to-many-to-many relationship I basically have with my...

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

Yup. I was being dim. isn't it annoying when you realise the code is this simple: Private Sub Command5_Click() Dim listString For Each i In Me.lstSp.ItemsSelected listString = listString & Me.lstSp.Column(1, i) & ";" & Me.lstSp.Column(0, i) & ";" Next i...