Search results

Sorry, Can you elaborate a bit more? Do you mean create a separate alphabetic (text) field and a separate numeric field?

Hello, I am trying to get double digit numbers to ascend when there is a letter prefix in datasheet view. I have tried the Ascending/Descending function but it doesn’t seem to work for this format. Example: A1 A2 A2 A4.... to A9 no problem. However , when I go to enter A10, A11...

Galaxiom, Eureka! Changing the Trusted Location seems to work. At least now I can get Rainlovers error message to appear, but i am still haveing problem with the pop up message.This is what i am doing. I am going to a new record and putting in a value that i know is a duplicate. The error...

Rainlover, This is a large institution and personal folders are on a shared drive. I thought since i only have access to my folder (ie password protected) that this would be a secure (?Trusted Location). I am stumped!! I will talk to my IT guys on Monday and ask them if they know anything about...

The current Trusted Locations for this db sits on a shared server within the institute. I also have a personal folder on this drive that is password protected Should i put the db there and enable content? :confused:

Thanks Galaxiom- This is exactly what i am trying to do here. I am trying to preempt the possibility on entering data by setting up the No Duplicates function. so that when I migrate my data across any future duplicates will be caught. I know this data current has no duplicates Perhaps you can...

Don't know if this will give you any insight to this problem, but i have several basic macros running (OpenForm) that work fine. Does this indicate that the code is running???

Thanks guys/gals?? As I indicated this is a work computer as such wouldn't the Trusted Location be secure? Or does this mean something else. Thanks so much for you patience.

Hi Bob, I have done as you suggested The message bar setting for all office application has two options: 1. Show the Message Bar in all application when content has been block. This has been ticked 2. Never show information about blocked content. Un-ticked. I just tried ticking the other option...

RainLover. 1. Your db came as a read only. To enable content I had to make a copy. 2. In design view I was able to verify that I have put the code you had sent me in the right location on the Form i.e. On Error. 3. When I open the your db I was able to enter the...

Hi Rain, Thanks for the info. I am running Access 2007 so i guess it won't help if i send you a copy, but i will still look at your database. Yes, Melbourne is nice.I worked in Brisbane for a year and a half before returning to Melbourne and I loved the weather up there. Thanks again for your...

Rain, my new best friend! After much head-banging and near tears of frustration I finally found the 'Module behind the Form" ie VBA screen. Your message worked. However , (isn't there always :-) I have several problems. 1. I still get the original Access error message for the duplicate. I click...

Hi RL, Sorry, you have lost me. I created a command button using Wizard for a Go To Record button. I clicked on the ... which brought up the command code sheet. This is the code: Private Sub cmdNextRecord_Click() End Sub No indication of an Error Number. Obvioulsy I am not following you...

Rainlover- I love you! I re-read your answer a few times until I Got It!. I was not going to a new record to test the duplicte or the new value- I was just changing the value in the same field. It is working just fine now!!great! Now, can you guide me through the steps to create a custom pop-up...

To all that responded so quickly, I thank you. Re: DLook up. The database is one i am trying to develop. As such there are only 6 'play' subjects in the database with no chance of the data being duplicated. I was hoping to build in this precaution before i start to migrate data. Re: PatientID...

Hello, (Access 2007) I have one form that has the follow data types Patient ID (primary key) Patient Research number. This is a text field with a unique alphanumeric code. I do not want this code to be duplicated when i enter a new subject. I have set the Table view Indexed condition...

Re: Building buttonto oepn form with a Where condition Sorry for the delay in replying, but i have been:banghead:. Sadly I could not get the code you sent to work. I did all the steps you suggested. Someone sent me the following for the Where condition and it works great:o ="[Biomarker...

Re: Building buttonto oepn form with a Where condition Hi Boblarson, Sorry, really new at this. Can you please take me through the steps for attaching this code? I have gone to the button on Form 1 in Design View and opened the Maco. When hit the three dots on the Where Condition it brings...

Hello, I am currenly working with two Forms Form 1- Patient Form (PatientNum) Form 2- Patient History (PatientNum) I have just viewed a great YouTube video on how to make a button Open a Form and go to a matching record using the Where Condition. I got it to work great, but it only works once...

Hello, I did as you suggested but had a difficult time understanding. From what i glean from YouTube this seems to have something to do with standardizing data? I have created multiple reference tables for drop down fields for information that doesn't change ie Country, a diagnostic procedure...