Recent content by mircho

  1. M

    Export to excel and pdf in access 2003.

    Thanks Trevor, using those steps do the trick. However even I changed every single macro my database still does not saves to access 2003 (.mdb). I have attached it so if someone can have a look at it and help. You could use admin and admin1 as user and pass.
  2. M

    Export to excel and pdf in access 2003.

    Hi all, Recently I developed a db program for the needs of my company. However in the end it turned out that not all computers have access 2007 or higher so I needed to convert it to 2003. At that point I realized that I have used macro builder to export with formating the reports which is...
  3. M

    Login Username and Password

    Nope, it returns a mistake in the body of the macro. It shows that it is in Me.Username.
  4. M

    Login Username and Password

    Hi, I am not really familiar how this could happen, but I am currently creating a database, that will have 2 forms to be displayed when the user enters his credentials - administrative or user form from which they will proceed. What I need is a macro that will lead me on a click of a button to...
  5. M

    Copy from one table to another.

    Well, it might look wired but it is normalized. For the purpose of the database this is needed. Anyway I managed to do this, but now I am facing another problem. In the forth column in the second table has to bee assigned specific date. What I mean is that when i filter lets say 50 records, I...
  6. M

    Copy from one table to another.

    Sorry, I could not reach my computer recently. I tried Append Query but it gave me a mistake as a result (I have attached a screen shot). To give some more clarifications: I have 1 table with basic data, and another table with more specified data. I have 3 columns in the first table and more...
  7. M

    Copy from one table to another.

    Hi all, I am facing the following problem: in my program I have several tables and I need to copy the data from one table to another. What I need to do is primary to filter the data from one of the tables (which I have already done using form and query) and what I need is to save those records...
  8. M

    Form help needed?

    Hi, thank you for the answer. I have done the tables, and the form. Now I am facing another issue. My form filters data from one table and displays it to me, but i want to save this specific record to another table. A friend of mine told me to use "Create a Record In" macro action, but there is...
  9. M

    Form help needed?

    Hi, I understood where I am mistaken in the tasks issue. I have done a separate table. Also one additional clarification is that the tasks are one and the same for the department employees, as many tasks as indicated, but each employee should do it separately, so each task will be assigned to...
  10. M

    Form help needed?

    Hi Cronk, thank you for replying me. The tasks are all the same for one department but each employee need to comlete it separately. I have the tables and the relationship already. The tblEmployee has the following fields: Employee Number, Employee Name, Departmernt. TblDepartments has DepName...
  11. M

    Form help needed?

    I have the following issue, I have a table with employee names, departments etc. The case is that each department has different tasks that needs to be fullfilled. I need a form to indicate if the tasks are completed or no. I imagine it like a list of all the employees that appears from initialy...
Top Bottom