Over 1 million tech questions and answers.

Access 2007 Developer

Q: Access 2007 Developer

I am using Access 2007.
I have lost the Developer tab in the Microsoft Office Dropdown box. This happened after downloading Access runtime.
In the Access Options, the ‘Microsoft Office Access Developer Extensions COM Add-in’ will not stay checked.
What can I do to reinstate the Developer Tap
Other info

OS Version: Microsoft® Windows Vista™ Ultimate , Service Pack 2, 32 bit
Processor: Intel(R) Pentium(R) 4 CPU 3.00GHz, x64 Family 15 Model 4 Stepping 3
Processor Count: 2
RAM: 2046 Mb
Graphics Card: RADEON X300 Series, 128 Mb
Hard Drives: C: Total - 152615 MB, Free - 28694 MB; D: Total - 156331 MB, Free - 118784 MB; G: Total - 953865 MB, Free - 736437 MB; M: Total - 953866 MB, Free - 675617 MB;
Motherboard: ASUSTeK Computer INC., Puffer2 , 1.xx, X312345678
Antivirus: Sophos Anti-Virus, Updated and Enabled


Read other answers
Preferred Solution: Access 2007 Developer

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


Hi...wow it's been a long time since I posted on this website

Can someone please tell me how to use Developer in Microsoft Word 2007 to do 2 things:

(1) Enter text in one box, and have it copied and pasted into another one
(2) Work out someone's age from their date of birth and today's date


Read other answers

my hp chromebook developer mode is off and I cant access the administraters account .how do I get pass it

A:my hp chromebook developer mode is off and I cant access the...

Hello,                                              Thank you for visiting the HP Forums! A great place where you can find solutions for your issues with help from the community!Just hit Esc + Refresh and unit will reboot. You will see a screen that tells you OS verification is disabled. That?s the recovery screen. From there you can reboot into developer mode by pressing Ctrl + D.Note: that doing this will wipe all data from your device. Basically, the HP Chromebook 11 will reformat your storage space and set you up with a fresh version of Chrome OS with developer privileges. Once you log in with your Google account info, all of your settings, apps, and extensions will be re-downloaded, so there?s not much risk involved, but you will lose any files in your downloads directory, so make sure to back them up if you need them.Hope this answers your query, If you have any queries please reply back to me.Have a great day!

Read other 1 answers

We've created a large access database using Access 2002 devleoper for each computer in the building. On a majority of the computers the program works fine, but on a few it doesn't. By Double-Clicking on the desktop icon the program begins to load but only goes so far then basicly stops. Checking the task manager it doesn't show the program running under the applications tab but shows msaccess.exe under the processes tab. There is no CPU usage for that file and I have to log off and log back on again. All computers are running WIN2k. The two particular computers that don't work are running wireless to the server to get the data using Cisco wireless cards and access points. Is it possible the mdac needs updating or certain drivers are out of date?

Read other answers

Is there anybody who has used Access 2003 Developer Extensions? Is it a tool which can pack an Access 2003 application. Could the packed application run stand-alone (no need to have Access 2003 installed)?

A:Access 2003 Developer Extensions

My Access 2000 book says that the Microsoft Office Development Tools (ODT) do what you have asked about and is the only way to do it, so the later 2003 should do it as well.

Read other 2 answers

Hello All,

Just recently my company purchased Office 2000 Developer Edition because they were in need of purchasing the Access Runtime Library, to distribute their Access Databases.

However as of yet, I have been unable to use the Access 2000 Runtime Development Tools to distribute these databases due me not understanding the process clearly (previously in Access 97 it was a case of install the program and away you went, now I haven't got a clue where to start as we weren't given any software manuals).

An urgent response would be appreciated

Many Thanks In Advance



A:Office Developer/Access 2000 Runtime

Office includes quite alot of information in its 'Help' files. If you can't find what you're looking for there you might be able to find more in-depth Office Developer information in the MSDN Library.
Office 2000 - Developer

There are also several books that you can acquire. Check Fatbrain.com or Que Publishing. You will be able to find titles for MS Office and Access development.


