Search results

If you're putting it in the Format box, just use: £#0.00

You can use the combo box's On Get Focus and On Lost Focus events to make the color change when you click on it. For instance: Private Sub cmbExample_GotFocus() Me.cmbExample.BackColor = vbGreen End Sub Private Sub cmbExample_LostFocus() Me.cmbExample.BackColor = vbWhite End Sub

Format(100,"£#0.00")

Listbox -> Property -> Multi Select - > Extended This will allow you to pick multiple items one by one by holding down ctrl or a selection of items by holding down shift.

Hmm, it might still be something with the formatting. Honestly, since I live in North America, I usually don't really have to worry about the date formatting issue, so I may have messed that part up. This thread might help though: http://www.access-programmers.co.uk/forums/showthread.php?t=229037

Not really familiar with what you're doing, but if you want to get all the fields in mSysObjects, then: Function GetTableFields(strTable As String) Dim r As DAO.Recordset Dim fld As Field Set r = CurrentDb.OpenRecordset("SELECT * FROM [" & strTable & "]") For Each fld In...

I don't think it's the 'BETWEEN' keyword that is actually giving you trouble. There's nothing else to it other than what lagbolt said. Instead, from what I've seen of several of your posts, your main problems are that you need to learn how to write SQL strings and you need to proof-read your...

It's best to use a query. If your outcome can be reproduced from the data you have at any time, it's better not to store it. First, it bloats the database. Second, if some of your data (eg. ingredient quantity) changes then those stored values are no longer correct. There are special occasions...

I haven't tried this out yet, it's just an idea floating in my head: Create a query that lists the groups, such as a Distinct query on the group field. Tie that to your main report. Create a sub-report that is tied to the main report through the group field.

Have you read up on this? http://stackoverflow.com/questions/1541212/microsoft-access-and-paging-large-datasets Basically, create a Query that adds a column with rankings. Personally, I would create the ranking column based on primary key if it's an autonumber. Then you just need a Select...

It doesn't sound like you've really tried most of our suggestions. It might be helpful if you do. For running from query, just paste this into your query window in SQL mode: UPDATE [Document Table] SET [PathInformation] = Replace([PathInformation],"SERVER","SERVER.srl.local"); The where...

An Access forum probably isn't the #1 place to ask about stuff that doesn't have much to do with Access. In your case, the best responses should come from a VB.NET forum. Although, I do have a bit of experience with VB and Visual Studio Professional, so I'll share that with you. First, if...

In addition to what plog advised, there are pre-existing lists of countries that you could just import into a table. For instance, you might Google "list of countries excel".

Are you putting that code in your main form or your subform where you may have archived records? It should either be in the subform or you need to change the code to affect the subform. To do things in a subform from VBA in the main form, your syntax would look like...

Yes, if there is no installation of Access or Access Runtime, then it will need to be installed. For very small deployments, it might be easier just to check and install manually. Otherwise, I've heard SageKey is a commercial software that works well with creating Access application installers...

It is not an easy task since you have to re-write the frontend. Some of the API codes might be similar, but the general syntax and structure of VBA and C# are very different. As for the BE, both Access and Microsoft SQL have a wizard for a free conversion. It's not perfect since a lot of data...

Regardless of whether you have an accdb or accde file, you can rename them to accdr to run them with Access Runtime (or Runtime mode if you have full Access installed). The one major issue I have with compiling an accdb is that compatibility goes down, at least in runtime mode. For instance...

When splitting an Access database, you get a FrontEnd (FE) and a BackEnd (BE). What you would probably do is put a password on your BE like you did before. By default, your FE has the location of your BE, although if you change the location of your BE, you will have to use the Linked Table...

Did you check off "Always prompt for new location" as well as the desired table before pressing OK?

One option is just working with text format. You can then set the IsHyperlink property in your form controls. Alternatively, you can update everything with the following SQL statement modified to fit your table and field name: UPDATE [TableName] SET [urlField] =...