Run time error-1004 (error in line 40) as activesheets.
run-time error '-2147024809 (80070057)' (error in line 19) as sheet1....
run time error 438 (error in line 19) as sheet1(sheet1)
User Profile
Collapse
-
...Code:Sub Scrape_sheet1_btn_Click() Dim LResponse, I As Integer Dim a, b As String LResponse = MsgBox("You must list the URLs you are planning to scrape in sheet1 and create a blank sheet2. Once the scrape macro starts, each column is represented by individual URLs from sheet1." & Chr(13) & Chr(13) & "Do you wish to continue?", vbYesNo, "Continue") If LResponse = vbYes ThenLeave a comment:
-
Not working. I would get the run-time error '-2147024809 (80070057)';
"The destination range is not on the same worksheet that query table is being created on."
What I'm trying to accomplish is as it scrapes craigslists URL 1st page, it pastes it in a worksheet then moves to creating a new sheet for the new scraped data.
Thank you.
-AlLeave a comment:
-
Run time error-1004 on query tables.add connections - need help.
...Code:Sub macro1() 'Dim frm As UserForm Dim I As Integer 'To could be as many as you want. I only put 25 as a limit. For I = 1 To 25 Dim a As String a = Sheet1.Cells(I, 1).Value Dim b As String b = ActiveSheet.Cells(I, 2).Value 'get URLs 'option after "URL;" & a 'UserForm1.txtbox1.value With ActiveWorkbook.ActiveSheet.QueryTables.Add(Connection:="URL;" -
Thanks. The code is not working for me though. I'm not linking to SQL Server just to the backend access data.
Any suggestions?
Thanks.
-AFLeave a comment:
-
Thank you jforbes. Do I need that pwd=secret statement? I dont use password on my db.
Once again, thank you.
AFLeave a comment:
-
VBA to auto Refresh Linked Table Manager or linked tables
Hello Everyone,
I was wondering if anyone knows of a way to add a code that would automatically refresh link tables upon opening of database. This is needed due to fact that sometimes split forms wouldn't open due to a lagg and would freak out the user with the error.
The fix was to refresh linked tables manually.
THanks./
-AF -
VBA issue run time error 3061
Hello,
I need some help troubleshooting the code below. I'm getting a run-time error code 3061, "too few parameters, expected 1". I've searched online (google) but haven't found anything that could help me. Thank you.The code works when the referenced query doesn't have a criteria. I'm usingCode:Set rst1 = db.OpenRecordset("qry_selected_email_distinct", dbOpenDynaset)criteria on the...Code:[TempVars]![username]
-
Outlook is stripping the file. The receiver of the file wouldn't know how to open it though or will it open in the same way?Leave a comment:
-
Need a work-around for sending .zip attachment in Access 2010.
Hello,
Does anyone have a work-around into sending emails with .zip attachment? The code below doesn't seem to work and I need to attach .zip files.
Thanks.
Code:objMail.Attachments.Add "c:\location.zip"
-
I would prefer to click a button and upload a .oft template but a static location in the share drive is fine.
Thanks a lot for the help.Leave a comment:
-
Need VBA coding for sending msgs using .OFT as body
Hello evryone,
Happy Friday! I'm looking for a way to send mass emails using outlook email template (.oft) as body of the email since using information from the text box ruins the formatting.
Below is the code I'm working on.
Thank you.
...Code:Private Sub btn_send_Click() Dim olApp As Object Dim objMail As Object Dim Issue As String strIssue = Me.txt_body -
aflores41 replied to Need advice on how to solve user log-in to open tables that's filtered by usernamein AccessNevermind. I used tempvars and it works!
...Code:Function Log_in() On Error GoTo Log_in_Err With CodeContextObject If (Not IsNull(.cmb_user)) Then TempVars.Add "UserName", .cmb_user DoCmd.Close , "" DoCmd.OpenForm "frm_tools", acNormal, "", "", , acNormal End If End WithLeave a comment:
-
aflores41 replied to Need advice on how to solve user log-in to open tables that's filtered by usernamein AccessWell not use the windows log-in information. I want to use the log-in information from table which is a selection in a combo box.
For example, user logs in selecting username: A123. He then enters password as: pass. Then as he logs in, a table opens filtered to only show data for A123 username.
I'm trying to research global variable and it looks like it's gonna work. I just don't know how to declare or use the tl_users table...Leave a comment:
-
aflores41 replied to Need advice on how to solve user log-in to open tables that's filtered by usernamein AccessThank you. I had a feeling access doesn't have very good security so I was thinking of just adding dummy passwords. The goal is really to use that user name into filtering the tables opened so that I don't have to make a multiple queries per user. Could you provide examples?
Thanks.Leave a comment:
-
aflores41 started a topic Need advice on how to solve user log-in to open tables that's filtered by usernamein AccessNeed advice on how to solve user log-in to open tables that's filtered by username
Hello,
I need some advice/help into solving an issue I have with user log-in. Currently, I have a working log-on screen with password that's linked to a table. Once password is entered correctly, the form opens with a text box naming the username.
Here are my issues:- The issue is, once the main form closes, the link between the two gets severed and I get an error (username is not populated in the textbox anymore. Here's
-
Thanks it works! I'm just being lazy at changing it one by one. I a lot of databases to build and this saves me time.
The code below doesn't work though, could you assist?
I get a run-time error 2136:Code:Forms(frm).PopUp = True
to set this property, open the form or report in design view.Leave a comment:
-
Is there a way to permanently change access form properties using VBA?
Tried the following code but it doesn't work. I was also hoping in adding this to the module so I can just call it in each forms using the me and not using form name.
Code:Private Sub Form_Load() Me.RecordSelectors = False Me.NavigationButtons = False Me.ScrollBars = 0 [Forms]![frm_Import].DefaultView = 5 [Forms]![frm_Import].PopUp = True [Forms]![frm_Import].SplitFormOrientation = 1 End Sub
-
Thanks Twinn. However, the query sends out mass email by grouping data into based on grouped field so there'll be many saved files in the folder if we do it this way. I guess the question is how do I automatically attach the saved file to the correct email if we do it this way.
Thanks.Leave a comment:
-
Twinn,
Could you help me modify the query above into instead of sending the transactions as part of the body of the email into sending it as excel attachment?
Same rules apply as to grouping the email by a field i.e. Name.
Let me know if you have any questions.
Thanks Twinn!Leave a comment:
No activity results to display
Show More
Leave a comment: