Search results

Wowwww this is old. I'm re-reading this question and remembering all the work I used to do in Access. I'm glad this project sort of fell in the wayside. I'm glad to see Happy's post is helping people.

Well the issue is are you trying to update through an objects event, or strictly through code. If you have a form attached to a table, you don't need to be messing with VBA, however if you want to strictly do it through VBA then I would look into DAO recordsets. Ex. Dim db as DAO.Database Dim...

I think the reason you're not getting responses is probably due to your terminology/vocabulary. While words have multiple meanings, a fixture is generally used when referring to devices, such as a light fixture or plumbing fixture; it's something that's been installed or added on to property...

This has to do with attaching a form to a table that has a password field. The form has 3 textboxes; one for the original password, and two for the new password (one is used as verification of correct input). The problem with doing what is shown here is that there is no username associated...

I think the reason you're not getting responses is probably due to your terminology/vocabulary. While words have multiple meanings, a fixture is generally used when referring to devices, such as a light fixture or plumbing fixture; it's something that's been installed or added on to property...

bump. .

Wondering if anyone found a solution to this yet: 'Put cursor at the end of the text box Me.txtBoxName.SetFocus Me.txtBoxName.SelStart = Len(Me.txtBoxName) The problem now is that even if 2/3 of the textbox is whitespace, the scrollbar still scrolls to the bottom of the box. Anyone...

It'd be nice to have that link in a sticky.

Interesting Doc. But still, keep it simple. Use a query and the time functions as I previously suggested, it's quicker to construct. If you are in need of something more versatile, use what Doc provided. It will be able to break down your groups easier in the future.

In the other box's _Change() event, do the following to refresh the list: combo_CostCentreLevel.Requery If you want to reset the listbox's value completely: lstListBoxName.Rowsource = "" lstListBoxName.Requery

There are essentially three kinds of modules: class, standard, and object Class is where your class definitions go Standard is where your commonly used functions should go Object is where functions pertaining to a particular form/report are (it is where the event handling goes) When using...

Just a supplement to what Bob wrote, The DLookup() will return a Value or a Null. You just need to test if it found anything with IsNull(): If IsNull(DLookup("Invoice_Number", _ "LOE/Facility Construction - Updated", _ "Invoice_Number = " & Forms![LOE/Facility Construction...

Just wanted to send a congratulations to BobLarson, theDBGuy, and PBaldy for their efforts noted on utteraccess.com. Their generosity has extended here, to Access-Programmers Forum, and though there isn't an official "recognition" page, they still deserve it.

We've posted several functions on this forum that breaks a fullpath to it's corresponding root directory, file path, filename, and file extension

Just use time functions to break the minutes and place them with their corresponding hours. I stored your data in a table called "Price" SELECT Price.Contract_Date, Price.Current_Date, IIf(Hour([current_time])<10,"0") & Hour([current_time]) &...

Thanks, but Refresh is not a valid option for a form's control - this function does not exist

Hey all :) Does anyone know how to force the value of a listbox to refresh, without refreshing the form? The form has a few controls that are based off of linked tables so I don't want to call the Me.Refresh if I don't have to because of delay times and performance issues. I am doing...

Unfortunately, company policy will not allow me to post a copy of the database, and it would be too much time to break it down into a prototype that may/may not reproduce the same error. If I find time, I will try to recreate the problem and let you guys play with it until your heart is content...

eval brings error. I do thank you though, because I wish I would have remembered eval() with this other thing I was doing: calling multiple functions with similar names

It's okay, next time. :)