access

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...

Hello All, I have an excel workbook which is linked to an Access Query via the Data>Get Data Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me. The past couple of days I have started to receive the following: "ODBC Microsoft Access...

I have a pretty simple database that I use for basic reporting. Every day I download a csv report from a website that contains sales metrics from the previous day. There are 4 columns of data (A-D in Excel). The Access table I import into has 6 fields (the first being an auto number record...

I have used the following previously to open a query in Access and then copy the data to a holding sheetrsQuery.Open strQuery, cnConnection, adOpenKeyset, adLockOptimistic I now need to use the same but stop anyone else from getting any of the records that are in the recordset so effectively...

Hi I am reading about macro settings and found this link about the option [] trust access to the vba project Mine is not check and I ran many small macros without problem so far. I read what is explained below but did not understand it well. Could you please explain to me why I need this...

I am wanting to get some data from an Access table based on multiple criteria and I'm not sure if my criteria is working and I can't seem to find anything that would let me verify it. the query as it stands isstrQuery = "SELECT Name, Wage, Pre_App_Adds, Food, Home_Start, Other, Mileage_Pay...