Search results

In the below sql statement within my query how can I set the invadjust in the first line to true when this is ran? INSERT INTO tdatInventoryRec ( RecDate, Item, Qty, invadjust ) SELECT [qdatInventoryCheckupGather Diff].InvDate, [qdatInventoryCheckupGather Diff].Item...

I have an error in this VB and it says Mismatch... Not sure what is wrong... Can someone please help me find the error? Dim strsql As Boolean Debug.Print strsql = "SELECT * FROM qdatInventoryCheckupGather Diff " & _ "WHERE Diff = '' " & _...

Any help would be greatly appreciatted.... I have a form that I change some records for inventory purposes and after all changes have been made it updates the records to a table. I'm going to give a short version that if you want to look at the database you can figure it out and a long...

What is wrong with my combobox? I cant it to display the Item int he box instead it wants to display the ItemID... I cant figure out if its in the properties or if its in the afterUpdate Event (I dont think its here)... The actual event would be you select the item and then all the other...

ANy idea why why I keep getting this? I have a query named "qdatinventorylevelcurrent" and I'm trying to run this query in VBA using VBA Code below but I keep getting error Object requiredsetrst = MyDB.OpenRecordset("qdatInventoryLevelCurrent") then I want to write these records to a table...

I have two tables 1 that is inventory Recieved and 1 that is inventory Used. I runa query on actual inventory by subtracting used form received. This works fine. What I want to do is show this on a form or report where I can enter the actual inventory beside each record and then be able to...

I need some suggestions on the simplist way to handle somethign like this. i'm thinking my way may be the difficult way and I wanted to see if anyone had any better ideas.. ANY SUGGESTIONS would be greatly appreciatted..!! I have a database that has inventory of each and ounces as well as it...

What is the best way to get the difference between two queries? I tried Union but dont get any results. I tried Crosstab but that doesnt allow multiple queries.. Hmmm So I tried the simple query and added both queries to it and right joined by Item and added the field "Qty" from the Recieved...

I have a report that is calculating from four fields it could be a positive number or a negative.. What is wrong with this? =Sum(nz([Sales],"0"))-nz([Payroll]+[InvPurch]+[nonInvPurch]),"0"))

Hey I have seen several people post that it is a solution but i do not see anything saying how to do it. I want to run reports from a single form and I want to have the start date and the End Date for the reports on the form they run the report from. My question is how do you have the report...

I have a form "fdatPayEmp" that has fields "WeekStart" "WeekEnd" "GrossPurchase" I have a table "tdatPurchases" that has Fields "ChkDate" "ChkAmt". I want to get the total of the ChkAmt for the reange of dates entered on form and have the value placed in "GrossPurchase" If either of the dates...

I have an error in this code which is error 3061 "To Few Paremater Expected 2" I have a table "tdatInventoryRec" which has two fields "recdate" and "Cost" On my form I have Fields "Weekstart" "WeekEnd" "GrossPurchase" I'm trying to get this code to gather all records in table...

I have a form that has a field on it that someone enters data in after its entered I want it to fire the vb along with it. I'm using hte on_Change but it fires on the first character they enter. I dont want to use the after_Update even though it works because that means that the curser has to...

I have the attached report and I want a user to be able to open this report and it will show them the date range selected. I'm not sure of the best way to do this but I thought just adding the Start date and End Date on the top of the report would be the easiest way but from reading different...

I have attached a small db that has 1 query with several fields.. Here is what I'm looking to do. In the Query there is the following fields: SignINMemberID GuestOfMember SignInDateTime AllowedEntry Now all these are derived from tdatMemberSignIn. What I want to do is show the name that...

I have this code on a form that i enter a "WeekStart" date in a text box and a "WeekEnd" Date that looks at table tdatPurchases on change. I'm trying to get it to place the results of the sum of chkAmt in the table in the text box "GrossPurchases" I get an error: Runtime Error 3061 To Few...

Good Afternoon everyone... I have attached a basic form so maybe someone can help me out and I can get the concept and build upon it in my actual database. In the form fdatMemberLookup I want to be abel to enter the MemberID and click Search. It will then search a table and show the records...

When I run this command on the Receive Inventory it inserts into the table the Primary Key instead of the Item Name.. When I select the item on the form it shows the Item Name so why wouldn’t it insert that? The order of the table the Combo Box looks in is “PrimaryKeyID” “Item” Private Sub...

I have never tried this one before so I need a good boost on this one to even get started.. Heres what I want to do. This looks long and complex but its really simple to say and I think that it should be simple to do for someone who actually knows what they are doing in code LOL.. ANy Help...

I'm stumped for some reason and cant seem to get this to work... Maybe someone can help me out and give me a boost so I can get going again... I have this and it works perfectly:Private Sub CheckSun_AfterUpdate() If CheckSun = True And PayType = Salary Then rs.SundayPay = PayRate...