Search results

i have a form with combo boxes, from where i select surnames (field of a table). In that table, i have a field that is a combobox named "situation" and takes 2 values: d_n and e_w I want to insert a list box in the from. In that listbox i want o show all the records (field: surname from table)...

Yes Really sorry I mean list boxes (i translated it directly from greek! :-) )

Hi there! I need to insert a calendar in a form but in a specific way. I want to have a form like this: First column: Surnames Second column: Property (i get these columns with a query from the same table) the other columns will be the days of the month. Someway i have to select the month and...

Hi there! I have a form with combo boxes, where i select surnames from a table. In that table i have a field that is a combobox named situation and takes 2 values - d_n and e_w. I want to insert a frame list in the form. In that frame list i want to show all the surnames(in a list) which do...

Hello there! Is there a possible way that i could lock all the tables and querries on a database and make it invisible to the user, all the content of the database except from a form which is the main form. Through the main form, the user can navigate through databse, insert, delete and edit...

It really worked! Thank you very much for your time!

You were right about the column number. Now its really working! Thank you a lot for your time!

Here is a sample of what i mean.

Thank you all very much! It really worked!

Hello there. I have created a combobox that reads from a query. This query shows 4 fields from a table. All i want, is when i choose a selection from the combobox, to show me both 4 columns (the whole row). How can i do this? Thanks in advance

The edit button worked!Thank you very much! The edit button worked!Thank you very much! I found another code for delete button: Private Sub delete_record_Click() If edit_list.ListIndex > -1 And edit_list.Value <> "" Then Dim response As Integer response = MsgBox("Do you want to...

I tried this out for one combo box and it worked. But when i added the And's for lots of combo boxes it appears no values at the combo box for me to select. Any ideas? Cause i have lots of combo boxes and the code will be pretty large, i though of another solution. I inserted a yes/no field...

I am rookie so, sorry for the stupid question: CurrentDb.Execute "DELETE * FROM TableName WHERE KeyFieldName = " & Me.ListboxName which also assumes the listbox is single select, and that the bound column is the appropriate key field. You can add a Yes/No message box to confirm the delete if...

Hello there.I tried out the tutorial at http://www.access-programmers.co.uk/...d.php?t=185430 that John Big Booty proposes. In this form, i want to add 2 buttons: Delete record button and Edit record button. For the delete button i want to delete the record that is selected from the listbox...

Hello there I have a form in which someone can fill in his personal info. One of the fields is Surname. I have save record, new record and back buttons but i want to place a text box and a find button. (or without a button). So, when i start typing a surname at the text box then it will be...

In the drop down there will be values from another table. For example the choices of each drop down will be: waitress barwoman cleaner And i want the other columns (except the surname column) to have labels the days of each month we are into. So, i want for each surname to check if Monday for...

Hello there, I am new in access and i try stuff. I have created a table. One field of the table is called lastname. I want to create a form like a table, where the first column will be the lastnames and the rest columns will be blank but in combo box style. Each of these columns will have a...

So, because i am a rookie at access, all i have to do is: Inside the form, select the new subform button. I will insert the field lastname from the table Employee in the subform When you say "Use this statement as the RecordSource of a subform" what i must do exactly? and where should i put...

Hello there.. I have a form in which i have combo boxes. The combo boxes are drop down menus from a field of table called lastnames. All i want is that when all these combo boxes have a selection in, to have a table in the form, where the rest lastnames (that are not selected at the combo...

My field is called lastname and my table is called Employer. My form is called JOBS and for example i have 3 combo boxes: combo1 combo2 combo3 So, the code will be: SELECT EMPLOYER.lastname WHERE EMPLOYER.lastname <> [form].[cboposition1] and etc? or i will have to write [JOBS] instead of...