• 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:
  • CSV file to database table

    Hi Experts, I have a question is the csv file can be converted to a database table with same column and data i hav gone through the CSV format tag,not getting idea about this i just would like to know is there any procedure or sysntax to do this thanks for the hlp

    Inprise610 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:
  • 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:
  • DATABASE FoxPro 2.6

    How to recover a damaged database file in Foxpro

    Prabhakaran20095 pointsBadges:
  • Would you go with iSCSI or Fibre Channel for mass storage in this case?

    Is there any TPS benchmarking available in deciding whether to go for Fibre channel or iSCSI? We are using Oracle database which requires a Terabyte of storage and will be operating at the 1000TPS at peak level. In this case - should we go for iSCSI or Fibre Channel as the mass storage device?...

    BrentSheets6,925 pointsBadges:
  • Using MySQL message API on Windows

    I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for the...

    Linux - Ask the Expert270 pointsBadges:
  • Execute a query on table in different db that will make a table in currentdb

    Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places... The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can...

    Rjwilcox45 pointsBadges:
  • Conversion of table into XML

    How to load a table into XML in a CLOb using Oracle 8.1.4

    SBK20095 pointsBadges:
  • pasting a database query into crystal

    I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?

    Messe5 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 retrieve images from the database programmatically using .NET?

    insert and retrieve pictures from database

    Danielrajthedon5 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • Find and replace in Foxpro 2.06 for DOS

    Hello i am using foxpro 2.06 for dos fro my small application needs. i want use find and replace a character in low level file opening..... ( using fopen() ) pls help. 2nd Q : How to use the ; (semicolon ) as Delimiter in fox 2.06 for dos. Thx Giri

    Giri7525 pointsBadges:
  • ORA-01031 Insufficient privileges

    I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

    SRDBA5 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