Search results

Hi divardo When you export a little check box usually not checked but shown in the picture "save formatted", attached which is checked, it will help removed the " ' ", that you mention. Robert88

Hi dcnick Have you compiled the VBA? :cool: Robert88

Hi halen99, Fair to say you have these statements somewhere? Dim mString As Integer Dim VarName As Integer And then try; mString = mString + VarName Does this append correctly? Look forward to your response Robert88

Hi mdcory, Anything is possible, hehe!!!! Check this code, only written quickly but hope it solves your problem? Attached is the file so you can also see it in that. Option Compare Database Private Sub CmdScannedBarcode_Click() On Error GoTo Err_CmdScannedBarcode_Click Dim stDocName As...

Hi TinkerMan, I gather your currently in A2K format. What format do you want to move it too and is it neccessary dependant on version you are moving it too? Access 2003 runs A2K by default. Look forward to your response. Robert88

Hi Wazz, You beat me too it..... Hi Anthony George, Attached is a database with your needs? DoCmd.Restore does the trick!!! That of course all depends on how you save the form sizes in thier original size, not maximized? Robert88

Hi DaneRanch, Are you able to get to the database window? If so what file type is the mdb? Usually written in the top of the Database Window. 1. Microsoft Access 97 2. Microsoft Access 2000 Robert88

Hi grnzbra, I have a question? Are you able to open this file, manually going down its network path from your pc? Robert88

Thank you!!!!! Hello to all who wrote this article, I am back from the dark depths of being unemployed and now searching this forum furiously for the answer which I have found above. Just thought I would say a quick thank you for those that wrote this article as it just saved me. Seen the...

Hi tiffster, Here is info on licenses. Essentially there a few different types of licences; 1. OEM (Original Equipment Manufacturer, This type of license is only available when purchasing new machines) 2. Software assurance with product licences (allows for even monthly payments of...

Hi pepegot, Have you got the same file system on both operating systems? Right click the drives (where informartion is contained, home and work) in my computer and select properties, in this dialog box you will find what type of file system is present. If the same then this is not the...

Hi Namliam, You've taken the words from my mouth :eek: Hi Ashfaque, Good question, testing...... :p Robert88

Hi JReichnan, I am glad it has helped, I myself find this site is very helpful. In retuurn it is the least I could do.:p Robert88

Hi JangJang, First, since your condition was not met a division by zero is possible, I would sort this out first then revisit the conditions, what are you saying in the condition statement (3 if then's) and think about what you are trying to accomplish? Are you just trying to get the fields to...

Hi MarkAccess, Help me to help you? The button is being used to execute the macro, what method are you using to start the macro and has it the correct macro name? Robert88 P.S - Sorry, been a while since I used a macro but used them a lot when I used them, then I learnt VBA and all my macros...

Hi JReichnan, No Problems. Worked a treat for my combo boxes and thier default tables, I supose you just have to address the date variable and all the rest should be the same. :p Have fun with it. Robert88

Hi GHudson, One issue I pondered over was that I use Windows NTFS in order to also secure files generated on the Windows NT File System, allowing Windows NT File Security. I have not tested this issue with Windows 98 yet but surely you cannot open NTFS files under Windows 98 which I beleive...

Hi MarkAccess, The name of the macro that the command button wants to run has not changed? Robert88

Hi JangJang, If I follow the flow of this code for the "Calculation" button, the variable Counter is equal to zero and hence the overflow and null Value. It seems to not meet any condiditions (if then) earlier and does not count and therefore is zero? Is this what you were meant to do...

Hi MarkAccess, When you run your macros does it open the form specified in the macro rather than running them with command burttons? Robert88