Search results

Hi MsLady, I recently took check boxes and Option boxes to write to table and then when opening form it reads the values from the tables. Check the link; http://www.access-programmers.co.uk/forums/showthread.php?t=103048 As you can see I got a lot of help, oh well. But as you said Fun and...

Hi A2KNovice, I have in the past used unbound forms, which is the type of prgramming you are probably used to. Check this link to help you; http://www.access-programmers.co.uk/forums/showthread.php?t=102707&highlight=Robert88 However as you will read in the link it is better to use bound...

Hi jkfeagle Sorry about that, here try this link. http://www.access-programmers.co.uk/forums/showthread.php?t=102185&highlight=Fox+Pro I hope it helps.

Hi fulltime, When you have your db open in Access, goto "Tools", "Stratup...." and then select your "Display Form/Page:" form the combo box. Then when you open it the next time it should automagically open it.:p Good Luck. Robert88

Hi a2knovice, Your original post indicated you wanted connection to the AS/400 data, which you have. The table that is linked form AS/400 is now like any other table. What is it you were wanting to do in Access with the data now? :rolleyes: Robert88

Hi FFDiz, Check the connection below as replication for WAN I find fantastic. http://www.access-programmers.co.uk/forums/showthread.php?t=103460 Reverse it why not? Robert88

Hi neous, ac2K3 by default is set to ac2k files, you have to change the default to ac2k3 in order to use ac2k3 files on ac2k3. To change the default goto "Tools", "Advanced tab" and then select the appropriate "Default File Format:". I have updated a few from ac2k to ac2k3. It is not hard...

Hi Skea, You could always try google. I would use the following in the search window The double quotes make google only look for this combination rather than only one of the words. The results http://www.google.com.au/search?hl=en&q=%22microsoft+Office+XP+icons%22&meta= Hope it helps...

Hi a2knovice, A pass through query is a type of MS Access query, found at the menu item Query, SQL specific, pass through. An append query is also a ytype of MS Access query, found at the menu item Query, Update Query. Robert88

Hi vassago, This code gives me a table of all files anf thier path on a CD and places them in a table. Private Sub CmdReadMedia_Click() Dim Drivename As String Drivename = Forms!frmMediaLabeller!CboDriveName & ":\" Dim dbs As Database Dim Mysize Set dbs =...

Hi All, I was looking to check the numbers from a tattslotto ticket stored in the zip file above Tattslotto.zip in a table tblTicketNumbers. I was thinking of running routine like one similarly pasted. However was looking to display the results of the routine on a form with different colours...

Here it is......... Hi SBM, Sorry, didn't realise I could convert it as I am using A2003. If you have problems when you open it as I think the autoexec is not working hit F11 to display database window. Good Luck with the 97 Version, hope everything works.... :rolleyes: Or were you after...

Hi jalverson, Not sure what your button names are or your subforms but I have used the wizard in order to create the code based on a subform with name frmMetal_subform (shown in code below in green) and a command button with name CmdOpenMetalsubform (shown in code below in red). So in order to...

Hi Paul200968, Never really placed a network path string with any of my code. But thinking out a loud, normally you would map a network drive to a shared folder. I do not know your shared folders but with your example below maybe; \\\\Tgsshs11data.nl.post.com\occ&sqa$ is a share which I...

Hi amanke, Not sure if these notes will help; http://www.fontstuff.com/access/acctut10.htm Good Luck Robert88

Hope this is what you wanted? Hi Amavadia, I grabbed the table from your other posting and changed it accoding to the SamplSearch2003.zip file above. the remodelled mdb is attached. SampleSearch2003.zip did have a lot of unneeded info in it, maybe you might be able to make heads and tails of...

Hi Amavadia Any chance of posting an empty table of the field you are searching? Robert88

I finally got it Hi All, Finally got there;:eek: Private Sub Form_Open(Cancel As Integer) Dim varMediaType Dim DefaultMediaType Dim varLabelNumber Dim DefaultLabelNumber varMediaType = DLookup("[fldMediatype]", "[tblMediaType]", "[fldDefaultMediatype]= -1")...

Hi hat_town21, Create a query and use the functions to do your statisical analysis. Check the attached and check the Query qryCountAvgMinMax_tblData. Hope it helps :p Robert88

Hi jkfeagle, What type of dbf file is it? I have done this with a Fox Pro dbf. I have read in dbf's but you also have to play around with your ODBC driver. Check these two connections; http://www.access-programmers.co.uk/forums/search.php?searchid=849582 Good Luck Robert88