Search results

I have a hard time pulling from different subforms, it always seems to be done a different way and I haven't figured out why yet. Anyways this trick works great if everything is on the same subform but for the life of me I can't get it to call info from another subform, please help. This is...

I have a query made up that brings up damages, I have 2 tables that cover damages, "Transfers" and "Orders" My query has the data I want except I need to combine 2 date fields. On thing to note is both those tables share a table called "inventory" where all the numbers are actually stored. It...

Oh one other related thing. I'm doing the same trick on another form and the field that is doing calculating I want that number to be stored. It's the payment amount I'm capturing. Someone enters the payment as 2 - $20, 1 - $10 and the total says $30 paid then I want that number to go into...

Thanks, that was too easy, why can't everything be this easy. :)

Hi, I know you shouldn't store calculated values but this is a special case I believe. I'm playing with inventory, we have cases, boxes and pieces. A case could have 4 boxes and each box has 12 pieces. When I transfer inventory I use cases, so if I need to transfer only half a case I go .5...

One other thing the form isn't opening over the form that's loaded when the database loads. When I close that form its open behind it.

If I use the following code it will open the employees form on open however it does it now, it shouldn't until june 10? Private Sub Form_Open(Cancel As Integer) DoCmd.OpenForm "employees", acNormal, , "[Date]" = "#6/10/2011#" End Sub

Yeah something like that would work, can I have it open a form instead of closing the program? Would you what code I would use or what command as in "DLookUp"?

I don't really wanted to lock it hard core, I just want something simple, its not going to anyone savy. I just want a form to popup automatically when a date arrives. I'll lock the form, and have just a dialog with an exit button and some comments. Because that form is open over everything they...

Hi, I can't seem to find this anywhere, is it possible to set a database to expire in say a couple days or whatever. I'm trying to sell this database I'm making to someone and want to give them a trial version to try before buy. I want to set the database to expire in a couple days, no...

Hi, I've been struggling trying to get a DLookup to work. I have a report that I want to look up some data. I'm trying to make a report that will print an old invoice based on a date and employee and show the correct inventory levels at that time. Right now I have it working so a person can...

Thanks JR works like a charm, I was actually just getting back to that problem as I needed to solve it to start moving on so you're reply couldn't have come at a better time.

I looked at that option and under file type only access database shows up. In my options under default file type for blank database its set to 2007, it doesn't even have an option for 2010, it shows '03 as well. So it is in the only file type I can go unless I go lower but can't change an...

ah that sucks, I guess it is in '10 format, I thought it was '07 because at the top in brackets it says (Access 2007)

sounds good, thanks! This is only my 2nd database I've built so let me know how I've done as of yet, I think its coming together nicely. I still have lots of changes to make on forms for the looks end but that I'll leave till I'm done. Almost Everything runs from the "orders" form, most...

What version do you use? It's build in 2007 format.

thanks for the link, I tried a few things but got no where, no really sure what words to change in syntax. That's a great page but would be better if it explained which words in the syntax refered to what. Whatever I type in criteria in the record source under employeeID it will just give a...

Surely someone has had this happen to them, please help...

I have a bunch of forms created which have an unbound combo box which is used to search the records. On the "record source" for my "employees" form I have a query looking up all the fields in the table and the field "employeeID" with a critera Like [Forms]![Employees].[myselector] &...