Search results

I see. How would I read the ASCII code so that if the IP address changes increment form A - B - C - D etc

I need access as we are using an access form for the user to select the workbook then using access vba to control excel to format the workbook in the way that we need.

Not that I know of. Doing it via acmess as we are using a form to allow the user to select the workbook then the data manipulation is done behind the scenes and will save the workbook in the format that they need it in.

possibly. I know if I was going to do it straight in Excel - I would copy the list to a new worksheet, remove duplicates, then assign a alphabetical letter to each unique. Then I'd do a VLookup() and pull over the assigned alphabetical letter. I was thinking maybe read the column into an...

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 googled gridlines, and the first hit I got was your site. Way to go, and thanks again!

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

oooo it was before section. Thank you so much!

Looking at the Force New Page, my options are: None Before Section After Section Before & After

I have the group in place. How do I set the "Force New Page" ?

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 am refreshing the tables via a button click on the form, so a user does not have direct access to the "standard" database view. I was hoping in a perfect world, situation 1) Access VBA could grab the error code saying we need credentials (or based off amount of time it's taking to get data)...

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

That was so close! When I used your code, I kept getting the 2nd and not the first. Example: Debug.Print DateSerial(Year(Date), Month(Date), 1) - 60 Debug.Print DateSerial(Year(#07/14/2019#), Month(#07/14/2019#), 1) - 60 Returns 5/2/2019 Which got the wheels turning and I used...

I think I’ve done a poor job of explanation What my issue is, is that we are using Date() which is based off the current Fate. I need the calculation to be based off the first day of the month For example, the current day of the current month is no matter to the calculation. I want to show...

All right! I’m very close now!! Can someone help me with the condition for the 30 days past due? The Source date displayed that we are checking against will always be the 1st of the month For > 60 day accounts I am using Expression is [SourceDate] <Date()-60 If I use Expression is...

I have tested on ONLY my SourceDate field and have added in the criteria Red: Value < Date()-60 Yellow: Value Between Date()-30 AND Date()-59 The only issue I have remaining is that it ONLY will backfill the SourceDate column, I want ALL textboxes on the form to have the back-color changed when...

Hah - so it's the same steps as for Excel! HOOZAH!!! I have a New Formatting Rule Rule Type: Check values in the current record or use an expression Format only cells where the: Expression Is: [SourceDate] >= Date(Now()+60) Change Back Color To Red This gives me an error of: The expression...

I don’t believe the sub form is set to co tinuous view. Conditional formatting - how would I do that? Could I set the on load event of the sub form (which is a form itself) and when the sub form loads in the parent form the colored rows will remain?

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