Search results

Hello, I currently have two listboxes on my form and was wondering how to make a horizontal scrollbar appear for each. I would simply make them wider but I need them to stay a certain size to fit on the form. Since the total column widths is longer than the listbox width I assumed the...

I seem to be getting a subscript out of range error now. it's being caused from the "Set ws = wb.Sheets(xlSheetName)" line. I googled the error and tried the suggested resolutions from other forums but cant seem to have any luck.

Also, I tried hardcoding the query into it to see if it worked and it is giving me the error: "The table name you entered doesn't follow access object naming rules".

Do you know how I could pass the queries to from outside reports? For the hosted report I used: Set db = CurrentDb() Set rs = db.OpenRecordset(Me.Report.RecordSource) I have each query used saved in the "Queries" section of the "All Access Objects" schema on the left side of the screen. I...

Hello, I have several reports that I've created that each have a button in them that will export that report to its own excel file and then format it accordingly. Ideally, instead I would like to have one button somewhere that will export all of these reports into a single workbook, but each...

I got the error to go away!! For some reason I need to use the property number values rather than their names. for example, the following line of code works for me: .Worksheets(1).Range("C" & lngRcdCt + 2).HorizontalAlignment = -4108 'xlCenter value 'And...

Thank you for your help and dedication with this but I don't understand; my code is laid out exactly the same as yours but its still giving me the same 1004 error message. Yours runs fine though.

I'm getting an application defined or object defined error message -_-

Hahaha thank you very much for catching that. That solves the issue of opening the spreadsheet but however I am still getting errors with the other bolded lines. The error message reads "Unable to set the Weigh property of the Border class" and "Unable to set the HorizontalAlignment property of...

Private Sub exportButton_Click() On Error GoTo Err_export Dim lastRow As Long Dim strWorkSheetPath As String Set db = CurrentDb() Set rs = db.OpenRecordset(Me.Report.RecordSource) rs.MoveLast lngRcdCt = rs.RecordCount rs.Close Set rs = Nothing Set db = Nothing strWorkSheetPath = "C:\Users\" &...

Hello, I am currently exporting a report to excel and trying to format it with VBA within access. I have come across this problem but no solution is working for me. I came from here: http://www.mrexcel.com/forum/excel-questions/463356-unable-set-weight-property-border-class.html My...

Hello, I have been searching online for a while now and and im coming up dry. I have a button in my report that when clicked, exports that report to excel and opens the file. Here is the code for the button: Dim strWorkSheetPath As String strWorkSheetPath = "C:\Users\" & GetUserName()...

Thank you for your response. I will start doing further googling with those options. Would you be able to elaborate more about Access Runtime? The main function of my database is for people to create and submit change requests regarding part data. If someone on another machine downloads...

Hi, I have a regular access database that I have been working on for some time now. I was wondering if it would be possible to get it linked up to sharepoint so people can use it without having access installed on their machine. I tried googling this and it seems that the only way to do it is...

Yes, it is a subform. There is a master form which is bound to the Parts table and then there is an embedded subform within that which is bound to the documentation table. The master and child links are initially set at the Part ID. I wanted to try to add more links by hardcoding the document...

On a form I am trying to use bounded subforms for people to fill out documentation info. There are two types of documents that the user will be filling in info for. For both of the types of documents, they will have to fill out the document number, title, and revision. These documents are tied...

They do insist on letters to represent this. currently, i have the values hardcoded into the rev table and then increment the id if it exists. I dont think doing this should be an issue really cause it will be a static table. I just think it would be better if the table didnt have to be...

Hello, I currenlty have a table for all revision letters that get assigned to a given project. In my form, there is a listbox containing all of the projects and the user should have the ability to press a button and add a new revision to it. For example, when a new project is created, it...

thanks for the responses guys, I ended up making a new table and changing the text box to a list box. :D

Hi, I have a memo field called History in my table that I use to store long text in as that record gets changed. Every time it does get changed I create a string with a time stamp and description of the change and use "vbCrLf" to format it to the next line so its displayed nicely in the form...