Search results

  1. K

    Creating a checkbox field through a make-table query

    Hello to everyone, I have a colleague who executes a make-table query that reads a txt file. While doind this, he wants to convert two columns (binary format) to checkboxes (Yes/No format). Is there a way to do that? Thanx in advance
  2. K

    Inserting time into a cell through a checkbox

    Hello, I want to create an excel file with daily jobs for some colleagues to check in whether they are done or not. In detail, I want to create 2 checkboxes for Start Time and End Time per row and as soon as they tick the box, the time should be entered into the proper cell and should not be...
  3. K

    Log creation for editing on a table

    Hello, I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action. Any ideas of how I could set this up in Access? I have...
  4. K

    Use of EXCEPT command in Access

    Hello to everybody, Is there a similar command in Access for the EXCEPT command in SQL? I have created two queries. One with the document types that contain all the accounts from the general ledger (Accnt_All) and one that contains the document types for some accounts (Accnt_Some). I want to...
  5. K

    Using Microsoft Access with Oracle data w/o password

    Hello to everybody, I want to access Oracle 8.0 Data (meaning Oracle tables) with Access 2002. My problem is that I do not want to enter the username and password every time I connect to the Access db, as I want to create some queries in Access which I will export to Excel. I do not think that...
  6. K

    Import data from Access to Excel?

    Hi to everybody, I have a problem and I was wondering if someone could help. I have created a grouped query in Access 2002 from some linked tables from Oracle 8.1.7. I want to import its (query's) data into a pivot table in Excel 2002 like the one in the attached picture. The query is grouped...
  7. K

    Office XP ODBC drivers???

    Are there any ODBC drivers for the Office XP? I am asking this because I was using Excel 2000 to import some queries from Access 2000 (from tables linked with Oracle 8.1.7). Everything was going on fine but when we installed Office XP, I cannot import some queries, especially the big ones. And I...
  8. K

    Joining two linked tables in one query

    Hello, This is my first thread in this forum and I hope to find some answers. I am trying to make a query from a linked table (PRODDTA_F0006) and a select query (F0911), but when I am running it, I am getting the following message: ODBC - call failed [Oracle][ODBC][Ora]ORA-01013: user...
Back
Top Bottom