Read other 2 answers

Dear Sirs,
I wanted to get more info about the Microsoft Security Updates API, so I'm having a look at the Guidance tab on this page https://portal.msrc.microsoft.com/en-us/
When I click on the "developer" tab I get redirected to the Sign In page - however, upon selecting my profile, I get redirected back to the Guidance tab on Security Updates page https://portal.msrc.microsoft.com/en-us/. and
I am stuck in this loop. This happens both with the old and the new Sign In experience. No way to access the developer info.
What can I do?
Thank you,

Read other answers

CLOUDY FILE GULPER Dropbox has come under fire from tech savvy chaps who are not happy about the company gaining access to a PC or Mac's operating system kernel.
Dropbox's Project Infinite is aimed at moving the service beyond being just a browser-based interface and integrating it more tightly with an OS so that files can be plonked into cloud storage in a more seamless way.
Dropbox also wants this deeper integration with a computer’s operating system and local file storage to prevent what it calls the "untrained intern problem".
This means that Dropbox wants to stop an inexperienced employee removing files from a shared Dropbox folder and screwing up the cloud synchronisation and file access for everyone.


Read other answers

Dear forum readers,

I have a problem when trying to install:

Windows 8 Developer Preview with developer tools English, 64-bit (x64)

When using the DVD tool from Microsoft as explained in one of the tutorials in this forum,
I receive the following error message:

The disc does not have sufficient free space.

I use a 4.7GB DVD disc, and the size of the Windows 8 Developer Preview with tools English, 64-bit (x64) iso file
size is: 4.83 GB.

Of-course this is the source of my problem, and i need a way to fix it.

What i am doing currently, is downloading the Windows 8 Developer Preview without tools.

I have read some solutions, but they did not offer what i am looking for.

I need a way to install the complete version with developer tools, including:

64-bit Windows 8 Developer Preview
Windows SDK for Metro style apps
Microsoft Visual Studio 11 Express for Windows 8 Developer Preview
Microsoft Expression Blend 5 Developer Preview
28 Metro style apps including the BUILD Conference app

I only have a normal DVD drive, no USB stick of the required size, but I have a second hard-disk with sufficient space.
AND I have an external USB hard-disk with sufficient space.

Tried to install from local hard-disk in Windows 7 by using the setup.exe in the sources directory, gives me the following error:
To install Windows, make sure that the partition on your bootdisk has at least 1243 Megabytes (MB) of free space.
Error code 0x8007049... Read more

A:Installation Windows 8 Developer Preview Developer DVD

Originally Posted by zx81

Tried to install from local hard-disk in Windows 7 by using the setup.exe in the sources directory, gives me the following error:
To install Windows, make sure that the partition on your bootdisk has at least 1243 Megabytes (MB) of free space.
Error code 0x80070490

I think i will buy a USB stick with enough capacity, but if someone has a quick fix, it would be very welcome!

Best regards,


Don't make that USB purchase yet.

Can you screen shot your disk management and we'll try and sust it out for you.

Read other 9 answers

