Search Results

Search found 71736 results on 2870 pages for 'how to create an access d'.

Page 1/2870 | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Linked Tables not working With Access Database

  - by Kronass

  Hi, I have an Access database in a computer and I want to access it from other computer in the network. so I made mapped drive and created Linked Tables, then Imported all the objects (forms, queries, reports). when I open access database in the second computer and make any changes in using the forms non of the changes are affected in the main…

  Read the article

• MS Access 2003 - Embedded Excel Spreadsheet on Access form

  - by Justin

  lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in the A1 cell on that spreadsheet. What VBA do I…

  Read the article

• Generating a twitter OAuth access key - the semi-manual way

  - by Piet

  [UPDATE] Apparently someone at Twitter was listening, or I’m going senile/blind. Let’s call it a combination of both. Instead of following all the steps below, you could just login with the Twitter account you want to use on http://dev.twitter.com, register your application and then click ‘Edit Details’ on the application overview page at…

  Read the article

• Using a PivotTable to Count Items in Access

  - by Sandra

  I have a list of text entries and I want to count how often each entry appears in the list. e.g. Berlin Paris London London Paris Paris Paris The result would be Berlin 1 Paris 4 London 2 This result easy do to achieve with an pivot table in MS Excel (see: Count Items in Excel). My data not in spreadsheet in Excel but in a MS Access…

  Read the article

• Postgres user drop

  - by Grasper

  I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access to table main.user_instance access to…

  Read the article

• Postgres user/role drop

  - by Grasper

  I am trying to drop a user: drop user testUser; I want to force this to work in a simple manner (Not a million calls)... How can I do this easily? I get this output: ERROR: role "testUser" cannot be dropped because some objects depend on it DETAIL: access to table main.tap_db_version access to table main.user_instance access to…

  Read the article

• ruby on rails configuration

  - by Themasterhimself

  Im using the following guide for getting started with rails for ubuntu 9.10. http://guides.rails.info/getting_started.html I have installed both ruby and gem. gokul@gokul-laptop:~$ ruby -v ruby 1.8.7 (2009-06-12 patchlevel 174) [i486-linux] gokul@gokul-laptop:~$ gem -v 1.3.6 gokul@gokul-laptop:~$ For rails, …

  Read the article

• How do I create an Access 2003 MDE programmatically or by command line in Access 2007?

  - by Ned Ryerson

  I have a legacy Access 2003 database file that must remain in that format to preserve its menus and toolbars. I have recently moved to Access 2007 in my build environment and will be deploying the compiled Access 2003 program with the Access 2007 runtime. In Access 2003, I could script the process of creating an MDE…

  Read the article

• Create user in Oracle 11g with same priviledges as in Oracle 10g XE

  - by Álvaro G. Vicario

  I'm a PHP developer (not a DBA) and I've been working with Oracle 10g XE for a while. I'm used to XE's simplified user management: Go to Administration/ Users/ Create user Assign user name and password Roles: leave the default ones (connect and resource) Privileges: click on "Enable all" to select the 11 possible…

  Read the article

• Connect Access 2007 to SQL Server 2008 Database

  - by Peter

  Hi, I've seen numerous answers to similar questions like this one. I haven't seen on the web many people have asked the seemingly simple question "How do I connect Access 2007 to an SQL server 2008 database" - but all of the answers describe how you can migrate from access 2007 to an sql server 2008 database, or…

  Read the article

• MS Access group development

  - by Hubidubi

  We are planning to redesign quite a huge MS Access application. Is there any way to work concurently on the same application or is it possible to merge two seperate instance of the same file (not the data, but the forms and code). Now Access contains the data, but in the future version MySQL will host the data…

  Read the article

• SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

  - by pinaldave

  First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and I must say I…

  Read the article

• Best way to read an Excel file into an Access 2007 database

  - by waanders

  What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table.

  Read the article

• VBA for Access 2003 - DDL help with creating access file: setting the Autonumber data type

  - by Justin

  So I have the below VB that creates an access file in the default workspace, creates a table, create some fields in that table...just need to know the syntax for setting the first data type/field to autonumber...GUID, Counter, etc will not work as in Access SQL ' error handling usually goes here dim ws as…

  Read the article

• Unable to remove master -> child subform links in microsoft access 2003

  - by Doug

  Hi, I am having an issue removing the master - child link fields in an access subreport data form. I have tried every avenue to remove them, using the properties window of the subreport as well as the link wizard. I have also deleted the subreport from the database and then gone as far as re-importing…

  Read the article

• Get records from Access table

  - by chianta

  On Access 2010 I need to use VBA to get the records in a table, process them and put them in a new table. Could you tell me how can I do? Is there a way similar to C # to put everything into a datatable the result of a query? I found an example on how to get the data. http://pastebin.com/bCtg20jp …

  Read the article

• Access View Missing in Access Data Source Configuration Wizard

  - by Steven

  I added an AccessDataSource to my ASPX page. I clicked on "Configure Data Source...", chose my Access database, and clicked the "Next " button. A couple of my queries / views are missing from the list. What might be causing this?

  Read the article

• ACCESS VBA - DAO in VB - problem with creating relations

  - by Justin

  So take the following example: Sub CreateRelation() Dim db As Database Dim rel As Relation Dim fld As Field Set db = CurrentDb Set rel = db.CreateRelation("OrderID", "Orders", "Products") 'refrential integrity rel.Attributes = dbRelationUpdateCascade 'specify the key in the referenced table Set…

  Read the article

• MS Access 2003 - ordering the string values for a chart not alphabetical

  - by Justin

  Here is a silly question. Lets say I have a query that produces for a list box, and it produces values for three stores Store A 18 Store B 32 Store C 54 Now if I ORDER BY in the sql statement the only thing it will do is descending or ascending alphabetically but I want a certain…

  Read the article

• MS Access 2003 - Message Box: How can I answer "ok" automatically through code

  - by Justin

  So a couple silly questions: If I include this in some event: MsgBox " ", vbOkOnly, "This little message box" could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away? I know its silly…

  Read the article

• Access 2007 VBA & SQL - Update a Subform pointed at a dynamically created query

  - by Lucretius

  Abstract: I'm using VB to recreate a query each time a user selects one of 3 options from a drop down menu, which appends the WHERE clause If they've selected anything from the combo boxes. I then am attempting to get the information displayed on the form to refresh thereby filtering what is…

  Read the article

• Access 2007 VBA : Building a listbox with selection choices from another list box

  - by Justin

  So there are 8 categories that may be associated to each order, but not necessarily all of them. So i was going to build a list box that allowed the user to double click each of the category they wish to associate when they have an "Order Detail" form opened up (unbound form that has hidden…

  Read the article

• MS Access 2007 - Warning box everytime the database is opened is different from 2003

  - by Justin

  Everytime I open my mdb copy to work on something, I get this little warning label that some somethings have been blocked....click this button to un block? anyway I can default that off? thanks justin

  Read the article

• Access: Data Type Mismatch using boolean function in query criteria

  - by BenV

  I have a VBA function IsValidEmail() that returns a boolean. I have a query that calls this function: Expr1: IsValidEmail([E-Mail]). When I run the query, it shows -1 for True and 0 for False. So far so good. Now I want to filter the query to only show invalid emails. I'm using the…

  Read the article

• ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

  - by Thirst4Knowledge

  ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to…

  Read the article

1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >