Search results

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...

I am unable to figure how to have word 2007 insert the name of a document (file name) in the document. I have done it in 2003 but am stumped in 2007??:confused:

Great, for a user with limited access skills 2007 is a learning curve that makes my life difficult when I try to open my old 2003 db's & edit anything. So far I haven't found anything that has helped in any way or saved me time. In fact just the reverse, I've spent lots of time trying to figure...

Pbaldy Great, thank you for your advice. It's difficult for me when I only get access to his computer once or twice per week at best. Right now I haven't got the courage to upgrade to 2007 myself, I've got too much back in 2003 to risk :eek:but as time goes by I might change my mind.

I'm helping a friend with a db on his computer and he has Access 2007. I am a 2003 user so things look a bit different in 2007. I need advice on the following; 1. In access 2003 I have several calandars (not ms access variety) which I have introduced to use on various forms. On these I often...

peckitt99 I use AJBCalendar,I think, an example of which is available somewhere within this Forum, I'm not sure of the link though. Another good example which is probably somewhere on this Forum would be the one provided by Old Soft Boss. Both these are simple to get working & work well. Do a...