Search results

I am using acFormatPDF to convert a report to a pdf. I have both Adobe and CutePDF installed on my computer. Is there a way I can select which one generates the PDF? I ask because Adobe is not writing my label to the PDF but cute is, so I would need to use cute.

I am importing two spreadsheets into access for comparison. I am using this to import the spreadsheets as I do not know how many columns the workbook will have. DoCmd.TransferSpreadsheet Sometimes the workbook will have 20 columns of data, while others it has 8. The only thing that is...

Is there a way to link a google sheet into Access (similar to how you would link a Sharepoint table or ms sql table) and I can use that as the datasource of an access form?

I am taking over a project that someone else created and I want to understand what the code is doing. This line of code, is it simply finding the last column with data? Dim dColumn As Long dColumn= Excel.Cells(1, Excel.Columns.Count).End(Excel.xlToLeft).Column

I am curious about the best way to handle this. I am using access vba to open an excel workbook delete a few rows, then delete a few columns, then add some data. so it's like a step process, each step is dependent upon the first being completed. For example, I need this Rows("1:2").Select...

I have scenario where on my Excel Worksheet I have IP Addresses so something like 192.168.5.110 169.222.2.210 300.111.43.810 etc etc. What I need is access vba that will assign a alphabetical value to each one and write that value down each cell. (Yes there will be duplicates in the IP...

I have 3 fields in the Data section of my report. Is it possible to place "borders" around those three fields so the data will appear like this? (I want a solid line not dotted, but just for example sake) -------------------------------------------------------------------- | bbt12183. |...

I have a report that shows sales by sales person. How can I set it so that each sales persons data shows on a new page?

I have linked SharePoint tables into an access database, and for some reason now anytime I want to access the linked SharePoint table it asks for username and password. Which equates to DomainName\username and password is domain password Is there a way to pass this information in VBA instead...

I have a form with a sub form on it. This sub form shows dates, I want to change the row color to red of any date that is >= 60 days from today and change the rows to yellow for any date that is between >=59 days and >= 30 days from today I assume I’d use the form_load event but what would be...

In working on some VBA code I have become curious as to how Outlook resolves an email address For example, internal contacts within my company show as LastName, FirstName But what is throwing me is that I have yet to see a consistency with external emails. These emails are not saved in my...

I have a short text field that I am parsing out the month from. I then want to use it as part of my where clause I have this syntax but am getting data type mismatch...but am a i not converting it to date format so the DateDiff function should work? Select * from teamroster where...

I am linking in multiple tables from SharePoint into an access database, I have no control or access to the back-end SharePoint tables. My issue is that in SharePoint there is a field that is a memo? Or super long text, and append value is set to true, so that you see historical data "stacked"...

Hi - I found a post from @June7 assisting another member here and my issue is quite similar, so hopefully not much mofidication is in order. I am in need of creating an email draft for each row in my recordset. So if the recordset returns 3 then I need 3 drafts created. This is the code I...

I need to query my access table to determine which review each employee needs completed. We have 6 fields Empreview1start Empreview1finish Empreview2start Empreview2finish Empreview3start Empreview3finish What I am after is a query that will show this: If empreview1start is not null and...

I am working on a function that will scan a string to see if it has a comma. If I use Function CommaCheck() If InStr(“Bob, Frank, James”, “,”) = 0 Then Debug.Print “No comma” Else Debug.Print “At least one comes” End If End Function This properly identifies the comma - however I’m...

Is my best plan of attack here using If .... then....else....end if I have a combobox with 40 possible options in it. Based off the selection in the combo box I need to open a file browser to a specific folder. What seems most logical to me is to do 'Declared Public in diff module Public...

I have a database with roughly 100 tables in it, now 75ish are linked SharePoint tables, and the other 25 are local access tables. Can I edit my VBA to ONLY scan the local tables and ignore any other tables? This is my current syntax but it is slow... Dim tblNamesArray As Variant...

I have a List Box on a user form that is multi-select. With a little assistance I have code that will iterate the list box and show me what has been selected from the list box. The last step of my journey is to now have the selected items from the list box on a user form, display in a text box...

Hi - I have a form, with a multi-select list box, I am using this code to populate the list box Private Sub Combo2_AfterUpdate() Dim strSql As String strSql = "SELECT ID, txtName, [CVN] & ' - ' & [SNV] AS FullInfo FROM AllData WHERE txtName = """ & [Forms]![Form1]![Combo2] & """ ORDER BY...