Search results

Haha yeah but the second guy never got a reply so thought I might help another searcher!

Hi, you are correct because you have no way to get to the proper part fo the code! Try this instead: Private Sub previousButton_Click() ' I take the easy way out for error code On Error Resume Next ' Use the recordset currently available (I have a filtered query and it only loops through...

Thank you so much, I was having a really bad day thinking wise and just couldn't get past that simple concept. I appreciate your help!

This is so simple I am actually embarrased to ask, but here goes. I have a simple relational database with the proper linking tables, etc. I am normalized through BCNF. I have a table that will track tasking details, however, more than one person is assigned the tasking. How do i add to my...

I was unable to test this feature. Our SharePoint no longer has MS Access Services enabled. Hopefully, one day, this will eb re-enabled and I can test it then. Thanks all that took the time to review this. Hopefully future searches will find this helpful.

It seems there is a CurrentWebUser() method that can be used in conjunction with SharePoint Foundation 2010. I will test it out when I can and hopefully it will work! When I can I will let everyone know my findings.

Hello everyone. I am using Access 2010 on a Windows 7 computer. I have an extremly simple web databse I am trying to create for our SharePoint site to seperate, track and store comments for a particular project. I know SharePoint features, but like I said, it is for a particular project, so...

I tried that too. I am at a loss. I appreciate your insight, hopefully I can figure it out. If I ever do, I will post it here. Thank you!

It isn't just the data that is...it is also the labels and code unfortunately. Basically, anything useful! The fields typically have less than 300 characters but sometimes go well above. This is also actually a sharepoint list. A multiple Lines Of Text field. Additionally, I should mention...

I wish I could, unfortuantely it gets into proprietary information. Have you heard of anything like this before? All fields but these two save and they come from the same table with the only macros/vba being the buttons and load/unload events. None of which has anything to do with any field in...

I have a table with lots of different fields and field types. The two memo fields will not save. I have tried Runcommand and if me.dirty. Neither seems to work. All fields are from one table and I have tried deleting the fields and repopulating them onto the form to help reset defaults. The...

Hi everyone! I am new to the Access Web environment and was wondering if there was a way to have the database open on the desktop from a macro in the web version. Here is the scenario: A user has certain functions that can be accomplished. Fairly routine tasks that may or may not be used...

Hopefully it won't change and things go well. My prayers will always be offered, I know I appreciated them while on active duty. I am using the text box to verify my code. this is one part for what the total usage will be. I am creating a random record generator that will generate first, a...

My best wishes to your son-in-law! Do you know where he will be deploying to? I will pray for a safe return. You are correct. I simply missed my incrememnt. I needed to initialize and use from the same point. I intentially skipped the '0' element on the first For Loop, but forgot to on the second.

So I take it I simply mistyped and need to ignore my first ( '0' ) array element and display 1 to dateCount rather than 0 to datecount, correct? And that seems to have done the trick... I knew it was something simple, much appreciated!

By the way, this was the input: Date From: 4/1/13 to 4/30/13 9 days to randomize It correctly gives 9 random days, but adds that time at the begining...

Hello everyone and thank you for taking the time to view this posting. I am using Access 2010 and have created a randomizer for dates that store in an array and then display those dates in a text box. It works great except that when it displays the results a time is shown then the correct...

Don't forget to close the parenthesis! DLookup("[Password]", "tbl_SystemUsers", "[UserID]='" & UserName.Value & "'")

Is there a way to make it auto send given a specific time each day?

Thank you nanscombe. That was a well recieved answer. I simply needed a number to do the math off of later. Dim lngCount As Long lngCount = DCount("lastName", "specialistLookupQuery") DoEvents MsgBox "Records returned: " & lngCount The above code was actually all...