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...

As I said, I can delete record from the table with hidden textbox with RecordSource of PrimaryKey. But the politic of company - minimaze used controls on the form. So if I have hidden controls, i must remove this controls, because they are locked and not enabled.

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?

The end of the day, so i'm getting a little bit crazy ;)) The first part of my question i did. ;)) Another part. I have a field with data. for example: fiels - specials; data - "ABS, CD changer, garanty, air condition". And to view this data in form, in listbox, I need to explode this data...

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 can concatenate two fields. and is very fine. for example text1||text2. it's possible to read string until this simbols and to trunc all simbols after text1?

I know. But it was old database with form on CMS. And there was two languages Lithuanian and English. And all data were stored in two languages in on field. I don't know why. :(

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

oh, thank you, thank you

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'll try AfterUpdate method. And I'l try to explain in details my problem. on first Step i'm working in Orders. Each order has a status_id ( 1 - "Set" 2 - "Answered" 3 - " " 4 - "Active".) When order "Active", i'm choosing active order in listbox, and on doubleclick on this order i'm opening...