Search results

any ideas? - just trying to bump this up as nobody has replied.

Josh, Double check to make sure the bound column of the combo box is set to 2 or whatever column the Resource number is. Rob

try Private Sub Command32_Click() Dim strSQL As String Dim var As String Dim int as integer int = Me.Combobox ' the box that the user uses to select the resource number strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN INTO [Tbl_AttachPatients] FROM [doctoremail] WHERE...

Hi, I'm trying to dynamically get columns of data into a calander-like report. So far I have my data being formatted in the detail of the report - see below. The one hitch is that there are too many columns for one page and I can't get it to move onto the another page. It seems to format as...

Hi Teresa, Were you ever able to figure this out...I know it was a long time ago, but I'm running into the same problem here. "You must save record before requery" Any help is appreciated. Thanks, Full Williams

I'm sending an email from Outlook through MS Access VBA. Does anyone know if there's a way to specify the location of the attachment. Right now it's just poping up in the in the middle of the email text and the people with screen readers are having problems with it. If I can put it at the...

I want to apologize, I'm actually not on location so I'm getting my information from someone else. It's the DBSECURE.mdw not found message not that actual database. The mdw file is in the same folder as the database. Any thoughts on this? Thank you, Full Williams

Yeah the mapped drive letter is the same.

Hi, I just added a new user to access this database. Set up an icon on her desktop. Copied and pasted the Target Path from another users icon into hers and I'm getting a message saying "database not found" 1. I've checked to make sure she has access to the folder where the DB is. 2. I've...

Thanks Peter - that worked!! Appreciate the help. Full Williams

rst0![SchoolComments] is in the if statement 3 times because it's looking for 0, 1 or 2 spaces ("", " ", " ") - just experimenting with different things to try to make this work. The data came from a webform and was submitted with ASP code. Guess I should trim that going forward before the...

sorry I copied the wrong piece of code.... rst0.movefirst Do Until rst0.eof If rst0![SchoolComments] = "" Or rst0![SchoolComments] = " " Or rst0! [SchoolComments] = " " Or rst0![SchoolComments] = " " Then rst0.Edit rst0![SchoolComments] = Null...

Hi, I've searched thru the forums, but haven't found any problem similar to mine. I'm trying to strip a field of spaces...certain fields have one space as the string and the code doesn't seem to recognize these fields. If str = " " the code doesn't recognize it. Here it is: str =...

Trick, The database wizard has an Inventory type you might want to check out. When you open access from Start-->Programs click Access database wizards then choose Inventory. Full Williams

Okay so I've found some code on how to send the email, but I haven't found anything on how the "User" that sends the email from the Access Database can view the email text before it's sent. I suppose I could create a text box and the user could type the text in there then run the CDO code from...

Thanks! So smtp seems like a good option for my situation. Does anyone have any instructions on how to set this functionality up?

Is it possible for the users to view/edit the email for sending using smtp?

Thanks Doc. I'll bring this up with our network guy when he gets back into town. I'll let you know how it goes. Are you in the DC area? My company is in McLean VA. Full Williams

Doc, It's more like #2, but the server log is showing that 2-4 of the emails aren't even being sent from the server and the recipients aren't gettting the emails. The other recipients are recieving the emails OK. Outlook is showing that these emails have been sent. Does that help clarify...

Hi, I have code set up to loop add email address to an Outlook email. I populate the bcc. The users are stating that certain emails (about 2-4 emails)aren't getting sent. Out network guys are saying that they're not showing these emails being sent in their logs. They think it has something...