access

Hello everyone, Can you please tell me the best practice for importing SQLITE data into Excel? I want to create a pivot table for several users to access. I tried the get data from other source but doesn't seem to work

Hello, does anyone know if there is an easy way to import XML data and relationships into access? I am interested in working on a publicly available dataset (here: https://www.hesa.ac.uk/support/tools-and-downloads/unistats) but have only been able to import the xml tables - not the...

I have a database that prints out around 50 reports directly from my Access database. Just this week I've run into an issue with the printer settings. When I select Staple + Collate the settings will always automatically change to Staple + Group. I have the reports automatically printing, so I...

Can you close one form from another? I know you can close the form you're on by using DoCmd.Close , "". How do I close another form. I need to make sure its not open when I run code. Thanks

Hi, I have an Access Macro. In this macro, Microsoft Access 14.0 Object Library is ticked in Reference. I want to un-tick this reference. However while doing so I get pop-up as ‘Can’t remove control or reference; in use’. How do I find out what objects in my macro are related to this reference...

Hi, Hoping someone can point me in the right direction with this one.........thanks in advance. So as part of the company structure individuals have different access to spreadsheets based on their username. Some can only view certain sheets, some read only, some have full access etc etc...

Hello everyone, This is my first time posting just as an FYI. I am trying to make a cross tab query that shows Location as the rows and Week Number as the Columns with a value set up in builder. Where I'm running into an issue is that in order to get the accurate value, I need the distinct...

Hi When trying to open an access file, I am getting below message. If I click OKAY on this, I get further pop-ups with similar type of messages. Only the dll name is changed. I guess, this is about missing dll, but not sure, also how does I fix this. Can anyone please tell me what does this...

Hi I am new to these concepts. Not requesting for exact answers. You may also help me with useful links for these two. I know Google will help, but trying to seek help from experts here. Also, I have another question here. Not sure if I can merge it here only. How does early binding or late...

Hi guys -- I've posted separately about this before, but the issue has seemed to have gotten worse so I thought I'd try again. I created and administer an MS Access Application -- 20 + users -- each user has a FE on their desktop, while the BE resides on a Network Drive. Everyone has Windows...

I have a query that I want to have a dynamic criteria based on what someone selects in a Combo Box on a form (the Combo is in the Header Section) Like [Forms]![frm_Add_Supplier]![ComboVendorASL] But when I try to run the Query, I get a pop-up that asks me to "Enter Parameter Value". Not sure...

Okay, I create a combo box in my form, to work with a query below. It is supposed to search for two columns in the query. It works at first. Then, I change the combo box to sort ascending and then it goes bonkers.. When I click on a name/area (my two fields) it will find the name but a...

We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit. We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...

I have code in my Access Database that does the following: In a form (MainForm) that has a record source from a table called SectionTable. The below code is looking at the first record in SectionTable, running a macro that is using the first record from the table, then moving on to the next...

Can you use VBA to Filter a filed in a Query I have a Query (qry_OnTimeDelivery_MetricData) I want to Filter Field: "MONTH0_Active" to the value "1" I want to do this from a form using a Button. Can it be done using code?

Hi all, I know access is not the best at formulas, but I have certain customer names were they can have the name entered slightly differently ( like Microsoft, Microsoft Inc, Microsoft UK).. Is there a iif contains formula so that if the customer name contains Microsoft then return the word...

Incidentally, I've saved my Excel .XLSM Workbook with 2 macros with the absolutely same name. Forgot to rename the macro copy. Now, I can't open that workbook. Simple, no way! Is any way for this problem to be solved? Maybe to export codes to bases or text from another book? I am really...

WHEN click a button in Access, which suppose to generate an excel report normally. But this time it shows error 7: Out of memory Private Sub btn_Click() On Error GoTo ErrCheck Dim strPeriod As String Dim intFY As Integer Dim strFMth As String Dim cnt As New ADODB.Connection...

Is this correct? MONTH1_PDL: IIf(((DateDiff("m",[PDIR Due Date],Now()))>1) And ((DateDiff("m",[PDIR Completed],Now()))=<1) Or ([PDIR Completed] Is Null),1,0) I need the first condition met and only one of the next two to true [PDIR Due Date],Now()))>1 Needs to be True AND [PDIR...

I have a form that has some formulas in unbound fields. When I open it, I see in the bottom left corner that its "calculating". Is there VBA code to make a form Calculate. I know there is in Excel, but is there an equivalent for Access My form name is frm_Home_Page. I don't know if there is...