Search results

You can set the hyperlink path of the button to the path of the Excel file. If you want the button to open a file from a path typed inside a textbox you can use the following code: Dim file As String If Not IsNull(FilepathFIELD) Then file = FilepathFIELD...

Most likely unbound data entry forms... however you can use code similar to this on a Save button: Dim db As DAO.Database Dim rst as DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("TableName") rst.AddNew rst("FieldName1").Value = txtField1 rst("FieldName2").Value = txtField2...

This topic is personal interest (break time!) :) The forums in general is work related, hobby related, and consulting related ;)

You can setup an input mask for the field that is something like: "PM000"000

Alc: Well I guess I'm crazy too, just not to the extent of dilusion :)

You have a complete logical fallacy in that last post that kind of exposes you for who you really are. You stated you've done a test with a similar sensor and it worked, this is most likely complete farse as for the reasons I've stated before, they cannot just "use" our technology, they most...

I feel this is completely true, if these orbs exist I don't think they can willingly communicate with our electronic devices or sensors... The only thing that ever suggests so is maybe digital photographs, recordings, or the "picking up the ghost voice" on the old tape recorders. But even if...

If you are using a close button that you build yourself, and you don't wish to save you can try: DoCmd.Close , , acSaveNo or even if you wish to save DoCmd.Close , , acSaveYes If you are using the little X at the top, you might be able to add this code in the "On Close" event, but I've never...

http://ca.lifestyle.yahoo.com/family-relationships/articles/archive/cp/home_family-death_leaves_online_lives_in_limbo_leaving_instructions_helps_survivors

Glad it helped, about having a single form. You can, but you have to think of a few things: You need to pass the proposalID to the new form using the OpenArguements in the Form Open Command. Anytime the form is opened it should be filtered to show results only for that ProposalID (like you do...

Hello, The only few things I can think of that may not be working for you, is that you should be doing the DoCmd.Runcommand acCmdSaveRecord before the link criteria is setup in your code. On the form that opens, it should most likely be a Proposal Form / Sales Subform, but the Proposal ID is...

Haha, me and Tim are not the same person, I am actually a Database Developer and do help out people around here (and get advice from the even bigger guru's of course). I came across this thread because I find the topic interesting, and yes I do believe in paranormal activity and ghosts/spirits...

OK, you want to have a BrainGate left open for the orbs to use. This does come back to what someone earlier said, that's not really what the BrainGate does, it won't be able to detect an orb because it detects neurons, this orbs wouldn't have neurons that exist in our plane, or dimension...

Thanks for answering my thoughts and questions in depth. Those last long posts actually made more sense to me than anything previous. So you wish to use the braingate device to measure things, because as an "afterlife orb" you cannot hear, speak, communicate etc. Only see. So for you, your...

Tim, As we've described, the problem is not that we are not open minded... because I was completely open-minded to your idea, but you simply danced around my questions and points provided. Unfortunately you are citing yourself as high and mighty as the Wright Brothers, Edison, etc. The thing...

DoCmd.Setwarnings False 'Delete record code DoCmd.Setwarnings True This should do what you want, it will no longer prompt for deletion. You can also have your own msgbox YesNo popup if that helps the program get the focus of the messagebox.

Glad it worked for you! If you have any other problems, let us know.

Here is a cleaner version of the code for you to look at, you may be able to follow it easier than the current one. I corrected something at the end for you, in your code the msgbox "Incorrect, please try again!" comes up, and then "You don't have access to the database!" comes up. So if they...

Else MsgBox "Password Invalid. Please Try Again!", vbInformation, "Invalid Entry" With rst .AddNew ![ClientID] = Me.Combo0 .Update .Close End With MsgBox "Log In Successful" End If It appears that your "Log In Successful" and rst editing is done in...

I think Tim just completely ignored and bypassed my comment about proving the opposite with his method, and about Mike Gurman's post about what the BrainGate actually does seems to also have been completely bypassed. I think there were people open to your ideas and listen to what you had to say...