Search results

Hey guys, I'm using DAO to add a record to my linked table. When I get to the ".AddNew" part, I get the Error 3027/read-only error. Now, the linked table is not read only since it is an excel spreadsheet, but when I view it via Access as a linked table, it is read only(no editable...

The only reason I'm selecting D10:Kwhatever is because everything surrounding those cells is cosmetic to the GUI of the workbook. I'm using this for employees to keep track of their daily work. By taking the info from said cells and putting it into the output sheet, we can then save the output...

Ok, this was so much easier than I made it out to be. Here is my 100% working solution: Option Explicit Public Sub SaveREs() On Error GoTo prcdErr Dim proc As Double, ct As Double, r As Double, q As Double q = 2 r = 10 For ct = 1 To 65536 If shtDE.Range("D" & r) <> "" Then...

Ok, this isn't EXACTLY what I wanted, but if I use the following, it copies the data I need (along with all of the extra blank cells)

I put your code into my workbook and it copied from A10 to K10, which is what my code did as well. I don't see why I couldn't start at D10 and only copy between D10:K65536. If I can get the actual loop in my code to work, then I'd be set. I don't know why, but my code only copied the one row...

Thats doing the same thing the second code I posted does. What is happening is that I am copying all of the row (ex: A1:G11) and I need to start my copy @ cell 10. So the delete in my code was removing cells 1-9, and shifting the data to its appropriate cells. I guess the easiest was to put...

Ok, I got it down to this : Dim SiteCol As Range, Row As Object Set SiteCol = shtDE.Range("D10:K65536") 'Range containing data For Each Row In SiteCol If IsEmpty(Row) Then Exit Sub End If Sheets("DataEntry").Select 'select...

Hey guys, I'm trying to set up a loop to do through a range of cells and copy them to another sheet in my workbook. I need this loop to stop after 2 consecutive blank cells, that way it doesn't go through all 65536 rows of excel. here's what I've got so far. It goes cell by cell, but theres...

Problem solved. I took the code and placed it on the updating of the combo box that was "missing".

Thanks a ton bob!

Here's my situation: I work with database A. I update all of my tables and such daily. Another employee works on database B, and is linked to something in my database and has never made me aware of this relation. Now that I am going to move database A to a new directory, I'm going to ruin...

So in other words, it's not possible, right?

Hey guys, Basically what I need to do is see what databases (if any) are linked to my database. Is there any kind of tool or code that can be used? If I go to Linked Table Manager, that only shows me what I have linked my database to, and not what others have linked to me. Any ideas?:confused:

It's still "Method or data member not found".

Hmm...now it's highlighting the Private Sub cmbDept_Change()part. Any ideas?

Hey all, I'm working with a spreadsheet that contains to combo boxes, one dependant on the other. Everything works, but when I close the spreadsheet, I get the error "method or data member not found", pointing to the dependant comob box. Now, I made sure the name was correct on the combo box...

ajetrumpet, thanks for the links. I'm checking those out now. Pingo, I appreciate the suggestion, but I don't have Access 2007 unfortunatly. I'm using 2000. Thanks to the both of you! :)

Can you post a copy of your db?

Hey guys, I dont know if it is possible, but how would I send an email from Access using a List box as the list or recipients and a combo box as my subject. Take a look at my database here: select a report from the combo box. Now, the list that appears below is my distributionlist. I just...

Thanks for the help! I made a a new query linking emails, reports, and report list together and set the List72 requery back up and it works great. Thanks again for all the help!!!