Search results

Newbie here... coming from a world of creating UserForms for Excel. While recently starting to tackle Access, I've created some initial forms and learned about Bound vs. Unbound columns. I've created a significant form bound to a Table. Several Text Boxes on Form need to contain values that...

It was late when I started this thread. After some sleep I built a sample DB to model my problem. good learning experience for me. I got it to work, but I don't think it's as efficient as it could be. I've attached DB for reference. I couldn't make it work until I added a field to my...

Newbie here...struggling with a simple task. I need to retrieve a piece of data based on two criteria. Not sure my data model is in the best shape for this. In simple terms: tblThings has two fields, Type and Value. tlbType is related to tblThings,; there are several Types. A third table...

It actually needs to be like this: DateSerial(Year(Date()), Month(Date()), 0) That way, if it's the last day of the month eg. jan 31 2009, it will still return the teh day before the first day of that month. From the Help file on DateSerial: The following example uses numeric expressions...

Banana: I modified yours slightly to get this: DateSerial(Year(Date()), Month(Date()+1), 0) Now it returns the result I'm seeking. It will always return the last day of last month. Thanks for the pointer in the right direction.

I see where you're going with that idea, but the code you posted doesn't quite do it. The DAY parameter is not optional in the DATESERIAL function. You'd still need to account for a change to the YEAR parameter if DATE() is within January, and in order to be accurate, you need to know how...

Hi! I'm used to Excel, and trying to convert some things I've done there to Access. (Without using a Reference to the Excel Object Library in my Access Project) I'm looking for the VBA equivalent of this Excel formula: =EOMONTH(TODAY(),-1) Which gives me the SerialDate # of the last day of...

Re: SOLVED Change Event vs AfterUpdate I had to add the same line of Code to set the .Value for the lboxContractData in order for the contract SubForm to refresh correctly. Became a problem when a property was selected with more than one contract associated to it.

SOLVED Change Event vs AfterUpdate The key turned out to be setting the Value property in the code. Just setting the Selected Property, did not change the Value Property. Since the query for the subsequent Listbox was based on the VALUE of the first Listbox nothing was happening. When...

Here's how I use the Form_Current event now... Private Sub Form_Current() 'MsgBox "Form_Current() -fired" 'Refresh the Property Listbox With Me.lboxProperty2 .Requery .Height = .ListCount * 230 + 230 If .ListCount > 2 Then lblChooseProperty.Caption = "Choose Property:"...

Hi! I'm new to this forum, and new to Access. I'm attemtpting to convert an application I developed in Excel in order to capture the power Access provides. Given the nature of my data, a relational DB is where I need to be as opposed to the way I've prototyped things with Excel. I'm hitting...