Search results

I found 2 examples of code to refresh my attached table link to sharepoint lists. I have a scheduled task open my Access 2010 db and an autoexec macro runs and closes the db. My problem is my tables disconnect from sharepoint 2010 and the update fails. I added the code I found to a module...

I have a scheduled task that runs at 1AM that opens the database and then I have an autoexec file in Access 2010 that automatically imports a txt file and updates all my tables and then closes the database. This works great maybe twice and then my tables lose connection to sharepoint. What...

I have Access 2010 tables linked to Sharepoint 2010 lists and my table becomes disconnected when I run a delete query on the table in Access. I can append the table and Sharepoint stays connected. Can I do an append that deletes the previous contents of the table? Thanks.

query in Access 2010 Between Date() and Date()+1 This worked in 2007 but in 2010 it adds quotes around the 1 and does not work. My dates are date and time so I have not been able to just set date. Thanks, Tina

I have a daily import into Access 2007. I have attached a sampledata.txt file. I could not get the date/time fields to import as date and time. What is the best way to do this. All of the other fields are just numbers or text. Thank You for the help. Tina

I have a table that is appended with new data once a week. There was a problem with that and for several weeks the data was added more than once. Now I have 2, 3 and 4 entries that are exactly the same and I need to delete all but one. Can I export and remove duplicates or append to...

I have a file that is placed on server01 every night at 11 PM Every morning the file has to be moved so that the users can access it. I would like to write a batch file that moves the file to a new locaton so that the users can get to it. I will setup a scheduled task so that I do not have to...

I have a form that you enter start date and time and end date and time I have an input mask that uses this format 11/13/2009 7:00 I want to use a validation rule or code that will not let them save the record if this format is not perfect. No Nulls allowed. People are deleting the date and...

I have a very handy bit of code that I use to enter the login information of the person completing a form. It is in the default value of the field and it enters the AD logon. What I am trying to do now is use the same code to enter the login information of the person who opens the form at a...

I want to take a string 070809 for example and convert it to a date. table name: phonedata field with string is Field3 I have tried so many ways I have forgotten what I tried. I cannot get it right. should I create an update query? Field: Field3 Table: phonedata update...

So much great information here. The problem I have is I have implemented several solutions that I have found on this forum. I still struggle when I find code or figure out code because I cannot figure out.... WHERE DO I PUT THIS!!! does it go in query field does it go in query SQL view...

I have attached two pictures with notes. Please review and tell me what I need to change to make this work. I am so close just not sure if I should add a field or what. Also not sure what makes it put some items on its own row and some items are side by side. Thank You, For any help, Tina

I have a bit of code I have tried to modify to give me what I want but I need help with last little bit. See Attached query I want the RN and A as the rows and I want the departments as the columns. I have a problem with the rows because it only shows me one RN and one A their should be 6...

I have been researching some advanced training. The products tab on this site has some tutorials that look good for Access 2007. Has anyone taken it or other advanced training classes that they would recommend? Thanks, Tina

I need to make a field look different based on a condition. What I have done is I have a default value field that puts a U for updated in a certain field so I import the data from excel then when people add new data my U gets put in the field. I think I need a macro that checks the field...

I was given this code that worked great but I need to tweak it. TRANSFORM First(Format([StartDateTime],"HH:MM")) AS ValFld SELECT YourTable.Name FROM YourTable GROUP BY YourTable.Name PIVOT Format(Int([StartDateTime]),"dd-mm-yy"); row is name column is date and value is starttime I need to...

I have a table with employeeid employeename positionid then I have another table Positionid positionDescription How can I select the emplyee's name and have it file in the description of the position? so I select john doe from the drop down list and it enters the positiondescription...

Hi, I need some clarification about look up fields. is it better to do them at table level or Form level? If you do them at form level what is the advantage of remember the value for later use vs. store that value in this field Thanks, Tina

I have a database for staffing. I have employee table with positions department table positions table schedule table I import the schedule from the time clock and I want to run reports from this. I have emplyeeid positionid departmentid scheduleid all primary keys in their table My...

I need a query that gives me .........date.....date.....date Name name name name This is like a crosstab query but I want a start time to show in the cross section of the table like this ............date.........date.........date Name...7:00 AM.....8:30 AM....7:00 AM name...8:00...