Search results

Hi there! I use combo boxes at a form. I want, when i select a specific value from the combo box, to change the inner color of the combo box. I use the after update and if me.comboboxname.value = "value" then WHAT? Thanks in advance

I need to take 3 fields from a query as columns(name, lastname ,id) and then the other columns to be all the days of the month. So, each row will show a person (name, lastname, id) and i can select with combobox what he did each day.

Hello there! i have to use a calendar in a form. Any suggestions? If you suggest some kind of calendar, could you tell me if i can use each day of the month of the calendar in seperate columns? Thanks in advance

Thank you very much. I found what you mean!

ok figured that out. At the properties panel i had number of columns:1 and 2 values for width column. I erased one width value and its working. Thanks

i want something like the attached file but in access. The first 4 columns are dragged from a query from a table.the other columns will be days.

ok i found this and its working fo me! Private Sub ΑΠΟΘΗΚΕΥΣΗ_Click() On Error GoTo Err_button_name_Click DoCmd.OutputTo acForm, "form_name", acFormatPDF Exit_button_name_Click: Exit Sub Err_button_name_Click: MsgBox Err.Description Resume Exit_button_name_Click End Sub it also works for...

do you know any tested programs to convert the database to mde? Cause i cant find an option from access 2007

That really worked ! Thank you very much!

ok i just fixed it. I had one column but at the width it had values for two columns. Now its working! Thank you!

Hello there! i have table with two fields. The one field is called "Surname" and the other field is called "situation". I have set the "situation" field to be a combo box and can take 2 values: d_n and "e_y". I created a form which has combo boxes and 2 listboxes. The combo boxes take values...

I tried this: SELECT table1.surname FROM table1 WHERE (table1.situation) = ""d_n"; and it worked....but.... This query results to 3 records. At the form, i get a blank listbox but i can click with the mouse at 3 first records - although they are blank. And if i right click - copy and paste...

Hello there! i have table with two fields. The one field is called "Surname" and the other field is called "situation". I have set the "situation" field to be a combo box and can take 2 values: d_n and "e_y". I created a form which has combo boxes and 2 listboxes. The combo boxes take values...

is there a way to click a button and the a report is created? The report could be like a mirror to the form and then i could save the report perhaps?

This form will not save data anywhere. I just want to have a general idea of what each employee do each day of the month - through the form and then print it or save it somehow to a file.

Hello there! I have created a form and i have put one button to print the form after selecting some values through combo boxes. After that, i have put a button that clears all the values so i can reuse the form. How could i save a form?For example, for today, i complete the form and before i...

Its not necessary for me to make it work (the dynamic change of the number of columns depending on the number of days per month ). I can create a table with 31 columns (plus the 2 initial columns) and each time i can complete the table to the point i want. But i would prefer the columns...

No, i want this: 1st column:all surnames from the table 2nd column: their "property" field next columns will be the days of each month, but the records of these columns will be combo boxes which can take 3 values (which i will drag from a table through query) i do not know if it can be done...

its like an assignment. We have a lesson called "Databases" and we work on access. So, i created myself an imaginary database and try to learn extra stuff!

could you give me an example 'cause i'm kind of rookie in access and i try to learn? Thanks in advance