Search results

You could put a new button on the form using the wizard to save the info. Which would in a sort requery the info. You could also make the "next record" button and have it requery the info on click etc... Also what I do for the Case part is I put a single line of script in the afterupdate...

I have two forms that have a link to open the same form. IE Test taking Form Survey Form they open up this form: Update jobtitle form Both the test taking and survey forms have a button that opens up the jobtitle form. I have it set when you close the jobtitle form that it requeries the test...

If I am understanding this correctly does it speed up the process within the database? IE you don't have to go through the ado>>ole db... with the odbc it just has the one step? Or am I missing what it is saying. Also what is the prevailing census that you need to make sure your db has an...

Also make sure the permissions are set on the folder if the folder has security settings/permissions assigned to it. That can also play havic on your security settings...

Brian.. I wanted it to group like items...... that part is right.. but it isn't adding up the quanity correctly.... IE query: Order # 12345GG Part# Quanity Price total 123 2 $1.00 $2.00 123 1 $1.00 $1.00 Report (what I would like for it to read)...

I have upped a version without the macro..

I should take at the macro part for right now.. but if you hold down the shift key..... is that what you are referring to?

Hello.. I have a report that is based of a query. In the query I have the following calculation: total: ([quanity]*[packagecost]) I have also been able to group the like products, but it does not add the quanity correctly. Here is the sql of the query: SELECT tblOrder.OrderID...

Hello... Question, do you need one for your database and if so why? I have read what they are but I haven't found really why you would need it? Don't know if this is the right place to post this question but wanted to get some input on this. Thanks R~

ghudson Thank you.. and it is very easy to use and see what it going on. Thank you again R~

Thank you for the link...

Hi all here's my question. Have report based on query. In the query I have items ordered by unit "unit is IE personnel, Exams, etc.... Example: Personnel,,,,,computer,,,,$50.00 quanity 2 part number 345 Exams,,,,,,,,,computer,,,,$50.00 quanity 1 part number 345 In the report or query how...

Oh... I see.. That makes more sense...... I was looking at the code... and was scratching my head thinking to myself.... "how did he get it to work"... LOL.......

pBaldy.. Thank you very much.... I have looked at your code and then looked at mine.. The code looks the same: SELECT qryVendor.VendorID, qryVendor.VendorName FROM qryVendor ORDER BY [VendorName]; I am now running into more problems... I have a feeling my design might be flawed...

Hi all.... Thank you for the reply's.... I looked at both answers etc.... Can you tell me what other table(s) I would need to add. I am still new at this, having a couple small databases under my belt, but this is by far been the most challenging. Thanks R~

Could you post what you changed so I can take a look at it?

Hmm... If I pull the vendorID only, how can I get the actual name in the drop down? Also when I switched it to the vendorID from the order table it will only populate with the one vendor. How can I get it to pull from the list of vendors? I am still getting the same type of error...

Hello.. I have not run into this problem before and it has me stumped. I have a form that is based off a query... I then tried to create a drop down box so the person can pick which vendor for this order. But it will not let me pick the vendor. I get a beep beep when I try to pick one...

I think I figured it out.. I created a conjuction table with the following fields in it: unitorderID UnitID ProductID That seems to be working.....

Hello.... Here is what I am doing. It is an inventory database that also is an order tracking per se database. When you are entering in the order, the top part is the vendor with an order number, date etc (will show table later). The subform is the order details. This is the tricky...