Search results

I have my main database that generates new user information. What I would like to know is how can I take this information either writing it to a text file or a direct import to another Access database? Can this be done and if so, how?? Thanks

My Table is called Objects and my form is called New User Form The field I need to reset is ID Can I do something like ID=ID-1?

I have a UNDO command button that when pressed undo's any change made to the form. The only thing is that the record ID keeps increasing. How can I requery the database to reset the ID?? I am using me.requery now and it's not working...

I have a command button that when you press it allows you to create a new record. How can I disable the command button after to press it? I am using: Me.AddNewRecord.Enabled = False right now, but it comes back with an error that I cannot disable the selection because it has focus. How can I...

I have a tab control page setup. If the user selects the 2nd tab and is not in the "Domain Admin" groups, it will not allow him to access it. If you are in the "Domain Admin" group, it will allow you to access it and also enable a command button.

That did it!! Thanks!

On Click What I am trying to do is when you come to a new blank form, it says "Blank Form". How can I check to see if [ID] is set to "(AutoNumber)"

If Me.Dirty Then Me.[Status] = "Entering Data" Else Me.[Status] = "Blank Form" End If I am running Access 2k and trying to check to see when you press the forward button to go to the next record it'll check to see if it's blank or dirty. Only thing is, it reports "Blank Form" at all times...

This does it: stSiteName = Me.Site.Column(1) It now works!!

This is what I am using so far... When it hits the [Site] it displays the ID number instead of the name. Any ideas why? Private Sub Command387_Click() On Error GoTo Err_Command387_Click Dim stAppName As String Dim stUser As String Dim stFullName As String stFullName =...

I have a command button that when pressed should create a text file with some code in it. I am in need of some code that will show me how to write a txt file and create some text.

I have a command button that once pressed, exit's the database. I would like it to ask if you are sure and if you say no - it cancels the request to quit. I have tried many solutions but none of them seem to work.

This is the way that I am doing it now: ============================================== DoCmd.OpenReport stDocName, acPreview, , "[ID] =" & Me![ID] DoCmd.SendObject acReport, "New User Report", "SnapShot Format", _ "my.name@work.com", , , "User Request Form", "User Request", False...

I have a form that a user fills out the information and selects the email button to send it on. Once it's sent, I want to delete that record so it always shows a new record. I do not want it to retain any information. Any ideas on how to do this??

When Access starts, it's full screen. I know that I can manually change it, but is there any code that will minimize it for me?

I have a mdb that opens up and loads my form. What I would like to do is get rid the MS Access toolbars. Is there away to do this??

How can I tell it that if a record is dirty that you can not modify it?? I only want you to enter information into a new record only but view and print existing records...

I've only tested this on Windows NT and Windows 2000.

Worked like a charm!!

Has anyone been able to get the full username yet?? I have searched the board and found messages where people attempted it but none have found the answer... Thanks in advance