Recent content by alpertunga65

Hi everyone Actually I had posted a thread about this issue but I could not get any answer. Then, I tried to do something to solve the problem In my database, I am assigning frequencies (TEMASFRE), to the radionets at their locations (VERYERID). I want to assign any frequency to a...

Hi everyone I have two forms, Frm_ FREQUENCY_LIST (it’s table is FREQUENCY_LIST) and Frm_FREQUENCY_PRO (it’s table is FREQUENCY_PRO.) Frm_FREQUENCY_LIST is for listing all frequencies in a band. Frm_FREQUENCY_PRO is to assing frequency for a radionet from FREQUENCY_LIST table. Key...

Hello lagbolt, First of all, Thanks for your quick reply. I tried your codes. But unfortunately codes didnt worked. After witting codes; when I clicked Tables or Query, it showed both tables and queries. I used the first part of codes for afterupdate property of KynkSec, But I could not...

Hello, I have a form (named Example) to create reports by selecting fields from tables or querries On this form, there is a option box (name is KynkSec) with two options (Table, Query) and a combobox named as KynkTurSec. I want to change the data source of combobox either table or query...

Hello everybody, I am trying to build a database to assign specific frequencies to radionets. And I am able to assing one frequency to one radionet by clicking a button each time. I have solved this problem. But the second step for me is; assinging frequencies to all radionets at once...

Hello, I have three tables named as; Tbl_Shopowners, Tbl_Shops and Tbl_City Main table is Shopowners, the second shops and the last one is city. Tbl_Shopowners has fields as; OwnerID, OwnerName and a checkbox. Tbl_Shop has fields as; ShopID and ShopName Tbl_City has fields as; CityID...

Hi highandwild, Thanks for quick reply. As I told to CJ London; the serial numbers dont have any specific meaning and increment. Both will be random and I will check if ny onf them has already been used by a checkbox.

Hi everone, I would like to produce a serial which will have 4 members. The first, the second and the fourth members will be always CAPITAL Letters and the thirth one is always NUMBER. Here is an example for the format: AC3H Each member will change in any line and never match... I would...

Hi, thanks for your advise. I know that. Somebody can make mistake. The attachment is not my original Db. Ofcourse I will limit the lowest and highest frequencies. 88 and 108 were just examples for here. Thanks...

Hi pbaldy yes I have tried it. Not only your method but also I got sodbme other methods, but unfortunately I could not do it. I tried 4 different method. unfortunately I couldnot. Actually sevral years ago I had a similar Db and I had done at that time. In the beginning I used my own code. It...

Hi again me and the same problem "for..next loop" After my first thread, I got some help but unfortunately I couldnot solve my problem. So I decided to add Db here. If anyone opens my database; there is a table "frequencylist" and a form of this table with fields; firstfrequency, lastfrequency...

Hi Emir, In easy way; for the button for entry, you can write; DoCmd.OpenForm "Entry_Form" DoCmd.Close acForm, "Main_Menu", acSavePrompt Then try it for the other forms and reports. After clicking Close buttons on each form you turn back Main Menu. For reports you can write it under...

:confused:hello, I need help to run "For..next loop" I have a table named as FrequencyList (fields are; FreID, Frequency) I want to create a frequency list between "firstfrequency" and "lastfrequency" by a form I made a For..Next loop and put a msgbox at the end of the loop. When I...

Hi Simon, First of all, Sorry replyins so late. But I was busy so that I haven't joined the forum. Your Attemps are really good to translate Turkish words. No problem with them. Actually I am sure that you get problem with my English. I solved my problem. I am still working on my database...

Hello, I have a function for a keyboard. But only as UCase. I want to use that keyboard as LCase too. So I put a button to change it to LCase. Unfortunately I couldn't do it. Here is my function for UCase. How can I change my keyboard to LCase by clicking a Button then to UCase by clicking...