Search results

First, I have to first tell you that it is not possible to actually create an exe out of the front-end Access database file. You can create a compiled version and your users can open and use that with the Runtime version of Access. Here is a link that should provide you with code that will...

As it turns out, it is possible to include the Port in with the server. All you need to do is to separate the server from the port with a comma. Works great.

You can utilize the "tag" property of each control that you need to manage. For each control that you want to "Lock" by putting "SetLocked" in the tag property. I then use a public function that I have written that evaluates these controls in the specified form or sub form and sets or...

It is not really possible to group controls in the way you might want. However, I have had to deal with this same type thing over the years and have come up with what I thing is a good method for accomplishing the desired results. I utilize the "tag" property of each control that I need to...

There are a couple of ways you can deal with this. One way is to add an option group to your form with two options and a command button to perform the user selected choice. The first option would be "Preview" which when selected would allow the user to preview the report. The second option...

Why not just use the native functionality and create a link to the tables you need from the 2003 database?

Does anyone have an example of an sql server connection string where the port is being specified? I have seen threads that kinda indicate that the SQL Severe Native Client driver must be used when needing to specify the port but I have not been able to get a handle on the requirements. Any...

Anna, I have to assume that there is a numeric value and then a text value being provided by the rowsource of your combo box. If this is true and you have changed the bound column to be the second field then you need to click on the Format tab of the Properties sheet and find the Column Widths...

You are quite welcome. Glad to help.

First, Anna, welcome to the forums. Next, I must tell you that although Access will certainly allow you to create a combo box in a table, it is not recommended by most Access Developers, including me. Tables should be used to store data. Forms should be used to provide the user interface to...

You can pass a value to your form using the OpenArgs parameter of the OpenForm method. Here is a link that may help understand this: http://www.comboprojects.com/articles/accOpenArgs/accOpenArgs.html

I can tell you that I not only have a multi-user Access Application running using the exact configuration you are describing but I also have a web application linked to the same data, allowing users to interface with the data both from a desktop application but also by using their web browser...

The way I normally do somthing like you are describing is: Use VBA code in the OnOpen event of the next form to generate the appropriate SQL statement and then apply that sql statement as the row source for the form. This sql statement can provide the criteria that will limit your records to...

With your button selected, in the Properties pane, select the Other tab and sett the Default property of your button to Yes.

Your project is interesting to me as I have been working on a budgeting application that would be used by anyone wanting to project a budget. My concept started out primarily designed at individuals but it could just as easily be directed at a corporate level. Because my project is an...

The easiest way to get the statement correct is to have your navigation form with the sub form in in open in design view. Open your query. In the criteria where you have your reference now, right click and select the "Build" option. Use the options to locate the open form and the sub form...

I do understand that if it is not broken, don't fix it. Gald you got it figured out.

Rather than try to close the orphan Excel instance, you will be much better off to eliminate the creation of it in the first place. That instance of Excel is being created when you do not use complete references to the object and the methods you are trying to access. Here is a couple of lines...

This sounds like the situation that can occur when VBA code is being used to access objects in the Excel model but not specifically addressing the object. One way to check to see if this is the case is, after running your code the first time, start the Task Manager and and check to see if...

You evidently have your field set to a "general" date type format. This will mean that all dates will be evaluated not just by date but even down to the second. I was assuming that you only needed to evaluate by the date only. Glad you got it to work.