Search results

Stop execution of code running and References should be available. The error is caused by missing DAO library.

Hi Rich Thanks very much for your reply Rich. You got me on the right track. The method I was after was the SelHeight. This gives me the number of records selected. Thanks for your help. Much appreciated.

Thanks for your reply ghudson Not quite what I'm after.....i think. I'd like to prevent deletions of multiple records in a continous form. So if the user clicks and hold the mouse button, drags along the record selection bar, multiple records are selected. I would like, using VBA, to be able to...

KHi, Is it possible to get the number of records selected on the record selection bar using VBA? TIA

Hi! I'm sorry for the exceptional late reply here Geoff. After I started this thread I got my computer destroyed by lightning causing electrical shock to my system. It did take some time til I was up and running again since I had to build a new one. Now I'm online again with a new machine. I...

Thanks for your reply and interest Ken I think I'll use a new query for each source, just to be on the safe side. It's also more flexible then. I have to come up with a good naming sceme, so it's easier to see where each query is used. Thanks again.

Thanks for your reply. I've made a multi user db that has a split setup (FE/BE). I'm redoing the db now, due to some structural and table changes. I've always made new queries as a recordsource for new 'items' in Access, even if I have a query that could be used. This of course increases the...

Hi! Can I use the same query at the same time in different forms or in a form and create a recordset in VBA using a query? Thanks in advance!

I'm using a function in Access to automatically send an e-mail report in Excel format as an attachement. I would like to insert the Excel file as an object into the body of the e-mail. You can do this manually, but how can this be done using VBA? I'm using the Outlook object ftom Access. Thanks...

I have a printer connected to the COM port that I need to send control characters to using VBA. What is the easiest way to do so, using VBA, that is - if it's possible? TIA

Glad to see it has helped others. Here's the thread which got me on the track finding the solution. Link:Snapshot format not working Good luck!

Hi Forgot about this thread. I posted this one on three different forums, but forgot to put the answer here. I'm sorry for that. So.....this problem is spesific for the norwegian version (which I use). In the VBE I had to use the Norwegian translation of SnapShot! Not good sinceI then cant run...

Thanks for your help.Perfect!

Hi, Is there some way I can select a record using VBA, as if I clicked on the record selector at the left side of a form? (the record selector is marked black) TIA

I've resolved it. I had not referenced the cells I wanted colored properly. By adding a period in front of the Cells property, it worked as it should. here's the way I referenced the cells Do While Not rst2.EOF For I = 0 To rst2.Fields.Count - 1...

Ok. I've found what's causing this but not how to resolve it. I hope someone can help me out here. The disappearing sheets dissapear when the line Sht.Range(Cells(J, 4), Cells(J, 6)).Interior.ColorIndex = 3 is used. The sheets don't dissapear when I use this...

Hi Anne Thanks for your reply. I haven't tried your augestion using VBA, but I've tried it in the Excel app. It don't show the workbook. Only 'Full Screen' makes the workbook visible. I've just started debugging now, and I found that it affects the Excel application itsself. This because if I...

Hi, I have used a procedure to transfer data to Excel from Access. I'm using the Excel library from Access. This has worked fine ubtil I added a new sheet to the workbook. Everything works as it should. When I close down Excel, (Which is started when the transfer is in progress) I'm asked to...

Thanks for your reply Rich! I haven't made myself clear enough. Sorry about that. The new date is already in the combos list (using a requery as you posted). It isn't displayed in the Combos Control Box. It is blank (unbound combo) I would like to see the date here. TIA

Hi, I'm trying to get an unbound combobox in a form to show what I want. I'm using this combo to change the forms recordsource, so only entries from the selected date shows. This works fine. If I add a new record to the form with the current date, I would like the combo also to be displaying...