Search results

Thanks MarKK for your post. When asking for help should I only post on one form? I see you have 256 Posts. Do they all start with: "Cross posted:"

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...

Thanks NauticalGent - Gives me a good place to start looking

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?

dates are not working

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...

Can we start by looking at this one 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 query/Report to take...

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...

These two formulas work, I just want to automate them so the dates change when each day changes Project Amount: [Fees_Collected]+(([Fees_Collected]/8)*22) Project Amount_NB: [REFERRED]+(([REFERRED]/8)*22)

Thanks fvdb, but this dosent help me. How would I put this into a formula?

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...

My apologies. I’m working with Ms Access 2013 VBA

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