Search results

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 ;)

Hi Everyone just want to say to the people who have helped me out in the past ....THANK YOU. ok so for my next challenge, has anyone attempted this before. my DB is on our server, so users can login and use. However my boss is wanting to take it on the road with him. while i am going down the...

Hi Orthodox thanks for the comment Yes the main_id is PK auto num for the main page. However the subform has a relationship to the 1toM Main_ID which takes the auto PK and places it in the Main_ID FK on the subform table. which the script as i have is saying "after duplicating the frm_main...

Hey everyone I have been trying to do an append query to duplicate my frm_main and all my subforms on a command button. i found this on the net from MSoft https://support.microsoft.com/en-gb/help/20...-detail-records ok so i have copied this to the letter .... i think ... just obviously...

Hey Ridders oh course ! i feel like a dumb as now.. cheers mate worked a treat bud Munk

Hi everyone i am having a little trouble with some code for a search box. on my main form i have a quote Field "Quote Rev Number" - the quote could be a number or numbertext. i have an unbound text box called txt_QuoteRevSearch then a command button with the below script: Private Sub...