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

Firstly, I thank you for the sample. I must say that I also prefer Access, but my boss doesn't! If I use Access, everything must work through a form, right? In any case, the idea is to be able to maintain a daily file, that will be used with a new name the next day (for example job051213...

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

Thanx a lot!:)

I created the field on the table and the checkbox on the form but I get the message pointing on the line Private Sub Form_Current(): Compile Error: Method or Data member not found

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

Firstly thanx a lot for the code. Secondly I must look at the code and try to understand what exactly it is doing! I will be in touch ...

Since no one is answering, I begin to think that this can't be done with VBA.

In fact, I want to matchup the first column of the query with the column header of the excel file and the second column of the query with the row header of the excel file. Then to import the value the third column of the query into a specific position in the excel file.

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

Thank you for your answer. As for the timeout property, I had no result but the pass-through query seems to execute faster. Can I use the results of a pass-through query to other queries with the same velocity?

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