Hello all,
I am having an issue accessing the Developer API access page within the Microsoft Security Response Center website (https://www.microsoft.com/en-us/msrc). When I click on Customer Guidance > Developer API access, or navigate to https://portal.msrc.microsoft.com/en-us/developer,
my browser first asks me to sign in and click which account I would like to use. I click my desired account, and it briefly redirects to the Microsoft Developer API Access page, but then after a split-second it redirects me back to the sign-in page. Is it
a requirement to have a specific type of email associated with the Microsoft account in order to get past this? 

Thank you for your help!

Read other answers

Hello again,

I found out that these extensions are supposed to make it where I can export my access databases as .exe files. This would be great, since then I could just have a .exe for ones in the office to run, so that no one could edit forms, tables, etc.

Now, I googled it, and got this site. I can't seem to find where to actually download it however.

Is this a good fix for what I am wanting to do? This way, everyone in the office wouldn't have to have access, they could just run the .exe, and that would allow them to use the forms just as they would if they had the database itself.

Any suggestions will be greatly appreciated.

A:Microsoft Access 2003 Developer Extensions - Where to find them?

Read other 6 answers

Hey everybody

I've been trying to figure this out for a while, but just can't seem to get it to work right.

I have the Microsoft Office Access 2003 Developer Extensions, which has a packaging wizard, that is used to package up a Access database and include a runtime environment, so users without access on their computer can use a database.

I have access on the computer in my office, so I take the file I want to package, and run the wizard, creating a setup file for the database and runtime. Now, I go over to the server, run the setup program, and have it installed on the server.

I can run the database on the server fine. I open it up, it runs in runtime mode, just as the package wizard said it should, and I can do whatever I want. The problem I am having is, I try to create a share, so that I can share this program with users on the network.

When I do this, it just doesn't work right. It is saying that it can't find the file "C:\Documents and Settings\Administrator\Desktop\ifg_agent_database\ifg_agents_modified_10_13_05.mdb"

Any ideas on what is going on?

A:Solved: Microsoft Office Access 2003 Developer Extensions Troubles

Read other 13 answers

I have an Excel workbook in which I keep racing records. The data goes back about 5 years and as i have accumulated several hundred thousand records, I have moved much of the historical data onto separate sheets in the workbook so that values for calcs that rely on the historical data can be auto updated.

For current data I use a separare sheet as i was finding that it was takin g a long time to perform calcs when all the data (up to 200,000 rows) was all on the 1 sheet.

I wanted to know if it was possible to convert what i have to Access as it has been suggested that a database would do a better job of handling so much data, rather than Excel. I have moderate knowledge of Excel and have been able to build up the series of formulas for calculations in Excel over the years and have it pretty well doing all the things i want now but I have very little knowledge of Access design so not sure if I can convert and how to do it.

The Excel workbook contains a lot of formula that do calcs on past results and then use those calcs to do predeictive calcs for upcoming races. Because it was very "maths"based to start with, I started off using Excel and it has all grown from there. Is it possible to convert what I have to Access? Is is reasonably able to be done (by a moderate user like me with some expert help)?.
The files i have are too big to attach here, but would be happy to prepare some sheets without much data to show what i am doing and get advice.

A:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007

Read other 13 answers

I'm trying to run an Excel 2007 macro from Access 2007, when I get to the point where I want the macro stored in the active workbook I'm getting the following run-time error: run-time error '91' object variable or with block variable not set . It won't run the macro at all. I would greatly appreciate it if someone could help me fix my code so the macro will run. The code is listed below; step 10 is where I get the error.
Option Compare Database
Sub GetJournal_Entry_Data_transfer_to_Excel()
'Step 1: Declare your Variables
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As DAO.Database
Dim MySQL As String
Dim MyRange As String
Dim s As String

Dim Db As Database
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
Dim xlwkbk As Excel.Workbook
'Dim xlworkbk As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer

'Step 2:Declare your connection string
MyConnect = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info = False;Data Source= P:\FINANCE\Balance Sheet\Inventory\Project TAN\Project TAN.accdb; User ID = Admin;"

'Step 3: Build Your SQL Statement
MySQL = "Select* From [mtb-TantasticJE's]Where [mtb-TantasticJE's].[Dscrptn_Text]='Culls_Stat34'and [mtb-TantasticJE's].[Co_Code]='1381'"

'Step 4: Instantiate and specify your recordset
... Read more

A:Access 2007 VB code to run Excel 2007 macro in active sheet

Read other 7 answers

I'm trying to get the results of Access queries to be linked to an Excel workbook. I've been using the Data tab in Excel, clicking the "From Access" button in the upper left, and choosing the Access database. Then it asks what query I want to link.

The problem arises when I try to link a specific query, which we'll call qry_x. This query is based on several other queries, one of which is qry_z. Frustratingly, when I try to link qry_x to the Excel workbook, I get an error message that says that Access can't find qry_z, and suggests maybe I spelled the name incorrectly.

However, qry_z definitely exists as part of the database, and when I run qry_x (which is based on qry_z) in Access, the correct results are displayed with no error.

Note: qry_x is the only query this is happening to. I can link any other query with no problem at all, including qry_z!!!

What could be going wrong?

Thanks in advance.

A:Solved: Access 2007 / Excel 2007 - Linking to a database

Read other 16 answers

I have Office 2007 on Windows 7.

When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).

