Access – Bound sub form trying to set the value of an unbound field

I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

TJay85 pointsBadges:

unable to connect to SQL from Access

I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version of...

Standaman15 pointsBadges:

Learning SQL Part 2

Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?

CompEng1,240 pointsBadges:

Update Table use Left outer join in ms acces

hello, i wont to ask i try to update table use from another table, i sue the left outer join if in ms sql server this command is run, but when i try to in ms acces its cant run please see the command Private Sub Command31_Click() Dim update_personallog As Integer update_personallog = "update...

Wahyono25 pointsBadges:

Access Switchboard Problem

The title of the switchboard changes to the title of one of the items. I can't figure out why.

Tryan1225 pointsBadges:

data copy – paste from the same table not showing in a subform

I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

Tcharlton7920 pointsBadges:

Microsoft Access Audit Report

I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...

WayneW194720 pointsBadges:

External document used as an Access Form?

I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a "User Request form" that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this option has been...

Rmason345 pointsBadges:

Showing a substiute value in a report if conditions are met – Access

In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...

Gbullo70 pointsBadges:

table from gridviewwith sql vs2008

hello, help, i have a access database with menu items--id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings...

Zpupster65 pointsBadges:

With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form when...

Swd14420 pointsBadges:

Microsoft 2003 Access relationship window

The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?

Rmrj5 pointsBadges:

dlookup

how does dlookup work?

Davva10 pointsBadges:

How to show two query results in one Microsoft Access report

I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is "jones" in query2 in the feild lastname the criteria is Not"jones". What I want to have is a report that shows...

Leilo5 pointsBadges:

Access Database Capacity

What is the data volume that an Access Database can effectively handle?

Tlee10 pointsBadges:

Grouping Query

I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 850,000 I need to write a query...

Mmak5 pointsBadges:

Toggle button in Microsoft Access form

Hi, in an access form I have included a Toggle button which when "on click" imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won't import the same database. Thanks

Codino10 pointsBadges:

Updating Combobox after new data added

Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn't exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new...

SteIT15 pointsBadges:

MS-Access

Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...

PIEGR10 pointsBadges:

enter key behavior on forms

when my user hits the enter key, i want it to return to the first field (which is hte id entry key).

Komita5 pointsBadges: