Search results

Is Forms![SfrmSubItem]![MainPartLink] linked with a table field? One to Many link from main table. Thanks for your help

Thanks for that, it got rid of the errors when I used the posted code. stDocName = "SfrmSubItem" DoCmd.OpenForm stDocName DoCmd.GoToRecord , , acNewRec Forms![SfrmSubItem]![MainPartLink] = Me.PartNum. Do I have to refresh aswell? It does not save to the table. Thanks for...

Hi, I posted this question on the forms area but with no luck, hope it is OK to try here. I need to copy the value of a field from 1 form to another form I open using a button. I can not use subforms. Cheers Gordon

Thanks for that but regretfully I get the ' invalid reference to the Parent property' error message (error 2452) This is what I have coded Private Sub Form_Current() Dim newval As String newval = Me.Parent.PartNum If IsNull(Me.PartNum) Then Me.PartNum.DefaultValue = newval End If End Sub...

Thanks for your reply but it does not help because I can not see where to add the parent / child links. They are not visiable on the properties list. Remember that I am opening a new form from the original. I tried the wizard but this only works if there are matching pieces of data in both...

passing and liknking data between 2 forms I have two basic forms, each with a sub and a subsub form. The first is for the main assembly type with a sub form for the serial numbers and a subsub form to track its history, (FrmMainItem) The second form has the same structure but is for any sub...

Sorry fo the delay been away but can go home at weekends if I behave. :D The problem was not ot remove the 05 but add it automatically and also increment it yearly. I do not know why I do as I am asked. Cheers Gordon

I have a form (created from existing xl and word tables)that records memos etc. Each new memo is given a reference number in the format: Project Name (this is constant)/year (i.e. 2005) /C+number(restarts at one every year). example: Project/2005/C001. To complicate things the user can add...

Thanks, I feel realy stupid now :o Gordon

I have a report where I wish to display data down the left side of the page and let if start at the top of the same page but on the right hand side., A similar effect as a news letter. Does anyone know how I can do this without using the label wizard. Cheers

I have a report that has a sub and sub-sub report. The database is based around documents, these documents have issues and ammendments and these have design updates. 1-many-many. When viewing a Document and latest issue with updates (Form, sub, sub-sub)in a form I want the user to be able to...

Hi, I am creating a DAP and I was wondering if there was a way of creating a generic hyperlink. I have a number of documents, with numeric IDs,which are stored in the same folder. Is it possible to use a hyperlink to the folder and add the doc id. Similar to below...

Thanks for that The site looks as good as this on. Something new to learn Gordon

Hi, I am creating a web page to display the same data as my form with subform. The questions are as follows: Can I link data like in a form to subform. Do I create a web page with frames or do I use the 'inframe' option. I have basic HTML and JavaScript I hope someone can help. Cheers Gordon

Hi again, I have 2 cascading comboboxes, code from this site, and I want to apply a filter to the form using the value of the 'child' combobox. Can anyone please help? Gordon

Thanks for that, sounds good BUT " He Who Must Be Obeyed " says he would rather have the choice if possible. All I need is an answer to give to him that 1) gives a simple solution that can be done or 3) It will need me to go on a developers course or something. Sorry to be a pain, but...

Hi, Is there a way I can let a user design his own report from a list of data on a form. Instead of designing lots of reports I want to let them choose what they want to see. Cheers Gordon

Thanks for that, that has helped alot. Gordon

Hi to everyone I have 2 tables, one holds info about a pc user and what type of pc they have (laptop/ desktop) as a primary unit. The othet table lists the users other pc's if they have any. What I want is to count the number of laptops and the number of desktops in total. How and where would...

I placed this here because I could not think of where else to put it. I am creating a ' page ' that allows individuals to enter their information. What I want to know is can I restrict them to there own page only (every user has a unique logon to the system) and if so how.