Search results

Hello, I would like to found how to insert values into Ms Access linked table? Table linked from sql server, with odbc connection. Thanks in advance for help...

Hi , I have a form with gridview data with database data. With query I run INSERT INTO from one table into another, with button. I would like when I run procedure, also reset/update/refresh gridview with new import data??!! For info, I have try with some methods, such as me. gridview.refresh()...

Hi, I have an issue, but do not know how to solve it. I have a sample database (see attachment) which I will filter with query/sql by date, and after "query run" export it into .xls. I have three dates from 1.jan - 3.jan. And I would like to export to excel as those three dates will be...

I have multiple checkboxes in form, and they are just as objects in form. Note related to any table. And I would like all unchecked with button, to call query or procudure, etc... See attachment... Thanks in advance for help...

Hi everyone, I have form with a few checkboxes, and button. With checkboxes I checked fields, and which are then exported into excel with button. But something is wrong with code, because when run code it open selection box to enter BirthDay parameter. Open attachment... thank you in...

Hello, I have a question. I need to pull out records, but some records have different nr. of characters or they are write oposite. And I need get them in the same group. I will write down examples... record: iron-EKO ironEKO EKOiron How can I get all 3 records in the same query by word EKO...

Hello all, I need to have a comboBox which will filter listBox. I have create a query, relationship, and put AfterUpdate VB code on comboBox. But wont work, and listbox getting a blank values...?! I have attached an example.... Thanks anyone in advance for help....!!!

I was doing with database at work PC, and after work I went home continue on my home PC. Do any one know how remove this message? And what is means? Thanks for help in advance....

Hello all, I have create a code for form field IME, for validation data if field is empty. So, my wish is, if field is empty > then message box turn on > press ok > and go to control field IME. Please help! thanks in advance to helpers... Private Sub Form_BeforeUpdate(Cancel As Integer) If...

Hello all, I need help. I have create very cool database for Company X. I have found one mistake about validation rule in Field Properties. I have create a few field, which some of them have validation rule Is Not Null, and they must not be empty. After enter information in the fields, they...

Hello all, I need help. I have add attachment Sample.mdb. I need to join two tables, Shipment_details.shipment_number, and shipment.account. But I want to replace JUST value "819161" in Shipment.account with accounts from Shipment_details.account????? I have just start learned SQL. It is...

Hello, I have a Combo box with 2 values, Shipper and Receiver. How to create a query, macro or code, when I choose specific value, in my case Shipper, I want to open specific form, or something else... thank you to everyone in advance for help

Hey, I have ComboBox with two values, "Blank" and "Yes". If I set some records with value Yes, after that I would like to clear it for all records back to Blank value, default value. Of course would like to be done with Comand Button. I was looking solutions, but... Thanks to anyone in...

Hi everyone, I`m learning access for one month, and more and more like it...but still need help. I have a button which is exporting files into .xls file. I have a button which is opening another application. In my case, that is an Outlook. How can be done, that export file will be auto...

Hey.. I export files from access into xls. I have a macro button to do auto...also have a query for selecting records which of them will be on the export list. So, each time when I export file, like name Sample.xls. And would liek that next time would be export file Sample1.xls, and next time...

Hello all, I have an access database. Have create a table, form, etc. In form I have create a Macro button which is exporting all records into Xls file. Next to that button I have put Check Box, which I would like to use, if Yes, then only this record will be exported to Xls. I`m still...

Hi everyone, I was looking macro OutputTo. I would like to export file in XML format with button, which will be apply with macro. But there is no options. Only a few formats are available. Is that correct, or can be done somehow? thanks in advance for help

Hi everyone, I`m a little new one with access, but still I have created a nice database for our employees. I want to do one thing. I have one button for preview printing and also one button for directly printing. I want to add a textbox next to those buttons, that user could type number of...