Search results

ok so i figured out to select all records on the duplication. the macro script is below. so now i am stuck on for the script to say something on the lines of selected all, copied, paste in new record where main_ID is "manual Input" sorry my VB is not great OnError Got to Next Macro Name...

Hi Everyone just wondered if anyone has come across this before. i have a main form with sub forms and trying to duplicate them. so method (in my madness) is to: first use the duplicate macro on a command button for main form (as this gives me the first ID) - if tried this and works ok. this...

HI Jdraw sorry i have just replied, thank you for the info mate. i shall do a bit of investigating.

Hey Jdraw sorry yes i did think about doing it that way , however it opens a connection the Third party database, which unfortunately IT will not let me have that connection . they are scared it may break the other Dbase or cause system hangs. which i can understand.

i also have to setup the Relationship again as it is new table ....mmmm puzzling

Hi Everyone i am having a bit of issues with this. i have a Db in access, within this DB i have a table called tbl_CParts. Which contains parts/stock information. The "tbl_Cparts" table is an import form an external ODBC DB which is called Cparts - i have imported this by this route External...

Hi every one not sure if this is possible, however id like to put this to you guys to see. Ok, so i have a main form with a subform. if i click on or use the subform that's ok but lets say the subform is a way down the bottom of the page and i need to scroll to the top of the form to look at...

Hey paul, sorry i have just replied ive been off sick, thank you for the message fella been having a look at my DB again sorry if i sound thick im not sure what you mean, could you elaborate further Cheers munk

Hi Paul, OK I've done what you said, if i understood you correctly, I've put the db here. Cheers Munk

ahh thank Paul i'll give it a shot and i'll let you know how i get on pal thank you mate

Hi everyone hope you can help my heads hurtin :S i am having issue with a cascading drop down issue, i have done some simple ones so not new to it. however this one is taxing me. i have a third party db (TP_DB) which gives me the majority of the information i need, i cannot touch this db as...

Hi everyone Just getting bit stuck on approaching a table issue. i have a item list table which is on another program which i can link to access, i cannot write back to the table as it will brake the other software. the issues is that the item table category A and A is limited so are numbered...

Hi CJ Thank you for your comment, i have had another go again. i have figured it out. so ok before, i was trying to set the =nz on the subforms footer text box, this was causing issues with the calculations of the rows. so instead i set the =nz on the summary text boxes on the main form so...

Hi C_J thank you for your post, ah no i had not mate. Just had a play about with it, not sure if i'm using it right. :S if i use the =nz which works for the null to 0, to show the £0.00 on the summary, however it does not give me the total sum of the rows and the hrs entered in the subform...

Hi Everyone I hope anyone could shed some light on this. I have multiple continues sheet subforms with fields including a subtotal, at the bottom in the footer i have placed a text box with =Sum([Labour rate]*[labour hrs]) which as soon as i enter the details in hrs (qty) Labour rate (£0.00)...

Hey CJ Ahhhh thanks pal, i'll give it a go munk

Hi Everyone I am having issues with updating a form to use a report for it. ok, so i have a form, and on the form i have my text boxes etc to fill in details, and i also have a button that generates a report. so if i update a small portion of the form by filling in some of the txt boxes...

Hi Ranman thanks bud for your help managed to get this one sorted. the child and master links were all screwed up. cheers bud munk

ok so i checked the form and data entry was set to no, ive set it to yes, tested, still no joy. The newparts form only displays a 0, though if i look at the newparts form props:data tab on the filter it shows [ID]=75 the number changes which ever form i open the new parts form on. Then i go to...

Hi Ranman yes the Text box is called ID on the main for and on the Newparts form. ok mate i'll check the form too cheers munk