Some MS Access related questions?

Question

I am trying to develop an access database, however since I have only ever really used MySQL or Oracle with PHP front ends in the past I am getting quite frustrated! I need to know the following stuff before I start loosing my hair:

1. How do I use a macro to enable a previously disabled control?

2. How would I go about making a blank form linked to a table which can be used for searching?

3. How can I make variable criteria query? (i.e. The user comes to a form with lots of controls on it, and enters search data only in the fields they want to search using, and the query is built arround that data.)

All this would be so much easier in PHP!

Any help would be much apretiated. Also if you can't be bothered answering the question but you know of a good web resource which has the answers, I would very much apretiate that as well!

Answer 1

1. Macros in MS Access are limited, I would use VBA code instead. Check out the Object library and find the object name for the control and change the enable property to true. Use the expression wizard if you are not familiar with VB. ([Formname]![controlname].enable = true)

2. You already have that ability built into MS Access. Create a form for editing the table. I use the form wizard to create a quick form based on a single table. Then add a button with the binoculars on it by using the button wizard and select the search method. This will provide a search based on any one field that has the focus in the form. For multiple field searches, use the filter by form icon from the icon menu to select multiple fields to search.

3. This is the definition of the filter by form icon on the icon menu mentioned in 2.

Answer 2

I tried to make a macro disable a control on a form I call Contacts. The control was named LastName. I was able to do it in VB code:
Forms![contacts]![LastName]. Enabled = False

Create a form using the wizard. It allows you to select the table and makes it for you. You can then modify the product and you usually do need to change it some way. The form will not be blank, you must have controls linked to fields on the form in order to search on those fields.

Use a form to select the criteria for the query. Unlinked controls that allow selections from a list, maybe based on table data. Supply a button that executes a query. Leave the form running. In the query's criteria put references to the form such as

Forms![contacts]! [SelectedLastName]

Note: Spaces added in long names above to force Answers to display the whole name.

SelectedLastName would be the name of the control on the form 'contacts.'

You may also want a button to close the form after the query is closed.

Another thing you can do is put bracketed names in the query and just run the query. It will prompt for the data, but it can only be user entered, not selected from lists or table data.

I like bracketed names like [Enter date: (MM/DD/YYYY)]

Put that bracketed name in the critera part of a query and run the query.

Answer 3

everyday ejaculate is round one tsp. No prevalent -- some couples do the wild component quite a few cases in accordance to day, different couples prevalent a pair of times in accordance to month. a youthful guy in a newish relationship would bypass 3 or perhaps 4 cases in accordance to evening, older adult adult males -- once is better the norm. pill is somewhat a lot less effective than condom -- condom plus pill equals very nearly no probability of being pregnant. If the lady is green with envy about it, then certain it pretty a lot truly will convey about relationship complications; in the different case i will't see the way it might want to. No, you could't make the mathematical calculation, because the probabilities are very low in case you take advantage of the pill and combine with the "rhythm technique" (it really is a woefully undesirable thanks to take care of birth control. perfect component is to religiously take the pill, in accordance to training, each day. If it really is a tremendous deal, evaluate combining pill with foam, IUD, or different non condom technique.

Answer 4

Purchase the book Windows 2000 professional.
Authors:Mark Minasi & Todd Phillps.
You won't need any help.