If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!

Any ideas?

Thanks for your time on this


A:Cannot access the Ribbon functions in Excel 2007 or Word 2007

Could you please post a screenshot or two?
And what are file sizes (MB)?

Read other 1 answers

Can anyone please help. I'm trying to look at Outlook 2007 Calendar Appointments in Access 2007.

I've seen many postings discussing adding appointments from from Access into Outlook, but I want to look the other way.

The code I've started with is

Dim olapp As Object
Dim olappt As Object
Set olapp = CreateObject("Outlook.Application")

...but that's as far I can get. I'm lost after that.

My game plan is to link our Exchange Calendars used on ipad2's to our Access database, to store Sales Rep visits against customers visited, straight from the ipad into the database.

Anyone know how? I'd be very grateful.

A:View Outlook 2007 Appointments in Access 2007

Exchange server is a database that can be queried by other databases. Look up Exchange OLE DB

Read other 1 answers

I have a access database thAT exports data to an excell file. A macro in access then opens this file and another in excell. The second excell file reads data from the first then uses a macro to format it properly and print the info. Right now I can only run this macro from the excell file. Can I run this macro (called Button2_Click in Module 3) from access? I have been using the OutputTo and RunApp action to run this macro so far.

A:Solved: How do I run an excell 2007 macro from access 2007?

Read other 11 answers

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD A6-7310 APU with AMD Radeon R4 Graphics, AMD64 Family 22 Model 48 Stepping 1
Processor Count: 4
RAM: 7113 Mb
Graphics Card: AMD Radeon(TM) R4 Graphics, 1024 Mb
Hard Drives: C: 814 GB (753 GB Free); D: 17 GB (2 GB Free); E: 97 GB (73 GB Free);
Motherboard: HP, 81F5
Antivirus: Windows Defender, Disabled

I have a form that gathers the required information from within the database

I then use this code to send the email

Private Sub Command20_Click()
'sending email
Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)

Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatHTML
.To = Me.Email_Address
.Subject = Me.Mess_Subject
.HTMLBody = Me.messtxt
If Left(Me.Mail_Attachment_Path, 1) <> "<" Then
.Attachments.Add (Me.Mail_Attachment_Path)
End If
'.DeleteAfterSubmit = True 'This would let Outlook send th note without storing it in your sent bin
End With
'MsgBox MailOutLook.Body
Exit Sub
MsgBox "An error was encountered." & vbCrLf & "The error message is: " & Err.Description
Resume Error_out
End Sub

Everything wor... Read more

Read other answers

I've developed a database in Access 2010 and am using the Navigation Form for users to access the different forms and it's working very well. The problem is we still have some workers who are on Windows XP boxes with Office 2007 and the Navigation Form won't work for them. I've been asked to develop an Access 2007 Switchboard which will mimic the Navigation form so there is some continuity between them and so that once all the systems have been upgraded the users willbe familiar with the interface. I easily designed a form with the look or the Navigation Form but haven't been able to figure out how to handle opening the different subforms on the one main form. Is it possible to place an Unbound Frame on the form and with a click of a button open a subform in the Frame or have a button just open a subform? How would that be coded?

Thanks for your assistance

A:Solved: Access 2007 Switchboard & Access 2010 Navigation Form

I am a bit confused because Subforms normally open when a mainform opens.
I am not familiar with the Access 2010 navigation form so I am not sure what you are trying to do.

Read other 2 answers

I am trying to convert a MS Access 2003 database to MS Access 2007. I have tried both the "convert" and the "save as" methods. The conversion process provides the message, "All open objects must be closed prior to converting to a different version. Do you want Microsoft Office Access to close he objects?" I choose Yes. The Save As window opens and I pick a valid location and name.

