Search results

Hello I have a table and one of the fields is "status". In the report I would like to paint all backgroud row in green when the status is "done" . if it is not possible I would like to paint all fields in the same row with green Can someone help me with that? regards

I split the database and the users can work simultaneous. and the problem is not with the close form I will try to explain shortly again I would like to mark the users in the users table so all the users will log off from the ms-access

Hello I have few users that login at the same time. from time to time I would like to upgrade my vb code or forms and for that I need that every one will log off. but I don't want just close, I would like to send a pop up with countdown. my soulution is 1. I have a users table. I added yes/no...

No the update query i am using looks like docmd.runsql "update tasks set description='" & me.description & "' where id =" & me.id

I am using an update query

Hello I have a long text field. I created a form with that field and update button which has an update query. When i type more than 2037 letters it gives me an error message like "update didn't succeed because the item is locked," if i click debug it show me the update sentence. If write less...

Hello I would like to create a form with multiple selection for example I have a list of sale person and I would like to choose 3-5 salepersons. what is the best way to do it and how do I update the table (any table) . is anyone have an example for that? Thanks

I am asking to choose and reorder the record as i want. not necessary in alphabetically order

Hi I have some records in a form. I would like to create "sort" object. When i click on a record it should go up or down and it should save the sorting in a table EX. I have 5 rows with id, description 1 aaa 2 bbb 3 zzz 4 ffff 5 ccc i would like to move the row zzz to the end when i am click on...

Hi I would like to create pop up with the current data field details. Something like ALT in HTML For example if i display in a field abcdefghi... The report display just abc... When i over the field with the nouse i would like to see all text Any suggestions?

Hi, When the report is open i created an event when click on one of the field. It open the form. After i update the field (on the form) i would like to refresh the report. I don't want to close the report and reopen Any ideas? Thanks

can you give me an example?

Hi I have a form with 2 links to the same report. I would like to pass a value regarding each link and use the query on the report the filter for example: At form called x i have 2 buttons. each click open report called Y ( i use the on click event and use docmd.openreport .....) . the only...

That's exactly my question. How do i call the other navigationSubform9 from navigationSubFotm7

thanks for the anwer, stilll doesn't work let me try to explain: i have main form called main menu. in the first navigation form called navigationSubForm7 I have 5 buttons. I would like to make an event click on each on eof them (5 buttons) . the event will send the number according to the...

Hi I have a navigation form called "main_menu" with 2 button called "navigationSubForm7" and "NavigationSubForm9" with sub-form inside caled "F_Title". When I am at navigationSubForm7, I would like to click on a button and load NavigationSubForm9 with a parameter I am sending. this parameter...

Hi I would like to create Hierarch in my employee table. I created a new field with name "teamLeader" which is the manager of the employee I would like to have in a new table all Hierarchy sepetate by comma for example A is the Boss, b is the manager, c is teamleader which has few employee . The...

EBS17 you are funny.. Solved with recordset Thanks

I don't familiar with bound form. Do you have any example?

I solved the problem with DLOOKUP. but now I have another problem since I have 20 textbox's to fill with data it works slow since it run DLOOKUP for every textbox any ideas?