Search results

Hallo. Could you help me with my problem. I have 3 tables - Contacts, Orders and OrdersLines. All relationships are one to many. I need to delete a record from contacts. But this contacts could have a lot of orders with products from orderlines. So, when i Deleting a contact i need to delete all...

Hello. I have form. and i need to delete record. Id is a unique key. When i have invisible textbox with source of this key, it's very easy to delete record from database. But is it possible to delete record with query without using textbox?

Hallo. I need Help. I have two tables Contacts and Orders. And have a Form with data from table Orders and one One ComboBox with data from Contacts. So, when i chhose in combobox for example contact name, i need to see all indormation about this contact from table Orders. How to make this?

Hallo. Could you help me a bit? A have a database on MySQL with ODBC. And in one form i need to have a multiple listbox. How to make, that when in new record i'm choosing data from this listbox, and saving it, in future i'm retrieving this data in listbox, in format, in which i have been saved...

Hallo. could you help me a bit? I have a Access database with MySQL on remote server. And sometimes record has some photos about product. Is it possible to make checkbox, that when product has images, checkbox automatically have status checked? Not user check this status, but automatically. All...

Hallo. I have a database on ODBC. MySQL collation is utf-8. With normal languages (english, french, ..) i have no problems. But when I using lithuanian, i have different different simbols. How to make, that i directly write some data to base in UTF-8?

Hello. I have problem in my database on ODBC. When i'm trying to save all records on button click, i have i all textbox'es #Deleted, but i know, that new record was made. How to fix his problem?

Hallo. I need help. I have record (text1||text2) in field. I know, that is not good practice. So, i need to read these record, find simbol's "||" and to delete this simbol's. How to make this?

I have database with ODBC. In mySQL i have field "rooms" with data "Flats || Houses". Is it possible to view only "Flats" in textbox1 and to view only "Houses" in textbox2 from field "rooms"? And is't possible to save data from 2 textboxes in 1 field in MySQL?

how to make low security level, when i'm installing database only with access runtime? i my computer i have low level, but when I installing DB on other computer i need access to set level of database from medium to low.

Hello Could you help me with this problem? I have Db on ODBC. i can import records from SQL to file and save this file on local disk. But how to create query, that i could make export from file to SQL tables? How to read all information from file? I cannot use export from File -> Export...

I have a form with listbox, where i can view a stored information, and textbox, where i writing information. So, when i saving information, i must have focus in listbox on last saved record. Or, when i changinh information in different record, i must have focus in listbox on last saved record...

how to make, that when I click on a record in listbox1, I see a full details about this record in listbox2? this listboxes on the same form

I have a little question is't possible, to made record Update without Promt "Your are about to update 1 row. Are you sure to update these records?"

I have two tables. First table "Orders" is parent, secondary "Works" is child. In Works on button event in field work_status i have the number, for example "6", which i must have in parent table "Orders" in field status_id. Criteria of this tables is order_id. What i must use? Update or copy...

i have table works. and each record (work) has work_status. i need to count, how many works has work_status = 3 i wrote i query dim b as integer b = Count("SELECT [work_status] FROM [Works] WHERE [work_status] = 3") compile wrote: wrong number of arguments or invalid prperty assigment. I don'...

Hallo, i have a question I have a form with listbox. A lot of records in listbox have the same status. For example: Pending, Active, Frozen. Could i make colors in listbox, which depends of status. Pending - Yellow, Active - Green, Frozen - Blue active - Green .... ....

Hello. Can I make a filter in ListBox, that i see only those records, which have the same Id?

Hello. I'm first time here. I have a problem. Two forms - the one is Orders with field "id", other - Works with fiels "order_id". I form Orders i can record company name an other information. In this form exist ListBox, in which i can see information about company. In this ListBox i can choose...

Can i make report with checkbox, that if I want print report only with records, which are selected in report with checkbox?