Access

run vba code as admin

I am currently working on an ms access application for a large insurancecompany which generates reports for the user after the user inputs/selectsome data....Unfortunately the application has already been built - and till now we usedto run the application/reports by logging in as admin.. however,...

Answer Question   |  Mar 8 2008   11:56 PM GMT   |  asked by Gangac
VBA, Access, Microsoft Access

Using Access Data Bases on My Web Site

I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By...

View Answer   |  Mar 8 2008   4:32 PM GMT   |  asked by Strategist
Database, Access, Web development

MS Access-Query

I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

View Answer   |  Mar 6 2008   4:54 PM GMT   |  asked by FranktheMan
Access, Database programming, Microsoft Access

How supply password in VBA during CompactOnClose for back-end password-protected db?

Access 2000:Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close.Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link.I have password protected...

View Answer   |  Feb 19 2008   9:46 PM GMT   |  asked by Dlc9ball
Microsoft Access, VBA, Access

Microsoft Access - Find and Replace Issue

In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

View Answer   |  Feb 18 2008   6:21 PM GMT   |  asked by Santino
Microsoft Access, Microsoft Office 2007, Oracle

Months query in Microsoft Access 2000

On the basis of my query i have built a totals query as follows:SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedateFROM qryMarginGROUP BY qryMargin.invoicedate;I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange them...

Answer Question   |  Feb 16 2008   12:57 AM GMT   |  asked by Peljo
Access

Exporting MS Access data to Oracle

Hi,I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101.Please provide suggestions for how to solve this...

View Answer   |  Feb 8 2008   3:33 PM GMT   |  asked by M1
ODBC, Oracle, Access

MS Access Date Time

I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time

View Answer   |  Feb 8 2008   11:10 AM GMT   |  asked by Han8484
Access

Microsoft Office & AS/400 Database

I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

View Answer   |  Feb 5 2008   5:56 PM GMT   |  asked by Lshipley51
ODBC on i5, i5, Access

IIF clause

Can you help me build the right IIf field in the query with the following conditions :The field DDU consissts of :DDU :[exworks]*2+0,4+0,01To the above expression i must also add 0,001 if size = 205, etc according to the following table :205 0.00160 ...

Answer Question   |  Feb 5 2008   4:24 PM GMT   |  asked by Peljo
Access

How to read/write Access 2003 mdb records on server via INTERNET connection

It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box.Running Access 2003 on client under XP Pro.mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb.All works when opening mdb locally.When...

View Answer   |  Feb 4 2008   10:53 PM GMT   |  asked by RalphW
Access, SBS 2003

MS Access - Count of parent table items in a report

I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on...

View Answer   |  Jan 16 2008   8:43 PM GMT   |  asked by LegacyDave
Microsoft Access, Access, Access reports

Access 2007 refrence look up

Ok this question might sound kind of elementary but i just seem to be missing something.I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for.when i choose a selection from the combo box i want it to display...

View Answer   |  Jan 15 2008   3:05 PM GMT   |  asked by IT-Guy1509
Access, Microsoft Access, Microsoft Office

MS Access Question

ok im working with office 07, Access.I have multiple checkboxes for one question. I need to create some kind of auto warning system if the user checks more then one box for the same question.I cannot change design because it needs to mimic a current form. As well as needs to have the ability to be...

View Answer   |  Dec 21 2007   2:49 PM GMT   |  asked by IT-Guy1509
Microsoft Office, Access

SQL 2000 to Yukon Migration

We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

View Answer   |  Jul 25 2007   8:02 AM GMT   |  asked by Kilaru
Database, Oracle, DB2

Controlling VPN access

Here's my scenario.I fall under guidelines of HIPPA.I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain.Is there an easy way...

View Answer   |  Feb 5 2007   7:41 AM GMT   |  asked by gforsythe
Microsoft Windows, OS, Servers

What is NAT port forwarding?

Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

View Answer   |  Jan 31 2007   6:23 PM GMT   |  asked by 111110
Exchange, Instant Messaging, OS

Dynamic updates to a DNS Server

What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

View Answer   |  Jan 31 2007   4:38 PM GMT   |  asked by 111110
OS, Servers, SQL Server

Outlook - Intermittant ability to view shared Calendar folder.

The Office assistant at our office has permissions in Outlook to several users' calendar folders to make appointments. The permissions have been verified and setup correctly. She can usually access any of the shared folders in question but occassionally she will not be able to access one of the...

View Answer   |  Jan 31 2007   3:57 PM GMT   |  asked by jmello
Exchange, Exchange security, OS

Managing SQL 2000 server over the internet

I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.

View Answer   |  Jan 18 2007   12:20 AM GMT   |  asked by SQLDEV
OS, Servers, Security