Search results

Hello everyone, I have a query which one field's criteria is refrenced to a form : [Forms]![frm_InsurancePolicy]![txtInPolicy] And Also it is needed to refrence to another form, it means I want to use two criterias for the field of the query. (the query is linked to a report which it's...

Hello All, I've create a report that is included two columns, first columns is words and second is sentences (example for word). Word | Example .................................................. Ensure | The airline is taking steps to ensure safety on its aircraft. invent |...

Hello everyone, In a project on report, All text in a long textbox must be justified, but as I realized that Ms access only has 3 text alignment (Left,Right,Center) and Distribute which is not my aim. My question is that, Is there a workaround with vba or any other way to allign text justfied...

Hello everyone, There was an unnecessary module (Module1) in my program and I removed it from modules list via IDE. I reloaded the program but I noticed the module is not removed and when I click it to view codes, this error appears : Unfortunately,this error appears on each opening program...

Hello all, there is a subform on the main form in my project and I use another form for data entry. Now I want to set focus on last record of subform after data entry, so I added the codes after insert sql : Forms!frm_Main!Sub_Words.SetFocus DoCmd.GoToRecord , , acLast but it doesn't work or...

Hello everyone, For limitaion of access database which is 2 Gb, I splited backed database to two backend, but relationships between them has gone and Cascade option are disables. I also know I can use SQLServer databse instead of Access database, but for some reasons I have to perform it by...

Hello everyone, I've added a small code to OnKeyPress event of a Textbox and it works correct, but I need to assign it on all forms and all Textboxes of my program : Private Sub txtCustomer_KeyPress(KeyAscii As Integer) If KeyAscii = 1740 Then KeyAscii = 1610 End If End Sub I can put it on...

Hi all, As you know the first row of datasheet is always focused and highlighted as default when we open a form, I'm trying to find a way to deselect the first row . Do you think it's possible ?

Hello all, Yesterday, I was working on my two MS Access projects and my system (windows 10) was crashed and restarted suddenly. After running system, the two Accdb files give this error : "Unrecognized database format ........." I also tried some recovery access database tools and I didn't...

Hi all, I'm using a continous subform on the main form and the scrolbar of the subform is full while there are some records (15 records) in it : Of course, the problem is solved after changing the scroll bar manually, it is just annoying on load of the form. Can someone tell me how I can...

Hello everyone, I have an access file with some forms and tables in it, I was entring data for monthes until it fialed some days ago and no forms and tables comes up. it only shows a table which its name is "MSysCompactError" and it contains some erros : What exactly should I do ...

Hello everyone, I'm trying to disable form shortcut menu except a textbox, I mean I want to disable right click on a form except a textbox so that users be able to right click and paste on the textbox, is it possible?

Hi all, I have a table of Product names and I need a sql code to pull products name till a speciific products name, like : For example, If the target record is "Canon i70", SQL code must select products names until the target product name that are 1 to 7. "HP pro 400" "AOC T96" "HP 220"...

Hi all, I have a field on subform that contains short time data, now how can I filter subform by typing time in text box on form? is it possible?

Hi all, As you know access database is limited in size (2GB) and it's not good to attach more files in it for example images, musics , ... I have been using to attach the files in a folder beside access database and call them from access, but I need to store all files (jpg, png, pptx, mp3 ,..)...

Hi all, I'm trying to populate a table field to ComboBox so that another column of the table is greater than sum of another table : Table1 : C_Code C_Amount A190 2600 A250 3200 Table2: D_Code D_Amount A190 150 A190 500 A250...

Hi everyone, newly I migrated from access back-end to SQL Server, and I create all tables with sql server and connect it with access by OCDB. But I have a question, How can I store and read file in sql server like "attachment field type or OLE-Object type in access? For example I want to insert...

Hi all, I'm confused by the relationships between 3 tables. I have 3 tables include "Project name","Section","Samples", that every Project has several sections and every section has several samples. like this: (this example for 2 project) The first table (projects) and the second table...

Hi everyone, I created a graph by a query on a form and now it shows only the graph, How can I print the graph or form, or export to pdf?? (Horizontally) Thanks in advanced.

Hi all, I'm trying to filter subform by a combobox on main form, but the field on subform is unbounded control.(Dlookup from another table) Private Sub txtBranch_AfterUpdate() With Me .Child01.Form.Filter = "[Text28] LIKE '" & Nz(.txtBranch, "*") & "'" .Child01.Form.FilterOn =...