Search results

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

OK thanks. I will do that later tonight. It is a huge database and probably way over my head. It is a lot bigger than the Tradewinds sample database. And I will need all the help I can get. I did figure out the answer to my question though. I ended up using a query wizard and created a...

Sorry, I tried everything. My zipped size on this database is 2.11MB so i cant attach it yet. is there another way of attaching it?

I keep getting a missing operator error when i paste this into a database. I made three tables exactly like the three described and created a query. when i go to SQL and paste this into it i get an error and have to close down the query to get out. keep in mind i have never worked in SQL before

Hi guys, I have an agreement details table that i can query and get a rate table that looks like this depending on what Agreement type is picked Rank Rate GF $110 FM $90 JM $75 3rdyr $70 2ndyr $60 1styr $50 Thats the easy part, I need to figure out how to...

I added a refresh macro to the on change for the combo box and this seems to work but I'm still looking for the reason for the lag as this could be an indicator of an error