• 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:
  • Access Subform Blank

    Subform doesn't appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

    Billa15 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:
  • Access Reports to PDF file

    Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...

    SeenFresh25 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:
  • Filtering a Subform

    How do I filter a form based on a value contained in the subform?

    Johnandy5 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:
  • Update Microsoft Access database from VB6

    Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...

    Codeless5 pointsBadges:
  • Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 pointsBadges:
  • Query showing vbCRLF in string data

    Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....

    Sandisk25 pointsBadges:
  • Disconnecting a Crystal 8.5 report while report is open in VB6

    Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require...

    Slscheer5 pointsBadges:
  • What backend works best with Cognos frontend?

    Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren't sure if that is the best option. Any suggestions?

    Jayne46245 pointsBadges:
  • How to publish a MS Access application as a regular web page in Internet Explorer.

    I'm publishing a Microsoft Access application, on a Windows Server 2008 machine, with RemoteApp. I want to know if there is a way to access this application over the Internet without using the web access feature. To be more precise, I want to publish my application as a regular web page in Internet...

    WindowsServerATE335 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following