Search results

Well I just got the code to work. After reading both code examples again I realized I had changed the order of the fields on sharepoint and changed the default view. I still have my custom fields they are just not in the default view and I made sure the order of the fields matched my access...

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

No I appended this and it worked great. Not sure what I was thinking. Thank You for getting me through that. Tina

My next question is about my formulas this now shows as a text field so none of my date formulas will work right?

That worked like a charm. Since I need this in Military time I can just change the format on the end report or can I change it in the query? 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

The duplicates are spread over several fields. The start date and time and the name will be the same but the combination will be different. Example 12/10/2009 15:00 jane doe 12/11/2009 15:00 jane doe those two are fine they are for a different date this would be ok 12/10/2009 13:00 jane...

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

That did the trick. You guys and gals rock. Thanks, Tina

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 tried to click on add to your reputation but it said I had to share the love. Thanks Again, Tina

EEEEUREKA!!! I see it now. WOW! Looks complicated. Thank You so Much

my system must have stripped the query because all I see is the table? I see that it worked by the column in the table. Tina

This one removed the leading 0 on import

Here is an example of the import file. Here is my table I had to convert this to 2003 to make it small enough to upload. My DB is in 2007 .accdb Let me know