The status bar indicates Access is closing temporary objects, and then briefly displays the converting status before popping the error message that "You attempted to open a database that is already opened exclusively by user 'Admin' on machine <machine name>. Try again when the database is available."

The problem is that the <machine name> displayed is my own machine name. I've tried to convert from other desktops, with the same result. Access does not seem to be able to close all objects before attempting to convert to a new databse.

Does anyone have any idea how to resolve this?


A:Solved: Problem converting Access 2003 to Access 2007

Read other 6 answers

According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through to many Access upgrades?

A:Any problems using Access 2007 database with Access 2010?

Hi bbinnard,

If you have not purchase Access 2010 yet, what I'd recommend is....download the Trial Version and play around with it for quite a while.

Read other 4 answers

Hello again, dear forum.

I just finished up a tiny little database, nothing complex... and when I finished, I went into the options to remove the navigation bar, all of the menus, everything... so that the user would have to use the menus I'd created in the database. I figured it was the best way to make sure no one messed around with the back end.

And now, I want to make a change, and... I can't get into my design view or anything anymore. I can't see my tables I tried customizing my quick access menu with the "Options" button so I could go in and reverse all those settings, but it's greyed out.

Help? (And if this doesn't make much sense, please feel free to ask questions and I'll clarify... I'm a little panicky right now, haha).

A:Solved: Access 2007: Can't Access Options, Locked Out

Read other 8 answers

I created a database in Access 2007 but my client has just upgraded to 2010. I have not upgraded yet. My problem is that when I took a copy of the program home so I could tweak it some, my 2007 will not open it. I get a message that the format is uncrecognizable although the extensions are the same. With earlier versions of Access, I have noticed some loss of function or changes in the appearance of forms, but I have never experienced a databse being unrecognizable. The options under 2010 allow a database to be saved down to 2000-2003, but not 2007. I can't figure how I can work on this at home unless I go ahead and upgrade. Please advise.

Read other answers

Afternoon techies,

I've been having a few issues with Access 2007, and was wondering if anyone could help me or provide any suggestions on how to go about this. But first, I'll give a background to the whole database. My database consists of only one table, which will be used by my company to store a digital collection of all their business associates (I had chosen to use Access instead of the Outlook Business Manager because I have more experience with Access). I then created three queries based on the table, and then also made forms and reports for the queries. So that's pretty much the gist of it.

So, here are my problems:

1) I have also included an OLE object for pictures in the forms, but would like to inform the employees that certain specifications need to be met before the picture can be placed. My concern is whether someone will place a massive image and drastically increase the file size of the database. The idea is to put a picture specified to be 95x125 (roughly passport size) and also use a JPEG format, so that the overall size is <50kb. I initially thought of placing a default background image with the specifications written (Constraints.jpg), but I couldn't seem to get it to work. So my next thought was to incorporate a validation rule for the OLE object, but so far, I haven't had any luck on this. Any ideas?

2) The database will be shared over a server, so that all the employs can upload their business contact simultaneously and... Read more

A:Solved: Access 2007: OLE Objects and access restrictions

Read other 10 answers

Hey guys long time no hear! Anyhoo, The office has recently upgraded all the computers to Microsoft Office 2010 except for mine because of my Access 2007 database. Hey they're more network/server oriented then software oriented so understandably they're a little gun-shy. Well, just wondering what consequences lie out there if I upgrade? Don't like what I'm reading out there right now, but I have always liked TSG's input on matters.

A:Solved: Access 2007 versus Access 2010

Read other 6 answers

First off I know little to nothing about MS Access so pardon me if I use inproper terminology or just plain act like I don't know what I am doing. The problem here in our office is that I am 'it'. I know more about technology than the others rolled into a ball.

No that we have that out of the way we had an Access database with all of our client contact info in it. It sat on our server so that everyone used the same database and no one wondered why new info was not input, etc.

I upgraded my PC to Office 2007 to give it a whirl. I opened the database the other day to see what the interface looked like and it was spewing messages about some kind of security issues. I think that I just clicked "OK" a couple of times and discovered that it would not let me into the database forms anymore. The file is still there, but our forms do not exist.

Any ideas what might have happened or how to get them to come home?



Read other answers


We have a moderetly complex database which runs fine in Access 2003, but we have been told that later this year all our machines will be upgraded to Office 2007.

Does anyone have any practical experience of having converted a database from Access 2003 to Access 2007? Is it possible? What are the likely problems? I remember when we converted from (i think it was Office 2000) to Office 2003 we had some problems, but nothing we couldn't overcome.

One of the reasons I ask is that we have someone here who seems preyyt adament that an Access 2003 database will not run under Access 2007. can this really be the case?

A:Access 2003 to Access 2007 Conversion

Read other 9 answers

Hi all,

New to Access 07, anyway i have a small db that i use to track my projects and wanted to know how to make this db read only when another user opens it so they can not modifiy it.

A:Solved: MS Access 2007 Read Only Access

Hey Antmar,

There's a few ways to do this. You can either assign everyone logins through the users and permissions wizard. Through this you can specify who has read only and who has access to modify data at whatever level.

The other way...without using logins that I use is modifying the forms that I don't want people to be able to edit through the form properties. In the data tab of the form properties...I change the choice for "Allow Additions" and "Allow Deletions" to "No".

The second method may cause a hassle every time you make updates since you'd have to have two different versions of the database you're working with or you'd have to make a new "read-only" version every time you make an update.

Hope this helps.


Read other 3 answers

I have a well established application developed in Access 2000. I have a customer using this application in Access 2007 in Vista, and for certain reports, a couple of fields display as #Name?.

I tested the application on my kids' laptop, which also has Vista & Access 2007, but I don't see that problem. I'm on SP1 for Access 2007, but my customer is not. He claims to have updated his Access, but no luck.

I noticed that both of the problem fields used the UCase( ) function, so I removed it. One of the fields is OK now, but the other one persists.

The problem field contains:
=Mid(DayOWeek(Weekday([Date1])),1,3) & "."
"DayOWeek" is my own function that returns the day of the week spelled out.

Thanks in advance for any help.


A:Access 2000 App displays #Name? in Access 2007

I do not have Access 2007 (thank the fates) but if that is the only field using your function and it is the only field that now has a problem, that strongly suggests that 2007 does not like your function.
I am not sure what your function does, but if it is to produce the day of the week from a date, i.e. Monday, Tuesday etc then you can achieve the same thing much easier by using
format([Date1], "dddd")
which might help.

Read other 1 answers


I need help on a shared access 2003.
in fact in my box, they decided to move to Access 2007.
when I open the database on access 2007, is just the Home window that appears, and that's it.
and yet I managed to load it with access 2007 two days ago and did a test to see if the updates back to the server and it worked, but since she no longer wants to market.

I enabled macros, I uninstalled Office 2003 and it gives nothing

After I checked the box "use special keys Access", the application starts but with a bug "2455 error Reference ...."

you have an idea about the problem?

Read other answers

What are the differences between Access 2003 and Access 2007? I have some code that works in Access 2003, but does not work in Access 2007.

A:Differences Between Access 2003 and Access 2007

Man, there are a lot of differences, ranging from the new database file type (no longer .mdb) to the fact that it is built on a new engine to....
Here is a good listing of the differences
Oh, one thing, code does not run unless your database is in a trusted location.

Read other 2 answers

Hi. I wrote an Access DB program on my machine which is running Windows 7 and Access 2007.
I want to move it to a machine that is running Windows and Access 2002.
I saved the program on my machine electing to save in Access 2002 format.
It doesn't run on the other machine. The diagnostic says something about being unable to locate a necessary reference.
The HELP suggests opening a module, clicking "Tools" then "Preferences", and do some things to make the reference
available. But "Preferences" is grayed out, not selectable.

The statement that is highlighted as the problem is a simple 'set' statement, as in: set rst = something (in this case it was an
openrecordset command). The variable rst is highlighted. If I eliminate the statement the system just finds and stops at the next 'set' statement, of which there are many.

I thought that saving in Access 2002 format would solve these incompatibilities, but apparently not.

Any suggestions?

Read other answers

