THANK YOU so much for this reply!
I will let you know how it goes.
Stephanie...
StephR
Last Activity: Sep 8 '08, 08:07 PM
Joined: Jan 26 '08
Location: VA Beach, VA
-
OK... I double checked on everything you suggested and it's still not working. If I take the field from the field list, there is nothing displayed. If I source it to the form, then #Name comes up...Leave a comment:
-
Thank you! Yes, I am still working on it... I acutally used the inventory template from office.com for a reference on the code.
I'll try out what you said and let you know how I did.
Thanks again!
Stephanie...Leave a comment:
-
Getting closer with Inventory Database
Hi guys. I posted a question last week about getting the order qty based on my case packs. I couldn't figure out the code, and I couldn't seem to explain myself right. So what I did was added 5 new label and text boxes on my form to do my math for me.
1: =Abs([availableStock])
2: =([qtyOrder]/[cartonqty]) + .4 (I couldn't get it to round up...)
3: =Round([qtyCasepack],0)
4: =[qtyRoundCase]*[cartonQty]... -
It's ok. Turns out, my neighbor is a programmer and he said he would help me out.
Thanks anyway.Leave a comment:
-
What about this:
Variables - *work through example*
Available qty (in stock - allocated) *-51*
Carton qty - Qty the item comes in *50*
Order qty - How much I will need to order *?*
Case - How many cartons I will need to order *?*
While Available qty is less than 0
then add integers from Available qty to 0 *order qty = 51*
...Leave a comment:
-
By adding a carton qty, I was hoping to get the order qty.... Now that you say something I guess that doesn't really make any sence...
Here is what I was thinking...
Let's say item 1 is less 12 of available stock. My carton qty is 15.
So I would order 15....
Let me rethink the formula and post back. Thank you for your help
Thank you,
StephanieLeave a comment:
-
Help with Inventory Database
Hello!
I'm not very good in making code work for me, so I thought I would put it on here and ask for some suggestions. Here is some back ground. I have an inventory database that I can log what is on order, in stock, allocated, and shinkage. By entering each transaction, I can tell what I have on hand vs. what is "avaliable" . Now. As I'm entering a new job, some of my available stocks are going into the negative and I will... -
Report Will not Print what's in the table...
Hi,
First here is the background of the problem:
This is an inventory database. There is a table with all the required fields, I then made a form based on the information. Then there is a query based on 2 tables in which is the subform.
In the subform I have 3 fields that add the collection of data I need to figure out how much is in stock. on order and available. The main form only reads from... -
I just tried the same thing with my database... I ended up making a find command button on the main form, which would then show all the records in the subform that I wanted.
Also, I had to go back and click "cascade updates" in the relationship (between the form and subform) to allow the user to enter information both ways.
Does that help any?
StephanieLeave a comment:
-
Ok... I got side tracked on this project and I revisited my strategy and what I did is really working out for the users... It's not really doing what I wanted, but it's working. I simply just put a FIND RECORD button on the main form, and added a sub form to show the rest of the data they are looking for... Again, I'm still a newbie, but I hope to play with this a little more and perfect it.
Then, I made another command button that...Leave a comment:
-
Puppydogbuddy,
I put the form of the table in the footer of the Search Form and made it the record source.
Then I wrote this:
...Code:Private Sub Search_Click() Const cInvalidDateError As String = "You have entered an invalid date." Dim strWhere As String Dim strError As String strWhere = "1=1" ' If PO # If Nz(Me!PO#)Leave a comment:
-
Puppydogbuddy,
I think I am very close too. I really need to get this working so I can move on. I am so obessed with it, I'm dreaming about it. It's really bothering me I cannot complete the form.
So if I made a make-table query and put that in the record source, that wouldn't work? Because that's what I did. This guy that is using the form knows pretty close to nothing about computers. He knows how to type, use e-mail...Leave a comment:
-
I changed the code and it still isn't working. I don't think it was becuase of your suggestion, but becuase I am not doing the record sorce right. So I deleted the form and I'm starting over.
I am sorry if I wasited your time....Leave a comment:
-
Thank you for the replies! Your descriptions were very helpful for me to understand this more. I loved the idea for the book too. I went to the library and found one book for SQL and one for VBA. Does anyone else have any good recommendations ?Leave a comment:
-
Ok. I'm not doing something right. I keep getting an error message saying the variable is not defined.
...Code:Private Sub cmdFilter_Click() If Not IsNull(Me!City) Then strFilter = strFilterCity & "[City]=" & Chr(34) & Me! City & Chr(34) & " AND " If Not IsNull(Me!Carrier) Then strFilter = strFilter & "[Carrier]=" & Chr(34) & Me!Carrier &Leave a comment:
-
Oh I see!!! I have just enrolled back into school to learn more about code. I am very excited to work more with it. Hopefully I will get to the point to give out tips and tricks like you.
I am going to try this and let you know how I do. Thank you so much for your help!
StephanieLeave a comment:
-
Help Please with Search form
Hello, the users on this site seem to be very helpful. I hope you guys can help me. I have been searching for the past 2 weeks on how to create a search form for my database at work. I'm not really experienced with working with code, although I have been able to pull a couple of them off. This is what I did:
I have two databases my co workers use - one for the trackers and one for the shipping guy. (Since he has absolutly no computer...
No activity results to display
Leave a comment: