Recent content by rem2088

Because then the query will pop up every time the page is refreshed

From what I can tell, this is counting all the "UPS" shippers from today. It is not sorting out by the batch number as well. As far as I can tell, it should be. I can't really think of anything that could be causeing this. -Ben

here is the syntax : =DCount("*", "tblPackageTracking", "Shipper = '" & Forms!FrmPackageTrackingUPS![Shipper] & "'" AND "BatchNumber = " & Forms!FrmPackageTrackingUPS![BatchNumber] & " AND ShipDate = #" & Forms!FrmPackageTrackingUPS![Date] & "#") I don't think it is pickinng up the right...

Will this work if it is going into the form that it is taking the settings out of ? I still can't get this to work and i'm sure it is something syntaxial. -Ben

What if I try this in the control source of the textbox : =DCount("[PackageCount]", "tblPackageTracking", "Forms!FrmPackageTrackingUPS![Shipper]" AND" Forms!FrmPackageTrackingUPS![BatchNumber]" AND "Forms!FrmPackageTrackingUPS![Date] >=DateAdd("d",0,Date()) What I am hoping this will give me...

I'm not seeing how the DLookup would help me in this situation. It would appear that it can lookup a value in a table or some such. -Ben

I have 2 queries that I want to run each time a form is updated. The first one is a select query and the second one is a count query that adds all the records selected in the first. My problem is I don't want to see either of the queries, just the value returned from the second one. I can't...

Ok, I need some help with getting a count of a field called Batch# and I need that field put in a text box. I need to have it filtered out by Shipper. For example. We received 5 UPS packages at 10am and they were entered with a batch # of 1. Then at 1pm, UPS drops off 7 more packages, this...

Ok, that will work I guess.... .Probably a better way of doing this to begin with. -Ben

I know I've disabled these before with a menu setting on my PC, but I can't remember how I did it. I have a delete query that runs when you open the database and I moved the DB to another computer and now they are getting the "You are going to delete, blah, blah, blah" msg. I know I didn't use...

Everytime I create a form I get this thing off to the side that I can't get rid of. I have attached a screenshot of it. Thanks for your help. (I was going to insert it into the post, but I couldn't figure out how :( ) -Ben

Well, I just when ahead and did it another way. Insted of trying to get the combo box to retain its settings, I made another combo box on the main form that you choose your name with. Then I set the default value of the sub form combo box to it and it seems to be working. -Ben

Well, everything still resets when it goes to the next record. I'm not having much luck with this :(

Thank you for your responce, I am able to get the text box to auto populate with the selected contence of the list box, but I cannot get the info to go back to the list box once a new record is created. -Ben

Hello all, I need some help with a list box. I created a DB that is used to keep track of packages being delivered to our office. So anyways, I have a drop down box that has a list of people who receive packages at our office. What I want to know is how do I keep one person's name selected in...