Search results

David, Put the following code on the Form's AfterInsert Event: Frame4.defaultvalue = "" Frame4 is the name of the option group. This should do the trick. Andy

Why do you want to do this? If you use Access then you can store all of the information and export it to text file when you so wish. Andy

Sharon, The error that is generated, is this in access or windows. If it's access then is there a module or underlying code that looks for a file ? Try creating a blank db and create a form with a cmd button and put the code: Call Shell("C:\Program Files\...",5) Hope this helps Andy

Sharon, Sorry I couldn't be more help, but the code should open the file automatically, it certainly works on an exe file on my pc. Good Luck! Andy

The code is on the Report. No Problem. Good Luck with your project! Andy

Just thinking about it, How are you maximising the reports? Andy

Go into Design Mode on frmMsgbox. Press F4 or select Properties. Click on the Other Tab. You will see two options : Popup = Yes Modal = Yes There is also a little vba code on the onOpen event of the Report (Press ALT + F11 to view the code) The code is commented. If you can't figure it out...

Sharon, I tried the code without explorer.exe and the code works fine just like the first example you gave. I did notice in the screenshot of the shortcut link to the program in the Start In box the C:\Program Files..... should be in quotes like "C:\Program Files\..." The only other...

Have you tried : Call Shell ("explorer.exe C:\Program Files\......",5) Regards Andy

Try this example. I can show a form that looks like a msgbox that won't maximise when a report is open. Just open the Report rptReport. Hope this helps Andy

Afraid Not. You will have to design your own form, but you can set the properties of the form, so that it looks like a msgbox. The only thing that you can manipulate in a msgbox is bolding the text, that was posted on this forum a while again. Andy

Whoisit, If you are working on a movie rental database, why would you create copies on the fly. Surely you would have a table where all you stock is situated, which could be added to when you buy new copies and when the copies are rented you lookup it see if it is available and if so then set a...

No Problem! Glad to Help. Andy

David, You could do the following : Make the option group unbound. Create a textbox on your form and set it's visible property to NO. and bound it to the field in the table. Then on the AfterUpdate event of the option group put the following : Select Case Me.OptiongroupName Case 1...

Personally I don't use macros, because of error handling. To the put the code into a function you can do one or two things. Create a Module call it say modDeleteRecord. Then type the following: Option Compare Database Public Function DelRecord() If MsgBox("Are you sure you want to delete...

You could use DAO to change the fields. You will need to set a reference to DAO 3.5/3.6 Object Library. The below example I have used a checkbox as you condition = true and an If statement to change the fields. If Me.CheckBox = True Then Dim db As DAO.Database Dim rst As DAO.Recordset Set...

First thing if you are trying to delete the current record , you add the following code to the onclick event of the button you suggest you want to use without using macros. If MsgBox("Are you sure you want to delete this record?",vbYesNo+vbCritical,"Delete this Record!?")= vbYes Then...

To set the focus you would use : yourobjectname.setfocus But it sounds like your second check box should be : Me.Text1 = "" You might want to do some research into naming conventions in access. HTH Andy

I don't believe there is a function within access becuase the clipboard is part of windows. You will have to use win api to do this. The following link shows you an example of the win api and sample code for a command button to enter the contents of the clipboard into a textbox...

No problem. Welcome to the forum. Andy