Search results

Run-time error '1004' Application-defined or object-defined error I want to copy down the formulas from Row 10 to the last row, and I keep getting this error for the lastrow code.

I am trying to auto-fill tow formulas into two columns to the last row on my report. Every things goes thru smoothly until I get to the LastRow formula. I keep getting an error and I don't understand why. Dim xlApp As Object Dim lRow1 As Long Set xlApp = CreateObject("Excel.Application") With...

Would you happen to know why when I run my export (transferspreadsheet) it is showing the old format of my query name on my excel sheet name. I updated the name on my query from _Ins202 to Ins202, but when I run the export it keeps showing the sheet name as _Ins202 even though the query states...

YES!! This is exactly what I wanted it to do! Thank you so much for your help and patience, truly appreciate it. Have a great day.

Thank, yes sorry about that, I wasn't sure if it was possible or not which is why I just used generic words. I tried the code you provided above but it is counting the line items in order rather than how many instances there are. These are the fields I have below and this is how I want it to...

I do, but there is a chance the other field will have the same detail in the line item, all other fields I have are exactly the same. What if I add an ID (Primary Key)? Would this help me?

Hello, I was wondering if someone would be able to tell me if this is possible or not. I want to build a query with a count function that also includes duplicates. For example: STREET 1 ROAD 1 AVE 1 AVE 2 WAY 1 WAY 2 WAY 3 I am looking to count the duplicates in...

Hi Mark, I tried it, didn't get the error this time, but nothing happens in the file and the text is not formatted to column after it goes through. Would you happen to know why nothing is happening?

Hi everyone, I am having trouble formatting my csv file to text to column. Below is my code and I am getting an error for the Destination:=Range("A1") stating,"sub or function not defined". With xlApp 'delete row 1 and 2 .Rows("1:2").select .Selection.Delete Shift:=xlUp...

Hello kasper5023, I did not. I pretty much asked my team to tell me if they encounter this issue to just follow the steps to correct the problem.

You're not going to believe this, but I just figured it out. All I needed was to add a format. Field: Start Date: Format([Forms]![frmMain]![txtStartDate],"m/d/yyyy") Something so simple that makes a big difference! hahaha Thanks again for your help!

I would but due to PHI, I am unable to upload the database. It seems to be working, reason why is because when I run my Report Form it populates the dates in the header field and I reference the query fields to the textbox in the Report Form. for some reason it does not populate it on the query...

I have been googling a solution for this and have had no luck. I am trying to use a textbox from a form as the value of query field. I have my field as below but my table returns nothings. my field in my query is as below. Field: Start Date: [Forms]![frmMain]![txtStartDate] Thank you.

Hello Everyone, I recently developed a local access database that feeds information to a SharePoint Access database. This is my first ever doing or working with something like this so I an not to sure how exactly to ask or document the issue but I will do my best to provide as much detail as...

After looking over everything and because the columns are formatted as general, the import is not sure what to do with the data. Looks like I will just have to import this manually for now until I can figure out away to format the source file to reflect the correct data type for the import...

My excel file has 29 fields, and the first 12 do not import the data from the excel file but there after the data imports just fine. I do not receive any type of error or error log once the import completes, which is why I don't understand why it is happening in the first place. The field format...

Hello All, I have been stuck on this import and I am not sure what else to look at to correct this issue. I have an excel file (XLSX) with a number of fields, which also match my table in my database. When I run my DoCmd.TransferSpreedsheet it does not import the first few fields of data but...

Hello Everyone my name is Jesus and I am from Phoenix, AZ. I have been working on and learning Access for about 7 years now. There is never a dull moment when it comes to building forms, queries, and writing VBA. I came across this site from doing google searchers for help and this site was...