Hi, im just wondering, if access 2007 is backward compatible to 2003? i have a work to be done, but the system in the office is 2003, while i only have access 2007 software in my computer, do i have to consider something else? or its better to get access 2003? any suggestions for professional database programmers out there?


A:Access 2007 and Access 2003?

It will load just fine in both. Just when going from 2007-2003, when you save the file do save as, select the file, and there should be a dropdown under the file name. Click that and select office xp/2003 (will say one or other or both). Now if you save from 03 for 07 just save normally and the file will open just fine.

Read other 1 answers

2 Things:

1. Access used to have the name of the database on the top most bar. Where is the name now? When i have multiple access databases open at one time, how do i know which database is which?

2. Access used to have each Table/Query/Etc in its own minimized window (on the Windows task bar at the bottom). Now it's all in one making it difficult to switch between Tables/Queries/Etc in one database.

Is there a way to put these 2 things back to the 2003 way?

Read other answers

Hey guys, i'm in need of some help. Currently I'm developing an access database and its getting rather complicated with all the forms, queries and reports; so i decided to make form that works as a switchboard. My question is, how do i make that form automatically start when the user opens access. I've tried making an openform macro, but it just doesnt seem to work. I know in access 2003 there was an option for an autostart macro, or some version of start options, but it seems to be gone in 2007. Its probably rather simple, i just have no clue where to look.

Thanks in advance,

A:Access 2007 Help

Read other 9 answers

I'm kind of Access-retarded. I'm managing a small business and I need to keep track of cutomer accounts, balances, products and their unit prices.

So somebody in my office makes a bunch of tables listing all of this information. The problem is, I can't form "relationships" between these tables because I keep getting a message that says, "database engine could not lock table 'Products' because it is already in use by another person or process".

What do I do? I need for the balances to change every time a customer makes a purchase, and I need listed unit prices to automatically show up on the 'Purchase' table.

Does forming relationships automatically calculate tha for you? What about that message that shows up when I try to form a "relationship"?


A:Access 2007 Help Please!!

Does anyone else have the database open while you are in it?

Read other 2 answers

Can anybody give the download URL for Microsoft Access 2007 free version.

Kindly help me?


A:Access 2007

Read other 8 answers

Good afternoon. This may be a fairly simple question.
I am creating forms from a table in Access 2007. I have several combo boxes 2 of the boxes require a check box to be activated to enter the text and 2 of the boxes do not require this. How do I remove the check box requirement. All of the property sheet settings are the same.

A:Access 2007

Sorry I don't understand why you need the Check boxes in the first place.
In the case of the Combos that don't need them why not just delete them?

Read other 3 answers

About Me:

I am a TOTAL novice when it comes to designing databases in Access 2007 (or any database).

The Scenario:

I need a database listing all network and power connections in a large LAN.
Table 1 lists devices
Table 2, which relates back to Table 1, lists interfaces on the device
Table 1 contains a switch called "Switch_1"
Table 2 contains all interfaces on Switch_1, so that when I click on the + in the left column of Table 1, it opens up and I can see the interfaces
Table 1 contains a server called "Server_1"
Table 2 contains all interfaces on Server_1
There is an Ethernet connection between Switch_1 and Server_1

What I want to be able to do:

Right now, I have to enter each connection into the database twice. This leads to errors.

Ideally, if I enter a connection to an interface in Switch_1 leading to an interface on Server_1, I want Server_1 to automatically update itself to connect its interface to the appropriate interface on Switch_1.
Example: Switch_1 Gig 0/0 to Server_1 LAN 1 should then update Server_1 LAN 1 to Switch_1 Gig 0/0
Am I making sense here? I don't know enough terminology to be any more specific than that... please help!

A:Access 2007

I think you are misunderstanding how to tie things together, it would help to upload a copy ( preferrably in 2002-2003 version). The Tables you describe are the tables that define your devices, I think you need a table for connections where you will select the devices, the related data to those devices can be pulled together in queries.

** I can open 2007 version

Read other 1 answers

I don't think that I've used my copy of Access 2007 before & this guide about Converting an Excel Spreadsheet to an Access 2007 Database shows a different picture than what I have which is:

