Recent content by hairwormman

Oh boy!! I recently lost my hard drive through physical error. I thought I was good about backing up all files and I was. The only exception is my Access database. The way I have been backing that up is by saving a replica (since this gets copied for my workgroup daily anyways). Is there...

Skip, Thanks for your timely response. The [Shift]+[End][Down Arrow]is a neat trick!! But, for me, I need to fill in about 5,000 cells. For each I give a designation (e.g. A03, P09, C10), then I manually fill in the number needed for each. For example, I might have 10 cells with A03, 33...

Thanks for replying. I have made it work by using the VLOOKUP command. If anyone is interested, the formula I ended up using is below. Cheers...Ben the worm =IF(ISNA(VLOOKUP(C2,'Seq data'!$A$2:$H$961,2,FALSE)),"", VLOOKUP(C2,'Seq data'!$A$2:$H$961,2,FALSE))

Fellow Troubleshooters: I have searched old posts and have not found anything but people broaching this subject, so here we go. I want to copy single cells in Excel by using my mouse (i.e. Auto fill). No matter what I do, Excel uses Fill Series by default (so that when I put in F02, and...

Hey Y'all: This is best explained by an example Data sheet 1: Sample Result 100 atta 101 cccc 103 tcga 106 tttt (Note data is ordered by sample, and NOT all samples have a result(note that samples 102, 104 and 105 do not have entries). Now, I want to populate data...

Y'all: I have written an Access DB in Access 2002. Now, we bought 2 new laptops (which have Access 2003), I split the DB, and want to have DB run on all 3 PC's. It works flawlessly in 2002. However, When I try to run certain macros in 2003 (for examples to change the setting on visibility...

I have noticed that many people are having the same problem as I, but this forum has not been able to provide an answer. Thus I suspect that this is a flaw in Access, but let me give this question one more try (thanks for your patience!!). When looking at a report in Access 2002, the text...

Hi olgas74: I have been having this problem for about 5 months. I have not found a solution, short of reporting this flaw to Microsoft. They claim that I am the only one to ever have had this problem, and it must therefore come from some magical hidden code I accidentally programmed. This...

I am trying to mass update existing hyperlink fields. The new information is in Excel (which is how the new data is coming to me). When I do this, thorugh an Update query, the "text to display" field within the hyperlink changes, but the "address" field does not. How can I...

Thanks! I tried the import function through the update query and it works like a charm. Do you think that this process could now be done thorough a macro? Thanks again. Ben

I have a database containing ever changing records. To start with, I create individual records with several blank fields, which I fill in over a few weeks (as the data comes in). Is it possible to integrate batches of new information as it comes in, to fill in those blank fields? I have tried...

You were right. Adding the combo's name into the control name part of the requery action did the trick. I did not know that a requery of a form would cause the form to "reset" to the first entry. Thanks!!!!!!

JimbOne, thanks for your input. The way I update the dropdown list (after making an addition), is that on exit from the "menu form" I run a macro with a requery action. I just went through all the code and the only things running after exiting the "menu form" are in the...

I am working in Access 2002. I have a dropdown menu within a form (master form). Items to this menu can be added by the user if the appropriate choice is not available, by clicking a button below the dropdown menu. Clicking this button will open another form (menu form) containing the list of...

Thanks for your input. Here is some more info: The information gets to the DNA comparison server via URLAPI; a standardized application program interface (API). It uses direct HTTP-encoded requests to the DNA comparison web server. So, I do not own the website, but I think by using...