Search results

It looks like a consesus to me...it can't be done unless concatenated. Have completed that step, but now I need to figure out how to do a Select Unique as I'm getting multiples in the combo box which I wasn't before with the Last Name, First Name separated. Also the PK is showing in the concat...

I have searched through most of the threads for an answer and couldn't find an exact answer for my problem. I have a combo box pulling three columns, Primary Key, Last Name and First Name. The properties box has a column count of 3 with column widths set to 0,1,1. My problem is the combo box...

Yep, that worked! Thanks again Paul, To me, logically, there had to be records for the DCOUNT to count which would come after the query ran. I didn't realize this this wasn't the case. I'm trying to learn a new skill-set in Access and VBA. Thanks much. Jim

Almost working Thanks Paul, Part of it is working, the MsgBox part is showing, so I know I'm into the If statement, but the form is still not closing. The standard datasheet view is what is showing and what I want to close. I don't have an actual named form bound to a query. So, would I...

Hi all, I'm asking for some help on this simple question. I have a form with a button that runs a query based on user's selection. Sometimes the query returns no records but leaves the query window up. The user has to manually close the window. I want to add the feature that if the query...

Thanks Thanks all, that was an easy one to solve :D

I am new to writing VBA and am stuggling to understand why my ElseIf statement is failing to complie. The combo box is unbound and pulls data from a lookup table. I put a "0. All" record in the table so the user could select it to retrieve all records after a filter. Right now, once the...

I wish I knew more about the syntax of VB. but alas I don't... I don't know what the underbar is for _ I'm having trouble with the code not working. I finally got it to compile. Any help would be apprecaited. 'Is this a new record? If Me.NewRecord = True Then 'then carry on. 'Create a...

Tim, No, I didn't know Access was doing all this stuff in the background. Thanks for the information and the code. I haven't gotten around to trying it yet, but will. Thanks, Jim

I'm stuck on a problem, not knowing the best way to handle it. I have a form which reads one table. The table has two fields that I'm working with. One is a location and the other is a sequential number. Currently, I have a combo box that contains the location from the table. I can step...

BL, I don't know what I did, but somehow the problem was fixed. All I did was to look at the code for a Save button I had on the form (didn't delete or anything) and everything started to work..... go figure... :rolleyes: Thanks for taking the time to reply. JDB

Hi all, There is hopefully a simple fix to my problem...it's baffling me :confused: I have a Command Button on my form which opens another form. Both forms use data from the same table. I don't want the user to be able to change two fields on the opened form. The third field on the opened...

Rich, I maxed my date field in my subform footer with an unbound textbox and that part worked. My problem is referencing that textbox on the main form. I thought it would be as easy as creating an unbound textbox on the main form and putting this in the control source...

Wayne, Thanks for the help. I know this is an ignorant question, but where does the code go? In the Control Source of the Current_Status field on the main form? I'm attaching a picture of my table relationships. I don't know if that will help. jdb

Rich, That helped in that I was able to get the max date for the selected Action Item, but not the Status associated with the Status_Date. How do I do that? I was thinking that a nested SQL statement would be the only way do this and that it would have to be in VBA. If there's a better way...

Hi all, I've never written a lick of VBA, so this may be an easy problem to solve. I have a parent/child table construct. In the Parent (Action_Item_Main_Table) I have an element named Current_Status. In the child table (Action_Item_Status_Table) I have the element Status. I know this isn't...

It's been at least five years since I've written any SQL. I remember there was a SQL function where you could retrieve the greatest date. I seem to remember SELECT Max(Date) from whatever, which would return the greatest date. If this is true, then I'm having a problem interpreting it into...

I was planning on filling in the Current Status field on the form with status from the Status table and saving it to Current Status in the main table. It all revolves around the problem I ran in to with subforms. As it stands, I have a Point of Contact subform on the Main form and didn't want...

Maybe someone can point me in the right direction. I have a one-to-many table construct. A problem (Main Table) goes through many states. It can be open, working, closed, etc. In the many table I have Status and Status Date. What I'm trying to get to show on my Main form is the most current...

dcx, thanks for the reply. Yes, I do want to be able to type something into a text box and have the cursor position find matching data. I don't know about using a listbox as I've never had a reason to use one up to this point. Any help will be greatly appreciated. jdbegg