Search results

Hi mjohnson629, Check the attached mdb, is this the sort of thing you were after? Check frmClearTable and click the button within to clear the tblDetails contained within. Like Data Miner indicated are you sure you want your users to do this? :eek: I hope it helps :rolleyes: Robert88

Hi Amavadia, Here is a search mdb I refer to when doing what your wanting to do. Hope it helps, good luck with it.;) Robert88

Hi all, Love the help I am getting here, LOL!!!! Anyway, I have managed to read in the default values from the tblMediaType & tblLabelnumber tables. The code below is for when the form frmDefaultCDDVDLabelling opens. What I do not know is how to set the default Group Options default on the...

Hi Paul, Not sure if this will work but what if you use; DoCmd.SetWarnings False and then of course to reverse it; DoCmd.SetWarnings True I am not sure if this will work and probably not a good idea as maybe the error should be addressed but you do say that you can then enter the info...

Hi All, I managed to get it working but changed the fldLabelnumber from "Text", to "Number" within tblLabelnumber. Another issue now is that when I open the form "frmDefaultValue", I have set the default value of each group option to 1 so it opens always with the top of the option group...

Hi Buachille, Is it possible to paste the zipped mdb to the site? If not I would be checking the names of the events starting this click event. Not sure if this will help? Robert88

Hi All, Now for the problems I am having with the 6 option group for the label number. I have the code above within the CmdUpdateDefaultValues but currently it is giving me errors. ' This is to set the default value (Options: CheckLabel1, CheckLabel2, _ ' CheckLabel3, CheckLabel4...

Hi All, I managed to get my tblMediaType to update, syntax problem show in red below. Private Sub CmdUpdateDefaultValues_Click() If Me.optgMediaType = 1 Then 'If this is true CD becomes default in tblMediaType 'Reset the tblMediatype DoCmd.RunSQL "UPDATE tblMediaType " _...

Hi All, So I am going solo here, thanks for all the help, LOL!!!! (Only joking):D OK so I have code now that is a little closer. Private Sub CmdUpdateDefaultValues_Click() If Me.optgMediaType = 1 Then 'If this is true CD becomes default in tblMediaType 'Reset the tblMediatype...

Hi All, I am currently trying this based on the mdb attached further up but with no luck. Private Sub CmdUpdateDefaultValues_Click() 'I am trying to reset the fldDefaultMediatype of tblMediatype when the Update button on form frmDefaultValue is selected Dim OptionCD If OptionCD = -1 Then...

Hi Seargent, Thanks for that, I will have a good look at this. I was also looking to display the numbers on the form, hopefully displaying them in different colours if matched. I will give it a go based on what you have done as that shouldn't be too hard from what you have given. Appreciate...

Hi Krash, Have you tried google? Try this in your search window in Google The double quotes above make Google search for the pairs of words in the example above rather than individual words. I tried it without the quotes and got over 8 million results. Hope it helps as there is 804 items...

Hi All, I have a database which contains all historical draws from our Tattslotto system here in Australia. I want to get some comments on the best way to tackle checking two tables as listed below. tblDrawn_No 'This is the table with drawn tattslotto numbers so only one row per draw...

Hi Marion, Damn it about all the editions I did, how do I delete them???? I have also done some research on the kill function. it states that in the example I have here, that if an object uses a Get Method it places a read only attribute on the file. in order to use the kill read only is...

Hi MarionD, You have presented a good problem. Just thinking out a loud, I have been looking at msaccess.exe /cmd From Microsoft; But not sure if this will help you?:confused: Robert88

Hi MarionD, You have presented a good problem. Just thinking out a loud, I have been looking at msaccess.exe /cmd From Microsoft; But not sure if this will help you?:confused: Robert88

Hi MarionD, You have presented a good problem. Just thinking out a loud, I have been looking at msaccess.exe /cmd /cmd Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last option on the command line. You can...

Hi , OK, the permissions I spoke of earlier were from a 2000 or 2003 Server along with Windows XP local machine. In your case you will have a shared folder on a Windows NT 4.0 Server so you will have to change the file permissions according to this list; 1. No Access: The user or group is...

Hi accessman2, Do a search for system.mdw, the default Access one and then place copy in D:\ next to other. Then try executing .Body = "<A HREF='C:\Microsoft Office XP\Office10\MSACCESS.EXE' D:\db1.mdb /WRKGRP 'D:\system.mdw' >Open database</A>" Does this open it? With your quote; If...

Hi razaqad, Windows XP is for your clients. With Servers, Windows Server 2003 is more secure than Windows Server 2000 by default, Microsoft tried to follow the LINUX method of security everything by default is closed and then the Administrator gives permissions. Give me a day or two to set-up...