Search results

I can't get this IF statement to return correctly. I have a field that can contain 4 answers: MP, MP1, MP2, or blank. If MP return "Not Assigned" If MP1 return "User 1" IF MP2 return "User 2" If blank return blank =IF(C8="MP1","User 1",IF(C8="MP2","User 2",IF(C8="MP","Not Assigned",""))...

So no one has ever seen this or knows where a selectable option might be that controls this?

I have a database that if I set the option to compact on close it is creating a default (db1.mdb, db2, db3, ect.) database copy. It does not do it if I do not compact on close. The only code I have is an Autoexec module. Option Compare Database...

Thanks all. I guess it's like the KY Derby. When it's in your backyard you don't pay any attention to it. I've never been to the Derby and it's only 2 hours away.

For the Florida people (Vass / TessB) or others with experience. I am going to be in Florida during the next Space Shuttle launch. Specifically I will be in Sarasota / Siesta Key. I don't want to drive all the way to Cape Canaveral so in what way could I optimize my launch viewing. I am willing...

Data from one table is not updateable. It is linked data from an SQL table. When I combine it with the data from another table that is updateable I find that all of the data becomes not updateable no matter what view it is in. The only way I have found around this is to create a single record...

I have data in my db that is not updateable and I want to add some fields to enhance it. Presentation to another group of people to data entry is where I am stuck. Can I present it in datasheet view keeping in mind that the data must come from two queries (one set that is not updateable and one...

Thank you Vass. I don't come around much anymore either. Are you still in Florida? Where?

I've got some speaking (i.e. no music) cassettes that I am copying to my PC and I need some help. I am using Roxio Media Manager 9 to capture the audio. I can burn with MS Media Player, ITunes, Roxio or basically whatever is on my pc. 1) I am recording at 128kbs CBR in stereo at 44.100khz, 16...

Yes, thank you.

This is a real silly question but Access' action irks me and if there is a solution, I want it. I have a dropdown combo box where the file number is entered to pull up the record. Because the sytem is thinking ahead of you it is prefilling the box with the record it thinks you might want (i.e...

Display results on a form. Set form to popup with size you determine under form Properties. Nice grey checked shirt.

Gave up too soon didn't I? A-B-C...Q.

Is there a command line argument to open AND close a db? I am running a schedule task to open a db which has an autoexec macro but I don't want the db to stay open after running the macro. Or is there a close db function in a macro? I see close form but not db.

Found something. Used www.surveymonkey.com

I am trying to post a voting poll in a Goggle Group so that group members can vote on an issue. I know you can create a voting poll in Outlook but Google Groups isn't a MS Exchange server. Has anyone ever seen one created in Excel. I want to list the possible voting choices and have a single...

Got it... Private Sub Form_Open(Cancel As Integer) Dim UserLoggedIn As String UserLoggedIn = CurrentUser() If UserLoggedIn = "userid1" Or If UserLoggedIn = "userid2" Then PendingDate.Enabled = False

I have the following code which allows one user to only access some fields in a form and it works fine. Private Sub Form_Open(Cancel As Integer) Dim UserLoggedIn As String UserLoggedIn = CurrentUser() If UserLoggedIn = "userid1" Then PendingDate.Enabled = False I need to add another user...

Thank you Moniker for the excellent post. I'll file that away for the day when I breach 65K rows!

Worked great. Much faster that OutputTo as well. Thanks!