Search results

Yes it is bound. Like I said, it will allow for entry of the first record, but if I try to enter any further record, it just sits there. Below is my code for the Button_Click() event, which is wheere I think the issue is. '------------------------------------------------------------ '...

I have a form that is for inputting new data into a table. It works great, except when you go to enter in any new records after the initial record. I have a button for updating, and after the button is hit, it clears the form for the newxt entry. If I put in new info, and fill out every text...

Man its the little things. I forgot to make the report unbound. When it "OutputTo" it was still using the query I had as its control source. Once I removed the Query and made the report Unbound, it worked.

RESOLVED!!!!! Text Box Value not printing on Report I have a txtBox (txtAcct#) on a form that once entrered on the form I can use to populate another txtBox(Acct#) on a report. It works great using the unbound txtBox Control Source =[Forms]![CblCardDispoTool]![txtAcct]. I can open the report...

RESOLVED!!!!!! Combo Box visible I have a form with 9 combo boxes of different data. They are all 9 invisible. Depending on which selection is made in a different combo box, then the corresponding 1 of the 9 combo boxes becomes visible with that list of choices. The problem is when I make a...

That was it...Making it a text only field resulted in: Greg_Batchelor@xxx.xxxx.xxx#mailto:Greg_Batchelor@ xxx.xxxx.xx# in the cell. So I just went in and made the Address text and deleted the excess info THANK YOU.

RESOLVED !!!!! Email individuals Info I have a quick question. I am using the following code to send the contents of a record set row to email addresses in the contents of a different row. Set rstAM = New ADODB.Recordset rstAM.CursorLocation = adUseClient rstAM.Open "Select * From...

Sorry I did not catch it sooner, but I just saw why your original code did not work. Dim strFilePath as string strFilePath replace(NOW," ","") strFilePath replace(strFilePath,":","") strFilePath replace(strFilePath,"/","") strfilepath = "c:\"My_Report_Name_" & strfilepath & ".xls"...

Nope, Sorry did not work. All it does is sit there. I use an OnClick event and it does nothing.

RESOLVED -- Access 2007 Qry to Excel 2007 I know this has probably been asked and answered multiple times before, I have spent the better part of the day trying to find an answer to this, even searching on here. I have a query that I want to export as raw data. I have an email aspect that...

One final thing, Is there a way to Bold Face the fonts of the items so they stand out from the actual #'s?

Thanks, it worked with one little tweak. I moved the purple section from where you had it in the string creation down to the Body creation. This was the subject line, and did not need to be created more than one time. THANK YOU... This saved me alot of wasted coding. strMailBody =...

I did not exactly embed the table, as I said I embedded data from the table. Private Sub Command45_Click() Dim strMsg As String strMsg = "Are you sure you want to send email?" If MsgBox(strMsg, vbYesNo) = vbYes Then Set rstAM = New ADODB.Recordset...

I wanted to know if it is possible to embed a pivot table (from a query) in the body of an email. I know how to use VBA to embed data from a table in the body, but not sure how to incorporate an entire pivot table, or if it can be done.

Moved to Forms::::::Email using Access I wanted to know if it is possible to embed a pivot table (from a query) in the body of an email. I know how to use VBA to embed data from a table in the body, but not sure how to incorporate an entire pivot table, or if it can be done.

Thank you both. It works like a Gem, as it was intended. Ill be back at some point, as they are constantly requesting new stuff. Thanks

Yeah I must have deleted the cmbSupervisor box when I was copied over my DB and deleted info. My bad. Also, one last thing. Is there a way to make the cboSupervisor disappear and reappear upon selection in any of the fields? Right now, If I select Supervisor in field 2, and go on to field 3...

Thanks CBrighton. I see it works great now, what had to be changed?

The report is opening in acDesign so that it can create the report on the fly based on the fields chosen in the form. It only does this in the background and never actually shows the report in design view. I have attached a 2003 copy.

Thanks cBrighton, that gives me more information about how it should work. I tried it and still I am getting the entire report. It will not filter on Supervisor. I have attached a copy of my DB for review