Search results

yes the two tables are related on ProductID. Yes I can join them in a query and have the recordsource of form1 be qryproduct_order. I'm not sure what this will do but I hope you understand that the when an order is placed for say an apple and the user selects "apple" a value of that apple...

Rural, Thanks for the reply. I think I answered it in my edit. You are right. When I change the value in the amoun t it does change the value in the underlying table, ordertbl. The value for txtamount is supplied from a on_update from cboname. So cboname is a list box. They select what they...

This is my first bit of code I have written. So I apologize in advance. In my order form if the amount gets changed then ask if you would like to update the producttbl with that amount. So I have the following Private Sub txtamount_Change() Dim Message, Buttons, Choice Message =...

Split Function Ok, I'm totally lost and my head is swimming. It seams there are at least 2 different ways to do this. 1 is thru an expression in a query using split([name]," ",0) which has not worked for me yet but I'm trying to figure it out. 2 is thru code. I haven't even started figuring...

Well now that I know what I'm trying to do, PARSE, there is alot of information out there. Thank you. However I have never wrote a function before and know nothing about code. I'm trying to figure it out now but I'm still going need some help I fear.

I posted this in the table section however it is better suited here I think. I have a field in a table that I imported in. This field has the first/last/ and Middle initial all in one. So name=Frank H. Urtz. So I want to set my criteria to say something like give me everything up to the first...

I think this is an age old question but I have yet to ask it. I have a XLS spreadsheet I'm importing into a table in access. One of the column in excel has both the first and last name and middle intial sometimes such as Frank H. Urtz. I want to seperate this in access. firstname =Frank...

Forget it. I figured out the why and eliminated the problem. Thanks.

I have a field in the a query with the following: % OVER NB: 1-([Monthly MTA Table]!NB/[main inventory table]!PRICE) I then format the column in properties to percent When I try to put anything in the criteria I get an error "Division by zero" I want to only the records that are greater then 80%

What criteria will you use for the ten records?

Good Afternoon. I'm trying to create a string of text that has two fields and 5 records. I have two tables. The first with all the specifc info on(lot #, Serial Number, manufacture, and etc.). My second table has the equipments specific descriptions. First line is for instance [26124][168][hp]...

Dr Stu, I am looking for the answer myself to a similiar problem. I need have a 0 count show up as 0 rather then not at all. Have you gotten any answers other then what is posted?

Thank you very much. I did just that and it works just fine.

Rob, This could help me as well. Although can you tell me how I would get the selected text to another form? Meaning if I create a new form and create a list box in that form what do I have to substitute in the code to make it go to a text box in the previous form?

ghudson, I would like to revisit this if you are still interested. As I have said I don't know VBA however I really need to learn this function. In order to get this to work where do I need to start? Rob You wrote: I had done something like that before and I just dug it up to compare to...

I have a table where I'm recording when I need to follow up with a client. From this table I want to create a query where as the criteria is everything more then 30 days from todays date. I built an expression of Expr1:[date of follow up] - date(). I set the criteria for <30. It gives me...

If you go to design view and open the properties of that form you can select the default view to be single form or continouus forms or datasheet. However if the body of your form takes up the most of the screen it will look like a single record. Look for the scroll bars on the right. Hope it...

I'm not sure if we are onn the same page. I will try to explain it the best that I can. My Fiend "Judy" who is a realtor is trying to compile info for her reality business. She asks her clients what areas are they interested in. She then has to type these areas into the form in the text box...

They are both. Westhill is a city but Syracuse-East is an area.

I tried to attach it. I don't have the list of all the areas yet.