Over 1 million tech questions and answers.

Solved: Help! Security Feature + Access 2003

Q: Solved: Help! Security Feature + Access 2003

I have been getting help from OBP and jimr381 during the past few months to build a database for my workplace - on MY computer in my office.

I recently added the security feature on it, and am completely satisfied with it, however now this morning I burned it on a CD and tried to use it on the secretary's computer and it is looking for the exact file path it used on my computer to access its security file and related information. also, the secretary's computer is windows vista and mine is just good old XP.

What do I do? How would I disable the security feature in order to re set it up on the appropritate computer?

aaaaahhhhhhhhhhh! just kidding, I know someone will know the answer

Preferred Solution: Solved: Help! Security Feature + Access 2003

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

A: Solved: Help! Security Feature + Access 2003

Read other 6 answers

I have one workstation (Win2K Pro) on a LAN that refuses to use the default workgroup security file. Every time you open Access 2003 it creates a new file named system1.mdw. I have deleted all of the system.mdw file and placed the correct workgroup file in the user profile and it is still ignored and still creates a new system1.mdw

I have not checked the Office SP level on the workstation and there are no older versions of access on the PC. I suppose I could use the /wrkgrp switch if all else fails.


A:Solved: Access 2003 Security file

Have you used the workgroup manager to join the default group?

Read other 2 answers


Is it possible to start the app without "Security Worning" window ("Cancel. Open, More Info" buttons)? If yes, how you can make changes then?

Is it possible to start the app without "Microsoft Access" window on the background?


A:Solved: Access 2003 - To start the app w/o "Security Warning" and "Microsoft Access"

Read other 6 answers


I probably could ask this question to the person that told me he could or had done it, but I would like your input as to how to disable Vist's Security Feature.

Can it be done and if so, how?

A:Solved: I would like remove Vista's Security feature

Note sure if you meant the UAC or Security Center, but here is how to disabled the UAC:

Read other 2 answers


I am thinking about splitting my database putting the back end on my server and the front end on 2 machines. 1 user needs to be an administrator but without the ability to change the design features and the 2nd user needs only to input information.

Can this be done?

Thanks in advance.

A:Access 2003 security

Karl, yes it can be done, but you don't actually need to split it.
I am not sure what you mean by "1 user needs to be an administrator but without the ability to change the design " because if they can't change the design theay are just a user like the 2nd one.

Read other 2 answers

I help out a non-profit agency by writing Access applications for them. Their OS is WinXP SP-1. Mine is WinXP SP-2. They're using Access 2003. I have Access 2000. Evey time you open a database in their Access 2003, you get the ". . . may harm your computer. . ." message, and have to click OK to get by it. That's only an annoyance, but if I build mail-merge buttons into the switchboard where the query behind the mail-merge asks for user input, like a date, other messages pop-up about macros harming your computer BEHIND the other windows. When that happens, the mail-merge appears to have locked up because there's a security message the user can't see waiting for an OK to proceed.

It's my understanding that these (stupid and intrusive) messages can be eliminated by lowering a security setting, but I can't find any place in Access to do that. Are these Windows or MS Access security messages? If you can lower the security level in Access, how?

A:Access 2003 Security Messages

Tools / Macro / Security

Read other 1 answers

Hi. When I open a .mdb file created in Access 2000 in Access 2003 I get a security warning. How do I stop that from happening. I'm sure there is an answer to that on the board already but my search function doesn't seem to be working.

Thanks in advance


Read other answers

A few users in our network started using this feature and now when the user removed the delegates. The delegates are still able to view the other person's In-Box.

I checked the permissions - it's empty of other users
I checked the "Delegates" folder and it's empty.

So why is it that user1 is still able to view user2's Inbox?
I tested another user, for example: User3's permission is normal because User3 cant view User2 or User1 by using the "Open other user's folder: Inbox"

A:Solved: Outlook/Exchange 2003 - "Delegates" feature

User1 had "Admin" rights in the AD - duh
ran gpupdate /force /sync /boot

Read other 1 answers

I installed Office 2003 Prof on my windows 7 x64 machine. I unselected access and all its parts when installing the suite originally. Now the computer installed without my wanting it "Security Update for Access Snapshot Viewer 2003 (KB955439)" when I do not have any Access of office on my computer.

I tried to remove - uninstall it but the option does not exist. I have tried to uninstall it from Office suite directly but no luck.
Any one have any ideas on how to remove this from my machine.


