Search results

thanks a million for that mate, it worked like a charm!

Hey guys Firstly, my Access-Word automation is working fine. however, ive run into a new problem now. (im using templates and bookmarks) - when i export the data from access to my template, the information is not stored in a new document, instead the template is opened and the data inserted...

hey guys please bear with me - i have some basic q's about modules and procedures that im sure would be best explained by someone on the forum heres my situation: i need to include some VBA code to export info from an Access form to a Word doc. Im reading up and learning about how to do this...

hey guys with access to word automation, im confused about the datasource to use. my understanding is that the datasource can either be a table or query. firstly, a query is not applicable for me. as for a table - this is where im getting confused. I am trying to send the data as entered by...

wow thats pretty intense for a novice Access user.... hmm... is there any way that you could help me through the parts of the code that i should change? it does seem like this is what i need to do, but im not going to be able to get my head around editing that code..

hey guys i really need some help with this... i have a form that contains 2 subforms that relate to different tables in my db is it possible to get the information entered into the form and suvbforms exported to a Word doc? if so, can someone give me the steps involved or some pointers please...

i really need some help with this... heres the background. I have an unbound search combo box in the header of my form. when users select the PCNo from this combo box, i need the associated container no to appear in a control on a bound form.. below are my tables: tblShipping ShipID (PK) PCNo...

v sorry for the basic question, but ive been banging away at access and i cant my head around this.. i need to run a simple query. the query/ search will ask users to enter in the number of a document. i want, when this code is entered, for 2 controls on the form be updated with codes that are...

thanks for this... ive tried adding the following code to the 'Close' button on my subform: Forms![frmShippigNotice]![Combo66].Requery DoCmd.Close but still no good - same problem occuring. ive attached the db - i really appreciate this

nope no good :( same problem - the previously entered supplier detail is getting replaced with the newly entered details, leaving me with only 1 record in my supplierdetails table... any other ideas?

the row source is: SELECT tblSupplierDetails.SupplierID, tblSupplierDetails.CompanyName FROM tblSupplierDetails;

sorry if this q has already been asked, but i couldnt find what im looking for after searching.. i have a main form. there is a combo box that is that is bound to tblSupplierDetails. this combox displays the records stored in tblSupplierDetails fine. now beside this combobox i have a hyperlink...

ok guys very simple question i have manually built my form in Access 02. Now i want to bind a particular control to a table - ie. when the user hits 'Submit' the record will get written to the correct tables. simple data entry i have a table called tblShipping, in which there is a field called...

Hi guys i really hope this is possbile... i need to basically alter the layout of a subform to replicate the layout of the 'Columnar' option... i cant use the datasheet and tabular options for my subforms - i need the subforms controls to be displayed vertically rather than horizontally, as...

Pat, you are really helping me along here, and I seriously appreciate it. I can see how my current structure is still weak. Im in the process of rethinking these table designs. It seems to me, given all your advice thus far that I have over complicated this importing-shipping-delivery database…...

1) No - each container has one customs record. its more the case that each shipment (with how many containers) will have one customs record. hmmm i think maybe this relationship incorrect on this basis? would your suggestion of merging tblShipping and tblCustoms be advisable? 2) No - each...

Hey Pat, you suggest merging the Shipping and Customs data into either Container or Order - i would have thought that having stand alone tables, that contain the info on these seperate entities was a better approach? I would honestly prefer to keep these tables as individual tables... if you...

thanks for the tip, thats actually gonna help me out with some links that i need to update!

Pat, thanks very much for your advice. I'll re-think the structure along your suggestions and get back to you! (i realise that you dont need to help out this much - but i seriously appreciate it!)

hey guys just wondering if you could have another look at my new relationships.. i think this is a better attempt, can you guys have a look and see if theres anything obvious im missing please? im still a bit confused about junction tables - my understanding is that they are required for M:M...