Search results

Hi, we all know the Northwind sample database that MS offers. Could we say that Northwind is a kind of ERP software? For those who don't know or not sure what ERP is- I am one of those- I copy paste from Google (What is ERP and how does it work? This is called Enterprise Resource Planning...

Hi The above is a draft of my table. There are records and dates that the event happen for each record. If one record has been sitting idle in one event for too many days, this needs extra attention because it must be some business errors or bad service. In the last field "status", I need...

I checked. Indeed , example database has a tick in Microsoft Office 16.0 Object Library which I don't find this reference in my database. Could I update it from somewhwere ? Alternative, I could transfer the objects from my database into example and continue with example

https://www.access-programmers.co.uk/forums/showthread.php?t=297837 Hi, I visited the link. This sample database, in that link, does exactly what I need. I downloaded in my pc and db works just fine, when I transfer the code to my own database, I get the below error --- Dim fd As...

Hi I have downloaded this file and it does exactly what i need to do in my database. When I transfer the code to my database, I click the "browse for file" and I get the below error on code Dim fd As Office.FileDialog Compile error User-defined type not defined My knowledge in vba is...

Hi I want to display a pdf file on a form. I tried the exact steps from this video https://www.youtube.com/watch?v=UltWxgzgXPk&t=17s as well as from several other similar The error I get is "The OLE server isn't registered" To register the OLE server, reinstall it" There is no object in...

Thank you for the very useful post, I made it. It works. I am testing it , the problem I get is an annoying warning, although I reach my goal, the below warning message pops up after every click or change field focus. What have I done wrong ? The expression on Current you entered as the event...

Hi Is it possible to use shell function and open an external pdf file but in a specific page?

Could we link access with specific emails that are stored in an Outlook.PST file ?

Hi I have a report which works as "quotation". There are report header/footer, page header/footer, no problem with these HOWEVER I need always to display a "first" page which is a full A4 page with company's logo - company's moto and advertisements, on the second page the report "quotation"...

Thanks Doc_Man My problem is how to make auto number is query, i got it, then how to make record id for each change of data. Maybe I don't describe this very well Let's suppose we have query results A A A B C D D E F F and make it A 1 A 2 A 3 B 1 C 1 D 1 D 2 E 1 F 1 F 2 Then , yes, I...

i tried to link a picture then I upload, You will see, there is a general id for each record, regardless of what is as bner and another id that counts the bner, new bner, id starts from 1.

Hi I have a query which displays data from a table, I copy paste this query in an excel and I create an XML. Manually I add number id in the excel, say, from one to 300. I have recently insert a function like the below and now the id is ready, not need to insert manual...

A small problem, I need to lock the form design (Datasheet View) so that users canNOT delete controls or move controls from one place to another. This may happen by accident. Could I "lock" and secure the form ?

I would like to use as report "background image" one PDF file. The access allows only JPG files as background.

Hi I have a table with several fields, suppose it is about a fleet of vehicles which are moving from one point to another, may stray idle for some time until they get order for next activity. There are too many fields which must be displayed in the result, i will outline only few important for...

Dear pdaldy, so far I am using Docmd method DoCmd.OutputTo acOutputReport, "table1", acFormatPDF, "C:\Users\Cpc\Desktop\depo\nameofdocumentasfieldA.pdf" How can I interfere in the last part and I save a report with, say, ABC1.PDF and ABC2.PDF This report retrieves data from a table using...

How to save an access report but with a custom name name that is pulled out of the report header? So far I can save reports as document, document name is the report name and i have to change it manually. Could I do it automatic?

I have tow database. Say A and B A db, needs information pieces from a query in B db. So far I copy the query from B and paste to table in A. I wonder if I could avoid this copy paste by using a direct link.

Hi We can link a table data source to another table from another database. Could we link table to a query ? (not table, link to a query)