Wornout
Last Activity: Feb 7 '14, 06:42 PM
Joined: Oct 9 '13
Location: home
-
If you right click on the home tool bar and minimize it you will only see the word home -
How Do I Use Downloaded Progress Bar
if I can use it. I down loaded it and I can not open it in any other way except to run it so dont know the code behined it. I was wondering A) How I can get it into access and B) how can I make it run when my report is loading and go away again when it has finished. -
Hi Topher23, I did as you said and copied and pasted what you wrote and changed the form to report name of report. but got lost when you said "So, you pass a "percentage " number like so: pfnProgressBar 20". The above code is not in an event attached to anything,I just opened my report in design view and up the top on the tool bar next to properties sheet I clicked on the VBA code symbol and put it there is that right?now I can...Leave a comment:
-
Thank you Topher23 will give it a try,and let you knowLeave a comment:
-
Thanks NeoPa, I did not realize, I did do a search on here but did not really understand what I was meant to be doing and if it was even a good idea.Maybe cause it was getting late and my mind was getting tired and I was having trouble formatting some equations in a union query and getting frustrated with that.Leave a comment:
-
Please Tell Me about the Progress Bar
Original title :
Thanks Rabbit and ZMBD, Please Tell me about progress bar
I solved my last issues Thanks. I started again I think I was trying too much and got too bogged down, so started again and kept it tidy and clean.
I would like to know about a progress bar. I have a parameter form with a button that you click and opens a report but the report takes a while to do all the calculations as there is a lot. You...Last edited by NeoPa; Nov 6 '13, 02:59 PM. Reason: Changed title and tidied up question to be more easily read. -
Sorry Rabbit,The 3 combos are on my main form and the 3 sub forms are child fields off the combo boxs. Everything was fine untill 2 sec ago when I added the last subform and then my main form combo boxs wont work!Leave a comment:
-
Sorry Rabbit I have no idea what you are talking about. But what I did was start again and my new form was working untill 2 seconds ago. I had the sub form x3 that were run off queries on my main form they are all editable. on my main form I have 4 combo boxs each one a master field to the 3 sub forms everything was fine even to the point that I had code to be able to add new names to the combo lists then I added the last table and now I can not...Leave a comment:
-
No the 3 sub form are from 3 different tables. Each is a list of different kind of recipesLeave a comment:
-
I have a form Recipes and 3 combo boxs and 3 subforms
My form Recipes has 3 sub forms each has a Master/Child to a combo box. each combo box is bound to a field on the form/recipes table but instead of saving all what picked in the combo boxs to one row in the table it saves all 3 to different rows I want them to save all to the same row -
Wornout started a topic I am trying to build one form that I can add to sub forms etc I just dont get itin AccessI am trying to build one form that I can add to sub forms etc I just dont get it
I have tried all sorts of ways,and they work up to a point,
I want 1 form that I can bring up a base recipe flavor(and can add new one to list) and a sub form lists all its ingredients and I can add to ,change,make new, and also bring up the variant flavor(and add new on to list) and a sub form that lists those Ingredients and I can add new, change add to and save the base to its table and the variant to and base recipe ID to a recipes table.The... -
ok will do thanks for all your help I have never been this stuck by a data base before but I have been a bit more adventurous with this one LolLeave a comment:
-
ok now I have bound my combo boxs to the right Fields and yes my sub-forms behave just like they should but my form is bound to recipes so when I alter a sub form it saves it as a whole new entry.May be you have a much better way of doing a form all I want to be able to do is bring up a base recipe(Mince or steak) it show the ingredients and I can add, edit or enter a new one,to it, the same with the variant recipe or enter a new variant recipe ....Leave a comment:
-
I think that's what I did in fact it is always open on the code I think? What I have copied and pasted is it correct I mean how you want? I don't know of any other way.
BaseTbl has ID(Auto Number) not PK for some reason I turned it off
Base RecipesTbl has BRecipeID(Auto N0) (PK) and BaseRecipeID
RecipesTbl has RecipeID(Auto No) again I turned PK off and it has ID(from Basetbl)
RecipesIngredie nts hasRecipeIngred ientID(auto...Leave a comment:
-
I am not sure what [Code] and [/code]tag meansLast edited by zmbd; Oct 15 '13, 09:57 PM. Reason: [z{What we mean, is that you need to select the text, and then click on the [CODE/] format button in the toolbar (^_^) }]Leave a comment:
-
Ok here goes I amuse you mean the code I have put there.
I am useing Access 2007, I have tables, [Base] (Which holds the flavour1, ID),[Base recipe](Which holds the recipe a long with RID(auto number)recipeID )[Recipes]( which holds Flavour,Flovour 1,Type,size,Bas e ID),[Recipe Ingredients],Recipe-ID(auto number)recipeID ), [Ingredients] (which holds all the ingredients in stock) Base Recipe and The Bace recipes and Recipe Ingredients are union...Last edited by zmbd; Oct 15 '13, 09:55 PM. Reason: [Rabbit{Please use [CODE] and [/CODE] tags when posting code or formatted data.}][z{added to and modified the code tags added by Rabbit}]Leave a comment:
-
Finally am where I was now I I am having saveing probs
Have my recipe form(RecipesTbl )
I have 2 unbound combo boxs that work! and are connected to separate sub-forms
Then I have 2 text boxs taken from the fields list in recipes form aka recipes table
Everything works fine but
the combo boxs save to one row and the text boxs save to another row both in my recipes table, They are supposed to save all in the one row
It has taken me all day to get the sub forms and combo... -
I should not of started playing round ruined my database
I had just what I wanted and I started playing round with it. I have tried to undo the changes but yes I saved them(dum)I think I almost have it but...
When a user uses the form they(form RecipesTbl)
Bring up a base recipe Name(Flavour1)C ombo box Basenametbl)
And sub form shows all the ingredients for that flavor1(Baserec ipestbl)
Both are editable and are saved to the Recipe table,
Then they are supposed... -
Wornout replied to Some Ideas on Tables my data base has got very messy and I dont think my tables are rin AccessWhy would you be afraid of that? was that data base not to good?
Thanks for your answer :-) Walked away for a couple of hours and am now trying againLeave a comment:
-
Useing an IIf statement to filtera sub form
My sub form I want to link master and child can I use an if statement? where would I put it and how would I word/code it. I want to say IIF [Flavor]is Null return new rec or if there is a flavor in the box return ingredients matching that flavor
Flavor is in the master form and is a bound txt box
I want to be able to add to it or change the ingredients.
No activity results to display
Leave a comment: