Recent content by AN60

Thanks for the reply s. I've been busy on other issues and haven't had time to come back here. I have solved the issue of the following message in my new Access 2019 db; "Missing or broken Reference to file MSCAL.OCX v7, Fix the reverence". I have several Office 2007 dbs running perfectly in...

I purchased Access 2019, with Office 2019. All my Access 2007 Db's, except one, work ok. When I open the problem Db I get a message "Missing or broken Reference to file MSCAL.OCX v7, Fix the reverence". Then Access opens up just about all vBasic tabs, which makes my job of finding the problem...

Hi It's been a while since I posted on this forum. I've been using Access for many years and am presently using 2007, which works ok for my needs. :) My question is regarding the idea of updating to 2013. Are there any known problems going from 2007 to 2013? FWIW I want to have 2013 on my...

Thank you for your speedy reply. I set up my combo with two choices <0 & >0. In the after update event I encountered a problem when I typed the * symbol you have shown above. Should I be substituting it with something relevant to my data? Where you have tbl I have my table name & where you...

In my db I have the following in access 2007; tbl qry form (with a combo to look up data) rpt My data tbl has several fields but the one I wish to lookup values in is a number field which contains either positive or negative numbers. I wish to select either positive, negative or all...

Thanks guys but I am familiar with what you are saying but the feature I am looking for was a combo that used to reside in the top left of the window (Of the Form,in Design View, not the property window) where we could just click the small combo arrow "thingie" & see a list of all fields, labels...

I'm looking for the equivalent field list in Access 2007 (Form Design View) that used to reside in the top left corner of Access 2003 & before. It was good for quickly selecting text boxes, labels etc. My searches haven't turned up anything.:confused: Can someone point me to it? Regards Ian

Bob Once again, thanks for your fast reply. I was about to do as you suggested however after several Google searches I found a suggestion to turn off the Switchboard then try a conversion. I did this & the conversion worked! After the conversion the switchboard seems to work on too, so...

I have been trying to convert two dbs from 2003 to 2007, after successfully converting several other dbs. Office 2007 gives the following message; "db already opened by 'Admin' on machine <name>. try again when application available." That might not be the exact wording but it's close enough...

Bob Thanks for your speedy reply. I guess I should convert my dbs to 2007 & not worry about turning the macro trust off then. Ian

I have a db created & saved in 2003 & now I want to use it in 2007. To get it working I have had to turn the macro trust setting off completely. Can someone nudge me in the right direction so I can edit the db so 2007 trusts it. :confused:I'm not familiar with the ramifications of leaving macros...

I just updated from 2003 to 2007 & am still finding my way about. Is there any need to save access files in 2003 format? ian

Thanks Gizmo, that worked.;)

Thanks for the quick reply, but unfortunately your suggestion still gives an incorrect date, only now in 1905. I was thinking about trying to use the start of the current century as a default if I can figure how to do that, any ideas there?

I'm using a form with two date fields (start date & finish date) to open a report in Access 2003 SP3. I wish to set the start date with a default of 1 January 2000 and the finish at the current date. I've done this heaps of times and it always works until today when I set the start field's...