Search results

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

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...

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...

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...

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...

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...

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...

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...