Search results

Hi, Can one of you pros take a look at this code and help get the bugs out? Compile error: Invalid outside procedure / syntax error Compile error: Sub or Function not defined Visual Basic for Applications Microsoft Access 16.0 Object Library OLE Automation Microsoft Office 16.0 Object...

Is there a simple way I can create a click on and have it open a folder browser that lets me go to the folder and select the file? That sounds simple, how would I create a macro or VBA that opens a browser?

I've been have problems with my database date after the new year. Could someone please look at my date fields below and tell me what I'm doing wrong Monday Date()-((((Weekday(Date()+2))+3))) Tuesday Date()-((Weekday(Date(),2))+5) Wednesday Date()-(Weekday(Date(),2)+4) Thursday...

I’m trying to make the follow syntax into a sub query. I really new with making subqueries could someone please take a look at the bottom and help me with this? Basically I'm trying to make a subquery from this COLLTRANS@.PAYMENTAMOUNT COLLTRANS2@.PAYMENTDATE COLLACCT@.RECNUM My select...

I’m looking for some help with my sql. • What I’m trying to do is ‘his • Take the Date of Service • Group all matching Master Account Number Have sql look at the group of Master Account = Then find the lowest Date of Service in at Master Account group. So the outcome would look like this. I...

Hello, I'm trying to create a report based on a query I'm looking for a formula that will take my Report date field and sort it by year (Oldest to Newest) I would also like to put this date in a Colum header for each row year (Oldest to Newest) I would like to continue breaking down the...

I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access. Thanks

Hello, I have a report titled “Monthly ABC Report” I use the following code to send out the email. How do I attached the “Monthly ABC Report” to my code below so that it will attach when I send out this email and change it to a PDF? Option Compare Database Sub...

Hi. I'm trying to find a formula that I can use to calculate the number of days left in the month and also the number of days current to past days in the month. I've seen some examples of this when searching on line but I don’t know how I would add them to my current formula that I have to...

Hello, I'm trying the to calculate the projected amount. I'm needing help putting this formula together using 2013 MS Access for starters I need to be able to Calculate the number of days to date in a month Calculate the number of days left in the month. I tried putting together some...

I've been researching how to add a paragraph under the first line. objItem.Subject = "Placements and Assessments Reports " objItem.Body = "I have attached this weekes Placements and Assessments Report. TCB Company P:555-555-5555 F:444-444-4444

Good day, I would hoping that I could get some help with this question: I'm working two dates that will highlight the accounts that have made a payment Today (Last Payment) + 60 days & move the entire row to another tab Payment Made: iff ([Date of Last Pay])>60 days from ([Dis Date) highlight...

Can someone please help me? I need to convert a numbers column in an access table to a text format

I have a list of 30 files I need to import into my access database. The files in the folder are named 1. Txt 2. Txt 3. Txt 4. Txt 5. Txt 6. Txt 7. Txt 8. Txt When I did the first import I did it by doing an import text file, located the file 1.txt. The Import Text Wizard opened and I picked...

Hello All, I have a query that does a great job at fining duplicate master records I'm hoping someone can help me add to this query so that it fining duplicate master records like the query show and add one more record that will link up as shown in the example. If you need any more...

For the past year I’ve been saving some really great VBA scrips that people have helped me put together. Now that I’ve saved all these wonderful VBA scrips in folders as .txt files I’m wondering if someone has been able to put together a macro that can be called from either a excel, access...

How do I view all my Post from this site?

HI, I’m working with MS Access 2013. I’m looking for the Macro that allows me to export a query to a .csv file. Did they remove this from 2013 or is it called something else? Thanks

I’ve been looking for a Macro I can run execute off a form that will open my Windows search box that shows folders and my network connections on the left hand side that will let me import either a Excel file or a .csv If there isn’t one could it be done in VBA? Thanks for your time and help

Hi, I’m running access 2013 and from what I read with this version of access we’re no longer able to create pivot tables or charts. Does anyone have any work around or examples that I would be able to create some time or work around? Thank you