Search results

In Access, I have a form fTest with the unbound combo box cmbOddelek that has search-as-you-type enabled, VBA code below: Private Sub cmbOddelek_KeyPress(KeyAscii As Integer) Dim strSearch As String Dim strSQL As String ' Combine the current text in the combobox with the typed...

I've a table tDeliveries and a table tOrders. tDeliveries has the fields DeliveryID, Delivery_Date and ItemID, and tOrders has the fields OrderID, Order_Date and ItemID. I want to create a query that displays, for each ItemID, a list of all deliveries from the tDeliveries table and their...

Hi! I have a form, that opens in Add New Record mode, using this code Private Sub Form_Load() DoCmd.GoToRecord acDataForm, Me.name, acNewRec End Sub For switching between the form and the datasheet view, I use this code: Private Sub Form_DblClick(Cancel As Integer) 'The CurrentView property...

Hello! I would appreciate it if someone could explain why I'm getting Run time error '3011' The Microsoft Access database engine could not find the object "C:\MyPath\MyFile 01.txt" when running the below code: Sub LoopThroughFiles() 'to import all MyFiles*.txt data to table MyTable Dim...

Hi! I know this has been asked many times, but I couldn't find an answer that would work, at least not for me. I'd like to send a report as pdf by email, using a Microsoft Outlook Template file (.oft). I have tried to use the OnClick event of a command button using DoCmd.SendObject and...

Hello! I have a problem using DCOUNT to prevent duplicate entries by date. I have a table named tAverage(with the ItemName, Quantity, AverageQuantity and Date_average fields) into which I add new records using the qAverage_Add query. This query also calculates the average quantity. I run this...

I don't have much experience in building databases with Access (or any other software ☹). I would appreciate it if someone could provide me with the info or step by step guidance on how to save an existing split database as a template. I have the latest version of Access 365. Frank

Hello! I need help building a query that will count and filter my records. I have a table like this, with several thousend records: I would like to build a query that will count and filter out all records with same Item and more than one Group and will give result like this: How should I do...

I have a master form and a sub-form showing records that meet the required criteria. On the main form, I have one check-box, and on the sub-form (datasheet view), I have a check-box for each record. When I click on the check-box on the main form, the status (checked / unchecked) of the...

I export data from Access database to an excel file using a macro. It works fine if the excel file is not opened, but it gives an error when it is. I would like to close the excel file before the data export. How can I do that? I'm using this function Public Function IsWorkbookOpen(ByVal...

Hi! I'd like to know if it is possible to import data to access as a linked table from an excel file, stored on a webpage (not in Sharepoint)? This is the link to the file: https://www.jazmp.si/fileadmin/datoteke/seznami/SFE/Prisotnost/Seznam_24_HUM_prenehanja_motnje.xls When I try to...

Hi! I have an update query and when I try to run it, it says that not all records could be updated because of keys violation rules. I understand why this is happening but I'd like to know how can I find those records that are violating the keys rule. I'm using access 365 and don't know much...

I have a problem that is driving me crazy. They replaced my computer at work and I was forced to start using Office 365 and Windows 10. In Windows 7 and Office 2010 everything worked as it should be. However, in Office 365, I have a problem linking Excel to external data from Access. I have an...

Hi! I was forced to start using Office 365. So now I'm using Access 2016 and Windows 10. I encountered a problem when using one of the files. The file is set to save a copy with the name and the current date at startup (AutoExec macro). In 2010, everything worked perfectly, but in the 2016...

I wonder if this is possible? I have a tale named tCBZ that serves as a data source for the form named fCBZ. The table has several fields, including the Short_Name and Long_Name fields. On the fCBZ form, only the Short_Name field is used(because it is shorter:)). However, for some records the...

Hi! I have a table with the following fields: Group_ID Offer_ID Notes Total _ sum Selection I would like to build a query that would show only those records (Offer_ID) for each Group_ID that are not selected and for which the sum is less than the sum of the selected Offer_ID. Please...

Hi! I have two tables. The first one, the tATC table, contains ATC codes and descriptions. As you can see from the attached access file, it has 5 levels of ATC codes. The second one, the tConsumption table, contains data on consumption of medicines, including the 5th level ATC codes. I'd like...

Hi! I'd like to know how can I select/deselect the checkboxes for all records on the subform when I select/deselect the checkbox on the main form? I tried the code Private Sub MySelection_AfterUpdate() Me.Subform2.Form!MySelection1.Value = Me.MySelection.Value End Sub but this only select the...

Hi! I somehow can't find an easy option to view all my threads. Is there any other way to view my own threads than using advanced search option Find threads started by user?

Hi! I'd like to know how to build a query to get the results I want. I'm using access 2010. I have a table with the fields Group_ID, Item_ID, Item_Name and Quantity Group_ID Item_ID Item_Name Quantity 1B.05.BB.01.017 64572 First Item Name 0...