A:How to remove Security Update for Access Snapshot Viewer 2003(KB955439) from computer

Hi welcome to the forum.
Open Configuration Managare and select the Install / Unistall Programs, you can also see the installed updates, select the one you nedd and click uninstall.
You haven't mention wchich version of windows you're using but it's there in the Configuration Manager

Read other 2 answers


I need to add rows from Access table to Excel spreadsheet by using VBA.

I cannot create a new file for various reasons, so I cannot use command “TransferSpreadsheet”.

Is it possible to do it?


A:Solved: Access 2003. How to add rows from Access table to Excel spreadsheet by using

Read other 16 answers


We have an Access application that holds employees' table. When new employee comes, the email stating the name of a new employee and the link to this Access app. being sent to a supervisor. When supervisor starts the app, it opens the list of all new employees for a supervisor to choose from.
What my boss wants is, that access will open a new employee record by itself, depending on the name from the email. In other words, he wants to open the specific record by the link from email.

Is it possible to do this?


A:Solved: Access 2003 - Opening specific record in Access table via link in Outlook

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

My company was using Office 2003 until 4 months ago when they moved to Office 2010. When they install Office 2010 Office 2003 was left on the machines so that we currently have both versions installed. I have developed and deployed several databases since Go Live, all in Access 2010, and all was going fine until Office 2003 was uninstalled from several machines and when they tried to open the database they got:

"Execution of this application has stopped due to a run-time error.
The application can’t continue and will be shut down."

I went all thought the code and couldn't find anything so on a whim our IT guy, the one that had removed Office 2003 reinstalled it and BAM, working again.

I have no clue as to what is going on here, Shared DLL, a Reference that's 2003, nothing. i need any thoughts as to where to look and what it might possibly be.


A:Solved: Access 2010 / Access 2003 Issue

When you uninstalled Access 2003 did you re-install or repair Access 2010, Office overwrites certain dll files so that the one in current use has control, if you then uninstall it the dll files do not necessarily return control to 2010, hence re-installing 2003 also re-installed the dll files.
Normally you can't run both versions of Access at the same time due to this problem.

Read other 2 answers

My problem is just a minor annoyance, so don't laugh.

I have numerous spreadsheets in Excel 2003 wherein I enter the month and year in the following style: 02-06. Even with the cell formatted as text, a darned green comment tag appears in the upper left corner of the cell telling me that, "This cell contains a date string represented with only two digits for the year."

Is there a way to eliminate the darned green tag?

A:Excel 2003 Comment Feature

Hi there,

You can go to Tools|Options|Error Checking and just uncheck the "Text date with 2 digit years" checkbox. There's all kinds of others that are in there as well if you have any others you want to disable.

FYI, if you only want to ignore the one, mouse over it till you see the little exclamation point in a diamond. It also has a little dropdown box. Click that and you can ignore the error on that cell only.


Read other 3 answers

I have an email with the subject
FW: Work Order Notify: WO00016815
This is a cut and paste fo the actual subject from subject line of the email that I received. I get a bunch of these and they are related to Work oders for me. When I try to use the find feature for "16815" or "WO00016815" it cant find it. Anyone have any insight as to why outlook cannot find this? I am making sure that I am looking in the correct folders and have those checked for searching.

Read other answers

Has anyone come across a situation when you make an appointment in your outlook 2003 calendar and invite people to join in and if they use outlook 2000, instead of automatically putting that entry into the outlook 2000 calendar, it just comes across as coding. It works fine if it's 2003 to 2003 or 2000 to 2000 but the feature doesn't work between the 2 versions. Any help would be appreciated.

A:Outlook 2003(XP)'s calendar feature

Read other 8 answers

Just rec'd Office 2003 and clicked on a feature that allows me to hover over a word in IE with the mouse and a translation of the word appears in Spanish in a little window that pops up.

It's a cool feature, except I forgot how to turn it on and off and want to know how to change it to German.

Also, is there any way I can get notified by email about responses to questions?


A:Word translation feature in Office 2003

Read other 6 answers


