Search results

Hi gemma-the-husky, Could you please paste an example of what you mention. Just wondering if it is easier. Robert88

Hi alexkong2003, The beauty of having the database split is that you can develop and trial changes without inteferring with other users, you have leaped over the most critical hurdle now to make a change is easy as you just make changes to your mdb (front end), compact and repair and then make...

Hi dcnick, Sounds like something has gone astray, what are the chances of re-loading this software? Or uninstall and re-install? Robert88

Hi qwertyjjj, What are you currently using to total that coloumn? Robert88

Hi alexkong2003, Sorry for not getting back earlier, playing tennis last night. One thing you might want to watch-out for is that this database was originally Access 97. I can tell this from the VBA code. I saw a "acView" amongst it, should re-code this as the "ac....." functions have been...

Hi alexkong2003, Sorry, it is currently being sent back. In this case the database is required to be split, which I have done and make an mde on the front end. Hope this is what you were after? Robert88

Hi alexkong2003, Yourv'e got mail, waiting for your return email now. :p Robert88

Hi qwertyjjj, I have got three text boxes, txt1, txt2, txt3 and summed them upon hitting the sum button on the attached frmSum, is this what you were after? Hope it helps. Robert88

Hi qwertyjjj, Access usually requires a method to identify each box, so it would be best if each one had a unique identifier, Calculatedtextbox1 Calculatedtextbox2 Calculatedtextbox3 Calculatedtextbox4 Do these calculations occurr when you open the form? Click a button? Or some other...

Hi dcnick, Your office suite, has it been loaded correctly? Or has something gone astray with it? I am wondering the loaction of the *.dll files that these references refer to have been moved or are in another location? Usually located in C:\Windows\System32\*.dll or C:\Program Files\Common...

Hi Tinkerman, Can you not get hold of an account from the secured database that will permit the appropriate changes? It would seem a lot easier.;) If it is secured usually access to an account with admin rights will do the trick.;) By moving it to another file it might neglect the...

Hi TinkerMan, For SQL, you would be looking to use the "ALTER TABLE" ;) Robert88

Cool :cool:

Hi plucnik, Sounds like you have to throw out your aluminium frypans/saucepans. Theory has it, it helps Alzheimer’s. :eek: Who said getting old was easy, :p You make me feel young. :D And glad to have helped. Robert88

Hi alexkong2003, Paste your email up and I will send you an email and then you can reply with the attached file. Robert88

Hi alexkong2003, So when you have the package open, what is at the top of your database window? What file format is it? See attached doc as it is Access 2002 - 2003 file format, is yours the same? How big is the file, maybe the data needs to be split from the main package? Robert88

Hi Ziggy, I used to work for a company that had a similar configuration as discussed above and replicated unfortunately was not involved with the replication. Great idea replication but has its problems if people work on the same file as errors are likely to occur when more than one want to...

Hi alexkong2003, Are you able to compact and repair it? I would suggest a back up before proceeding with it. What version of Access are you working with? There are know problems upgrading from 97 to 2000, XP, 2003. Robert88

Hi tubar, Could always try this for every button. Check the attached file, watch out for the invisible field........ The attached file only has two buttons, going to take a while to code all 118 buttons. Wish you all the best with that one.:D Private Sub CmdOpenForm1_Click() On Error GoTo...

Hi alexkong2003, Ah, tried re-booting? In addition if it hangs, have you let it hang to the point where it generates an error? Robert88