Search results

Look into the SelStart property of, say, your textbox.

Copy and paste it into a module. Then in your query, just type in as a new field, passing your value in. So: MyValue: GetValue([YourFieldName])

There will no doubt be a neater way of doing this, but I'm half-asleep and brain isn't fired up. But this will work: Public Function GetValue(ByVal dblValue As Double) As Double If dblValue > 100 Then GetValue = 100 * 5.79 dblValue = dblValue - 100 Else...

And if it goes to 400 or 500, is there any rate for that? Or is it just everything over 300 gets the final rate applied?

Are the users logging in via the same or separate machines?

When I joined this forum I was just starting out in Access. Think my first post was trying to figure out where I was going wrong with a calendar. From there people would say read on normalisation, etc, and I did.

Here's one for your learning curve: get out of the habit of using default control names. Combo31 is meaningless. And you may come to the database in future, find a reference to it, and wonder what the hell is going on. Give your controls names. Even better, give it a prefix and a name. I use...

Listen to the other guys. I answered your question, they have provided a more robust solution. Effectively, have a query be your RowSource for your combo box. So, for example, select CCode and CCompany in your query (order CCompany as Ascending) and save the query. In your combo, set the...

Would also suggest wrapping the DLookup with the Nz() function, just in case it returns a Null.

CCode is a string and not a number. Therefore you need to use the correct delimiter. strFilter = "CCode = """ & Me!CCode & """"

Two years on, they've either had it solved or given up.

I should say that I also echo the needlessness of doing this. Just showing the way, regardless.

Why interfere with the user's choice to organise their screen estate as they wish, window-wise?

Yes. You just bind the query to the report's RecordSource property. Plus use a macro or VBA to open the report on the command button's click event. Well done in resurrecting a fourteen year old post.

You want to look into the FLOOR and CEILING functions.

Google fOSUsername() by Dev Ashish.

Not going to work, as every time the button is clicked, intLoginAttempt will be redimensioned and will be 0. Replace Dim with Static, though...

I'm such a meta-data collector in my databases. I like to know what users are up to, how they use my database, etc. An example of how I would use something like this is to record average time spent on a form. If the average time is unusually high, it may pose questions such as a) are people...

Look into Static variables.

Perhaps I will. Would need to detach it from lots of other stuff, etc. Plus comment it for an example, etc.