Systems Management Server 2003 Device Management Feature Pack - ICP
The SMS 2003 Device Management Feature Pack extends the enterprise change and configuration management capabilities of SMS 2003 to mobile devices running Windows CE 3.0 or later (ARM based devices with required OS components) and Windows Mobile 2002 for PocketPC or later. The Device Management client included with Window CE 5.0 Platform Builder (all processor types) is compatible with the Device Management feature pack. The Device Management Feature Pack allows IT administrators to capture the asset characteristics, configure settings and security policies of mobile devices, and update or deploy new applications with minimal interruption to the end user’s experience, dramatically reducing the cost of deploying and managing devices in the enterprise.

The Device Management Feature Pack is not released in Chinese Simplified, Chinese Traditional, or Korean language versions. To provide language support for customers who use these languages – as well as Italian, Spanish and Portuguese, you must install the Device Management Feature Pack International Client Pack (ICP).

Systems Management Server 2003 Device Management Feature Pack
The SMS 2003 Device Management Feature Pack extends the enterprise change and configuration management capabilities of SMS 2003 to mobile devices running Windows CE 3.0 or later (ARM b... Read more

Read other answers

I have a [COLOR=green !important][COLOR=green !important]database[/COLOR][/COLOR] with 1 table named "Demographic" and 1 table named "Client data"; Client data is linked to an Excel spreadsheet. Both tables have different headings/fields for each column but similar data. I would like to get the data from the Client Data table into the Demographic table and correct for the mismatched column headings so that Client Data is correct in Demographic.

Would someone be willing to help me step-by-step so that I can merge these 2 tables AND have the data correctly aligned in the Demographic table?

I'm essentially a newbie...please be gentle with me.


A:Importing Data from 1 Access 2003 to Another Access 2003 Table

Read other 13 answers

Hello All

Looking for an explaination for this issue, client I support would like to send a word attachment via MS Outlook 03 but using the send to function in Word 2003 and selecting the mail recepient as attachment option, however the reciepients never get the email nor does it go into his sent folder. I have tested it and sent it to myself and have yet to receive anything. He does not get any error msgs, delivery failures etc... He can send the doc as an attachment by doing it the regular way through Outlook and it works and the msg goes to his sent folder.

Anyone come across this before?

Read other answers

I have upgraded to Office 2003 and when I try to open Access, i get the following message:

Cannot open a database created with a previous version of your application. (Error 3041)

Can anyone tell me what I need to do?



A:Solved: Access 97 - Access 2003

You could try this article:

I only have minimal experience with Access, but I believe you may have overall issues trying to make this type of conversion without using an intermediate version first such as Access 2000 or Access XP.

Read other 1 answers

I have the above installed and I am using Windows XP but NIS has started playing up and is blocking me getting on to the net. I have not changed anything but it has started to do this in the last few days. I have to disable it to get on line, help needed please, Dojo

A:Solved: Norton Internet Security 2003

yo dojo - what sort of error messages are you getting from NIS? what do you have to disable to get online - is it just the firewall or is it everything?

btw i recently upgraded from NIS 2003 to NIS2004 - i was dreading it but it all went smoothly - even the online activation worked!

...unlike my XP activation

Read other 3 answers

Hi everyone,

This is my 1st time here so go easy on me!

I have created a module in access 2003 that exports and access table to a .txt file, it works fine.

What i need help on is adding the date and time to the end of the file path when it is exported.

Here is my code below.

Function Send2TextFile()
DoCmd.TransferText TransferType:=ExportDelim
specificationname:="table1 export specification", _
filename:="C:\Documents and Settings\Nick\My Documents\RoyalMailExport.txt", _
End Function

A:Solved: Access 2003 Help

Read other 10 answers

I am having trouble with creating an sql statement.
It is as follows:
FROM Deductibles
WHERE (Forms!frm_AddEmployee!Company_ID=Deductibles!Company_ID) AND ((Select Date()) BETWEEN Deductibles!Start AND Deductibles!End);
I am attempting to have this query run to populate a drop down menu for a user to chose an insurance plan when an adding an employee. (I will later need to use this same code for updating an employee as a new plan year will then occur.)

When I attempt to save this querry it tells me that the WHERE statement has syntax error. I'm sure I'm just missing something rather simple. It's been three or four years since I touched sql.

*I also posted this in the software development, as I am not sure if it is better to post under business applications or not.

A:Solved: SQL help in Access 2003

Read other 6 answers

Hello, I am using Microsoft Access 2003. The database I am using is set up with a switchboard that goes to different databases.

I have one form that is linked to a table that has information about all the agents we represent at the company that I work at. What I want to do is have an exact duplicate of this form, and have it empty, and name it as Pending Agents. This way, we can put in agents that are still pending on whether or not they are with us.

What I want to be able to do is when they do get with us, is move that agent from the Pending Form, into the Current Agents form. Is their anyway of doing this? Please, any help would be greatly appreciated.

A:Solved: Help with Access 2003

Read other 15 answers

Hi Everyone, how do i grey out a box in a form?

Thanks in advance.

A:Solved: Access 2003 Help

Set the "Enabled" property to No.

Read other 2 answers

I have made a database which processes approxemetly 170 payments per month in addition to profiles for over 200 clients. In a year this could mean it would save information on reports from over 2000 payments. Can this database grow too big as the months roll on, and potentially start making mistakes?

I hope not. Please get back to me on this.

A:Solved: Can Access 2003 get Too Big?

Read other 7 answers

Hi. I know that this might sound as a silly problem to experienced VBA programmers, bu i need to know how to assign a field/control box reference from a Form to a Field variable ( I suppose this is what I use to hold such a reference) if I know the name of that field/control Box. I need something equivalent to

Dim q as QueryDef
Set q = db.QueryDefs("query_name")

but for a field/control box on a Form. I need this because i have several fields on a form with similar names , except a number at the end of the name, and i want to create a generic function that reads that specific number and accesses the corresponding field/control box.

A:Solved: Access 2003 - VBA Help

Read other 6 answers

I have a database of names and addresses to which I have added a "print" field which is a yes/no checkbox format. I want to be able to run a macro (or code) which will run through the whole table and make the print field "true". During different print runs I can then "uncheck" the records I don't want to print.

I am doing this at the moment with a "setvalue" command in the macro with the repeatcount set for the last record number. However the table length changes from time to time so that value is not constant. Can any one tell me what other means I can use to stop the macro at the last record in the table.

I am happy to use code for this if it would be easier.

A:Solved: Access 2003 help.

You do not need macros or VBA code to do this, just an "Update" Query.
Create a Select query with your "print" field in it, convert the Query to an "Update" query using the Main Menu>Query and in the new "Update to" row of the "print" field type in -1.
Run the query and all the Records will be set to ticked.

Read other 3 answers


Does anyone know where i can download Access Runtimes 2003?

Thanks in advance.

Read other answers

Hello all,

I have a problem with pulling some reports off my database, The report is taking a name, a date and then specific information on an accomodation issue. Because of the way I have set up my database (i'm a beginner, and self taught) all the information is on one table, so there'll be other fields on the table The table has a name, date and then specific information based on their accomodation. Because the date is specific to the whole page and not just a field (i didn't know how to do that) when I run the report it's showing every date whether there is information relating to the accomodation or not. But it isn't displaying the other information in it as it doesn't relate to accomodation.

Is there anyway I can hide the dates with no information in them? I can apply a filter in the query i have and it hides everything without information in it, so it hides the dates. But I can't then set up a report on the filtered information.

I'm sure I have completely confused you... but if anyone has an idea of what i'm saying, your help will be greatly appreciated. I can try and make this clearer too

Thanks in advance

A:Solved: Access 2003

Read other 13 answers

Is it possible to send data in Access to XML?

A:Solved: Access 2003 to XML

Read other 9 answers

I am new to access, I am serving i Iraq and in my little spare time I am learning access 2003 (2007 not allowed yet with the military). I wrote a date base to file our documents. My question is, how can I make a form run from a desktop icon without opening access (In a way that no one can go thru the design and manipulate the program). Any help is appreciated. Also what is a good book to by to learn access????

Read other answers


I have 3 text boxes on a form, i only want these boxes visible to some users. Perhaps a comand button when pressed asks for a password then shows the text boxes. Is this possible?


A:Solved: Access 2003 VBA


I have actually found the solution. Here it is if you want to have a look.

Dim strPasswd
strPasswd = InputBox("Enter Password", "Restricted Access")
'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.
If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
Exit Sub
End If
'If correct password is entered open Employees form
'If incorrect password entered give message and exit sub
If strPasswd = "Haywood" Then
[Funded By]. Visible = True
[Daily Rate].Visible = True
[Weekly Rate].Visible = True
MsgBox "Sorry, you do not have access to this form", _
vbOKOnly, "Important Information"
Exit Sub

Read other 1 answers

I'm trying to create a Macro to open form from a shortcut on my desktop. I've followed the steps in MS help but I must not be understanding the filter portion. Can anyone help?

A:Solved: Access 2003

Read other 8 answers

Here at America Online, we know that our members are the best source of good
ideas for a better Internet. And you have told us that one of your biggest
concerns is the threat of online viruses that can crash your computer, steal
your personal information, or damage or delete important files.

So I am pleased to tell you that our newest version of the AOL software, called
AOL® 9.0 Security Edition, now includes one of the leading virus-protection
programs at no additional charge. I encourage you to <A
HREF="aol://1223:135031/aol://1391:47-64928">upgrade</A> today.

McAfee® VirusScan® Online protects your entire computer from tens of thousands
of known viruses and is automatically updated to protect against the hundreds of
new virus threats that emerge each month -- helping keep you and your family
safe at all times.

No other Internet service provider offers this premium service to all of its
users for free.

And that's only the beginning. Because of your interest in safety and security,
we've built numerous enhancements into 9.0 Security Edition to better protect
your PC from other online threats. Among them:

* Better defense against spyware: AOL Spyware Protection helps protect your
computer from unwanted spyware and adware, and the new SpyZapper(TM) feature
automatically targets the most disruptive forms of malicious software for

* Improved spam and pop-up controls: Simplified spam control tools make it even
easier to keep you... Read more

Read other answers

I have an Access database that has excel files imported into it. The database was designed to make it simple for users by having a graphical Import button that users click on and the database automatically pulls the correct files. This has been working fine on most systems. I have one system running Windows XP where I am having difficulty with this function. Everytime I click on the Import button I get the following error message

"Runtime error '91' : Object Variable or With block not set"

and then it gives me the option to cancel or Debug. When I look at Debug it takes me to the Visual Basic Editior and has an entry highlighted. I then went to another machine this feature worked on and brought up its Visual Basic editior and looked at the contents and everything looked the same. I am unfamiliar with making changes in this context, but was curious as to whether anyone had seen this before and if there was a fairly easy way of solving it?

As always, thanks!

A:Solved: Microsoft Access 2003

Read other 16 answers

Several years ago, I created a database to enter requests for public information. I create a new table for each calendar year so that the tracking number for the first request of the year restarts at 1 (using the Autonumber field). For example, In 2007 it was 07-0001, in 2008 it was 08-0001. At first this wasn't a big deal but with each year the database has become more complex so I find myself having to go back and replicate all the objects and replacing the year. Is there a simpler way to do this? Thank you.

A:Solved: Access 2003: Need to simplify

Read other 16 answers

I have a report that is displaying a number field. I want to sort on the report by the numbers, but the sorting is not working properly.

For example, I have numbers: 1,2,3,4,5,6,112,200. Here is how the report is sorting the numbers:


Why will it not sort in a series?

A:Solved: Access 2003 Report

Read other 16 answers

I am using Access 2003. I have a form, 'Protocollo', with a subform 'sfrm Prot' that is linked to the form on the field IDProt. The record source for the subform is a subset of the table [Prot_detail], and it contains only two records. The first record is displayed when btnIn on the subform is pushed and the second is displayed when btnOut is pushed. I want to change the font on the buttons to bold if the underlying record has any text in the 'Oggetto' field. I wrote a routine that is attached to the Current event of the subform, but it is not working. Here's what I wrote:

Dim rst As Recordset

set rst = Me.Recordsetclone

Me.btnIn.FontBold = IsNull(Me.Oggetto)
Me.btnOut.FontBold = IsNull(Me.Oggetto)


Any ideas why this doesn't work? Can someone suggest something that would work, hopefully without using DLookup?

A:Solved: Access 2003 form help

Read other 9 answers

I have a database that works fine, except that when I click a button to run an application I get a "Invalid procedure call or argument" error message. The application I am trying to run is a *.BAT file and I have enclosed the full UNC path in quotes.

"\\server\share\full path\Q3.bat" - This will give me the error.
"C:\Documents and Settings\user\Desktop\Q3.bat" - This will work.

I have to use the full UNC path, as not everyone who uses this database has the network drive mapped to the same drive letter, and they cannot copy the files locally.

Any ideas?

Thanks in advance!

A:Solved: Access 2003 buttons to run app

Read other 7 answers

Small issue with Access 2003 which has been driving me mental all morning.

I have set up a large database. Some of the fields on one of the forms are either currency or number fields. When the form is opened some of the fields are blank and some are showing as a zero. I need all the fields to show blank.

I've been through everything and can't find any difference between the properties showing blank already and the ones showing a zero. The default value for all the fields in blank.

I'm sure it's a simple things to fix. Could somebody help before I go insane!!!

Nice walk in the fresh air and just managed to solve it. There was some data in the table which was there before the default values were changed, therefore, it was that data which was showing up in the form. Phew

A:Solved: Access 2003 default value

The form's RecordSource (think: table) has some Number data type fields, is this correct? Is it only the number fields that show 0 in their bound textbox controls when you open the form?

I don't know much about Access 2003, I only have 2000. Seems like an odd problem, though.


Read other 3 answers

Hi, in my database i have created a mail merge button with the below code attached. I am getting a runtime error 13 Type MisMatch but cant figure it out. The Error is in blue. Any help will be appreciated.

Private Sub Command16_Click()
'Declare Variables for storing strings (Text).
Dim AddyLineVar, SalutationVar As String
'Start building AddyLineVar , by dealing with blank
'LastName and Company fields (allowed in this table).
If IsNull([LastName]) Then
AddyLineVar = [Company]
'Just set SalutationVar To Generic "Sirs"
AddyLineVar = [FirstName] + " " + [LastName]
'If the company isn't blank, tack that on after name.
If Not IsNull([Company]) Then
AddyLineVar = AddyLineVar + vbCrLf + [Company]
End If
'Salutation will be customer's first name.
SalutationVar = [FirstName]
End If
'Add line break adn Address1.
AddyLineVar = AddyLineVar + vbCrLf + [Address1]
'If Address2 isn't null, add line break and Address2
If Not IsNull([Address2]) Then
AddyLineVar = AddyLineVar + vbCrLf + [Address2]
End If
'Tack on line break then City, State ZIP.
AddyLineVar = AddyLineVar + vbCrLf + [City] + ","
AddyLineVar = AddyLineVar + [State] + " " + [ZIP]
'Declare an instance of Microsoft Word.
Dim Wrd As New Word.Application
Set Wrd = CreateObject("Word.Application")
'Specify the path and name to the word document.
Dim MergeDoc As String
MergeDoc = Application.CurrentProject.Path
M... Read more

A:Solved: Access 2003 VBA Question

Read other 10 answers

Hello again,

I am working with Access 2003.

Is there anyway of coding a button in a form to where it will delete a record from one table, and insert the data into a seperate table? I want to do this so that if someone deletes this record, it will be archived into a seperate table than the one the form is pulling data from.


A:Solved: Access 2003 Question

Read other 12 answers

Good evening!

I'm very new to Access, but I've gotten pretty good at "cut/paste" engineering for a database I'm charged with maintaining. I have a combo box that's got a number of items to select from. Right now, we can select items in the combo box by clicking on each one, or Shift+click or Crtl+click--but the only way we have to select all the items in the box is to click the first item, then shift+click the last item.

I have followed the instructions in KB article 210290, but all I end up with is a "Type Mismatch" error and a blank combo box. The article is for Access 2000, and I'm running 2003. Is that an issue? The only code in the form (other than the usual "cmdDoReport...") is the bit that allows us to select multiple items:

Dim vItm As Variant
Dim stWhat As String
Dim stCriteria As String
Dim stSQL As String
Dim loqd As QueryDef

stWhat = "": stCriteria = ","
For Each vItm In Me!TEC.ItemsSelected
stWhat = stWhat & "'" & Me!TEC.ItemData(vItm) & "'"
stWhat = stWhat & stCriteria
Next vItm
Me!txtCriteria = CStr(Left$(stWhat, Len(stWhat) - Len(stCriteria)))
Set loqd = CurrentDb.QueryDefs("qryMultiSelectGroupTEC")
stSQL = "SELECT GroupTECRateQuery.*, * FROM GroupTECRateQuery WHERE TEC IN (" & Me!txtCriteria & ") "

Are the two bits of code incompatible in some way?



A:Solved: Add All Function in Access 2003

Read other 16 answers

I am a new member. I have Access 2003 and I tried to find samples on the forum but was unable to.

I am writing a report - this report has different criterias or different departments like commercial or Design build, etc.

What I would like to do is change the background when the department names change. Can this be done??
thank you

A:Solved: Access 2003 Background

Read other 6 answers