Recent content by Full_Williams

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