Recent content by Daveisalwayshere

this program runs everything from quotes to invoicing, rental, demand planning,payroll, hr, safety Stats, Deliveries, returns damaged goods, i have lots of different resources and different tracking for each type of resource. I probably have a few tables that can be a bit redundant and as i...

i have almost 80 tables on my database. it is kind of ridiculous but it is a major project. i did figure out a solution to the problem. i dont need to have a continuous form that is update able rather make it into a contiuous form based on a query.. and that works....thanks anyway

Hi i have a splitview form that has a sub form which is a continuous form. On the continuous form there is a start and end date for each record. i would like to be able to change all the start dates on the continuous form by selecting a date once and hitting update or something like that...

ok, i think i figured it out, I changed the join properties and it now works

Hi guys, I have a query called scaffoldTotalCostQuery that has all the costs associated with a scaffold tag Grouped by scaffold tag number. I am trying to add a new field in this query by adding a second query(called MiscScaffoldCostQ) to this. which also has costs associated with the...

Ok after Erasing and re doing the forms it fixed itself. I must have somehow corrupted the forms. thanks for the quick response though

Thanks for the help. The Event procedure works but it is has the same issue It still seems thought that the page doesnt filter unless the child form is open first. i think i might have to Re-make my forms and see if that changes anything

This is the formula that the wizard makes when you create an open form button. this works on all my other forms except 2. so i dont know what the issue could be. but if you have an event procedure that will replace the macro it would be worth a try

Hi guys I have a button that opens a second form and filters that form based on a text box on the first form(which remains open). the problem is that it does not filter the second form unless the second form is already loaded for some reason. for example if i click on the buton it opens the...

Thanks I tossed and turned last night thinking about this and thats exactly what i came up with too. i added QuoteStatusID to my query and then hid it on the subform then it was pretty easy from there

Hi Guys, I have a subform named [PMQuoteQuerysubform] and in this i have a textbox named

I Tried to use an expression =[Forms]![EditListPriceStart]![DateName] And it worked as the default So i got it guys thanks anyways

Hi Guys I have 2 forms that are linked, the forms are [EditListPriceStart] with the PK being 'DateName' The second form Is [EditListPrice1] with the FK name 'ArticleDateNumID' The Main form is a continuous form and i have the togglelink button at the end of each record The second form is...

Hi I have a set of linked forms that usher the user through a series of forms inorder to create a quote the forms have 2 fields each and then subforms attached to them. the forms are linked like this SalesNUM(PK)--- ---------------------->SalesNumID(FK)...

here it is. it is quite messy because i wasnt sure where to start