Search results

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

I am running into a curious situation... I have text boxes in a report footer. They are summing the values in columns in the main report. However, if the column happens to contain all zeroes, the summing does not show a zero, it shows nothing. How can I get to see the zero in the summed text...

AncientOne, Your solution worked exactly right. I was totally unaware of the quote differences based on variable type. Once I made those changes, the value was successfully retireved with no problems. Thanks for your help! Marco

I used the column numbers because the combo boxes have multiple columns and I thought that I had to reference a specific column. Both referenced are the bound columns. The company name is text and the stock number is a double. I also tried setting two variables equal to the values in the...

I have the following in an AfterUpdate event of a combo box: Shelf = DLookup("[Shelf_Life]", "Shelf_Life_Tbl", ("[Stock_Number] = " & Me![stock].Column(0) & " And [Company] = " & Me![Shelf_Company].Column(0))) Basically I want to look up the shelf life in another table based on the values...

I just tried your revised version. It has one missing parantheses but otherwise worked fine. I hadn't tried your first one yet, I was just about to.