Alby22
Last Activity: Aug 1 '12, 08:37 PM
Joined: Jun 11 '12
Location:
-
Alby22 replied to Order records so most recent entry to table appears first in linked form Access 2003in AccessYeah the database is a mess and it is obvious whoever made it didn't really know what they were doing. Is there a way that I can just convert the text into a date/time in the order by statement? I don't wanna change much because some how it works and I'm afraid if i start changing things its going to bring on more troubles that frankly I don't have the time to deal with. -
Alby22 replied to Order records so most recent entry to table appears first in linked form Access 2003in AccessYou are right it was a text field I should have checked that but I assumed it was set as a date. Now the problem is that to change it to a date it says that I have to delete the relationship it has with another table then change it and re-establish the relationship. Will changing it to a date have any major effects that you could predict on the data base. There are many other queries that use that filed through queries.Leave a comment:
-
Alby22 started a topic Order records so most recent entry to table appears first in linked form Access 2003in AccessOrder records so most recent entry to table appears first in linked form Access 2003
I have a linked table between two databases(A & B). The data is entered by multiple users in to A once all the data is entered I review the data in B and then append that data to my main table in B. I'm essentially using the linked table as a buffer so if there are any entry mistakes they don't go directly into the main table. After the data is appended I would like to view it in the form that is linked to my main table, the problem is when I... -
There is no "master time card" the master workbook is just a summary or a report of all the time cards. The purpose of the question is how to create a master workbook that will just directly import all of that data in an organized fashion. So there is currently not a master workbook created otherwise i wouldn't have asked the question. The reason there is no data in the drop down boxes is for that fact that I'm not going to put employee...Leave a comment:
-
Import Data From Multiple Excel Workbooks to One Master Workbook
I have a time card form set up in excel and each employee will have their own excel workbook for their time card. At the end of the day I need to import the data from each time card into the master workbook. I would like it to output the data in rows and columns in a different format that the time card entry. Attached is the time card form to get a better understanding.I have cleared out all the data in the lists below the form. When finished I will... -
I decided to go a different route and link two tables between the databases and then run an append query to pull the data form the linked table. Thanks for the input though!Leave a comment:
-
I tried the second solution and I received an "invalid bracketing" error on the IN statement.I figured i would try that first since I already had the code for it. I'm using Access 2003 so I don't know if that changes anything. I will go ahead to try the first solution as well and then let you know how that goes. Also, does anyone happen to know why the Access generated code doesn't work? Seems strange the the code generated by the program...Leave a comment:
-
Not a Valid Password problem Access
I am doing an append query that takes data from a table(TIMESHEET )from data base "A" and appending that data to the same table in database B. Database B has a password and when I try to run the Query I get the not a valid password message box. Below is what access gave me when I ran the Query Wizard. I found other similar questions online but none of the solutions for those worked.
For reference "bmi test.mdb" would be...
No activity results to display
Leave a comment: