Search results

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

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

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

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

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

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:

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

Hi all, it's been a while since I have done anything to my db's in Access so I'm a little rusty. I have a sub form with a Field, in which I enter ID's taken from physical forms(paper forms). The ID's are in booklets with increasing order throughout each booklet. I want to have MyField show the...

I am using something similar to the following in report & a module to draw a elipse around a field. I want to increase the thickness of the line but have had problems. I've fiddled with drawwidth without success. Any suggestions? Private Sub Detail_Format(ByRef intCancel As Integer, _ ByRef...

I've been trying to get a report to open up at the last or latest record. Initially I thought all I needed to do was sort the query date field or ID (auto numbers) in descensing order but that doesn't work. The query will sort ok but the report will only open up at the first record. I have a few...

Soon I'll be starting a new DB which will be used to issue receipts to people who attend courses run by a business. I don't want or need it to be very complicated so was thinking a something like the following; TblClient (ID,client name & address fields) TblCourse (ID,Date, course name & Price...

Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes; Microsoft Access You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded. can someone point me in the...

I'm changong computers and at prestne (for a few days) I am using a borrowed computer. When I edit any of my db's I now get a message telling me that I haven't got permission do carry out what I am doing & the permissions will be erased (can't remember exact message cause I'm on another...

I'm a bit tired of the buttons I have been using both default MS and my custom ones. I'd like to find some more interesting versions that I can use and have been searching on google etc but the options are limited. Does anyone have any favourite links I can follow?

Fellow Access users, I'm interested to know what you think about Listboxes v a combo. I don't use lists because combo's seem to look better. When do you use a list and not a combo? How knows I might start using them. Just seeking opinions.

I have a report used for chemical use which has the following fields in each record; ChemicalName ADateField BatchNumber ExpiryDate Volume Purchased (checkbox) Used (checkbox) Each time a drum of chemical is purchased the name, two dates, batch number, volume & a tick in the "Purchased" check...

I have been thinking about using some excel data in access. Reading the access help I noticed that it is possible to copy & paste data into access, is this a good way to go? Does excel data import easily and work ok in access?