Search results

This is for an access 2000 application that I am working to upgrade to V2016. Can you explain why it would be designed this way and yet not available in the database window? I've never seen this approach before.

Try this code instead , it opens a normal dialogue box to let the user select the file. It then passes the entire path and filename to your variable. There are other functions of use but you will use the variable myFilePath = GetOpenFile() modSaveASDialogue Option Compare Database Option...

You could add another column to your table for sequencing. Use a Dmax + 1 type statement to increment on new rows. Your decision to use only two characters at the end will limit your scope; are you certain this is all you will need?

I inherited this and need to understand it. Can someone point me to a reference that explains what is being done here and why this method would be preferable over the normal object designer? I understand this creates a calender object. I don't understand being able to view the form design in...

The answer is here (Check the connection then maybe combine with Cronk's response): https://stackoverflow.com/questions/35222503/check-internet-connection-from-excel-vba Option Explicit #If Win64 Then Public Flg As LongPtr Public Declare PtrSafe Function InternetGetConnectedState _...

Welcome to the forums! Feel free to ask stupid and basic questions for the next 89 days. On day 90 you will be limited to stupid and complex questions only. (Also: the pot luck is mandatory)

I'm finally able to get a DNS report on the site whereas yesterday I could not. The site still has some holes in the structure for DNS and more concerning, the nameservers are not resolving. You may want to look into this a bit deeper with your host and IT Team. I use dnscolos for my reports...

You would have to add the additional field as you build each of the source queries that are used in the Union or make a calculated field with all of them before the union. it would look something like this: Expr1:"my source - " & [field] Then join the three in a union.

Thanks June7, Ridders has had me chasing deep stuff the past two weeks with his Security Challenges that I forgot simple answers.

Creating the table and populating it with data are two different things. A Make table query could make this so simple but if you insist on doing it the long way, I would start by explaining what you thought you were doing in this line: Set TOT_R = tdfNew.OpenRecordset("RSC_Totals"...

I have a form with a subform. The subform is presented in DataSheet view so the user can edit a subset of data based on the selection of the filters employed. I have a field in the header of the subform [txtMyTotal]and a field in the footer of the Main form [txtClassTotal] to keep a total of...

Welcome to the Forums

Please help me understand what you need. 1. Fix the query or 2. Schedule it to run daily. If #2 then 1. Create a Macro that invokes the query, include action to close the database after. 2. Create a scheduled task like the following: "C:\Program Files (x86)\Microsoft...

Windows 10 Pro V.1803 OS Build 17134.112 64-bit OS, x64 bit processor Microsoft Edge 42.17134.1.0 Microsoft EdgeHTML 17.17134 If the browser is the issue, I'll argue with the admin to allow Chrome on my box, this will serve as the "Business use" case as I need access to this forums for my...

To the programmers of this site: The logout timing is annoying as hell. It seems that you have broken the caching. I am seeing double messages, sending double messages in some cases and can't seem to finish a post without drafting it in Notepad before my credentials expire on the site. If...

++Thanks, I'm taking this.

To expand on the response from Ridders: I use these snippets to make life easier when working with Listboxes and retrieving values for use in a query: Use the first one for anything that doesn't require being in quotes, use the second one to return a series of strings. I use it particularly...

M9620 - I have been a [something else] with MS Access as part of my duties until recently where it is my only duty. The as-hoc, or as I call them "quick and dirty", solutions will impress because you can produce usable results almost as quickly as you are asked for them. I suggest you sit...

You can make it difficult but you can't make it impossible to get at the tables.

The message thing happened to me yesterday where is sent the message twice and made me wait. The login credential caching appears to be expiring before I can finish typing in many cases.