I don't know if I did something to change this screen from the one in the link! How do I get it back?

A:I don't know where I am in Access 2007!

You are in the templates section. To create a new database you need to start in the Featuring section and then at the top in the middle section you didn't include in your screenshot there will be an icon for Blank Database. Click on that and the screen you see in the link you mentioned will appear on the right side column.

I hope this helps.

Good luck!

Read other 7 answers

hi guys,

i am a techie,
but never messed around with databases etc...

i want to build a small database util with my access 2007

all i want to do is this...

have a screen to enter info...name,address,telephone number etc...

then i can have another screen to call up info...so like when mr jones comes in i can have a record of him and his dealings with me.

can i make it user friendly for my wife...and put a company logo on etc..

im sure access can do this...or not?

do you need programming experience...

messing with access now...and i can put data into a database
do i use forms to create a "front" end and entry screen?
will read a book...

or does anybody know a good peace of software that will look after this?

thanks again...as always

A:can Access 2007 do this?

im talking to myself...this isnt healthy...

Read other 3 answers

I have 2 check boxes in the main form.
I have a subform in the main form attached to a query "xxxtest" (i have a "reviewby" field on the xxxtest query). I need a code to check that if any row in the column reviewby equals HLS the checkbox will be checked. This is the code that i currently have:

If Me.TaskDetails1.Form.reviewby = "HLS" Then
Me.Check585.Value = True
Me.Check585 = False
End If

This works only if the first row on the query equals HLS. It doesnt scan through the entire query. Any help would be appreciated.
Thank you

A:Access 2007 Help Please :)

VBA on the form will only act on the current record unless you use a Recordset and loop through all the records.
Or do the same on the form and move through all the records.
You can create an Update query to update all the table records and then just use the form VBA to keep the new entries up to date.

Read other 2 answers

Hello again...

If anyone remembers me from before you know I am working on a database for all the pickups we do at the company I work for. You will also probably know I don't have a clue.
After poking around on the internet I initially found a ton of posts describing how to do this with a bunch of complicated VBA code and whatnot.

Eventually I discovered the very simple code to make a combobox populate the fields I need. Name, address, that kind of stuff.

All that I had to do was put every field I need into the combo box. No big deal, and when I am done putting it together I will hide every field in the combobox except the company name. That works perfectly, and even with over a thousand customers (two actually, i entered everything in doubles to test it) it doesnt hesitate or freeze up at all.

Now I would like to use the same combobox to populate a populate a subform (table) on my "Customer Profile" form. I want to be able to select a customer name in the combobox. Populate the company information fields (done) and then display a list of every pickup we have done for the customer in order by date (P_Date).

Of course I have yet to actually enter all the fields I will need, but once I know HOW to do what I need to then that is trivial.
Anyways, here is what I have, minus anything specific or identifying as per the paranoid boss's request. I also cut out a couple of other forms which dont have anything to do with this for... Read more

A:More Access 2007 help!

Read other 16 answers

I need help appending table A and table B tables into a new table called table 3. Help please!

A:Access 2007

acc, welcome to the Forum.
Can you give us a bit more detail?
Are all 3 tables the same in terms of field names and types?

You use Append Queries to add from one table to another one.

Read other 1 answers


Hope you can help, im sure this is going to be a very simple soloution.

At the moment i have a value ie 12 months and at the bottom i have another text box to sum all of the months and i use the following control souce

=[G Period 1 Data]+[G Period 2 Data]+[G Period 3 Data]+[G Period 4 Data]+[G Period 5 Data]+[G Period 6 Data]+[G Period 7 Data]+[G Period 8 Data]+[G Period 9 Data]+[G Period 10 Data]+[G Period 11 Data]+[G Period 12 Data]
Click to expand...

However I have found out that it needed every box to have a figure in, is there any way it can sum up all the boxes even if it shows as nothing?


A:Access 2007

Ensure that the report is supplied it's data by a Query and use the NZ() function to replace Nulls with 0 (zeros).

Read other 1 answers