Private Sub TestButton_Click() Dim bc As Long bc = TestButton.BackColor TestButton.BackColor = bc End Sub
Somehow this changes the color of the button from light blue to a darker blue. Yes, this has no real purpose, but it is a test to see why be app. isn't working. I store the color, but it back and it's not the same color.
My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1.however "Name" get a value of 1 or 2 depending on the selection.how I can get a return of the String Values instead of the Numeric values.
I have two option buttons, 1_optn and 2_optn. I have two subforms, 1_frm and 2_frm.
When clicking the little round dot (the option button) for 1_optn, I want the subform 1_frm to become visible. Likewise, when clicking 2_optn, I want the subform 2_frm to become visible. In the properties panel, both forms visibility is set to No.
I have tried creating a Macro and the best I've gotten is using the OpenForm function but that opens up the forms in a new window. I'd set the Macro to the OnClick event for a combo box (as I couldn't get the option button to work) so when "1" is clicked, the form would pop up. But they have to be in the same form. No pop ups. It also has to be an option button, not a combo box or list box.It also has to be a Macro. No Event Procedure coding unfortunately.
I have a form with 2 option buttons on it one with year 12 on it and one with year 13. I have a simple form with drop down menus and text boxes allocated for year 12s and 13s. I want all of the year 13 text boxes and drop down lists to be locked if year 12 is selected and I want all of the year 12 text boxes and drop down lists to be locked if year 13 is selected. I do not want to over complicate the form by hiding parts of it or having a new form open depending on the option button selected.
I have a form with option group (two option buttons) and date fields (to select a date range). The form should pull/pass parameters from the query. There's a form button that generates a report based on the query.
Issue: I can't figure it out how to link option buttons and date range to the query so when the button is clicked it generates the report with chosen criteria. The form is for the user to enter parameters.
A2010 - on an existing form I have a few controls that I want to hightlight. I thought I would create a rectangle covering only the desired controls and then make the back colour a light grey. But if I do then I cannot see the controls. If I change the back style to transparent then the colour reverts to nothing and I'm back to square one.
It feels like I want to bring the existing controls to the font - but how?If I create new controls on an existing grey rectangle then it works fine.
Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?
I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers.
ANy idea's on how to accomplish this? What ever value gets stored I wouldn't include it in the results.
I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.
how do I reference the value of an option button in an option group?
i tried this: Code:If [exact] = -1 Then where = where & " AND [SerialNumber] = " & Me![serialno] ElseIf [exact] = 0 Then where = where & " AND [SerialNumber] = " & Me![serialno] Else where = where & " AND [SerialNumber] Like '*" & Me![serialno] & "*'" End If
I am new to access and databases. I have taken on the job of creating a new one form scratch for my company. We are an advertising company and want a system to log, track and search all jobs that go through our traffic and production departments.
I have attached the basic plan for what I think we will need. Can anyone have a look at this and tell me if it looks ok or am I going in the wrong direction. The database will record many different job types with each having unique information in it. I was thinking of splitting these job types in to separate tables but always looking up a value JobsID in the jobs table in order to provide a unique number. And would it be or how would ii go about linking jobs with each other? So one JobID may have more than one job type linked to it ?
Sorry if I have not explained this well but I am trying to learn as I go along.
I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.
We are shortly going to start using tablet PCs over a GPRS bearer circuit for some of our employees to update our core business system from within customers homes. To do this we have purchased a very streamlined version of our core system, designed to work at a reasonable speed even over a normal GSM connection.
The employees that will be using this also use an access database that I've created though. Whilst it isn't crucial that they can use this while they're out and about, it might be useful and it's something I am interested in looking into. In order to make it feasible though, I think I would probably need to dramatically reduce the amount of data transferred between the be and fe due to the high cost of data over GPRS (as well as the speed). So I have a few questions.
1) Am I right in thinking that if I am using ms access as a backend, all the processing is done at the front end? i.e. I run a query on the front end, the whole table is retrieved from the back end and then filtered at the front end?
2) Is there any way to get around this? Or would it require switching the back end to SQL Server or something?
3) Is there any way of measuring how much data (in bytes, kb etc) is being transferred between the front end and back end while running queries, updating records etc.?
I'll probably think of some more questions but this will do for starters. :)
Наверняка ниже должна быть масса профессиональных терминов: про регистрацию в каталогах, поисковую оптимизацию, релевантность запросов, целевую аудиторию, продвижение бизнеса в сети, результаты поиска, исследования поисковых систем...
По идее текст должен содержать: Узнаваемость сайта, стратегии интернет маркетинга, контекстная интернет реклама и пр.
Документов должно быть много. Статьи по темам, помощь в раскрутке, советы профессионалов и прочее, что может быть полезно начинающему веб-мастеру самому освоить "науку раскрутки" (а фигли, мы ж не жадные ;) ). Обязательно по всему тексту должны быть расставлены ссылки на самых "вкусных" словах:
Регистрация сайта в поисковиках и каталогах
Уверен, будет текст, призванный окончательно убедить клиента сразу оплатить услугу и получить гору клиентов. Примерно такой: Мы обладаем огромным опытом в оптимизации сайтов, ведьу нас работают только признанные специалисты интернет маркетинга и рекламы. Используйте опыт специалистов в области оптимизации сайтов, знающих свое дело.
Ну вот примерно так. Представили? А теперь к делу! оптимизация сайта (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) оптимизация сайта (http://www.mulka.ru) оптимизация (http://www.mulka.ru) интернет реклама (http://www.mulka.ru) создание сайтов (http://www.mulka.ru) создание сайтов (http://www.mulka.ru) раскрутка сайта (http://www.mulka.ru) раскрутка (http://www.mulka.ru) поисковое продвижение (http://www.mulka.ru)
Is there away to set the values in a combo box depending on what option button you have selected.
What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?
So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other
If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...
I'm new to access. I have created table with following fields.
ID No, Name, Address, Gender, Favorite Food
I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.