Search results for query: *

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

I have a database containing DNA sequences. One sequence per record. A website allows for a comparison of YOUR DNA sequence to all other DNA sequences ever derived. I would like (love!) to click a button in Access, which would take the DNA sequence in that database record, uploaded it to that...

Thanks for the suggestions. I have tried this, and the query will not return any data. For some reason the criteria section in the query will not read what is in the combo0 box. So, when I push the command button, the query runs without problems BUT it returns without any data. Thinking that...

I am running a query to limit a data set; pretend for a moment it is to limit the data to entries from certain states. When I do this, a "Enter Parameter Value Dialog Box" appears, within which you specify your choice by manually typing it (say Arizona). This works well, but...Is it...

Thanks for responding. Let me clarify. Indeed I am trying to export a report. The reason I need this to be in txt format is because I need to send this file off to an automated web server which will parse out the information and process the individual entries (they are actually all genes from...

Hey y'all: I am having problems exporting forms from Access. The form consists of a form header and multiple entries in the details section, drawn from a query. All other sections are blank. When I view the report, it looks exactly as I want it. Then, when I export it, it looks terrible...