Recent content by mlopes1

I have a text box on a form whose after update event is taking the value that was entered into the field and sending it to a query. If i perform this manually, meaning run the query in the after update it works just fine. But I want to learn how to do is set a Recordset equal to it. So what I...

Just like everyone has said, this site has been savior for me. Learning Access from scratch and without help here on site, this place has provided all the answers and then some. If its ok with this site's administrators, I would like to put a link to here on my company's internal web page. We...

Nevermind... I was able to figure this out. It was alot simpler to do the join query than I had thought. Thanks for the idea!

Thought I had checked that but guess not because it seems to have worked. Thanks for your help! Marco

I'm unfamiliar with how to do this? TableA, field called Item # and TableB field called Stock #. Query to pull both into one field so the form's combo box can be populated by whole list. I think I get the concept (thank you) but don't really know how to go about this. Currently have my...

Wondering if there is an easy way to do this: I have a combo box that is populated by a TableA with Product #'s. I also have another TableB that holds "miscellaneous items" and their Product #'s. I would like a combo box to show both sets of records in its list but I don't want to combine the...

I'm sure simple solution here: I have a form that runs on DB start-up. But now, more often than not, when it loads in form view the properties box also pops up for one of the control boxes on the form? Did I accidentally turn this option on? So basically a user will open the database and be...

LOL.... sorry about that. I guess its just like 2nd nature now to write that. Thanks for your answer!

Hi Pat, Thanks for that syntax fix, I would have never found it. I entered it exactly as you suggested however still was told "Previous Operation Canceled". Perhaps you have some ideas why this is happening. I call the function out of an OnClick event... fmName = "test1" FmCheck fmName...

Dim fmName as string Dim InUseVar as string fmName = "Test1" InUseVar = DLookup("[In_Use]", "All_Forms", "[Form_Name] = ' " & fmName & " ' ") Basically, I just want to take the value of the field In_Use found in table All_Forms and set InUseVar equal to it, when the field Form_Name =...

OK, got that to work. Thanks a ton. Now a follow-up: can this be modified for a multi-user database? I tried inserting it, and it does not recognize if a second user on another PC has the form open. Thanks again, Marco

Hey Jon, That is definitely a better solution and I think that I have put it in correctly. However, I get this error "Expected variable or procedure, not module" when I tried running the code: If (IsLoaded("Lookup")) Then MsgBox ("...") Else MsgBox("AAA") End If I named my...

I have a control button that opens FormA. On the "OnClick" event I want to : 1. Check the value of a variable named YesOpen in a table called FormOpen. 2. If YesOpen = 0 then, open FormA and then write to the table FormOpen to change the value of the Variable YesOpen to 1. Else if...

I have a multi-user database which is used by 2 people over our network. Occasionally, the 2 users will access the same form(there are dozens). Because most of the forms OnOpen event clears the underlying table, I don't want a second user to be able to open it. I tried record locking, but...

You were right in thinking that there is no default value option for the text box but the Print event worked perfectly. I did not try changing the query to include the function NZ but will design it that way next time. Thanks for the suggestions, Marco