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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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


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

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

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

I am totally a beginner, and I have taught myself Access 2007. I thought I had it down...I was able to make it slightly more difficult for people to get to the actual data by changing various properties in the design view (like taking out the navigation buttons, etc)...However, when I go back and put everything in so that we can see the data to create reports and such...I was able to delete two incorrect records...I hit save...and then I put all the settings back to where they were previously...and all the records disappeared. I'm not sure what I did. But, how do I fix it so that I don't erase records in the future? Or, how can I secure the database and unsecure it without messing everything else up? Or if you can help me set the 2007 up so that certain people can access the data entry, and other people can access the data...that would also be totally rad....just saying...
Any and all help are greatly appreciated!!

A:Please help with Access 2007

Are you sure that the Records were actually deleted from the table?
All of the records should not be deleted unless you highlight them all first.
If you convert the database to Access 2003 format (.MDB) you should be able to set up User Level Security using the Security Wizard. However you may not be able to due to some Access 2007 function not being convertable to Access 2003
Access 2007 does not have that function.

Read other 3 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

Hi All,

I've been looking for an Access Forum for some help and have come across to this one here.

I'm a total noob at Access - ignored it during high school days and tried to avoid it during Uni, thinking i would never need it - i was wrong

Come into my job and after 5 months and been asked as a favour to organise a program for call logging something basic just to enter details and export reports to Excel on a weekly basis. I know i can use excel to manage this and quiet possibly with something so basic i should - but there is 2 reasons why i want to or really need to do access.

1st - looks so much more professional since any one can use excel.
2nd - I really need to learn Access even if i dont want to.


What i basically need is the user entering information, such as Customers First and Last name, contact details, complaint information, complaint resolution, date of complaint, Reference Number and finally Store Name and Manager's Name. The user entering it will be using the Run time version of Access 2007 - so they wont modify anything at all... any changes would need to come to Me.

I've created Tables As per attachment.

What i want to avoid is creating changes to the Database - since we are a business we open stores frequently meaning i would need to update it and since this is only as a favour i was hoping if the user could input it and then it would remember.

Could be totally wrong here but i need a starting point - Ill end up creating ... Read more

A:Access 2007

Read other 6 answers

Hey all,
I am designing a software with access 2007 for invoicing and inventory and i need some basic VBA knowledge like adding and substracting. However, i dont have the smallest idea of VBA. I need an introduction to VBA starting from the most basic things.
The things i need the VBA for is for example:
- add invoice amount on the customer balance
- remove sold amount of products from inventory
- substract customer balance when a payment is made


A:VBA for MS Access 2007

Read other 10 answers

Hi folks,

I'm building a database in Access 2007 that will be used to track lab usage at my job. I have a table that has the user ID, date of sign-in, time of sign-in, etc. Now I'm trying to build a query to count the number of sign-ins in a given hour. So here's what I have, and it's not working:

First field is my sign-in date field where the date = a given date. Second field is where I'm having trouble. Here's what I have in the field box:

8 AM:[Copy Of SignIn]![Sign_In_Time] Between #8:00:00 AM# And #8:59:59 AM#

I'm naming the field "8 AM" (it won't let me name it "8:00 AM" for some reason but that is a minor issue), and I'm trying to tell it I want all entries between 8:00 and 8:59. I haven't even gotten to the count part yet. But am I supposed to use Group By or what?? Either way, it won't let me enter that in the field box. It's telling me I'm using an invalid date value.

Can anyone help me?

EDIT: It finally let me enter that expression above, but it is giving me a count of 35 (which is all of them!), when I actually only have 1 entry for that time range.


A:Access 2007 Help Please

I would guess that if you have the data in two fields, date and time, you need to query for both fields ... if date=xxx AND time=yyy, otherwise you're picking up everybody who logged in between 8 and 8:59 regardless of date, which might well be all the records you now have.

Read other 5 answers

I am using Access 2007 and not sure how to use the IIf statement in a yes/no field - if I click yes in one field in a table I need a field in another table to change to yes. IIf student.[form] = yes then data.[add] = yes

A:Access 2007

Where are you trying to do this in a Query, on a form?

Read other 1 answers

I am trying to use Link Table Manager and csv file. I can link the first file fine but when I try to link the second file to append to the first file, nothing happens. Is something turned off in Access or is this a glitch with Access 2007?

A:Access 2007 Help

First, welcome to the Forum!
I will assume you have done this before (it's not exactly something newbies start out doing) so it is probably a formatting problem (sigh, like usual).
Try importing the files and compare them in Access and see if there are differences that are obvious (it may be subtle, like date type or number type) - if you can run an append query with no problems, well, I don't know. I don't have 2007 - but I can call on some friends here who do.

Read other 1 answers

When I create a querry I use multiple tables and I have a joint going from one table to the next. My Question is how come when i run my querry I have multiple column even those column that i have not chosen

A:Access 2007

You probably added the whole table instead of the individual field somewhere within the query. If you double click on the asterisk at the top of the field list you will add the whole tab to the query instead of the individual field.

Read other 1 answers

I've been testing Windows 7 at my work for a few weeks now and I've run across an Access 2007 issue that I can't resolve. It happens when I open an Access database and it comes back with this error,

"The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."

I have no issues opening the files in Windows XP using Access 2007. I also tried opening the file when no one else has it open and no locks are on it and no luck. The database/s is running in shared mode.

Any help would be greatly appreciated.

A:Access 2007

You could first try running the Access MicroSoft Office Diagnostics:

Click the Microsoft Office Button, and then click Access Options.
Click Resources.
Click Diagnose, click Continue, and then click Start Diagnostics.

Read other 3 answers

Hello everyone. First off, i'm new to access, i've never used it before, but i'm helping a friend at the office.
We are using access 2007 on a pc running vista.
I've surfed the internet for a while trying to understand how to run a macro with a SQL query in it, but i just can't seem able to make it work. It keeps saying that i'm trying to use a function that office can't recognize.
The macro is a button that, when clicked, runs a certain code I made as a tester (which is probably the problem). The function code is:
[codebox]Function Revisar_Calendario()
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qdef As DAO.QueryDef
Dim consulta As String

Set db = CurrentDb
consulta = "SELECT Plazo FROM Actividades WHERE Plazo - Date < 7 Days"
Set rst = db.OpenRecordset("consulta plazos")
End Function

The idea is to go through a table and gather the items which are coming to a certain date (and, if possible, send an email alerting the participants, which shouldn't prove very hard once i get the hand of the syntax)

Please, if someone could guide me a bit, it would be wonderful. I've searched for tutorials, but haven't had any luck with the ones i've found, so if anyone has a tip there, that's also greatly appreciated

I guess that instead of "7 days" i should use "Date - 7" or something of the sort? I never understood very well the dating systems...

A:Need Help with Access 2007

Hello petocities,You might want to start by going to this website: Martin Green's Access TipsIt has help me get through some rough spots with SQL in VB code. The areas marked Access and SQL Part 1 (thru) 4 should be of interest to you.

Read other 3 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

Does anyone know if it is possible to create a custom menubar inside Access 2007? I as able to create a custom menubar in Access 2003.

A:Access 2007

Some links...not much help, though
In theory you can develop some custom functions by writing the XML code...

Read other 2 answers