Search results

Hi All. I connected Access 365 to SQL Server 2016. What extension I need to select to save Access DB file: .accdb or .mdb? Why I didn't see option to save Access as project with .adp extension? Thanks

Hi All. How create VBA Function or Procedure to perform following: Filter table data by current date Export result to Excel file Locate created Excel file to certain network folder If this is possible, how to do it? Thanks

Hi All. In the form I have 2 command buttons cmdPrevious and cmdNext. Also 2 text fields txtMonday and txtFriday. When I click one of the buttons, txtMonday and txtFriday get the previous week's or next week's dates: Monday and Friday. Now I would like to create a script, when the date value of...

Hi All. How to create 4 type of qury: 1. to retreive data where string field has only numeric data. 2. to retreive data where string field has onlt alphabitic data. 3. to retreive data where string field has only alphanumeric data. 4. to retreive data where string field has data with special...

Hi All. I created query: see attached file query_A1.txt When I ran I got error message: I tried to find a problem by cut code related for Execution2 and Execution3. But leave code related for Execution1 - see attached file query_A2.txt. That part of query works fine. Then copy and paste whole...

Hi All. I have problem to import .accdb database table to SQL Server 2019 via SSMS. The both apps MS Access 2016 and SQL Server are 64-bits. Also I installed Access Database Engine using accessdatabaseengine_X64,exe installation file. But when tried to use import data wizard in SQL Server...

Hi All. I tried to import data from an Excel spreadsheet that has no duplicates into Access. When I used the Access wizard to do this, I ended up with a lot of duplicates in the table. When I copied and pasted the same spreadsheet into an Access table, there were no duplicates. What is the...

Hi All. I would like to create a multi-user DB. If I create a database in SQL Server and then link it to an Access database, will I get a multi-user database? Or do I need to split the Access database anyway? In case if Access link to SQL Server what specific changes need to do in VBA code? Thanks

Hi All. how to set alternate color of row in continuous form? Thanks

Hi All. Is it possible to change font size in Access conditional formatting? If it is possible, please, explain how to do it. Thanks

Hi All. I tried to change color and font for selected ListBox item. For that I used this code, but unfortunately it don't give me result. Private Sub YourListBoxName_Click() Dim i As Integer For i = 0 To Me.YourListBoxName.ListCount - 1 If Me.YourListBoxName.Selected(i) =...

Hi All. I would like to filter different ListBoxes RowSource by value which differ by one day. For this I created a code Private Sub cmdFilter_Click() Dim strFilter As String strFilter = "CompDate = #" & Format(Me.txtFilter.Value, "mm/dd/YYYY") & "#" Me.lbxMon.RowSource = "SELECT * FROM...

Hi All. I have attached the sample of weekly worksheet. Based on this, I would like to create a database, because every new week I have to create a new spreadsheet for keeping statistics. I can't figure out how to create a form that will look like an attached spreadsheet. Where the user will be...

Hi All. I have the Access DB with a huge amount of macros that manage queries and files in explorer. The database file has almost reached its size limit (2 GB). I have an idea to migrate it to SQL Server. Questions: 1. Is it worth to do it? 2. If yes. Should I migrate all tables or queries as...

Hi All. I have couple update queries for the same table: UPDATE Table1 SET Table1.Code = "01" WHERE (((Table1.Code) Not In ("01","05","06","07","08"))); and UPDATE Table1 SET Table1.ANum = Null WHERE (((Table1.Group) Like "HC*")); Is it possible to combine those queries into one update query? If...

Hi All. I would like to create programmatically new network subfolder where name of the will be include the current date and transfer files to that subfolder from other network subfolder from the same path. If that is possible to do in Access VBA. Can somebody show and explain how to create it...

Hi All. I would like to open form with according title. For that I create following code: Option Compare Database Option Explicit Private Sub Form_Open(Cancel As Integer) FormArg = Split(Form.OpenArgs, ",") Me.Caption = FormArg(1) End Sub When I run the form I'm getting error message...

Hi All. I would like to highlight new record added to continuous subform in the parent form. For that I used code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.GoToControl "fDeviceSubForm" DoCmd.GoToRecord , , acLast Forms!fInventory!fDeviceSubForm.Form.Requery...

Hi All. The fInventory parent form has Tab Control where I located the fDeviceSubForm and button which call child form to create a new record. All controls located in detail section. When click Save button a new record successfully saved. But the code line...

Hi All. To delete record on continuous form I created button with code Click event: Private Sub cmdDelDelivery_Click() If MsgBox("Do you wish to delete this record?", vbYesNo, "Delete Confirmation") = vbYes Then If MsgBox("Are you SURE you want to delete this record?" & vbCrLf & _...