Search results

I was wondering how you would prevent users from having the same initials? If is the Initials field set to No Duplicates? Do initials and drafters full names have fields in the table or are you generating the initials from the full names be selecting the uppercase letters? If you want to use...

Okay I have a few fields that automatically update to provide the user with a preview of their record status. This information is at the beginning of their for and changes if the user makes changes to the fields that affect the status fields. All of the automatically updated fields that rely...

Just remember to reference the name of the mainform prior to the field name that you wish to perform the calculation on!

Yes, It is possible and quite easy. You can write a little bit of code and then set your switchboard option to "Run Code" or include the code in a macro if that's easier for you to understand and "Run Macro". I actually manually created a Form instead of a switchboard....that Form gave you...

OOPS...I meant to post to REPORTS:( Sorry.. I don't think it's going to work right because I have this information in a report and the report provides the data grouped based upon the Type of System. I'm using an unbound text box in the report to COUNT the total number of Operation_Dates...

If you're using a combo box in the form to auto fill based on your services selection, then you should select the third option in the Combo Wizard that asks if you would like to provide other data based on your selection. This will allow you to have the user select a service and then the...

I keep getting strange errors saying that I've got an extra ")" but I have three of each.....I can't be that tired because only half of the day has past. Here's my statement: IIF(((IsNull[Approval Date])AND(Not IsNull[Operation Date])),[Operation Date],"") Basically I have to provide a report...

Are you just trying to create a hyperlink to a specific file? Will the file be static or dependent uponthe record? If the file it static, then use the control box to place a button on your form (with the wizard disabled), then click on Properties...next to the hyperlink addess field click on...

The only point that I could offer.....seeing as I use Access 2002 on my labtop and in the office, but 2000 on my contract site would be compatibility. Although it might be a great idea to use the latest and greatest remember that when creating in one version.....you're coding and various...

DBL Hehe *blushing* I can't believe that Access couldn't give me a better error code. You were write about the misspelling. My little fingers got carried away and I typed [Archvie] instead of [Archive]. :rolleyes: Feeling really slow today....luckily my vacation starts in a few hours!

Hmm....it works for me. I have an [AccredDate] and then I have the expiration date set to Name[ExpireDate] ControlSource:[AccredDate]+30 So you could either use the following in your forms and reports: Name: SCRUB_DATE ControlSource: =[ADJ_DATE]-1 Or you would have your query assign...

Sounds like a relationship issue. If you're using the Agency combo box to determine the Employees in the List box...then you're creating a restriction based on the relationship of the two items in a single record. If you want to be able to Select an employee and attach then to a new agency...

Hi Neighbor. I'm not really sure why you're having the problem. It seems pretty simple. Have you thought about placing a Refresh command to the OnChange Event of the first combo box. From what I understand you allow the user to make a selection from the first combobox, then your query runs...

I don't know how to make a window always on top, but I do with with popups, modal forms, and I usually set the active form to DoCmd.Mazimize. You can find more information on these topics by selecting WindowState or BorderStyle Property in the Access Help, "Answer Wizard" section!

Ive seen this before but I can't rememeber what causes it. "Can't find the '|' in your expression." '|' is not a letter and it's not a field. It's hmmm...symbol over the back-slash. Anyway, if someone can guide me back to the light...I'd appreciate it. I'd added a refresh statement to my...

Pat...You're amazing Pat, It's amazing the things that we can over look...over and over again. I on't know why I didn't think about writing the statement out in two parts....I was looking through my code and that's how I'd handled it else where. I guess the Type Mismatch error was really...

If IsNull([Division2Del] or [ID2Del]) Then MsgBox "You must fill in the Division and ID fields before you can proceed" Else stDocName = "Archive Justification" stLinkCriteria = .......etc End If Could it be because the () around the two IsNull fields makes them boolean?

okay...I was misdirected Okay, I'm sorry for all of the madness. I'm not crazy...I just found that out. My String for the stLinkCriteria was fine. I keep rewriting it and it works, until I place it into the form that I want to use. So...I got some medicine to clear my head and I'm...

Pat...I tried : "[ID]=" & ME.ID2Delete &" AND [Division]=" & "'" & Me.Division2Delete & "'" and yes...it was just a typo....I was very sick yesterday....working from home to meet my deadline and I can't hook up my office laptop to my dialup, so I was just rushing to retype it. I did replace...

I've done this a couple of times and never had a problem before. I've been sick and now I'm rushing to meet my deadline and I can't seem to get his to work. I'm working with two ctriteria in the DoCmd.OpenReport function I was using the stLinkCriteria and even tried just using the following...