Search results

Yeah, I absolutely agree, Doc. Navy operations are a matter of national security, a good candidate for the extreme of the line. You don't want to use software nobody will be responsible for in such a case. There are so many other companies across the globe that can't afford to have such a high...

I accept your opinion and those of the others, George. But all I see is disqualification from you both. With what purpose?

Firebase may not be SQL-based, but it can still be used as an alternative to syncing data with MS Access. While it may require some changes to an existing app (and that's the idea, in exchange for worldwide access), that doesn't mean it's not possible to use or hard to do. The methodology for...

Open the table in design mode and change the data type to the appropriate type, double for your case or currency if you will need precise calculations

George, what do you hope to achieve with this? I don't understand. I came to recommend my alternative, I talked about its benefits, I posted a sample and even a tutorial.

@GPGeorge Do not add words I didn't say. Look at the context of the thread, the point is that we can never be 100% sure as long as we're using someone else stuff. It's pretty clear from post #14. The point is that not all apps show you an agreement, in order to put your app there, you need to...

Are you sure the value is comitted before you attempt to access it?

How do you make sure that, if you sign up to a service via email, they're not using Firebase as well? Firebase provides email and phone authentication as well. You can agree to any terms of service, all privacy and security you want, including contracts and that won't stop an employee of the...

@amorosik No, I still haven't found a way to tickle access' ribs and make it jump from outside of a form. You can set up a server that notifies you of that, but Access will be blind to it without a periodic query, the server can notify you though, easily. But it's a separate thing. I have seen...

@Pat Hartman If you use a mobile phone, regardless of the brand, a ton of its apps are using Firebase. In fact, if you've ever signed up to anything that lets you sign up with a Google/Apple/Facebook/Twitter/Github account, that's most likely Firebase. So, that's a LOT of companies relinquishing...

@Snowflake68 I recommend Firebase. You can setup a project here: https://console.firebase.google.com/u/0/ It costs zero money, it's by google, therefore you use your google account, and it's managed by their staff so it never goes down, you also don't need to pay hosting, it's blazing fast, it...

That's gotta be the problem, when the option loses focus it hides the combobox or something like that. Target the value change, not the focus. Check this out: "When you select or clear an option button that's bound to a Yes/No field, Microsoft Access displays the value in the underlying table...

Check the attached database, it's a very simple approach that should give you a north. How does your options code look? Maybe you are using the wrong events.

The last suggestion involves extracting the content of the file to show it in a user form. The vba code would simply declare the document, initialize it, opening it, traversing the document to extract its content and fill some text control and finally closing the document. What I meant by "if...

Then the user will simply use it to preview what document to open so he/she edits it from within Word itself, Access is just the preview tool? If so, have you tested what arnelgp does here...

I haven't read the entire thread. Why do you not want to open the document from Access and make your edits in Word? What advantage is Access expected to give you if you do it from Access? What is the typical user going to do if you manage to sync the two apps?

Oh, that is more interesting. You have to account for the way your data is input. There are many things you should take into account here, such as: How are the week days considered data wise? numbers or strings? How about months? Are you going to always type month-year? like this? FEB-2023, or...

Are you creating a calendar? Your explanation is vague. "Get all the dates of the month" means how many days there are? If so Dim FirstDay As Date FirstDay = DateSerial(Year(YourDate),Month(YourDate),1) Dim LastDay As Date 'The 0 as day returns the last day of the previous month LastDay =...

Assuming your field is called yearmonth and the table is sometable, start with this query: SELECT Left([yearmonth],4) AS YearPart, Right([yearmonth],2) AS MonthPart FROM sometable Call it qryParseMonths and use it for this: SELECT IIf([MonthPart]<5,[YearPart]-1,[YearPart]) AS StartRange...

Oh my, I must have speed read the post.