Search results for query: *

Hi All. I'm working in excel 2003 and want it to work a little like Access. What I have is two worksheets, the first is similar to a form, displaying a single record. The second worksheet is the table with many records (each with a unique number for reference). What I after is a method of...

Thanks Don't think the group header option will work with what I'm doing. I Know you can open the report up in design mode with code. So can you then adjust the page header height from code once its been opened in design view? Thanks again Mick

Hi Everyone. I'm having a little problem trying to set the height of the page header of a report. I'm using textboxs with cangrow on in the report header with no problem then I'm repeating some of the same boxes in the page header (for the 2nd page). I've found out you can't adjust the header...

Hi all. Im just stating with Visual basic 2008, downloaded the express edition off net. Done a bit of VBA in access before but new to VB2008. My problem: I've created a from (form1) and added some buttons and a text box. No code just wanted to get it looking something like first. Did a...

Hi Kinda sorted it, I set focus to the txtbox then copied text and then opened mspaint. Thanks

Hi All I've got a form with a textbox with unbound text. I want to create a small jpeg file of the text in the textbox. Text will vary in length. Any ideas Thanks Mick

thanks anyway mick

Hello all In Excel is there any way of printing several rows at the bottom of a page. I know it can be done at the top using page setup, but I want to repeat at the bottom as well. Thanks Mick

Thanks for all your help I've now sorted the problem. It was the rsmyrs("to") was incorrect, the query I was basing it on was "send to". Thanks again. Mick

Started again with a new sub, adding bits at a time and it crashes when I add the If then else into the do until. thanks for your help mick

None It's just a message box

Query is there. Has two record when run Thanks

Gone back to Item not in this collection :o( Are there any other settings I could check against the converted acc97 database. It works in that one? Thanks

...rsmyRS("BCC") = True Then sendBCC = sendBCC & rsmyRS("email address") & ";" Else End If rsmyRS.MoveNext Loop DoCmd.SendObject acReport, "RPT 8D", "SnapshotFormat_(*.snp)", sendTO, sendCC, sendBCC, "subject", "message text", False, "" rsmyRS.Close Once again...

Hi No it wasn't, added it but still no luck, I've turned if on and the error i'm getting now is "Item not in collection" changed start of code to. Dim rsmyRS As DAO.Recordset Set dbmydb = CurrentDb Set rsmyRS = dbmydb.OpenRecordset("QRY Email select") Do I need to start my pc? thanks again

Hello all I'm creating a recordset in access2000 and I'm having a problem starting it. The code I'm using is Dim dbmydb As Database Dim rsmyRS As Recordset Set dbmydb = CurrentDb Set rsmyRS = dbmydb.OpenRecordset("QRY Email select") I tried to sort the problem by writing the code in access97...

still no luck. the total value updates only after I've left the percentage control. What do you think about doing a record set? summing up the percentage and then checking that value??? Thanks again

Thanks I've requryed the totals box, with no sucesses. ??????

Hi all I've got a continuous form in which i am recording percentage values. In the form footer I've got a textbox calulating the total percentage using =Sum([Percentage]) in the control source. when I update the percentage values I requery the total percentage, no problem. What I...

Thanks It was flat. I changed it to a combo box in the end as the box was only looking up a single record. The drop down box bit on the side doesn't show when printed.