Search results

If you would like to contac me directly send email to: mrbpolk@suddenlink.net

I will have to send you a private message and we can work out something.

jules68, I had issues dealing with the same thing the first time I ran into this problem. For those that do not know about this issue, the problem comes from the fact that a crosstab query produces specific column names and a report has no way of knowing what those column names are going to...

I had been asked by a global corporation to create a Quote and Estimating application. I had started and basically completed the development of it when circumstances changed and they decided not to continue with the development of the application. I have attached the schema for it and I do...

If you can attach your database, I will take a look as see what needs to be done.

You will not be able to accomplish what you want to do with just one single table. You will need a table with the Equipment info and then another table what has records created each day indicating the equipment that has had the actions performed on it. You have a one to many situation...

Create an unbound form. Have a couple of text boxes (one for the username and one for the password). Create a couple of command buttons. One to be a Cancel button to allow the user to abandon the login in process. The other would be the "login" button and would be disabled until the user has...

It is very easy for anyone that is new to Acces to be somewhat confused. You are in goog company. We have all been there. You first need to create your database structure. It is critical that it be "normalized". I realize that you have said that you are creating a "simple" database but...

The short answer to your question is "Yes" it is possible to do exactly what you want to do. You would need to create a table with a date field with the default value set to Date or Now and a Yes/No field for each of the options you want to track. You would then need a form that you would...

You can use the name of a combo box on a form as the criteria for your query. Then what you selected from the combo box will be used as the criteria for your query.

I would suggest that you start by creating a form that will allow you and your users to input the data to your table. Once you have that working you will have learned much more about Access and developing forms. Once you have that experience under your belt, then you can create another form...

In the Controls section of the "Design" tab, click the down arrow at the lower right of the Controls section and click the "Use Control Wizards" option. The Icon to the left will be highlighted when this option is active. When you place a control (including a combo box) you will get a wizard...

This is one of those "do it yourself" projects. Implementing something like this depends on just how "secure" the requirements are. If you only need to have the user supply some basic password to gain access to the form then just create another form and have that form promt the user for the...

Have you considered using an Option Group. You can have as many option groups as need and have as many options in each group as needed. The opton group will only allow one option to be selected in each group. The option group can be bound to a field in your table and it will store a numeric...

You will need another table where you can create each of the two records needed to store the information about the tests that will be performed on each of the two halves of the first prism. In this new table you would include a foreign key to the original prism record so you would have the two...

I must admit that I am not up to speed with "web templates" and using them. However, with that said, I have developed forms in a web database and there are "events" that are triggered in forms in web databases just as there are in the normal Access form. With this in mind, instead of using...

A combo box can have more than one field returned from the data source. The bound column is one specific column or field. What I was attempting to tell you is that if you want the Name to be used then you need to make that field to be the bound value of your combo box. If it was then the...

Check the Bound column of your combo box to be sure that the correct value is being stored in the combo box. If your query is expecting a record ID numeric value and you are returning the string value of the name of the buyer that could be the problem.

You will definately need VBA code and you will need the code in the On Format of the Details section. Something like": if Not IsNull(me.NameOfControl) then 'make some control visible me.NameOfControl.Visible = True end if Just change the "NameOfControl" to the actual name of...

Why not just use the "a" and "b" without actually adding the initial prism number. Later if you can concatenate the initial prism number in front of the "a" or "b" when it is needed for clarification. Just a comment: If each of the halves of the prism are going to have additional tests will...