Search results

The answer to the question you have asked is much more involved than can be answered in a simple response. Here is link that might help get you started down the correct path: http://www.opengatesw.net/ms-access-tutorials/Access-Articles/MSAccess-Deployment-Best-Practices.htm As you move...

Access 2010 can and will open and allow users to interact with a 2007 database file. Because you are indicating a multi-user environment, I am assuming that you have split your application into front-end and a back-end files. I also am assuming that each user will have a copy of the...

The first thing you need to do is to make sure your database is normalized. What you are wanting to do is by not means a one table database. At a minimum, you will need two tables. One for data related specifically to each permit holder and another for data specific to the issue and renewal...

Check this link. It should help: http://www.fmsinc.com/free/newtips/access/accesstip3.asp

When the multi-select property of a listbox is set to "None" you do not have to iterate through the list to obtain the selected value. The selected value is simply the value in the listbox. You can read the selected value by just asking for the value: Me.condolist.value In fact, you don't...

Because the relationship between the Rental Income and the Contract is a many to one, you would want to have a subform in your main form that will be filtered to only show the rental income records for the currently selected contract. Additionally you could use a list box on your initial form...

Based on your post, I am assuming that your tables are normalized and that they are linked appropriately. If either of these are not true you may not be able to accomplish the steps outlined below. First, create a query and add the required tables to have it will return the information you...

Be aware that there is a default action on each form when the enter key is pressed. You can change that behavior in the Options setting.

Check out the "On Key Press" event of your form. You can use code in this event to evaluate the key that was pressed and then take the action you need based on the key that was pressed.

If your code is in a sub you could use to immediately stop processing any more code: Exit Sub If your code is in a function, you could use to immediately stop processing any more code: Exit Function if ..... then 'Message here Exit Sub or Exit Function would go here...

Try something like this: If [Voucher]>0 and [VoucherNumber]>0 then Msgbox "Your Message Here", vbOkOnly, "Message box title here" end if

I was assuming that you had access to the code for this applicaiton. If you do not, then you may not be able to use the application due to the refernces being missing. If this is an Access based application then you may need to contact the developer for assistance.

This sounds like a "References" problem. These problems are machine spacific and have to do with the version of Office, etc. that you have installed on the machine. From the Visual Basic code window, on the menu go to "Tools" and "Reverences". Check for any reverences in the list that show...

It would have been helpful if you had posted the code that you are saying is not working. However, here is a link that should help you get the code you need: http://www.mrexcel.com/forum/excel-questions/548529-visual-basic-applications-count-files-folder.html

I am not positive that I understand what you are needing help with. You can do the entire calculation and it really should not bog thins down at all. I would be something like...

I was only suggesting that you could check the "Text" property of an unbound text box because you cannot check the "Value" property of an unbound text box. I was just pointing out that the Value and the Text properties of any text box are totally different properties and there have to be check...

Provided your text box is bound then you can use: If it is unbound you will need to check the "text" property of the text box.

I would appear that you are now attempting to populate the records in the "tblPersonsOffences" table. If this is the case, rather than have to type the record id for the person (which is hard to remember) why not display a list of the available persons in either a combo box bound to the...

Try having your code create a comma delimited string instead of adding the "or" between each value. Then use an In() method that uses the delimited string in the criteria field in your query.

What version of MS Access are you using? I have attached an example in Access 2007 that will display the map in a brower window using a user provided address. I have not experimented with the new browser control only available in 2010 but I would think that there would really be no major...