Recent content by munkeyroot

hi everyone i keep having issues randomly with my Access DB Backend keeps coming up with Unrecognised database format error. is there anything i need to be aware of or what i should be checking for. soon as i kick users out and let Access repair itself it is OK for a while. but then happend...

HI isladogs Yeah i know fella, who i'm i to argue with my boss lol. yes the duplication automatically assigns a new ID, however i cant seem to change the join on the qry to referential integrity with cascade update they are grey'd out

Hey everyone i'm not sure how to tackle this one i have a duplication script (attached) which i run to copy whatever is in the main ID at that time. there is a parts list within this main_id which is built from drop downs and other tables inc a third party table. anyway issue is when this gets...

Hey CJ Thank you for your help, that has work a treat fella

Hey everyone sorry i have not posted much for this thread, other work came up. so little update. i have managed to find the tables on the TPS (Third Party Software. so the tables in the TPS called "tbl_Fact" This stores the "code", "dps" field "tbl_name" this stores the "cn_fact", "Instock"...

Hi ridders i know fella, having an open link would make life easier :), however my IT manager is a little nervous about it, as we have a lot of other things that link to the third party db already thank you for the info i shall give it a shot my friend. Munk

Hi Everyone hope you are all well i'm not new to access but new to macros, just wondered if is was possible to edit a relationship through a macro? Background: Everyday i have to import a new table from a third party DB. rename the old one ....old ...:) ..and rename the new. at this point the...

Ahhh i think i have cracked it...well maybe a bit clunky but it works i have my qry set on Grade | Percent. so because the 1st column is Grade as in A B C etc the code in the control source was picking up the letter .....so i switched them in the qry to be Percent | Grade so the C.Box shows the...

Hi guys apologies i have just got back to you all thank you soo much for your input. i have attached a screenshot hope this will help. yes so on the Revenue from Rental per annum Text box "TYRRetalRev_3YC". i am using the control source to populate the maths from the combo box...

Hi Everyone hope you can help i am a little stuck on a project i have a text box called percent - i don't want to use the amount as a customer may see this so i have a table with, and created a query for it. Grade | Percent A = 10 B = 15 C = 20 and made the Percent...

Hi Everyone I know this is not best practice for an access DB, however until i can find a better solution i'm a bit stuck :) So my main DB has auto gen PK - i also have other related sub tables with PK and FK to my Main db. i also have FE and BE i have had to take a copy of my DB away from...

hey ranman and arnelgp thanks for you comments. arnelgp: thanks i will give it a shot Ranman, access is not changing the format that should be easy enough, however its the third party table where the qty is stored, when the stock qty get inputted some parts are entered as "3" or "3.00". so...

Hi Everyone hope you can help i am having an issues with data with decimal places. Background: My third party software controls our stock and qty's. when users enter new stock they enter the new amount. thats ok no worries but some qty's get entered with a decimal place and some do not. so...

Hi Everyone i have an odd think happening to my db ok..so.. on my [frm_main] i have a total amount which is based on adding three different amounts together . not an issue all ok with that. however i have created a new table and form for a rentals [frm_rental]. FK_ID relationship to...

Hey guys apologies i have only just come back to you all. have been away for a few weeks. thanks for the information guys, just as i though world of pain!!! Munk ;)