Search results

I am currently working on a serialized bom inventory system. What kind of products is your inventory system based on?

The page https://cage.dla.mil/Search/Details?id=70 Gives quite some information, are you looking for specific info from this site?A quicker option is to let Access fill the inputfield with your request, download the whole page with msxml into your database and show it in your webbrowser...

You have to make a distinction between a rest api request. The provider has to have information about the api and mostly you need the have an api key. On the other hand you have the option to use webscraping. For webscraping you have to inspect the webpage and learn about the xml dom document to...

I think you have to look at building a form, there are form wizards to start with. Building a form where you select a contact and a subform will show all his payments and payment details (subscriptions) is easier then building a complex pivot query.

Breathe, meditate and breathe again. I love you to. The reason i want to do these two commands is not the issue, it would take to much time to explain. (And the user must be lighting fast to change the object between these two commands..) But Please, let’s keep the reply’s restricted to possible...

Strange, what is your code to set the focus to the control on the main form? Reason: i think i found an easy way to create an Accordeon table/subform view (like on websites) I have to overcome a view small problems like this one.

I still get an error when i set the focus to a control on the main form first.

When I run these two commands: "DoCmd.RunCommand acCmdLayoutView, DoCmd.RunCommand acCmdFormView" from a cmdButton on the mainform it will work but from a subform it doesn't. When I move the focus to another openform, the docmd works. My question is to remove the focus from the main form...

There are quite some hits, also youtube, when you google Access Library database. Access has also a working Bookstore/library template, but probaly with macro's in it. https://answers.microsoft.com/en-us/msoffice/forum/all/creating-a-library-system-on-access/9af26480-8c09-46ea-9497-487df8f4a307...

Thats’s quite an impressive cv you build over the years. I have a client who is looking for a serialized bom inventory system. It’s a small manufacturing company wich produces only 6 (highly technical) products. Do you have any tips on setting up a serialized bom structure with components and parts?

i have made an application where with the runtime version (menu hidden) the close button was pressed when closing a report in preview. I made a hidden form, with a msgbox on unload event. Private Sub Form_Unload(Cancel As Integer) If MsgBox("Do you want to close the database?" & vbCrLf &...

You forgot to read the copyright text?

Can you share the url, i have some code that might work.

Het zit je niet echt mee geloof ik, overal word je tegengewerkt. Je link nr stack overflow geeft volgens mij je antwoord?

Thanx Arnlgp, exactly what i am looking for! The next step is to save the changed positions, so when you reopen the form you get the last created layout. I think a table with top left positions of the controls. A new idea is always more work then you intentially expected. Thanx for helping me...

I have seen a post about running code asynchronously with excel vba..

Thanks for the information Doc! The company website is using a php MySql database, may be I can use a1 table on the server? And i have to google data-based triggers. I have made a test database with a timer event that was checking for a certain (very small) text file on onedrive, if it was...

I want to trigger code when data in a linked sharepoint table has been added. I want to establish communication between two seperate access db’s thru a sharepoint table. I could run code on a timer, but this would be every second, this could conflict with other code. A possible solution could be...

Is it possible to get sticky lines as show in the table relationship overview? I want to make a workflow interface where the different stations (=Subformcontrols) are draggable (this part is already working). It would be nice if the connection lines between the stations would also move along...

I agree with you in terms of investement and time. I already proposed to my client to look at already available systems. I think, in my case, that they are looking for a tailor made solution (they are producing 6 specialized products). I think it can be done in Access, but it will be a big...